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) < 1558287840
                    AND (
                        music.vis = 1
                     OR music.vis IS NULL
                    )
                    AND music_subscriptions.subscription_id <> 38        
                    AND subscriptions.music_album = 1 
                    
                     AND music.category_id = 7         
                   ORDER BY music.rating ASC 
                  LIMIT 0, 20

Song Album Time Label Price
BACHannal 1 Gags Network Ringtone Collection Vol. 1 00:00:25 AFL Music $0.99
BACHannal 2 Gags Network Ringtone Collection Vol. 1 00:00:13 AFL Music $0.69
BACHannal 3 Gags Network Ringtone Collection Vol. 1 00:00:19 AFL Music $0.69
Brahmstastic 1 Gags Network Ringtone Collection Vol. 1 00:00:19 AFL Music $0.69
Brahmstastic 2 Gags Network Ringtone Collection Vol. 1 00:00:16 AFL Music $0.69
Goofy Gypsies 2 Gags Network Ringtone Collection Vol. 2 00:00:28 AFL Music $1.29
Goofy Gypsies 1 Gags Network Ringtone Collection Vol. 2 00:00:17 AFL Music $0.69