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)
          RIGHT JOIN music_subscriptions ON ( music_subscriptions.music_id = music.id )         
          WHERE 1
            AND UNIX_TIMESTAMP(music.datetime) < 1711620780
            AND (
                music.vis = 1
             OR music.vis IS NULL
            )
             AND music_subscriptions.subscription_id <> 48                                                 
             AND music_subscriptions.subscription_id <> 49                                                 
            
             AND music.category_id = 5  AND music.type_id = 1  AND (music.duration > '00:01:00')         
           ORDER BY music.rating DESC, music.title_en ASC 
          LIMIT 0, 20

Song Album Time Label Price
(I Got) Money in My Pocket RTFACT
Life Is Good (Full Album)
00:06:12 AFL Music $1.20
7 Days With A Russian Beauty Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:01:53 AFL Music $0.99
Artifact RTFACT
Life Is Good (Full Album)
00:06:23 AFL Music $1.20
Festival Song Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:02:23 AFL Music $0.99
Foxy Roxy Song Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:02:14 AFL Music $0.99
Gotika RTFACT
Life Is Good (Full Album)
00:05:02 AFL Music $1.20
Hail to the Winner (Part I) RTFACT
Life Is Good (Full Album)
00:03:35 AFL Music $1.20
Hail to the Winner. (Part II. Tarantella) RTFACT
Life Is Good (Full Album)
00:03:28 AFL Music $1.20
Hollywood Walk of Fame RTFACT
Life Is Good (Full Album)
00:06:02 AFL Music $1.20
Life Is Good RTFACT
Life Is Good (Full Album)
00:06:03 AFL Music $1.99
Life Is Good (remix) RTFACT
Life Is Good (Full Album)
00:01:15 AFL Music $1.00
Lullaby Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:03:49 AFL Music $0.99
Maski Rap-Down Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:03:33 AFL Music $0.99
Mephistopheles' Couplets Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:02:13 AFL Music $0.99
Odessa-Mama Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:04:32 AFL Music $0.99
Police Patrol Rap Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:03:26 AFL Music $0.99
Police Patrol. Turn On The Engine Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:03:50 AFL Music $0.99
The King, the Master, and the Timekeeper RTFACT
Life Is Good (Full Album)
00:04:30 AFL Music $1.20
The Task Is Over Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:04:07 AFL Music $0.99
World Of Love Yuri Volodarsky & Friends
Hot Dozen (Audio Version)
00:03:01 AFL Music $0.99