По запросу
Сортировка
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) < 1670323800
            AND (
            music.vis = 1
            OR music.vis IS NULL
            )
            
             AND music.type_id = 2         
             ORDER BY music.rating ASC 
            LIMIT 0, 20

Ringtone Сollection Category Time Label Price
La La La Love It 2 Naked and Funny Energetic 00:00:37 AFL Music 39 руб.
BACHannal 1 Naked and Funny Prankish 00:00:25 AFL Music 29 руб.
BACHannal 2 Naked and Funny Prankish 00:00:13 AFL Music 29 руб.
BACHannal 3 Naked and Funny Prankish 00:00:19 AFL Music 29 руб.
Brahmstastic 1 Naked and Funny Prankish 00:00:19 AFL Music 29 руб.
Brahmstastic 2 Naked and Funny Prankish 00:00:16 AFL Music 29 руб.
Johnny B. Well-Behaved 1 Naked and Funny Energetic 00:00:22 AFL Music 29 руб.
Johnny B. Well-Behaved 2 Naked and Funny Energetic 00:00:20 AFL Music 29 руб.
Goofy Gypsies 2 Naked and Funny Prankish 00:00:28 AFL Music 29 руб.
Out Walking The Ducks 1 Naked and Funny Cool  00:00:23 AFL Music 29 руб.
A Walk Around The Loony Bin Naked and Funny Cool  00:00:30 AFL Music 39 руб.
Seriously Silly Naked and Funny Cool  00:00:30 AFL Music 39 руб.
Surfin' 60's, A.D.D. Style 2 Naked and Funny Scary 00:00:35 AFL Music 39 руб.
Yes Yes, Wah Wah 1 Naked and Funny Amusing 00:00:14 AFL Music 29 руб.
Yes Yes, Wah Wah 2 Naked and Funny Amusing 00:00:13 AFL Music 29 руб.
Ooh-Wah! 1 Naked and Funny Energetic 00:00:25 AFL Music 29 руб.
Ooh-Wah! 2 Naked and Funny Energetic 00:00:28 AFL Music 39 руб.
Jazzy, Jaunty Jog 1 Naked and Funny Energetic 00:00:19 AFL Music 29 руб.
Jazzy, Jaunty Jog 2 Naked and Funny Energetic 00:00:19 AFL Music 29 руб.
Sha Ba Doo Bah 2 Naked and Funny Funny 00:00:27 AFL Music 69 руб.