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) < 1544836740
            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 0, 20

Song Album Time Label Price
A Walk Around The Loony Bin All Music
Singles on Demand
00:02:07 AFL Music $0.99
Jazzy, Jaunty Jog Gags Network Music Collection
Naked and Funny Vol. 1
00:02:12 AFL Music $0.00
La La La Love It Gags Network Music Collection
Naked and Funny Vol. 1
00:01:54 AFL Music $0.99
Sha Ba Doo Bah Gags Network Music Collection
Naked and Funny Vol. 1
00:02:31 AFL Music $0.99
Classically Kooky Gags Network Music Collection
Naked and Funny Vol. 1
00:01:50 AFL Music $0.99
Saxy & Syncopated Gags Network Music Collection
Naked and Funny Vol. 1
00:01:33 AFL Music $0.99
Johnny B. Well-Behaved All Music
Singles on Demand
00:01:59 AFL Music $0.99
Out Walking The Ducks Gags Network Music Collection
Naked and Funny Vol. 1
00:01:56 AFL Music $0.99
Surfin' 60's, A.D.D. Style All Music
Singles on Demand
00:01:56 AFL Music $0.99
Rock-A-Hillbilly Gags Network Music Collection
Naked and Funny Vol. 1
00:01:20 AFL Music $0.99
BACHannal All Music
Singles on Demand
00:02:03 AFL Music $0.99
Brahmstastic All Music
Singles on Demand
00:01:59 AFL Music $0.99
Rock Around The Broken Digital Clock All Music
Singles on Demand
00:02:02 AFL Music $0.99
Seriously Silly All Music
Singles on Demand
00:02:23 AFL Music $0.99
Who's Yer Saxy Friend Gags Network Music Collection
Naked and Funny Vol. 1
00:01:55 AFL Music $0.99
Goofy Gypsies All Music
Singles on Demand
00:02:13 AFL Music $0.99
Ooh-Wah! Gags Network Music Collection
Naked and Funny Vol. 1
00:01:46 AFL Music $0.99
Jailhouse Crock Gags Network Music Collection
Naked and Funny Vol. 1
00:01:57 AFL Music $0.99
Silly Strings On The Farm All Music
Singles on Demand
00:01:49 AFL Music $0.99
Yes Yes, Wah Wah All Music
Singles on Demand
00:01:35 AFL Music $0.99