SELECT DISTINCT SQL_CALC_FOUND_ROWS 
                 music.*, 
                 UNIX_TIMESTAMP(music.datetime) AS d, 
                 music_projects.name_en AS project_name,
                 music_categories.name_en AS category_name,
                 music_authors.name_en AS author_name,
                 music_types.name_en AS type_name,
                 music_labels.name_en AS label_name
          FROM music
          LEFT JOIN music_projects ON (music_projects.id = music.project_id)
          LEFT JOIN music_categories ON (music_categories.id = music.category_id)
          LEFT JOIN music_genres ON (music_genres.id = music.genre_id) 
          LEFT JOIN music_authors ON (music_authors.id = music.author_id) 
          LEFT JOIN music_types ON (music_types.id = music.type_id) 
          LEFT JOIN music_labels ON (music_labels.id = music.label_id)
          RIGHT JOIN music_subscriptions ON ( music_subscriptions.music_id = music.id )         
          WHERE 1
            AND UNIX_TIMESTAMP(music.datetime) < 1711621680
            AND (
                music.vis = 1
             OR music.vis IS NULL
            )
             AND music_subscriptions.subscription_id <> 48                                                 
             AND music_subscriptions.subscription_id <> 49                                                 
            
             AND music.type_id = 1         
           ORDER BY music.views DESC 
          LIMIT 20, 20

Song Album Time Label Price
Finger-Pickin' Good! Gags Network Music Collection
2Rude4UTube Vol. 1
00:00:48 AFL Music $0.99
Bluestastic Gags Network Music Collection
2Rude4UTube Vol. 3
00:00:39 AFL Music $0.99
Classically Chill Gags Network Music Collection
2Rude4UTube Vol. 4
00:00:31 AFL Music $0.99
Funk-a-Licious! Gags Network Music Collection
2Rude4UTube Vol. 3
00:00:38 AFL Music $0.99
Amblin' Stroll Gags Network Music Collection
2Rude4UTube Vol. 1
00:01:32 AFL Music $0.99
Airing Out The Accordion All Music
Singles on Demand
00:01:05 AFL Music $0.99
Feet & The Funky Beat! Gags Network Music Collection
2Rude4UTube Vol. 3
00:00:53 AFL Music $0.99
Strip-Teased Gags Network Music Collection
2Rude4UTube Vol. 4
00:00:48 AFL Music $0.99
Strip Stop Gags Network Music Collection
2Rude4UTube Vol. 2
00:01:05 AFL Music $0.99
Strippin' Good! Gags Network Music Collection
2Rude4UTube Vol. 4
00:01:00 AFL Music $0.99
Foxy Roxy Song Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:02:14 AFL Music $0.99
Scratchalicious! Gags Network Music Collection
2Rude4UTube Vol. 2
00:00:40 AFL Music $0.99
How The Funk Are Ya? Gags Network Music Collection
2Rude4UTube Vol. 1
00:00:43 AFL Music $0.99
Fun 'n' Horny Gags Network Music Collection
2Rude4UTube Vol. 1
00:00:47 AFL Music $0.99
Trip-Hop Gags Network Music Collection
2Rude4UTube Vol. 1
00:01:01 AFL Music $0.99
Minute Minuet Gags Network Music Collection
2Rude4UTube Vol. 1
00:00:51 AFL Music $0.99
Silly Stroll Gags Network Music Collection
2Rude4UTube Vol. 1
00:00:43 AFL Music $0.99
Strip It Off! Gags Network Music Collection
2Rude4UTube Vol. 4
00:01:07 AFL Music $0.99
Classical Cool All Music
Singles on Demand
00:00:47 AFL Music $0.99
Odessa-Mama Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:04:32 AFL Music $0.99