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) < 1713548760
            AND (
                music.vis = 1
             OR music.vis IS NULL
            )
                                                            
                                                            
            
             AND music.type_id = 2         
           ORDER BY music.views DESC 
          LIMIT 20, 20

Play / pause < previous > next SonReal - LAExplicit 0:00 / 0:00 volume Brahmstastic 2 Out Walking The Ducks 2 Surfin' 60's, A.D.D. Style 2 Saxy & Syncopated Jailhouse Crock 2 Yes Yes, Wah Wah 2 Silly Strings On The Farm Johnny B. Well-Behaved 1 Ooh-Wah! 1 Ooh-Wah! 2 Johnny B. Well-Behaved 2 Seriously Silly Surfin' 60's, A.D.D. Style 1 Goofy Gypsies 2 < previous > next TRY BEFORE YOU BUY!
	Ringtone	Сollection	Category	Time	Label	Price
Play / pause	Brahmstastic 2	Naked and Funny	Prankish	00:00:16	AFL Music	$0.69
Play / pause	Out Walking The Ducks 2	Naked and Funny	Cool	00:00:24	AFL Music	$0.69
Play / pause	Surfin' 60's, A.D.D. Style 2	Naked and Funny	Scary	00:00:35	AFL Music	$1.29
Play / pause	Saxy & Syncopated	Naked and Funny	Funny	00:00:28	AFL Music	$0.69
Play / pause	Jailhouse Crock 2	Naked and Funny	Crazy	00:00:28	AFL Music	$1.29
Play / pause	Yes Yes, Wah Wah 2	Naked and Funny	Amusing	00:00:13	AFL Music	$0.69
Play / pause	Silly Strings On The Farm	Naked and Funny	Funny	00:00:23	AFL Music	$0.69
Play / pause	Johnny B. Well-Behaved 1	Naked and Funny	Energetic	00:00:22	AFL Music	$0.69
Play / pause	Ooh-Wah! 1	Naked and Funny	Energetic	00:00:25	AFL Music	$0.99
Play / pause	Ooh-Wah! 2	Naked and Funny	Energetic	00:00:28	AFL Music	$1.29
Play / pause	Johnny B. Well-Behaved 2	Naked and Funny	Energetic	00:00:20	AFL Music	$0.69
Play / pause	Seriously Silly	Naked and Funny	Cool	00:00:30	AFL Music	$1.29
Play / pause	Surfin' 60's, A.D.D. Style 1	Naked and Funny	Scary	00:00:22	AFL Music	$0.99
Play / pause	Goofy Gypsies 2	Naked and Funny	Prankish	00:00:28	AFL Music	$0.69

• « Previous
• 1
• 2
• Next »