По запросу
Сортировка
Gags Network Music Collection
2Rude4UTube Vol. 3
AFL Music
299 руб. купить
2Rude4UTube - это веселый комедийный сериал, состоящий из видеоклипов с участием реальных людей, которые ведут себя очень плохо на камеру.
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,
            music_subscriptions.`delimiter`,
            music_subscriptions.subscription_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) 
             RIGHT  JOIN music_subscriptions ON ( music_subscriptions.music_id = music.id )
            LEFT JOIN subscriptions ON ( music_subscriptions.subscription_id = subscriptions.id )
            WHERE 1
            AND UNIX_TIMESTAMP(music.datetime) < 1670320140
            AND (
            music.vis = 1
            OR music.vis IS NULL
            )
            
             AND music_subscriptions.subscription_id = 86  AND music.type_id = 1 
             ORDER BY music_subscriptions.sort 
            LIMIT 0, 20

Песня Альбом Время Лейбл Цена
Feet & The Funky Beat! 00:00:53 AFL Music 69 руб.
Funk-a-Licious! 00:00:38 AFL Music 69 руб.
Bluestastic 00:00:39 AFL Music 69 руб.
Just Twangin' Around 00:00:46 AFL Music 69 руб.
Sultry Casbah 00:00:40 AFL Music 69 руб.
Your Evening Blues 00:00:45 AFL Music 69 руб.
Red, White & Blues 00:01:01 AFL Music 69 руб.
Let's Take a Walk 00:00:58 AFL Music 69 руб.
Airing Out The Accordion 00:01:05 AFL Music 69 руб.
Meet The Gypsy Parents 00:00:52 AFL Music 69 руб.
Percussive Arabia 00:00:46 AFL Music 69 руб.