Музыка
По запросу
Сортировка
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,
            subscriptions.name_en AS album_name,
            subscriptions.id AS album_id
            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)          
            LEFT JOIN music_subscriptions ON ( music_subscriptions.music_id = music.id )  
            LEFT JOIN subscriptions ON (subscriptions.id = music_subscriptions.subscription_id)
            WHERE 1
            AND UNIX_TIMESTAMP(music.datetime) < 1670324820
            AND (
            music.vis = 1
            OR music.vis IS NULL
            )
            AND music_subscriptions.subscription_id <> 38        
            AND subscriptions.music_album = 1 
            
                    
             ORDER BY music.rating ASC 
            LIMIT 0, 20

Песня 1 Album Time Label Price
Finger-Pickin' Good! Gags Network Music Collection
2Rude4UTube Vol. 1
00:00:48 AFL Music 69 руб.
Funk-a-Licious! Gags Network Music Collection
2Rude4UTube Vol. 3
00:00:38 AFL Music 69 руб.
Strippin' Good! Gags Network Music Collection
2Rude4UTube Vol. 4
00:01:00 AFL Music 69 руб.
Bluestastic Gags Network Music Collection
2Rude4UTube Vol. 3
00:00:39 AFL Music 69 руб.
Feet & The Funky Beat! Gags Network Music Collection
2Rude4UTube Vol. 3
00:00:53 AFL Music 69 руб.
Jailhouse Crock Gags Network Music Collection
Naked and Funny Vol. 1
00:01:57 AFL Music 69 руб.
Ooh-Wah! Gags Network Music Collection
Naked and Funny Vol. 1
00:01:46 AFL Music 69 руб.
Out Walking The Ducks Gags Network Music Collection
Naked and Funny Vol. 1
00:01:56 AFL Music 69 руб.
Jazzy, Jaunty Jog Gags Network Music Collection
Naked and Funny Vol. 1
00:02:12 AFL Music 69 руб.
Classically Chill Gags Network Music Collection
2Rude4UTube Vol. 4
00:00:31 AFL Music 69 руб.
Sha Ba Doo Bah Gags Network Music Collection
Naked and Funny Vol. 1
00:02:31 AFL Music 69 руб.
Scratchalicious! Gags Network Music Collection
2Rude4UTube Vol. 2
00:00:40 AFL Music 69 руб.
Foxy Roxy Song Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:02:14 AFL Music 69 руб.
Strip-Teased Gags Network Music Collection
2Rude4UTube Vol. 4
00:00:48 AFL Music 69 руб.
How The Funk Are Ya? Gags Network Music Collection
2Rude4UTube Vol. 1
00:00:43 AFL Music 69 руб.
Trip-Hop Gags Network Music Collection
2Rude4UTube Vol. 1
00:01:01 AFL Music 69 руб.
There Goes The Bride Gags Network Music Collection
2Rude4UTube Vol. 1
00:00:41 AFL Music 69 руб.
Minute Minuet Gags Network Music Collection
2Rude4UTube Vol. 1
00:00:51 AFL Music 69 руб.
Metalic-Ahhh! Gags Network Music Collection
2Rude4UTube Vol. 1
00:00:41 AFL Music 69 руб.
Silly Stroll Gags Network Music Collection
2Rude4UTube Vol. 1
00:00:43 AFL Music 69 руб.