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) < 1710829140
            AND (
                music.vis = 1
             OR music.vis IS NULL
            )
                                                            
                                                            
            
                    
           ORDER BY music.title_en ASC 
          LIMIT 0, 20

Song Time Label Price
(I Got) Money in My Pocket 00:06:12 AFL Music $1.20
7 Days With A Russian Beauty 00:01:53 AFL Music $0.99
A Walk Around The Loony Bin 00:02:07 AFL Music $0.99
A Walk Around The Loony Bin 00:00:30 AFL Music $1.29
Adrenaline 00:04:22 AFL Music $1.29
Airing Out The Accordion 00:01:05 AFL Music $0.99
Amarea Omaya 00:06:00 AFL Music $1.29
Amblin' Stroll 00:01:32 AFL Music $0.99
Animal Wars (Medley) 00:05:14 AFL Music $1.29
Artifact 00:06:24 AFL Music $1.29
Artifact 00:06:23 AFL Music $1.20
BACHannal 00:02:03 AFL Music $0.99
BACHannal 1 00:00:25 AFL Music $0.69
BACHannal 2 00:00:13 AFL Music $0.69
BACHannal 3 00:00:19 AFL Music $0.69
Bluestastic 00:00:39 AFL Music $0.99
Brahmstastic 00:01:59 AFL Music $0.99
Brahmstastic 1 00:00:19 AFL Music $0.69
Brahmstastic 2 00:00:16 AFL Music $0.69
Bright Star 00:06:05 AFL Music $1.49