Anonymous

SELECT DISTINCT genre.name, artist.name, album.name FROM tags JOIN (genre, album, artist) ON (tags.artist=artist.id AND tags.genre=genre.id AND tags.album=album.id) WHERE 0=0 and artist.name IN ('', 'Magrudergrind', 'The Barbarians', 'Alton Ellis', 'The White Stripes', 'Annie', 'The Supremes', 'Desmond Dekker', 'D.B.'z', 'Johnny Cash & June Carter', 'Sally Shapiro', 'Ennio Morricone', 'Tokyo Police Club', 'Lorraine Ellison', 'Nina Simone', 'Unknown Artist', 'Sugababes', 'Shels', 'Coalesce', 'Aretha Franklin', 'Taint', 'Dionne Warwick', 'Roommate', 'Tiefschwarz Feat Tracey Thorn', 'Kavinsky', 'Justice', 'King Crimson', 'Lil' Wayne', 'L'Acephale', 'P.P. Arnold', 'Municipal Waste', 'Pelican', 'Toots And The Maytals', 'The Warriors', 'Led Zeppelin', 'Various Artists', 'Love', 'Intronaut', 'Ray Charles', 'Feadz', 'The Left Banke', 'Rosetta', 'Divine Heresy', 'France Gall', 'Simon & Garfunkel', 'Jefferson Airplane', 'Sir Richard Bishop', 'Royksopp', 'Coliseum', 'Hour of 13', 'Lil' Wayne & Young Money', 'Glen Campbell', 'Elvis Presley', 'Dead Serious', 'Nump', 'Wolves In The Throne Room', 'Mochipet', 'The Righteous Brothers', '? And The Mysterians', 'Truth Club', 'Dangers', 'Keak Da Sneak', 'Tyrannosaurus Rex', 'Danger', 'Dan Deacon', 'The Ronettes', 'Beastie Boys', 'New Young Pony Club', 'The Impressions', 'Roy Orbison', 'Datarock', 'Uffie', 'The Kinks', 'Albert Joseph', 'Charles Mingus', 'Matty G', 'Yung Joc', 'Van Morrison', 'One Be Lo', 'The Monkees', 'Jesu', 'My!gay!husband!', 'Alcest', 'The Walker Brothers', 'Ratatat', 'The Creation', 'The Byrds', 'Sky Balla', 'Del Shannon', 'Da Muzicianz', 'The Temptations', 'George Jones', 'Ghostface Killah', 'Messy Marv', 'The Team', 'The Stooges', 'Eskmo', 'Albert Ayler', 'Huey Lewis & The News', 'The Bobby Fuller Four', 'Drastik', 'Jackie Wilson', 'Darlene Love', 'Ike & Tina Turner', 'Holy Fuck', 'The Kingsmen', 'Chromeo', 'Balance', 'Stone Poneys', 'edIT', 'Neil Young', 'Creedence Clearwater Revival', 'Metric', 'Nick Drake', 'The Knife', 'Binary Star', 'Dusty Springfield', 'Mental Aardvarks', 'Neil Diamond', 'David Cross', 'Marc Ashken', 'Eskmo vs The Antiserum', 'Sam Cooke', 'Mr. Oizo', 'Cannonball Adderley', 'Rex the Dog', 'Gal Costa', 'Ignite', 'Frank Sinatra', 'Nancy Sinatra & Lee Hazlewood', 'The Association', 'The Angels', 'Emperor', 'Kinski', 'BBC Radiophonic Workshop', 'Dem Hoodstarz', 'The A'z', 'Birdman', 'Ion Dissonance', 'Sebastian', 'The Tammys', 'Weedeater', 'Dodheimsgard', 'DJUNYA', 'Cromagnon', 'Steve Reich', 'Stan Getz & João Gilberto', 'Fat Joe feat. R. Kelly, Lil' Wayne, T.I., Birdman, Rick Ross', 'A Wilhelm Scream', 'Bogdan Raczynski', 'flosstradamus', 'Albearrr', 'The Shangri-Las', 'Mistah F.A.B.', 'Marvin Gaye', 'Mac Dre', 'Lindstrom', 'unkle', 'The Flirtations', 'Os Mutantes', 'Smokey Robinson & The Miracles', 'Krazy Baldhead', 'Grails', 'M.I.A.', 'MSTRKRFT', 'The Four Tops', 'The Rolling Stones', 'D Program', 'Baroness', 'Mr Flash', 'The Paragons', 'Juliette Lewis', 'White Williams', 'Unpersons', 'The Beach Boys', 'DJ Mehdi', 'The Who', 'Paul Hamilton & Joseph Duarte', 'Phil Ochs', 'Eluvium', 'Stevie Wonder', 'Slint', 'Procol Harum', 'Buffalo Springfield', 'The Band', 'The Zombies', 'Otis Redding', 'Death From Above 1979', 'Tommy James & The Shondells', 'The Crystals', 'Lil Wayne', 'Nancy Sinatra', 'Caribou', 'Johnny Cash', 'Pink Floyd', 'Bembeya Jazz National', 'Kanye West', 'Archie Bell & The Drells', 'Kill Your Idols', 'Animosity', 'Busy P', 'Harry Nilsson', 'Xbxrx', 'T.I.', 'Serge Gainsbourg', 'Saviours', 'Ripple vs The Antiserum', 'Dirge', 'The Dixie Cups', 'Stephen O'malley & Atilla Csihar', 'Matthew Dear', 'The Hollies', 'Nurse With Wound', '13th Floor Elevators', 'California Love', 'Converge', 'Joakim', 'The Easybeats', 'The Cool Kids', 'Bobbie Gentry', 'Efterklang', 'Isley Brothers', 'Pola', 'Atomikdog', 'Whitehouse', 'Modern Life Is War', 'Dr. Delay', 'Savath & Savalas', 'Etta James', 'Outkast', 'Wu Tang Clan', 'Joanna Newsom', 'White Rainbow', 'Françoise Hardy', 'Juju', 'Mammoth Grinder', 'Babyface Assassins', 'Nico', 'Boys Noize', 'The Beatles', 'Bobby Darin', 'The Field', 'Merle Haggard', 'Tammy Wynette', 'Burial', 'Simian Mobile Disco', 'bone awl', 'Hot Chip', 'Om', 'DatA', 'Shook Ones', 'Gogol Bordello', 'SSS', 'Beneath The Massacre', 'David Bowie', 'Jason Anderson', 'Rockers Hi-Fi', 'End', 'Vicarious Bliss', 'the glitch mob', 'Sean Price', 'Spoon', 'Skream', 'Kyuss', 'Roxy Music', 'Shake Da Mayor', 'MC5', 'Miles Davis', 'ADULT.', 'The Foundations', 'The Austerity Program', 'Dick Dale & The Del-Tones', 'The Velvet Underground', 'Demetri Martin', 'Sam & Dave', 'Hummingbird Of Death', 'Vince Guaraldi Trio', 'James Brown', 'Diplo', 'Cursed', 'Brian Wilson', 'Jimi Hendrix', 'Muscles', 'Sly & The Family Stone', 'Bloodhorse', 'Bob Dylan', 'Irma Thomas', 'Liars', 'Midnight Juggernauts', 'Coliseum and Doomriders', 'Twisted Black', 'Ladytron', 'Mouth of the Architect & Kenoma', 'Leonard Cohen', 'MBZ', 'Unholy', 'Loretta Lynn', 'The Meters', 'Terry Riley', 'Scott Walker', 'Metro Area', 'Wessling & Schrom', 'Today Is The Day', 'Beirut', 'Silver Apples', 'Venetian Snares', 'John Coltrane', 'Donovan', 'The Sonics', 'Desmond Dekker & The Aces', 'The Jackson 5', 'DJ Monique Vs the Voice of Rita', 'The Shirelles', 'diplo & tripledoubl', 'Can', 'NIGHT HAWK', 'The Antiserum', 'The Ocean', 'E-40', 'Patsy Cline', 'Lemon Kittens', 'The Mamas & The Papas', 'The Monks', 'Ben E. King', 'Louis Armstrong', 'Klaxons', 'Furious', 'Steve Jansen', 'Bag Raiders', 'Zapper', 'David Axelrod', 'Daft Punk') ORDER BY genre.name, artist.name, album.name