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)
                   
          WHERE 1
            AND UNIX_TIMESTAMP(music.datetime) < 1713570000
            AND (
                music.vis = 1
             OR music.vis IS NULL
            )
                                                            
                                                            
            
             AND music.category_id = 4  AND music.type_id = 2         
           ORDER BY music.views DESC 
          LIMIT 0, 20

Play / pause < previous > next SonReal - LAExplicit 0:00 / 0:00 volume Rock Around The Broken Digital Clock 1 Rock Around The Broken Digital Clock 2 Jailhouse Crock 1 Rock-A-Hillbilly Jailhouse Crock 2 < previous > next TRY BEFORE YOU BUY!
	Ringtone	Сollection	Category	Time	Label	Price
Play / pause	Rock Around The Broken Digital Clock 1	Naked and Funny	Crazy	00:00:26	AFL Music	$0.69
Play / pause	Rock Around The Broken Digital Clock 2	Naked and Funny	Crazy	00:00:21	AFL Music	$0.69
Play / pause	Jailhouse Crock 1	Naked and Funny	Crazy	00:00:26	AFL Music	$0.99
Play / pause	Rock-A-Hillbilly	Naked and Funny	Crazy	00:00:22	AFL Music	$0.69
Play / pause	Jailhouse Crock 2	Naked and Funny	Crazy	00:00:28	AFL Music	$1.29