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) < 1714003020
            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 60, 20

Play / pause < previous > next SonReal - LAExplicit 0:00 / 0:00 volume Reggae Granny! Love's Philosophy How Great Delight You & Me Lullaby The Task Is Over Let's Take a Walk Reggae Woman! She Walks In Beauty She Was a Phantom of Delight 7 Days With A Russian Beauty World Of Love Festival Song Police Patrol Rap Police Patrol. Turn On The Engine Sultry Casbah Red, White & Blues Springtime Fountain Life Is Good (I Got) Money in My Pocket < previous > next TRY BEFORE YOU BUY!
	Song	Album	Time	Label	Price
Play / pause	Reggae Granny!	All Music Singles on Demand	00:00:45	AFL Music	$0.99
Play / pause	Love's Philosophy	Yuri Volodarsky & Friends Revelation: All About Love	00:08:40	AFL Music	$1.49
Play / pause	How Great Delight	Yuri Volodarsky & Friends Revelation: All About Love	00:04:17	AFL Music	$1.49
Play / pause	You & Me	Yuri Volodarsky & Friends Hot Dozen (Audio Version)	00:01:43	AFL Music	$0.99
Play / pause	Lullaby	Yuri Volodarsky & Friends Hot Dozen (Audio Version)	00:03:49	AFL Music	$0.99
Play / pause	The Task Is Over	Yuri Volodarsky & Friends Hot Dozen (Audio Version)	00:04:07	AFL Music	$0.99
Play / pause	Let's Take a Walk	All Music Singles on Demand	00:00:58	AFL Music	$0.99
Play / pause	Reggae Woman!	All Music Singles on Demand	00:00:48	AFL Music	$0.99
Play / pause	She Walks In Beauty	Yuri Volodarsky & Friends Revelation: All About Love	00:02:47	AFL Music	$1.49
Play / pause	She Was a Phantom of Delight	Yuri Volodarsky & Friends Revelation: All About Love	00:05:48	AFL Music	$1.49
Play / pause	7 Days With A Russian Beauty	Yuri Volodarsky & Friends Hot Dozen (Audio Version)	00:01:53	AFL Music	$0.99
Play / pause	World Of Love	Yuri Volodarsky & Friends Hot Dozen (Audio Version)	00:03:01	AFL Music	$0.99
Play / pause	Festival Song	Yuri Volodarsky & Friends Hot Dozen (Audio Version)	00:02:23	AFL Music	$0.99
Play / pause	Police Patrol Rap	Yuri Volodarsky & Friends Hot Dozen (Audio Version)	00:03:26	AFL Music	$0.99
Play / pause	Police Patrol. Turn On The Engine	Yuri Volodarsky & Friends Hot Dozen (Audio Version)	00:03:50	AFL Music	$0.99
Play / pause	Sultry Casbah	All Music Singles on Demand	00:00:40	AFL Music	$0.99
Play / pause	Red, White & Blues	All Music Singles on Demand	00:01:01	AFL Music	$0.99
Play / pause	Springtime Fountain	Yuri Volodarsky & Friends Springtime Fountain (Single)	00:05:29	AFL Music	$2.99
Play / pause	Life Is Good	RTFACT Life Is Good (Full Album)	00:06:03	AFL Music	$1.99
Play / pause	(I Got) Money in My Pocket	RTFACT Life Is Good (Full Album)	00:06:12	AFL Music	$1.20

• « Previous
• 1
• 2
• 3
• 4
• 5
• Next »