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) < 1711638060
            AND (
                music.vis = 1
             OR music.vis IS NULL
            )
                                                            
                                                            
            
             AND music.type_id = 2  AND (music.duration > '00:00:15' AND music.duration < '00:00:30')         
           ORDER BY music.title_en ASC 
          LIMIT 0, 20

Ringtone Сollection Category Time Label Price
BACHannal 1 Naked and Funny Prankish 00:00:25 AFL Music $0.69
BACHannal 3 Naked and Funny Prankish 00:00:19 AFL Music $0.69
Brahmstastic 1 Naked and Funny Prankish 00:00:19 AFL Music $0.69
Brahmstastic 2 Naked and Funny Prankish 00:00:16 AFL Music $0.69
Goofy Gypsies 1 Naked and Funny Prankish 00:00:17 AFL Music $0.69
Goofy Gypsies 2 Naked and Funny Prankish 00:00:28 AFL Music $0.69
Jailhouse Crock 1 Naked and Funny Crazy 00:00:26 AFL Music $0.99
Jailhouse Crock 2 Naked and Funny Crazy 00:00:28 AFL Music $1.29
Jazzy, Jaunty Jog 1 Naked and Funny Energetic 00:00:19 AFL Music $0.69
Jazzy, Jaunty Jog 2 Naked and Funny Energetic 00:00:19 AFL Music $0.00
Johnny B. Well-Behaved 1 Naked and Funny Energetic 00:00:22 AFL Music $0.69
Johnny B. Well-Behaved 2 Naked and Funny Energetic 00:00:20 AFL Music $0.69
La La La Love It 1 Naked and Funny Energetic 00:00:18 AFL Music $0.69
Ooh-Wah! 1 Naked and Funny Energetic 00:00:25 AFL Music $0.99
Ooh-Wah! 2 Naked and Funny Energetic 00:00:28 AFL Music $1.29
Out Walking The Ducks 1 Naked and Funny Cool  00:00:23 AFL Music $0.69
Out Walking The Ducks 2 Naked and Funny Cool  00:00:24 AFL Music $0.69
Rock Around The Broken Digital Clock 1 Naked and Funny Crazy 00:00:26 AFL Music $0.69
Rock Around The Broken Digital Clock 2 Naked and Funny Crazy 00:00:21 AFL Music $0.69
Rock-A-Hillbilly Naked and Funny Crazy 00:00:22 AFL Music $0.69