Excited to bring you guys the great news that we're finally managed to get Alvvays down under for a run of east coast headline shows in March!! On sale this Thursday! Check our Presents page for all the details. The lovely Major Leagues are supporting at all shows too!
1st December, 2015 : Posted by Admin
| OUT NOW!! ALVVAYS AND JONATHAN BOULET ALBUMS!! | 12th August, 2014 |
| 'It Was Always You' video | 3rd April, 2017 |
| New single from Major Leagues | 2nd April, 2017 |
| Popfrenzy and Solid Effort | 10th August, 2016 |
| The Soft Moon in Australia this October | 24th July, 2016 |
| Cate Le Bon tours Australia for the first time! | 5th July, 2016 |
| Black Mountain back in Australia!! | 21st June, 2016 |
| Bleached tours Australia this spring!! | 31st May, 2016 |
| New Eagulls album Ullages out now! | 11th May, 2016 |
| Major Leagues' EP Dream States out now! | 7th April, 2016 |
| HINDS INTERVIEW WITH ANA PERROTE | 5th April, 2016 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `headlines` | 10 | 10 | 0 | |
| 2 | DESCRIBE `users` | 7 | 7 | 1 | |
| 3 | DESCRIBE `artists` | 8 | 8 | 1 | |
| 4 | DESCRIBE `presents` | 10 | 10 | 1 | |
| 5 | DESCRIBE `tour_dates` | 14 | 14 | 1 | |
| 6 | DESCRIBE `records` | 13 | 13 | 1 | |
| 7 | DESCRIBE `reviews` | 12 | 12 | 1 | |
| 8 | DESCRIBE `media` | 11 | 11 | 1 | |
| 9 | DESCRIBE `audioplayer` | 4 | 4 | 0 | |
| 10 | DESCRIBE `photos` | 8 | 8 | 0 | |
| 11 | DESCRIBE `links` | 7 | 7 | 1 | |
| 12 | SELECT `Headline`.`id`, `Headline`.`user_id`, `Headline`.`artist_id`, `Headline`.`created`, `Headline`.`modified`, `Headline`.`enable`, `Headline`.`type`, `Headline`.`title`, `Headline`.`abstract`, `Headline`.`body`, `User`.`id`, `User`.`username`, `User`.`email`, `Artist`.`id`, `Artist`.`title`, `Artist`.`image` FROM `headlines` AS `Headline` LEFT JOIN `users` AS `User` ON (`Headline`.`user_id` = `User`.`id`) LEFT JOIN `artists` AS `Artist` ON (`Artist`.`enable` != "0000-00-00 00:00:00" AND `Headline`.`artist_id` = `Artist`.`id`) WHERE `Headline`.`id` = 357 LIMIT 1 | 1 | 1 | 1 | |
| 13 | SELECT `Headline`.`id`, `Headline`.`enable`, `Headline`.`title`, `Headline`.`type` FROM `headlines` AS `Headline` LEFT JOIN `users` AS `User` ON (`Headline`.`user_id` = `User`.`id`) LEFT JOIN `artists` AS `Artist` ON (`Artist`.`enable` != "0000-00-00 00:00:00" AND `Headline`.`artist_id` = `Artist`.`id`) WHERE `Headline`.`enable` != '0000-00-00 00:00:00' AND `Headline`.`enable` <= '2020-07-10 11:56:46' ORDER BY `Headline`.`enable` DESC LIMIT 11 | 11 | 11 | 1 | |
| 14 | SELECT `Artist`.`id`, `Artist`.`title` FROM `artists` AS `Artist` WHERE `Artist`.`id` = 131 LIMIT 1 | 1 | 1 | 0 | |
| 15 | SELECT `Present`.`id`, `Present`.`title`, `Present`.`image`, `Present`.`artist_id` FROM `presents` AS `Present` WHERE `Present`.`enable` != "0000-00-00 00:00:00" AND `Present`.`enable` < '2020-07-10 11:56:46' AND `Present`.`artist_id` IN (131) ORDER BY `Present`.`enable` ASC | 0 | 0 | 0 | |
| 16 | SELECT `Headline`.`id`, `Headline`.`enable`, `Headline`.`type`, `Headline`.`title`, `Headline`.`artist_id` FROM `headlines` AS `Headline` WHERE `Headline`.`enable` != "0000-00-00 00:00:00" AND `Headline`.`enable` < '2020-07-10 11:56:46' AND `Headline`.`artist_id` IN (131) ORDER BY `Headline`.`enable` ASC | 2 | 2 | 0 | |
| 17 | SELECT `Present`.`id` FROM `tour_dates` AS `TourDate` LEFT JOIN `users` AS `User` ON (`TourDate`.`user_id` = `User`.`id`) LEFT JOIN `presents` AS `Present` ON (`Present`.`enable` != '0000-00-00 00:00:00' AND `TourDate`.`present_id` = `Present`.`id`) WHERE date >= '2020-07-10' LIMIT 1 | 0 | 0 | 0 | |
| 18 | SELECT `Record`.`id`, `Record`.`title`, `Record`.`image`, `Artist`.`title` FROM `records` AS `Record` LEFT JOIN `users` AS `User` ON (`Record`.`user_id` = `User`.`id`) LEFT JOIN `artists` AS `Artist` ON (`Record`.`artist_id` = `Artist`.`id`) WHERE date <= '2020-07-10' AND date >= '2020-05-10' LIMIT 1 | 0 | 0 | 0 | |
| 19 | SELECT `Record`.`id`, `Record`.`title`, `Record`.`image`, `Artist`.`title` FROM `records` AS `Record` LEFT JOIN `users` AS `User` ON (`Record`.`user_id` = `User`.`id`) LEFT JOIN `artists` AS `Artist` ON (`Record`.`artist_id` = `Artist`.`id`) WHERE date > '2020-07-10' LIMIT 1 | 0 | 0 | 0 | |
| 20 | SELECT COUNT(*) AS `count` FROM `headlines` AS `Headline` WHERE 1 = 1 | 1 | 1 | 0 |