Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/bootstrap.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/app/webroot/index.php on line 79

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/basics.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/bootstrap.php on line 33

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/config/core.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/bootstrap.php on line 34

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/config/paths.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/bootstrap.php on line 35

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/object.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/bootstrap.php on line 38

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/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/bootstrap.php on line 39

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/security.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/bootstrap.php on line 40

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/inflector.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/bootstrap.php on line 41

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/configure.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/bootstrap.php on line 42

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/config/bootstrap.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/libs/configure.php on line 345

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/dispatcher.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/bootstrap.php on line 84

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: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php:1077) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/libs/session.php on line 154

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php:1077) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/libs/session.php on line 154

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/basics.php:1077) in /var/www/vhosts/popfrenzy.com.au/subdomains/studio/httpdocs/cake/libs/session.php on line 155

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/model/model.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 211

Warning: require() [function.require]: open_basedir restriction in effect. File(/opt/plesk/php/5.2/share/pear/cake/libs/model/model_php5.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/libs/model/model.php on line 40

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: require() [function.require]: 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/libs/model/connection_manager.php on line 161

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: require() [function.require]: 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/libs/model/connection_manager.php on line 161

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 14 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `headlines`10101
2DESCRIBE `users`771
3DESCRIBE `artists`881
4DESCRIBE `presents`10101
5DESCRIBE `tour_dates`14141
6DESCRIBE `records`13131
7DESCRIBE `reviews`12121
8DESCRIBE `media`11110
9DESCRIBE `audioplayer`441
10DESCRIBE `photos`881
11DESCRIBE `links`771
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 1111
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` <= '2019-12-11 17:22:35' ORDER BY `Headline`.`enable` DESC LIMIT 1111111
14SELECT `Artist`.`id`, `Artist`.`title` FROM `artists` AS `Artist` WHERE `Artist`.`id` = 6 LIMIT 1111
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` < '2019-12-11 17:22:35' 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` < '2019-12-11 17:22:35' 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 >= '2019-12-11' LIMIT 1001
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-12-11' AND date >= '2019-10-11' 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 > '2019-12-11' LIMIT 1000
24SELECT COUNT(*) AS `count` FROM `headlines` AS `Headline` WHERE 1 = 1 110