mysql> describe artist;
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | YES | MUL | NULL | |
+-------+--------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql> describe tags;
+------------+----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+----------------+------+-----+---------+-------+
| url | varbinary(255) | YES | MUL | NULL | |
| dir | varbinary(255) | YES | | NULL | |
| createdate | int(11) | YES | | NULL | |
| modifydate | int(11) | YES | | NULL | |
| album | int(11) | YES | MUL | NULL | |
| artist | int(11) | YES | MUL | NULL | |
| composer | int(11) | YES | MUL | NULL | |
| genre | int(11) | YES | MUL | NULL | |
| title | varchar(255) | YES | | NULL | |
| year | int(11) | YES | MUL | NULL | |
| comment | text | YES | | NULL | |
| track | decimal(4,0) | YES | | NULL | |
| discnumber | int(11) | YES | | NULL | |
| bitrate | int(11) | YES | | NULL | |
| length | int(11) | YES | | NULL | |
| samplerate | int(11) | YES | | NULL | |
| filesize | int(11) | YES | | NULL | |
| filetype | int(11) | YES | | NULL | |
| sampler | tinyint(1) | YES | MUL | NULL | |
| bpm | float | YES | | NULL | |
| deviceid | int(11) | YES | MUL | NULL | |
+------------+----------------+------+-----+---------+-------+
21 rows in set (0.01 sec)
mysql> describe related_artists;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| artist | varchar(255) | YES | MUL | NULL | |
| suggestion | varchar(255) | YES | | NULL | |
| changedate | int(11) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
3 rows in set (0.01 sec)
mysql> select a.title, b.name, c.suggestion from (tags as a left join artist as b on a.artist=b.id) left join related_artists as c on b.name=c.artist where b.name='Metric';
+----------------------------+--------+----------------------------------+
| title | name | suggestion |
+----------------------------+--------+----------------------------------+
| I.O.U. | Metric | Stars |
| I.O.U. | Metric | Broken Social Scene |
| I.O.U. | Metric | Tegan and Sara |
| I.O.U. | Metric | Rilo Kiley |
| I.O.U. | Metric | Yeah Yeah Yeahs |
| I.O.U. | Metric | The Arcade Fire |
| I.O.U. | Metric | The New Pornographers |
| I.O.U. | Metric | The Shins |
| I.O.U. | Metric | Wolf Parade |
| I.O.U. | Metric | Feist |
| I.O.U. | Metric | Death Cab for Cutie |
| I.O.U. | Metric | The Decemberists |
| I.O.U. | Metric | Death From Above 1979 |
| I.O.U. | Metric | of Montreal |
| I.O.U. | Metric | Spoon |
| I.O.U. | Metric | The Unicorns |
| I.O.U. | Metric | Bloc Party |
| I.O.U. | Metric | Modest Mouse |
| I.O.U. | Metric | Hot Hot Heat |
| I.O.U. | Metric | Interpol |
| I.O.U. | Metric | Architecture in Helsinki |
| I.O.U. | Metric | Belle and Sebastian |
| I.O.U. | Metric | Clap Your Hands Say Yeah |
| I.O.U. | Metric | Le Tigre |
| I.O.U. | Metric | The Stills |
| I.O.U. | Metric | Blonde Redhead |
| I.O.U. | Metric | The Postal Service |
| I.O.U. | Metric | Mates of State |
| I.O.U. | Metric | Emily Haines & the Soft Skeleton |
| I.O.U. | Metric | Pretty Girls Make Graves |
| Dead Disco | Metric | Stars |
| Dead Disco | Metric | Broken Social Scene |
| Dead Disco | Metric | Tegan and Sara |
| Dead Disco | Metric | Rilo Kiley |
| Dead Disco | Metric | Yeah Yeah Yeahs |
| Dead Disco | Metric | The Arcade Fire |
| Dead Disco | Metric | The New Pornographers |
| Dead Disco | Metric | The Shins |
| Dead Disco | Metric | Wolf Parade |
| Dead Disco | Metric | Feist |
| Dead Disco | Metric | Death Cab for Cutie |
| Dead Disco | Metric | The Decemberists |
| Dead Disco | Metric | Death From Above 1979 |
| Dead Disco | Metric | of Montreal |
| Dead Disco | Metric | Spoon |
| Dead Disco | Metric | The Unicorns |
| Dead Disco | Metric | Bloc Party |
| Dead Disco | Metric | Modest Mouse |
| Dead Disco | Metric | Hot Hot Heat |
| Dead Disco | Metric | Interpol |
| Dead Disco | Metric | Architecture in Helsinki |
| Dead Disco | Metric | Belle and Sebastian |
| Dead Disco | Metric | Clap Your Hands Say Yeah |
| Dead Disco | Metric | Le Tigre |
| Dead Disco | Metric | The Stills |
| Dead Disco | Metric | Blonde Redhead |
| Dead Disco | Metric | The Postal Service |
| Dead Disco | Metric | Mates of State |
| Dead Disco | Metric | Emily Haines & the Soft Skeleton |
| Dead Disco | Metric | Pretty Girls Make Graves |
| Wet Blanket | Metric | Stars |
| Wet Blanket | Metric | Broken Social Scene |
| Wet Blanket | Metric | Tegan and Sara |
| Wet Blanket | Metric | Rilo Kiley |
| Wet Blanket | Metric | Yeah Yeah Yeahs |
| Wet Blanket | Metric | The Arcade Fire |
| Wet Blanket | Metric | The New Pornographers |
| Wet Blanket | Metric | The Shins |
| Wet Blanket | Metric | Wolf Parade |
| Wet Blanket | Metric | Feist |
| Wet Blanket | Metric | Death Cab for Cutie |
| Wet Blanket | Metric | The Decemberists |
| Wet Blanket | Metric | Death From Above 1979 |
| Wet Blanket | Metric | of Montreal |
| Wet Blanket | Metric | Spoon |
| Wet Blanket | Metric | The Unicorns |
| Wet Blanket | Metric | Bloc Party |
| Wet Blanket | Metric | Modest Mouse |
| Wet Blanket | Metric | Hot Hot Heat |
| Wet Blanket | Metric | Interpol |
| Wet Blanket | Metric | Architecture in Helsinki |
| Wet Blanket | Metric | Belle and Sebastian |
| Wet Blanket | Metric | Clap Your Hands Say Yeah |
| Wet Blanket | Metric | Le Tigre |
| Wet Blanket | Metric | The Stills |
| Wet Blanket | Metric | Blonde Redhead |
| Wet Blanket | Metric | The Postal Service |
| Wet Blanket | Metric | Mates of State |
| Wet Blanket | Metric | Emily Haines & the Soft Skeleton |
| Wet Blanket | Metric | Pretty Girls Make Graves |
| Calculation Theme | Metric | Stars |
| Calculation Theme | Metric | Broken Social Scene |
| Calculation Theme | Metric | Tegan and Sara |
| Calculation Theme | Metric | Rilo Kiley |
| Calculation Theme | Metric | Yeah Yeah Yeahs |
| Calculation Theme | Metric | The Arcade Fire |
| Calculation Theme | Metric | The New Pornographers |
| Calculation Theme | Metric | The Shins |
| Calculation Theme | Metric | Wolf Parade |
| Calculation Theme | Metric | Feist |
| Calculation Theme | Metric | Death Cab for Cutie |
| Calculation Theme | Metric | The Decemberists |
| Calculation Theme | Metric | Death From Above 1979 |
| Calculation Theme | Metric | of Montreal |
| Calculation Theme | Metric | Spoon |
| Calculation Theme | Metric | The Unicorns |
| Calculation Theme | Metric | Bloc Party |
| Calculation Theme | Metric | Modest Mouse |
| Calculation Theme | Metric | Hot Hot Heat |
| Calculation Theme | Metric | Interpol |
| Calculation Theme | Metric | Architecture in Helsinki |
| Calculation Theme | Metric | Belle and Sebastian |
| Calculation Theme | Metric | Clap Your Hands Say Yeah |
| Calculation Theme | Metric | Le Tigre |
| Calculation Theme | Metric | The Stills |
| Calculation Theme | Metric | Blonde Redhead |
| Calculation Theme | Metric | The Postal Service |
| Calculation Theme | Metric | Mates of State |
| Calculation Theme | Metric | Emily Haines & the Soft Skeleton |
| Calculation Theme | Metric | Pretty Girls Make Graves |
| Love Is A Place | Metric | Stars |
| Love Is A Place | Metric | Broken Social Scene |
| Love Is A Place | Metric | Tegan and Sara |
| Love Is A Place | Metric | Rilo Kiley |
| Love Is A Place | Metric | Yeah Yeah Yeahs |
| Love Is A Place | Metric | The Arcade Fire |
| Love Is A Place | Metric | The New Pornographers |
| Love Is A Place | Metric | The Shins |
| Love Is A Place | Metric | Wolf Parade |
| Love Is A Place | Metric | Feist |
| Love Is A Place | Metric | Death Cab for Cutie |
| Love Is A Place | Metric | The Decemberists |
| Love Is A Place | Metric | Death From Above 1979 |
| Love Is A Place | Metric | of Montreal |
| Love Is A Place | Metric | Spoon |
| Love Is A Place | Metric | The Unicorns |
| Love Is A Place | Metric | Bloc Party |
| Love Is A Place | Metric | Modest Mouse |
| Love Is A Place | Metric | Hot Hot Heat |
| Love Is A Place | Metric | Interpol |
| Love Is A Place | Metric | Architecture in Helsinki |
| Love Is A Place | Metric | Belle and Sebastian |
| Love Is A Place | Metric | Clap Your Hands Say Yeah |
| Love Is A Place | Metric | Le Tigre |
| Love Is A Place | Metric | The Stills |
| Love Is A Place | Metric | Blonde Redhead |
| Love Is A Place | Metric | The Postal Service |
| Love Is A Place | Metric | Mates of State |
| Love Is A Place | Metric | Emily Haines & the Soft Skeleton |
| Love Is A Place | Metric | Pretty Girls Make Graves |
| The List | Metric | Stars |
| The List | Metric | Broken Social Scene |
| The List | Metric | Tegan and Sara |
| The List | Metric | Rilo Kiley |
| The List | Metric | Yeah Yeah Yeahs |
| The List | Metric | The Arcade Fire |
| The List | Metric | The New Pornographers |
| The List | Metric | The Shins |
| The List | Metric | Wolf Parade |
| The List | Metric | Feist |
| The List | Metric | Death Cab for Cutie |
| The List | Metric | The Decemberists |
| The List | Metric | Death From Above 1979 |
| The List | Metric | of Montreal |
| The List | Metric | Spoon |
| The List | Metric | The Unicorns |
| The List | Metric | Bloc Party |
| The List | Metric | Modest Mouse |
| The List | Metric | Hot Hot Heat |
| The List | Metric | Interpol |
| The List | Metric | Architecture in Helsinki |
| The List | Metric | Belle and Sebastian |
| The List | Metric | Clap Your Hands Say Yeah |
| The List | Metric | Le Tigre |
| The List | Metric | The Stills |
| The List | Metric | Blonde Redhead |
| The List | Metric | The Postal Service |
| The List | Metric | Mates of State |
| The List | Metric | Emily Haines & the Soft Skeleton |
| The List | Metric | Pretty Girls Make Graves |
| Combat Baby | Metric | Stars |
| Combat Baby | Metric | Broken Social Scene |
| Combat Baby | Metric | Tegan and Sara |
| Combat Baby | Metric | Rilo Kiley |
| Combat Baby | Metric | Yeah Yeah Yeahs |
| Combat Baby | Metric | The Arcade Fire |
| Combat Baby | Metric | The New Pornographers |
| Combat Baby | Metric | The Shins |
| Combat Baby | Metric | Wolf Parade |
| Combat Baby | Metric | Feist |
| Combat Baby | Metric | Death Cab for Cutie |
| Combat Baby | Metric | The Decemberists |
| Combat Baby | Metric | Death From Above 1979 |
| Combat Baby | Metric | of Montreal |
| Combat Baby | Metric | Spoon |
| Combat Baby | Metric | The Unicorns |
| Combat Baby | Metric | Bloc Party |
| Combat Baby | Metric | Modest Mouse |
| Combat Baby | Metric | Hot Hot Heat |
| Combat Baby | Metric | Interpol |
| Combat Baby | Metric | Architecture in Helsinki |
| Combat Baby | Metric | Belle and Sebastian |
| Combat Baby | Metric | Clap Your Hands Say Yeah |
| Combat Baby | Metric | Le Tigre |
| Combat Baby | Metric | The Stills |
| Combat Baby | Metric | Blonde Redhead |
| Combat Baby | Metric | The Postal Service |
| Combat Baby | Metric | Mates of State |
| Combat Baby | Metric | Emily Haines & the Soft Skeleton |
| Combat Baby | Metric | Pretty Girls Make Graves |
| Hustle Rose | Metric | Stars |
| Hustle Rose | Metric | Broken Social Scene |
| Hustle Rose | Metric | Tegan and Sara |
| Hustle Rose | Metric | Rilo Kiley |
| Hustle Rose | Metric | Yeah Yeah Yeahs |
| Hustle Rose | Metric | The Arcade Fire |
| Hustle Rose | Metric | The New Pornographers |
| Hustle Rose | Metric | The Shins |
| Hustle Rose | Metric | Wolf Parade |
| Hustle Rose | Metric | Feist |
| Hustle Rose | Metric | Death Cab for Cutie |
| Hustle Rose | Metric | The Decemberists |
| Hustle Rose | Metric | Death From Above 1979 |
| Hustle Rose | Metric | of Montreal |
| Hustle Rose | Metric | Spoon |
| Hustle Rose | Metric | The Unicorns |
| Hustle Rose | Metric | Bloc Party |
| Hustle Rose | Metric | Modest Mouse |
| Hustle Rose | Metric | Hot Hot Heat |
| Hustle Rose | Metric | Interpol |
| Hustle Rose | Metric | Architecture in Helsinki |
| Hustle Rose | Metric | Belle and Sebastian |
| Hustle Rose | Metric | Clap Your Hands Say Yeah |
| Hustle Rose | Metric | Le Tigre |
| Hustle Rose | Metric | The Stills |
| Hustle Rose | Metric | Blonde Redhead |
| Hustle Rose | Metric | The Postal Service |
| Hustle Rose | Metric | Mates of State |
| Hustle Rose | Metric | Emily Haines & the Soft Skeleton |
| Hustle Rose | Metric | Pretty Girls Make Graves |
| Succexy | Metric | Stars |
| Succexy | Metric | Broken Social Scene |
| Succexy | Metric | Tegan and Sara |
| Succexy | Metric | Rilo Kiley |
| Succexy | Metric | Yeah Yeah Yeahs |
| Succexy | Metric | The Arcade Fire |
| Succexy | Metric | The New Pornographers |
| Succexy | Metric | The Shins |
| Succexy | Metric | Wolf Parade |
| Succexy | Metric | Feist |
| Succexy | Metric | Death Cab for Cutie |
| Succexy | Metric | The Decemberists |
| Succexy | Metric | Death From Above 1979 |
| Succexy | Metric | of Montreal |
| Succexy | Metric | Spoon |
| Succexy | Metric | The Unicorns |
| Succexy | Metric | Bloc Party |
| Succexy | Metric | Modest Mouse |
| Succexy | Metric | Hot Hot Heat |
| Succexy | Metric | Interpol |
| Succexy | Metric | Architecture in Helsinki |
| Succexy | Metric | Belle and Sebastian |
| Succexy | Metric | Clap Your Hands Say Yeah |
| Succexy | Metric | Le Tigre |
| Succexy | Metric | The Stills |
| Succexy | Metric | Blonde Redhead |
| Succexy | Metric | The Postal Service |
| Succexy | Metric | Mates of State |
| Succexy | Metric | Emily Haines & the Soft Skeleton |
| Succexy | Metric | Pretty Girls Make Graves |
| On A Slow Night | Metric | Stars |
| On A Slow Night | Metric | Broken Social Scene |
| On A Slow Night | Metric | Tegan and Sara |
| On A Slow Night | Metric | Rilo Kiley |
| On A Slow Night | Metric | Yeah Yeah Yeahs |
| On A Slow Night | Metric | The Arcade Fire |
| On A Slow Night | Metric | The New Pornographers |
| On A Slow Night | Metric | The Shins |
| On A Slow Night | Metric | Wolf Parade |
| On A Slow Night | Metric | Feist |
| On A Slow Night | Metric | Death Cab for Cutie |
| On A Slow Night | Metric | The Decemberists |
| On A Slow Night | Metric | Death From Above 1979 |
| On A Slow Night | Metric | of Montreal |
| On A Slow Night | Metric | Spoon |
| On A Slow Night | Metric | The Unicorns |
| On A Slow Night | Metric | Bloc Party |
| On A Slow Night | Metric | Modest Mouse |
| On A Slow Night | Metric | Hot Hot Heat |
| On A Slow Night | Metric | Interpol |
| On A Slow Night | Metric | Architecture in Helsinki |
| On A Slow Night | Metric | Belle and Sebastian |
| On A Slow Night | Metric | Clap Your Hands Say Yeah |
| On A Slow Night | Metric | Le Tigre |
| On A Slow Night | Metric | The Stills |
| On A Slow Night | Metric | Blonde Redhead |
| On A Slow Night | Metric | The Postal Service |
| On A Slow Night | Metric | Mates of State |
| On A Slow Night | Metric | Emily Haines & the Soft Skeleton |
| On A Slow Night | Metric | Pretty Girls Make Graves |
| Siamese Cities | Metric | Stars |
| Siamese Cities | Metric | Broken Social Scene |
| Siamese Cities | Metric | Tegan and Sara |
| Siamese Cities | Metric | Rilo Kiley |
| Siamese Cities | Metric | Yeah Yeah Yeahs |
| Siamese Cities | Metric | The Arcade Fire |
| Siamese Cities | Metric | The New Pornographers |
| Siamese Cities | Metric | The Shins |
| Siamese Cities | Metric | Wolf Parade |
| Siamese Cities | Metric | Feist |
| Siamese Cities | Metric | Death Cab for Cutie |
| Siamese Cities | Metric | The Decemberists |
| Siamese Cities | Metric | Death From Above 1979 |
| Siamese Cities | Metric | of Montreal |
| Siamese Cities | Metric | Spoon |
| Siamese Cities | Metric | The Unicorns |
| Siamese Cities | Metric | Bloc Party |
| Siamese Cities | Metric | Modest Mouse |
| Siamese Cities | Metric | Hot Hot Heat |
| Siamese Cities | Metric | Interpol |
| Siamese Cities | Metric | Architecture in Helsinki |
| Siamese Cities | Metric | Belle and Sebastian |
| Siamese Cities | Metric | Clap Your Hands Say Yeah |
| Siamese Cities | Metric | Le Tigre |
| Siamese Cities | Metric | The Stills |
| Siamese Cities | Metric | Blonde Redhead |
| Siamese Cities | Metric | The Postal Service |
| Siamese Cities | Metric | Mates of State |
| Siamese Cities | Metric | Emily Haines & the Soft Skeleton |
| Siamese Cities | Metric | Pretty Girls Make Graves |
| The Twist | Metric | Stars |
| The Twist | Metric | Broken Social Scene |
| The Twist | Metric | Tegan and Sara |
| The Twist | Metric | Rilo Kiley |
| The Twist | Metric | Yeah Yeah Yeahs |
| The Twist | Metric | The Arcade Fire |
| The Twist | Metric | The New Pornographers |
| The Twist | Metric | The Shins |
| The Twist | Metric | Wolf Parade |
| The Twist | Metric | Feist |
| The Twist | Metric | Death Cab for Cutie |
| The Twist | Metric | The Decemberists |
| The Twist | Metric | Death From Above 1979 |
| The Twist | Metric | of Montreal |
| The Twist | Metric | Spoon |
| The Twist | Metric | The Unicorns |
| The Twist | Metric | Bloc Party |
| The Twist | Metric | Modest Mouse |
| The Twist | Metric | Hot Hot Heat |
| The Twist | Metric | Interpol |
| The Twist | Metric | Architecture in Helsinki |
| The Twist | Metric | Belle and Sebastian |
| The Twist | Metric | Clap Your Hands Say Yeah |
| The Twist | Metric | Le Tigre |
| The Twist | Metric | The Stills |
| The Twist | Metric | Blonde Redhead |
| The Twist | Metric | The Postal Service |
| The Twist | Metric | Mates of State |
| The Twist | Metric | Emily Haines & the Soft Skeleton |
| The Twist | Metric | Pretty Girls Make Graves |
| London Halflife | Metric | Stars |
| London Halflife | Metric | Broken Social Scene |
| London Halflife | Metric | Tegan and Sara |
| London Halflife | Metric | Rilo Kiley |
| London Halflife | Metric | Yeah Yeah Yeahs |
| London Halflife | Metric | The Arcade Fire |
| London Halflife | Metric | The New Pornographers |
| London Halflife | Metric | The Shins |
| London Halflife | Metric | Wolf Parade |
| London Halflife | Metric | Feist |
| London Halflife | Metric | Death Cab for Cutie |
| London Halflife | Metric | The Decemberists |
| London Halflife | Metric | Death From Above 1979 |
| London Halflife | Metric | of Montreal |
| London Halflife | Metric | Spoon |
| London Halflife | Metric | The Unicorns |
| London Halflife | Metric | Bloc Party |
| London Halflife | Metric | Modest Mouse |
| London Halflife | Metric | Hot Hot Heat |
| London Halflife | Metric | Interpol |
| London Halflife | Metric | Architecture in Helsinki |
| London Halflife | Metric | Belle and Sebastian |
| London Halflife | Metric | Clap Your Hands Say Yeah |
| London Halflife | Metric | Le Tigre |
| London Halflife | Metric | The Stills |
| London Halflife | Metric | Blonde Redhead |
| London Halflife | Metric | The Postal Service |
| London Halflife | Metric | Mates of State |
| London Halflife | Metric | Emily Haines & the Soft Skeleton |
| London Halflife | Metric | Pretty Girls Make Graves |
| Raw Sugar | Metric | Stars |
| Raw Sugar | Metric | Broken Social Scene |
| Raw Sugar | Metric | Tegan and Sara |
| Raw Sugar | Metric | Rilo Kiley |
| Raw Sugar | Metric | Yeah Yeah Yeahs |
| Raw Sugar | Metric | The Arcade Fire |
| Raw Sugar | Metric | The New Pornographers |
| Raw Sugar | Metric | The Shins |
| Raw Sugar | Metric | Wolf Parade |
| Raw Sugar | Metric | Feist |
| Raw Sugar | Metric | Death Cab for Cutie |
| Raw Sugar | Metric | The Decemberists |
| Raw Sugar | Metric | Death From Above 1979 |
| Raw Sugar | Metric | of Montreal |
| Raw Sugar | Metric | Spoon |
| Raw Sugar | Metric | The Unicorns |
| Raw Sugar | Metric | Bloc Party |
| Raw Sugar | Metric | Modest Mouse |
| Raw Sugar | Metric | Hot Hot Heat |
| Raw Sugar | Metric | Interpol |
| Raw Sugar | Metric | Architecture in Helsinki |
| Raw Sugar | Metric | Belle and Sebastian |
| Raw Sugar | Metric | Clap Your Hands Say Yeah |
| Raw Sugar | Metric | Le Tigre |
| Raw Sugar | Metric | The Stills |
| Raw Sugar | Metric | Blonde Redhead |
| Raw Sugar | Metric | The Postal Service |
| Raw Sugar | Metric | Mates of State |
| Raw Sugar | Metric | Emily Haines & the Soft Skeleton |
| Raw Sugar | Metric | Pretty Girls Make Graves |
| Fanfare/Parkdale | Metric | Stars |
| Fanfare/Parkdale | Metric | Broken Social Scene |
| Fanfare/Parkdale | Metric | Tegan and Sara |
| Fanfare/Parkdale | Metric | Rilo Kiley |
| Fanfare/Parkdale | Metric | Yeah Yeah Yeahs |
| Fanfare/Parkdale | Metric | The Arcade Fire |
| Fanfare/Parkdale | Metric | The New Pornographers |
| Fanfare/Parkdale | Metric | The Shins |
| Fanfare/Parkdale | Metric | Wolf Parade |
| Fanfare/Parkdale | Metric | Feist |
| Fanfare/Parkdale | Metric | Death Cab for Cutie |
| Fanfare/Parkdale | Metric | The Decemberists |
| Fanfare/Parkdale | Metric | Death From Above 1979 |
| Fanfare/Parkdale | Metric | of Montreal |
| Fanfare/Parkdale | Metric | Spoon |
| Fanfare/Parkdale | Metric | The Unicorns |
| Fanfare/Parkdale | Metric | Bloc Party |
| Fanfare/Parkdale | Metric | Modest Mouse |
| Fanfare/Parkdale | Metric | Hot Hot Heat |
| Fanfare/Parkdale | Metric | Interpol |
| Fanfare/Parkdale | Metric | Architecture in Helsinki |
| Fanfare/Parkdale | Metric | Belle and Sebastian |
| Fanfare/Parkdale | Metric | Clap Your Hands Say Yeah |
| Fanfare/Parkdale | Metric | Le Tigre |
| Fanfare/Parkdale | Metric | The Stills |
| Fanfare/Parkdale | Metric | Blonde Redhead |
| Fanfare/Parkdale | Metric | The Postal Service |
| Fanfare/Parkdale | Metric | Mates of State |
| Fanfare/Parkdale | Metric | Emily Haines & the Soft Skeleton |
| Fanfare/Parkdale | Metric | Pretty Girls Make Graves |
| Hardwire | Metric | Stars |
| Hardwire | Metric | Broken Social Scene |
| Hardwire | Metric | Tegan and Sara |
| Hardwire | Metric | Rilo Kiley |
| Hardwire | Metric | Yeah Yeah Yeahs |
| Hardwire | Metric | The Arcade Fire |
| Hardwire | Metric | The New Pornographers |
| Hardwire | Metric | The Shins |
| Hardwire | Metric | Wolf Parade |
| Hardwire | Metric | Feist |
| Hardwire | Metric | Death Cab for Cutie |
| Hardwire | Metric | The Decemberists |
| Hardwire | Metric | Death From Above 1979 |
| Hardwire | Metric | of Montreal |
| Hardwire | Metric | Spoon |
| Hardwire | Metric | The Unicorns |
| Hardwire | Metric | Bloc Party |
| Hardwire | Metric | Modest Mouse |
| Hardwire | Metric | Hot Hot Heat |
| Hardwire | Metric | Interpol |
| Hardwire | Metric | Architecture in Helsinki |
| Hardwire | Metric | Belle and Sebastian |
| Hardwire | Metric | Clap Your Hands Say Yeah |
| Hardwire | Metric | Le Tigre |
| Hardwire | Metric | The Stills |
| Hardwire | Metric | Blonde Redhead |
| Hardwire | Metric | The Postal Service |
| Hardwire | Metric | Mates of State |
| Hardwire | Metric | Emily Haines & the Soft Skeleton |
| Hardwire | Metric | Pretty Girls Make Graves |
| Torture Me | Metric | Stars |
| Torture Me | Metric | Broken Social Scene |
| Torture Me | Metric | Tegan and Sara |
| Torture Me | Metric | Rilo Kiley |
| Torture Me | Metric | Yeah Yeah Yeahs |
| Torture Me | Metric | The Arcade Fire |
| Torture Me | Metric | The New Pornographers |
| Torture Me | Metric | The Shins |
| Torture Me | Metric | Wolf Parade |
| Torture Me | Metric | Feist |
| Torture Me | Metric | Death Cab for Cutie |
| Torture Me | Metric | The Decemberists |
| Torture Me | Metric | Death From Above 1979 |
| Torture Me | Metric | of Montreal |
| Torture Me | Metric | Spoon |
| Torture Me | Metric | The Unicorns |
| Torture Me | Metric | Bloc Party |
| Torture Me | Metric | Modest Mouse |
| Torture Me | Metric | Hot Hot Heat |
| Torture Me | Metric | Interpol |
| Torture Me | Metric | Architecture in Helsinki |
| Torture Me | Metric | Belle and Sebastian |
| Torture Me | Metric | Clap Your Hands Say Yeah |
| Torture Me | Metric | Le Tigre |
| Torture Me | Metric | The Stills |
| Torture Me | Metric | Blonde Redhead |
| Torture Me | Metric | The Postal Service |
| Torture Me | Metric | Mates of State |
| Torture Me | Metric | Emily Haines & the Soft Skeleton |
| Torture Me | Metric | Pretty Girls Make Graves |
| Soft Rock Star | Metric | Stars |
| Soft Rock Star | Metric | Broken Social Scene |
| Soft Rock Star | Metric | Tegan and Sara |
| Soft Rock Star | Metric | Rilo Kiley |
| Soft Rock Star | Metric | Yeah Yeah Yeahs |
| Soft Rock Star | Metric | The Arcade Fire |
| Soft Rock Star | Metric | The New Pornographers |
| Soft Rock Star | Metric | The Shins |
| Soft Rock Star | Metric | Wolf Parade |
| Soft Rock Star | Metric | Feist |
| Soft Rock Star | Metric | Death Cab for Cutie |
| Soft Rock Star | Metric | The Decemberists |
| Soft Rock Star | Metric | Death From Above 1979 |
| Soft Rock Star | Metric | of Montreal |
| Soft Rock Star | Metric | Spoon |
| Soft Rock Star | Metric | The Unicorns |
| Soft Rock Star | Metric | Bloc Party |
| Soft Rock Star | Metric | Modest Mouse |
| Soft Rock Star | Metric | Hot Hot Heat |
| Soft Rock Star | Metric | Interpol |
| Soft Rock Star | Metric | Architecture in Helsinki |
| Soft Rock Star | Metric | Belle and Sebastian |
| Soft Rock Star | Metric | Clap Your Hands Say Yeah |
| Soft Rock Star | Metric | Le Tigre |
| Soft Rock Star | Metric | The Stills |
| Soft Rock Star | Metric | Blonde Redhead |
| Soft Rock Star | Metric | The Postal Service |
| Soft Rock Star | Metric | Mates of State |
| Soft Rock Star | Metric | Emily Haines & the Soft Skeleton |
| Soft Rock Star | Metric | Pretty Girls Make Graves |
| Rock Me Now | Metric | Stars |
| Rock Me Now | Metric | Broken Social Scene |
| Rock Me Now | Metric | Tegan and Sara |
| Rock Me Now | Metric | Rilo Kiley |
| Rock Me Now | Metric | Yeah Yeah Yeahs |
| Rock Me Now | Metric | The Arcade Fire |
| Rock Me Now | Metric | The New Pornographers |
| Rock Me Now | Metric | The Shins |
| Rock Me Now | Metric | Wolf Parade |
| Rock Me Now | Metric | Feist |
| Rock Me Now | Metric | Death Cab for Cutie |
| Rock Me Now | Metric | The Decemberists |
| Rock Me Now | Metric | Death From Above 1979 |
| Rock Me Now | Metric | of Montreal |
| Rock Me Now | Metric | Spoon |
| Rock Me Now | Metric | The Unicorns |
| Rock Me Now | Metric | Bloc Party |
| Rock Me Now | Metric | Modest Mouse |
| Rock Me Now | Metric | Hot Hot Heat |
| Rock Me Now | Metric | Interpol |
| Rock Me Now | Metric | Architecture in Helsinki |
| Rock Me Now | Metric | Belle and Sebastian |
| Rock Me Now | Metric | Clap Your Hands Say Yeah |
| Rock Me Now | Metric | Le Tigre |
| Rock Me Now | Metric | The Stills |
| Rock Me Now | Metric | Blonde Redhead |
| Rock Me Now | Metric | The Postal Service |
| Rock Me Now | Metric | Mates of State |
| Rock Me Now | Metric | Emily Haines & the Soft Skeleton |
| Rock Me Now | Metric | Pretty Girls Make Graves |
| Down | Metric | Stars |
| Down | Metric | Broken Social Scene |
| Down | Metric | Tegan and Sara |
| Down | Metric | Rilo Kiley |
| Down | Metric | Yeah Yeah Yeahs |
| Down | Metric | The Arcade Fire |
| Down | Metric | The New Pornographers |
| Down | Metric | The Shins |
| Down | Metric | Wolf Parade |
| Down | Metric | Feist |
| Down | Metric | Death Cab for Cutie |
| Down | Metric | The Decemberists |
| Down | Metric | Death From Above 1979 |
| Down | Metric | of Montreal |
| Down | Metric | Spoon |
| Down | Metric | The Unicorns |
| Down | Metric | Bloc Party |
| Down | Metric | Modest Mouse |
| Down | Metric | Hot Hot Heat |
| Down | Metric | Interpol |
| Down | Metric | Architecture in Helsinki |
| Down | Metric | Belle and Sebastian |
| Down | Metric | Clap Your Hands Say Yeah |
| Down | Metric | Le Tigre |
| Down | Metric | The Stills |
| Down | Metric | Blonde Redhead |
| Down | Metric | The Postal Service |
| Down | Metric | Mates of State |
| Down | Metric | Emily Haines & the Soft Skeleton |
| Down | Metric | Pretty Girls Make Graves |
| On the sly | Metric | Stars |
| On the sly | Metric | Broken Social Scene |
| On the sly | Metric | Tegan and Sara |
| On the sly | Metric | Rilo Kiley |
| On the sly | Metric | Yeah Yeah Yeahs |
| On the sly | Metric | The Arcade Fire |
| On the sly | Metric | The New Pornographers |
| On the sly | Metric | The Shins |
| On the sly | Metric | Wolf Parade |
| On the sly | Metric | Feist |
| On the sly | Metric | Death Cab for Cutie |
| On the sly | Metric | The Decemberists |
| On the sly | Metric | Death From Above 1979 |
| On the sly | Metric | of Montreal |
| On the sly | Metric | Spoon |
| On the sly | Metric | The Unicorns |
| On the sly | Metric | Bloc Party |
| On the sly | Metric | Modest Mouse |
| On the sly | Metric | Hot Hot Heat |
| On the sly | Metric | Interpol |
| On the sly | Metric | Architecture in Helsinki |
| On the sly | Metric | Belle and Sebastian |
| On the sly | Metric | Clap Your Hands Say Yeah |
| On the sly | Metric | Le Tigre |
| On the sly | Metric | The Stills |
| On the sly | Metric | Blonde Redhead |
| On the sly | Metric | The Postal Service |
| On the sly | Metric | Mates of State |
| On the sly | Metric | Emily Haines & the Soft Skeleton |
| On the sly | Metric | Pretty Girls Make Graves |
| Grow Up and Blow Away | Metric | Stars |
| Grow Up and Blow Away | Metric | Broken Social Scene |
| Grow Up and Blow Away | Metric | Tegan and Sara |
| Grow Up and Blow Away | Metric | Rilo Kiley |
| Grow Up and Blow Away | Metric | Yeah Yeah Yeahs |
| Grow Up and Blow Away | Metric | The Arcade Fire |
| Grow Up and Blow Away | Metric | The New Pornographers |
| Grow Up and Blow Away | Metric | The Shins |
| Grow Up and Blow Away | Metric | Wolf Parade |
| Grow Up and Blow Away | Metric | Feist |
| Grow Up and Blow Away | Metric | Death Cab for Cutie |
| Grow Up and Blow Away | Metric | The Decemberists |
| Grow Up and Blow Away | Metric | Death From Above 1979 |
| Grow Up and Blow Away | Metric | of Montreal |
| Grow Up and Blow Away | Metric | Spoon |
| Grow Up and Blow Away | Metric | The Unicorns |
| Grow Up and Blow Away | Metric | Bloc Party |
| Grow Up and Blow Away | Metric | Modest Mouse |
| Grow Up and Blow Away | Metric | Hot Hot Heat |
| Grow Up and Blow Away | Metric | Interpol |
| Grow Up and Blow Away | Metric | Architecture in Helsinki |
| Grow Up and Blow Away | Metric | Belle and Sebastian |
| Grow Up and Blow Away | Metric | Clap Your Hands Say Yeah |
| Grow Up and Blow Away | Metric | Le Tigre |
| Grow Up and Blow Away | Metric | The Stills |
| Grow Up and Blow Away | Metric | Blonde Redhead |
| Grow Up and Blow Away | Metric | The Postal Service |
| Grow Up and Blow Away | Metric | Mates of State |
| Grow Up and Blow Away | Metric | Emily Haines & the Soft Skeleton |
| Grow Up and Blow Away | Metric | Pretty Girls Make Graves |
| White Gold | Metric | Stars |
| White Gold | Metric | Broken Social Scene |
| White Gold | Metric | Tegan and Sara |
| White Gold | Metric | Rilo Kiley |
| White Gold | Metric | Yeah Yeah Yeahs |
| White Gold | Metric | The Arcade Fire |
| White Gold | Metric | The New Pornographers |
| White Gold | Metric | The Shins |
| White Gold | Metric | Wolf Parade |
| White Gold | Metric | Feist |
| White Gold | Metric | Death Cab for Cutie |
| White Gold | Metric | The Decemberists |
| White Gold | Metric | Death From Above 1979 |
| White Gold | Metric | of Montreal |
| White Gold | Metric | Spoon |
| White Gold | Metric | The Unicorns |
| White Gold | Metric | Bloc Party |
| White Gold | Metric | Modest Mouse |
| White Gold | Metric | Hot Hot Heat |
| White Gold | Metric | Interpol |
| White Gold | Metric | Architecture in Helsinki |
| White Gold | Metric | Belle and Sebastian |
| White Gold | Metric | Clap Your Hands Say Yeah |
| White Gold | Metric | Le Tigre |
| White Gold | Metric | The Stills |
| White Gold | Metric | Blonde Redhead |
| White Gold | Metric | The Postal Service |
| White Gold | Metric | Mates of State |
| White Gold | Metric | Emily Haines & the Soft Skeleton |
| White Gold | Metric | Pretty Girls Make Graves |
| Patriarch On A Vespa | Metric | Stars |
| Patriarch On A Vespa | Metric | Broken Social Scene |
| Patriarch On A Vespa | Metric | Tegan and Sara |
| Patriarch On A Vespa | Metric | Rilo Kiley |
| Patriarch On A Vespa | Metric | Yeah Yeah Yeahs |
| Patriarch On A Vespa | Metric | The Arcade Fire |
| Patriarch On A Vespa | Metric | The New Pornographers |
| Patriarch On A Vespa | Metric | The Shins |
| Patriarch On A Vespa | Metric | Wolf Parade |
| Patriarch On A Vespa | Metric | Feist |
| Patriarch On A Vespa | Metric | Death Cab for Cutie |
| Patriarch On A Vespa | Metric | The Decemberists |
| Patriarch On A Vespa | Metric | Death From Above 1979 |
| Patriarch On A Vespa | Metric | of Montreal |
| Patriarch On A Vespa | Metric | Spoon |
| Patriarch On A Vespa | Metric | The Unicorns |
| Patriarch On A Vespa | Metric | Bloc Party |
| Patriarch On A Vespa | Metric | Modest Mouse |
| Patriarch On A Vespa | Metric | Hot Hot Heat |
| Patriarch On A Vespa | Metric | Interpol |
| Patriarch On A Vespa | Metric | Architecture in Helsinki |
| Patriarch On A Vespa | Metric | Belle and Sebastian |
| Patriarch On A Vespa | Metric | Clap Your Hands Say Yeah |
| Patriarch On A Vespa | Metric | Le Tigre |
| Patriarch On A Vespa | Metric | The Stills |
| Patriarch On A Vespa | Metric | Blonde Redhead |
| Patriarch On A Vespa | Metric | The Postal Service |
| Patriarch On A Vespa | Metric | Mates of State |
| Patriarch On A Vespa | Metric | Emily Haines & the Soft Skeleton |
| Patriarch On A Vespa | Metric | Pretty Girls Make Graves |
| Poster Of A Girl | Metric | Stars |
| Poster Of A Girl | Metric | Broken Social Scene |
| Poster Of A Girl | Metric | Tegan and Sara |
| Poster Of A Girl | Metric | Rilo Kiley |
| Poster Of A Girl | Metric | Yeah Yeah Yeahs |
| Poster Of A Girl | Metric | The Arcade Fire |
| Poster Of A Girl | Metric | The New Pornographers |
| Poster Of A Girl | Metric | The Shins |
| Poster Of A Girl | Metric | Wolf Parade |
| Poster Of A Girl | Metric | Feist |
| Poster Of A Girl | Metric | Death Cab for Cutie |
| Poster Of A Girl | Metric | The Decemberists |
| Poster Of A Girl | Metric | Death From Above 1979 |
| Poster Of A Girl | Metric | of Montreal |
| Poster Of A Girl | Metric | Spoon |
| Poster Of A Girl | Metric | The Unicorns |
| Poster Of A Girl | Metric | Bloc Party |
| Poster Of A Girl | Metric | Modest Mouse |
| Poster Of A Girl | Metric | Hot Hot Heat |
| Poster Of A Girl | Metric | Interpol |
| Poster Of A Girl | Metric | Architecture in Helsinki |
| Poster Of A Girl | Metric | Belle and Sebastian |
| Poster Of A Girl | Metric | Clap Your Hands Say Yeah |
| Poster Of A Girl | Metric | Le Tigre |
| Poster Of A Girl | Metric | The Stills |
| Poster Of A Girl | Metric | Blonde Redhead |
| Poster Of A Girl | Metric | The Postal Service |
| Poster Of A Girl | Metric | Mates of State |
| Poster Of A Girl | Metric | Emily Haines & the Soft Skeleton |
| Poster Of A Girl | Metric | Pretty Girls Make Graves |
| Live It Out | Metric | Stars |
| Live It Out | Metric | Broken Social Scene |
| Live It Out | Metric | Tegan and Sara |
| Live It Out | Metric | Rilo Kiley |
| Live It Out | Metric | Yeah Yeah Yeahs |
| Live It Out | Metric | The Arcade Fire |
| Live It Out | Metric | The New Pornographers |
| Live It Out | Metric | The Shins |
| Live It Out | Metric | Wolf Parade |
| Live It Out | Metric | Feist |
| Live It Out | Metric | Death Cab for Cutie |
| Live It Out | Metric | The Decemberists |
| Live It Out | Metric | Death From Above 1979 |
| Live It Out | Metric | of Montreal |
| Live It Out | Metric | Spoon |
| Live It Out | Metric | The Unicorns |
| Live It Out | Metric | Bloc Party |
| Live It Out | Metric | Modest Mouse |
| Live It Out | Metric | Hot Hot Heat |
| Live It Out | Metric | Interpol |
| Live It Out | Metric | Architecture in Helsinki |
| Live It Out | Metric | Belle and Sebastian |
| Live It Out | Metric | Clap Your Hands Say Yeah |
| Live It Out | Metric | Le Tigre |
| Live It Out | Metric | The Stills |
| Live It Out | Metric | Blonde Redhead |
| Live It Out | Metric | The Postal Service |
| Live It Out | Metric | Mates of State |
| Live It Out | Metric | Emily Haines & the Soft Skeleton |
| Live It Out | Metric | Pretty Girls Make Graves |
| Glass Ceiling | Metric | Stars |
| Glass Ceiling | Metric | Broken Social Scene |
| Glass Ceiling | Metric | Tegan and Sara |
| Glass Ceiling | Metric | Rilo Kiley |
| Glass Ceiling | Metric | Yeah Yeah Yeahs |
| Glass Ceiling | Metric | The Arcade Fire |
| Glass Ceiling | Metric | The New Pornographers |
| Glass Ceiling | Metric | The Shins |
| Glass Ceiling | Metric | Wolf Parade |
| Glass Ceiling | Metric | Feist |
| Glass Ceiling | Metric | Death Cab for Cutie |
| Glass Ceiling | Metric | The Decemberists |
| Glass Ceiling | Metric | Death From Above 1979 |
| Glass Ceiling | Metric | of Montreal |
| Glass Ceiling | Metric | Spoon |
| Glass Ceiling | Metric | The Unicorns |
| Glass Ceiling | Metric | Bloc Party |
| Glass Ceiling | Metric | Modest Mouse |
| Glass Ceiling | Metric | Hot Hot Heat |
| Glass Ceiling | Metric | Interpol |
| Glass Ceiling | Metric | Architecture in Helsinki |
| Glass Ceiling | Metric | Belle and Sebastian |
| Glass Ceiling | Metric | Clap Your Hands Say Yeah |
| Glass Ceiling | Metric | Le Tigre |
| Glass Ceiling | Metric | The Stills |
| Glass Ceiling | Metric | Blonde Redhead |
| Glass Ceiling | Metric | The Postal Service |
| Glass Ceiling | Metric | Mates of State |
| Glass Ceiling | Metric | Emily Haines & the Soft Skeleton |
| Glass Ceiling | Metric | Pretty Girls Make Graves |
| Too Little Too Late | Metric | Stars |
| Too Little Too Late | Metric | Broken Social Scene |
| Too Little Too Late | Metric | Tegan and Sara |
| Too Little Too Late | Metric | Rilo Kiley |
| Too Little Too Late | Metric | Yeah Yeah Yeahs |
| Too Little Too Late | Metric | The Arcade Fire |
| Too Little Too Late | Metric | The New Pornographers |
| Too Little Too Late | Metric | The Shins |
| Too Little Too Late | Metric | Wolf Parade |
| Too Little Too Late | Metric | Feist |
| Too Little Too Late | Metric | Death Cab for Cutie |
| Too Little Too Late | Metric | The Decemberists |
| Too Little Too Late | Metric | Death From Above 1979 |
| Too Little Too Late | Metric | of Montreal |
| Too Little Too Late | Metric | Spoon |
| Too Little Too Late | Metric | The Unicorns |
| Too Little Too Late | Metric | Bloc Party |
| Too Little Too Late | Metric | Modest Mouse |
| Too Little Too Late | Metric | Hot Hot Heat |
| Too Little Too Late | Metric | Interpol |
| Too Little Too Late | Metric | Architecture in Helsinki |
| Too Little Too Late | Metric | Belle and Sebastian |
| Too Little Too Late | Metric | Clap Your Hands Say Yeah |
| Too Little Too Late | Metric | Le Tigre |
| Too Little Too Late | Metric | The Stills |
| Too Little Too Late | Metric | Blonde Redhead |
| Too Little Too Late | Metric | The Postal Service |
| Too Little Too Late | Metric | Mates of State |
| Too Little Too Late | Metric | Emily Haines & the Soft Skeleton |
| Too Little Too Late | Metric | Pretty Girls Make Graves |
| Monster Hospital | Metric | Stars |
| Monster Hospital | Metric | Broken Social Scene |
| Monster Hospital | Metric | Tegan and Sara |
| Monster Hospital | Metric | Rilo Kiley |
| Monster Hospital | Metric | Yeah Yeah Yeahs |
| Monster Hospital | Metric | The Arcade Fire |
| Monster Hospital | Metric | The New Pornographers |
| Monster Hospital | Metric | The Shins |
| Monster Hospital | Metric | Wolf Parade |
| Monster Hospital | Metric | Feist |
| Monster Hospital | Metric | Death Cab for Cutie |
| Monster Hospital | Metric | The Decemberists |
| Monster Hospital | Metric | Death From Above 1979 |
| Monster Hospital | Metric | of Montreal |
| Monster Hospital | Metric | Spoon |
| Monster Hospital | Metric | The Unicorns |
| Monster Hospital | Metric | Bloc Party |
| Monster Hospital | Metric | Modest Mouse |
| Monster Hospital | Metric | Hot Hot Heat |
| Monster Hospital | Metric | Interpol |
| Monster Hospital | Metric | Architecture in Helsinki |
| Monster Hospital | Metric | Belle and Sebastian |
| Monster Hospital | Metric | Clap Your Hands Say Yeah |
| Monster Hospital | Metric | Le Tigre |
| Monster Hospital | Metric | The Stills |
| Monster Hospital | Metric | Blonde Redhead |
| Monster Hospital | Metric | The Postal Service |
| Monster Hospital | Metric | Mates of State |
| Monster Hospital | Metric | Emily Haines & the Soft Skeleton |
| Monster Hospital | Metric | Pretty Girls Make Graves |
| The Police And The Private | Metric | Stars |
| The Police And The Private | Metric | Broken Social Scene |
| The Police And The Private | Metric | Tegan and Sara |
| The Police And The Private | Metric | Rilo Kiley |
| The Police And The Private | Metric | Yeah Yeah Yeahs |
| The Police And The Private | Metric | The Arcade Fire |
| The Police And The Private | Metric | The New Pornographers |
| The Police And The Private | Metric | The Shins |
| The Police And The Private | Metric | Wolf Parade |
| The Police And The Private | Metric | Feist |
| The Police And The Private | Metric | Death Cab for Cutie |
| The Police And The Private | Metric | The Decemberists |
| The Police And The Private | Metric | Death From Above 1979 |
| The Police And The Private | Metric | of Montreal |
| The Police And The Private | Metric | Spoon |
| The Police And The Private | Metric | The Unicorns |
| The Police And The Private | Metric | Bloc Party |
| The Police And The Private | Metric | Modest Mouse |
| The Police And The Private | Metric | Hot Hot Heat |
| The Police And The Private | Metric | Interpol |
| The Police And The Private | Metric | Architecture in Helsinki |
| The Police And The Private | Metric | Belle and Sebastian |
| The Police And The Private | Metric | Clap Your Hands Say Yeah |
| The Police And The Private | Metric | Le Tigre |
| The Police And The Private | Metric | The Stills |
| The Police And The Private | Metric | Blonde Redhead |
| The Police And The Private | Metric | The Postal Service |
| The Police And The Private | Metric | Mates of State |
| The Police And The Private | Metric | Emily Haines & the Soft Skeleton |
| The Police And The Private | Metric | Pretty Girls Make Graves |
| Ending Start | Metric | Stars |
| Ending Start | Metric | Broken Social Scene |
| Ending Start | Metric | Tegan and Sara |
| Ending Start | Metric | Rilo Kiley |
| Ending Start | Metric | Yeah Yeah Yeahs |
| Ending Start | Metric | The Arcade Fire |
| Ending Start | Metric | The New Pornographers |
| Ending Start | Metric | The Shins |
| Ending Start | Metric | Wolf Parade |
| Ending Start | Metric | Feist |
| Ending Start | Metric | Death Cab for Cutie |
| Ending Start | Metric | The Decemberists |
| Ending Start | Metric | Death From Above 1979 |
| Ending Start | Metric | of Montreal |
| Ending Start | Metric | Spoon |
| Ending Start | Metric | The Unicorns |
| Ending Start | Metric | Bloc Party |
| Ending Start | Metric | Modest Mouse |
| Ending Start | Metric | Hot Hot Heat |
| Ending Start | Metric | Interpol |
| Ending Start | Metric | Architecture in Helsinki |
| Ending Start | Metric | Belle and Sebastian |
| Ending Start | Metric | Clap Your Hands Say Yeah |
| Ending Start | Metric | Le Tigre |
| Ending Start | Metric | The Stills |
| Ending Start | Metric | Blonde Redhead |
| Ending Start | Metric | The Postal Service |
| Ending Start | Metric | Mates of State |
| Ending Start | Metric | Emily Haines & the Soft Skeleton |
| Ending Start | Metric | Pretty Girls Make Graves |
| Empty | Metric | Stars |
| Empty | Metric | Broken Social Scene |
| Empty | Metric | Tegan and Sara |
| Empty | Metric | Rilo Kiley |
| Empty | Metric | Yeah Yeah Yeahs |
| Empty | Metric | The Arcade Fire |
| Empty | Metric | The New Pornographers |
| Empty | Metric | The Shins |
| Empty | Metric | Wolf Parade |
| Empty | Metric | Feist |
| Empty | Metric | Death Cab for Cutie |
| Empty | Metric | The Decemberists |
| Empty | Metric | Death From Above 1979 |
| Empty | Metric | of Montreal |
| Empty | Metric | Spoon |
| Empty | Metric | The Unicorns |
| Empty | Metric | Bloc Party |
| Empty | Metric | Modest Mouse |
| Empty | Metric | Hot Hot Heat |
| Empty | Metric | Interpol |
| Empty | Metric | Architecture in Helsinki |
| Empty | Metric | Belle and Sebastian |
| Empty | Metric | Clap Your Hands Say Yeah |
| Empty | Metric | Le Tigre |
| Empty | Metric | The Stills |
| Empty | Metric | Blonde Redhead |
| Empty | Metric | The Postal Service |
| Empty | Metric | Mates of State |
| Empty | Metric | Emily Haines & the Soft Skeleton |
| Empty | Metric | Pretty Girls Make Graves |
| Handshakes | Metric | Stars |
| Handshakes | Metric | Broken Social Scene |
| Handshakes | Metric | Tegan and Sara |
| Handshakes | Metric | Rilo Kiley |
| Handshakes | Metric | Yeah Yeah Yeahs |
| Handshakes | Metric | The Arcade Fire |
| Handshakes | Metric | The New Pornographers |
| Handshakes | Metric | The Shins |
| Handshakes | Metric | Wolf Parade |
| Handshakes | Metric | Feist |
| Handshakes | Metric | Death Cab for Cutie |
| Handshakes | Metric | The Decemberists |
| Handshakes | Metric | Death From Above 1979 |
| Handshakes | Metric | of Montreal |
| Handshakes | Metric | Spoon |
| Handshakes | Metric | The Unicorns |
| Handshakes | Metric | Bloc Party |
| Handshakes | Metric | Modest Mouse |
| Handshakes | Metric | Hot Hot Heat |
| Handshakes | Metric | Interpol |
| Handshakes | Metric | Architecture in Helsinki |
| Handshakes | Metric | Belle and Sebastian |
| Handshakes | Metric | Clap Your Hands Say Yeah |
| Handshakes | Metric | Le Tigre |
| Handshakes | Metric | The Stills |
| Handshakes | Metric | Blonde Redhead |
| Handshakes | Metric | The Postal Service |
| Handshakes | Metric | Mates of State |
| Handshakes | Metric | Emily Haines & the Soft Skeleton |
| Handshakes | Metric | Pretty Girls Make Graves |
+----------------------------+--------+----------------------------------+
990 rows in set (0.00 sec)
mysql> select a.title as "tema" , b.name, c.suggestion from (tags as a left join artist as b on a.artist=b.id) left join related_artists as c on b.name=c.artist where b.name='Metric' and a.title='soft rock star';
+----------------+--------+----------------------------------+
| tema | name | suggestion |
+----------------+--------+----------------------------------+
| Soft Rock Star | Metric | Stars |
| Soft Rock Star | Metric | Broken Social Scene |
| Soft Rock Star | Metric | Tegan and Sara |
| Soft Rock Star | Metric | Rilo Kiley |
| Soft Rock Star | Metric | Yeah Yeah Yeahs |
| Soft Rock Star | Metric | The Arcade Fire |
| Soft Rock Star | Metric | The New Pornographers |
| Soft Rock Star | Metric | The Shins |
| Soft Rock Star | Metric | Wolf Parade |
| Soft Rock Star | Metric | Feist |
| Soft Rock Star | Metric | Death Cab for Cutie |
| Soft Rock Star | Metric | The Decemberists |
| Soft Rock Star | Metric | Death From Above 1979 |
| Soft Rock Star | Metric | of Montreal |
| Soft Rock Star | Metric | Spoon |
| Soft Rock Star | Metric | The Unicorns |
| Soft Rock Star | Metric | Bloc Party |
| Soft Rock Star | Metric | Modest Mouse |
| Soft Rock Star | Metric | Hot Hot Heat |
| Soft Rock Star | Metric | Interpol |
| Soft Rock Star | Metric | Architecture in Helsinki |
| Soft Rock Star | Metric | Belle and Sebastian |
| Soft Rock Star | Metric | Clap Your Hands Say Yeah |
| Soft Rock Star | Metric | Le Tigre |
| Soft Rock Star | Metric | The Stills |
| Soft Rock Star | Metric | Blonde Redhead |
| Soft Rock Star | Metric | The Postal Service |
| Soft Rock Star | Metric | Mates of State |
| Soft Rock Star | Metric | Emily Haines & the Soft Skeleton |
| Soft Rock Star | Metric | Pretty Girls Make Graves |
+----------------+--------+----------------------------------+
30 rows in set (0.00 sec)
mysql>