Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/controller/components/session.php) is not within the allowed path(s): (/var/www/vhosts/popfrenzy.com.au/:/tmp/) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php on line 1077

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/model/datasources/dbo_source.php) is not within the allowed path(s): (/var/www/vhosts/popfrenzy.com.au/:/tmp/) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php on line 1077

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/model/dbo/dbo_mysql.php) is not within the allowed path(s): (/var/www/vhosts/popfrenzy.com.au/:/tmp/) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php on line 1077

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/view/helpers/session.php) is not within the allowed path(s): (/var/www/vhosts/popfrenzy.com.au/:/tmp/) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php on line 1077

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/view/helpers/time.php) is not within the allowed path(s): (/var/www/vhosts/popfrenzy.com.au/:/tmp/) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php on line 1077

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/view/helpers/html.php) is not within the allowed path(s): (/var/www/vhosts/popfrenzy.com.au/:/tmp/) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php on line 1077

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/view/helpers/javascript.php) is not within the allowed path(s): (/var/www/vhosts/popfrenzy.com.au/:/tmp/) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php on line 1077

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/view/helpers/text.php) is not within the allowed path(s): (/var/www/vhosts/popfrenzy.com.au/:/tmp/) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php on line 1077

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/view/helpers/cache.php) is not within the allowed path(s): (/var/www/vhosts/popfrenzy.com.au/:/tmp/) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php on line 1077
Popfrenzy :: News

News

The Ruby Suns News

Hello the Ruby Suns!!

The Ruby Suns are our first New Zealand act on Popfrenzy Records and their debut self titled album is out in stores on August 6. To support the release they're crossing the Tasman as special guests of The Shins on their national tour. On their days off from playing at 2000 plus venues, the band will be launching their album headlining their own gigs.

Sunday August 5
Rocket Bar (ADELAIDE)

Monday August 6
Rob Roy Hotel (MELBOURNE)
with Aleks & The Ramps and Fabulous Diamonds

Saturday August 11
Hopetoun Hotel (SYDNEY)
with Mist & Sea, Pikelet and Tennis

1st July, 2007 : Posted by Jason

23 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `headlines`10101
2DESCRIBE `users`770
3DESCRIBE `artists`880
4DESCRIBE `presents`10100
5DESCRIBE `tour_dates`14140
6DESCRIBE `reviews`12121
7DESCRIBE `media`11110
8DESCRIBE `audioplayer`440
9DESCRIBE `photos`880
10DESCRIBE `links`770
11SELECT `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` = 5 LIMIT 1110
12SELECT `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` <= '2019-10-20 04:09:44' ORDER BY `Headline`.`enable` DESC LIMIT 1111111
13SELECT `Artist`.`id`, `Artist`.`title` FROM `artists` AS `Artist` WHERE `Artist`.`id` = 6 LIMIT 1110
14SELECT `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` < '2019-10-20 04:09:44' AND `Present`.`artist_id` IN (6) ORDER BY `Present`.`enable` ASC 440
15SELECT `TourDate`.`id`, `TourDate`.`enable`, `TourDate`.`date`, `TourDate`.`venue`, `TourDate`.`buy_url`, `TourDate`.`sold_out`, `TourDate`.`present_id` FROM `tour_dates` AS `TourDate` WHERE `TourDate`.`enable` != '0000-00-00 00:00:00' AND `TourDate`.`present_id` IN (1) ORDER BY `TourDate`.`date` ASC 660
16SELECT `TourDate`.`id`, `TourDate`.`enable`, `TourDate`.`date`, `TourDate`.`venue`, `TourDate`.`buy_url`, `TourDate`.`sold_out`, `TourDate`.`present_id` FROM `tour_dates` AS `TourDate` WHERE `TourDate`.`enable` != '0000-00-00 00:00:00' AND `TourDate`.`present_id` IN (68) ORDER BY `TourDate`.`date` ASC 660
17SELECT `TourDate`.`id`, `TourDate`.`enable`, `TourDate`.`date`, `TourDate`.`venue`, `TourDate`.`buy_url`, `TourDate`.`sold_out`, `TourDate`.`present_id` FROM `tour_dates` AS `TourDate` WHERE `TourDate`.`enable` != '0000-00-00 00:00:00' AND `TourDate`.`present_id` IN (74) ORDER BY `TourDate`.`date` ASC 880
18SELECT `TourDate`.`id`, `TourDate`.`enable`, `TourDate`.`date`, `TourDate`.`venue`, `TourDate`.`buy_url`, `TourDate`.`sold_out`, `TourDate`.`present_id` FROM `tour_dates` AS `TourDate` WHERE `TourDate`.`enable` != '0000-00-00 00:00:00' AND `TourDate`.`present_id` IN (86) ORDER BY `TourDate`.`date` ASC 220
19SELECT `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` < '2019-10-20 04:09:44' AND `Headline`.`artist_id` IN (6) ORDER BY `Headline`.`enable` ASC 660
20SELECT `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 >= '2019-10-20' LIMIT 1000
21SELECT `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 <= '2019-10-20' AND date >= '2019-08-20' LIMIT 1000
22SELECT `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 > '2019-10-20' LIMIT 1000
23SELECT COUNT(*) AS `count` FROM `headlines` AS `Headline` WHERE 1 = 1 110