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

24 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `headlines`10100
2DESCRIBE `users`770
3DESCRIBE `artists`880
4DESCRIBE `presents`10100
5DESCRIBE `tour_dates`14140
6DESCRIBE `records`13131
7DESCRIBE `reviews`12121
8DESCRIBE `media`11110
9DESCRIBE `audioplayer`440
10DESCRIBE `photos`880
11DESCRIBE `links`770
12SELECT `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
13SELECT `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` <= '2021-04-10 12:22:33' ORDER BY `Headline`.`enable` DESC LIMIT 1111111
14SELECT `Artist`.`id`, `Artist`.`title` FROM `artists` AS `Artist` WHERE `Artist`.`id` = 6 LIMIT 1110
15SELECT `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` < '2021-04-10 12:22:33' AND `Present`.`artist_id` IN (6) ORDER BY `Present`.`enable` ASC 440
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 (1) 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 (68) ORDER BY `TourDate`.`date` ASC 660
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 (74) ORDER BY `TourDate`.`date` ASC 880
19SELECT `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
20SELECT `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` < '2021-04-10 12:22:33' AND `Headline`.`artist_id` IN (6) ORDER BY `Headline`.`enable` ASC 660
21SELECT `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 >= '2021-04-10' 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 <= '2021-04-10' AND date >= '2021-02-10' LIMIT 1000
23SELECT `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 > '2021-04-10' LIMIT 1000
24SELECT COUNT(*) AS `count` FROM `headlines` AS `Headline` WHERE 1 = 1 110