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

Song Time Label Price
Red, White & Blues 00:01:01 AFL Music $0.99
Reggae Child! 00:00:43 AFL Music $0.99
Reggae Granny! 00:00:45 AFL Music $0.99
Reggae Mon! 00:00:48 AFL Music $0.99
Reggae Woman! 00:00:48 AFL Music $0.99
Retribution 00:07:15 AFL Music $1.29
Rock Around The Broken Digital Clock 00:02:02 AFL Music $0.99
Scratchalicious! 00:00:40 AFL Music $0.99
Scratchtastic! 00:00:46 AFL Music $0.99
Seriously Silly 00:02:23 AFL Music $0.99
Seriously Silly 00:00:30 AFL Music $1.29
Sha Ba Doo Bah 00:02:31 AFL Music $0.99
Shadow Of Love 00:07:05 AFL Music $1.29
She Walks In Beauty 00:02:47 AFL Music $1.49
She Was a Phantom of Delight 00:05:48 AFL Music $1.49
Silly Stroll 00:00:43 AFL Music $0.99
Sonnet 116 00:05:37 AFL Music $1.49
South Wind 00:04:49 AFL Music $1.29
Springtime Fountain 00:08:31 AFL Music $1.29
Springtime Fountain 00:05:29 AFL Music $2.99