So we've just heard The Drums Melbourne show has sold out via the East Brunswick Club site so the only place where you can still grab yourself tickets is through our webstore. You better hurry... they'll go real fast as well!
16th June, 2010 : Posted by Admin
| POPFRENZY CHANNEL ON VIMEO | 30th August, 2009 |
| THE DRUMS!!! | 17th September, 2009 |
| Summertime! on iTunes now! | 21st October, 2009 |
| THE DRUMS TO PLAY AT SPLENDOUR IN THE GRASS '10!! | 15th April, 2010 |
| The Drums Australian side shows announced!! | 26th May, 2010 |
| The Drums on sale today! | 4th June, 2010 |
| The Drums sideshows competition!!! | 2nd February, 2012 |
| '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 | 1 | |
| 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 | 1 | |
| 11 | DESCRIBE `links` | 7 | 7 | 0 | |
| 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` = 168 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 12:42:16' ORDER BY `Headline`.`enable` DESC LIMIT 11 | 11 | 11 | 1 | |
| 14 | SELECT `Artist`.`id`, `Artist`.`title` FROM `artists` AS `Artist` WHERE `Artist`.`id` = 75 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 12:42:16' AND `Present`.`artist_id` IN (75) 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 12:42:16' AND `Headline`.`artist_id` IN (75) ORDER BY `Headline`.`enable` ASC | 8 | 8 | 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 | 1 | |
| 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 |