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

Best Coast News

Best Coast and Beach Fossils downloads!

We're chuffed and totally excited to be releasing two amazing pop records this month. One from Brooklyn's Beach Fossils and the other from Los Angeles' Best Coast.

Even better we're letting you download a track each from them.

Beach Fossils - Youth
Best Coast - Boyfriend

Beach Fossils' album hits stores on July 17 followed a few weeks later by Best Coast's debut full-length. Or you could grab a copy right now from our webstore!!

7th July, 2010 : Posted by Admin

20 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `headlines`10100
2DESCRIBE `users`770
3DESCRIBE `artists`880
4DESCRIBE `presents`10100
5DESCRIBE `tour_dates`14140
6DESCRIBE `records`13130
7DESCRIBE `reviews`12120
8DESCRIBE `media`11110
9DESCRIBE `audioplayer`440
10DESCRIBE `photos`880
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` = 173 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` <= '2019-10-21 18:38:07' ORDER BY `Headline`.`enable` DESC LIMIT 1111111
14SELECT `Artist`.`id`, `Artist`.`title` FROM `artists` AS `Artist` WHERE `Artist`.`id` = 82 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` < '2019-10-21 18:38:07' AND `Present`.`artist_id` IN (82) ORDER BY `Present`.`enable` ASC 000
16SELECT `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-21 18:38:07' AND `Headline`.`artist_id` IN (82) ORDER BY `Headline`.`enable` ASC 21210
17SELECT `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-21' LIMIT 1000
18SELECT `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-21' AND date >= '2019-08-21' LIMIT 1000
19SELECT `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-21' LIMIT 1000
20SELECT COUNT(*) AS `count` FROM `headlines` AS `Headline` WHERE 1 = 1 110