- Resources
-
- Shipping and Returns
-
Orders within the Canberra and Queanbeyan region placed before 11am will normally be delivered next business day, providing all items are in stock.
If you require urgent same day delivery or have special delivery requirements, please call us on 02 6260 4571 to discuss your options.
If you live outside of Canberra and Queanbeyan orders will take a little longer to arrive as they are sent via courier.
For bulky items additional delivery charges may apply due to freight costs to us; you will be advised of these charges before the order is processed.
There has been an error processing your request
SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`required_options`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`uom`, `e`.`uom_value`, `e`.`ribbon`, `e`.`ribbon_value`, `e`.`bss_weight`, `e`.`v_manufacturer`, `e`.`v_model`, `cat_index`.`position` AS `cat_index_position`, `links`.`link_id`, `link_attribute_position_int`.`value` AS `position` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2' INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 1 LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '1' WHERE (e.status = 1) AND (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) AND (links.product_id = 10823) AND (e.entity_id != '10823') ORDER BY `position` ASC
Trace: #0 /var/www/master-2.2/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/master-2.2/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /var/www/master-2.2/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /var/www/master-2.2/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `e`.`ent...', Array) #4 /var/www/master-2.2/lib/Varien/Db/Adapter/Pdo/Mysql.php(508): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.`ent...', Array) #5 /var/www/master-2.2/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `e`.`ent...', Array) #6 /var/www/master-2.2/lib/Varien/Data/Collection/Db.php(760): Zend_Db_Adapter_Abstract->fetchAll('SELECT `e`.`ent...', Array) #7 /var/www/master-2.2/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1067): Varien_Data_Collection_Db->_fetchAll('SELECT `e`.`ent...') #8 /var/www/master-2.2/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(885): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false) #9 /var/www/master-2.2/app/code/core/Mage/Catalog/Block/Product/List/Related.php(70): Mage_Eav_Model_Entity_Collection_Abstract->load() #10 /var/www/master-2.2/app/code/core/Mage/Catalog/Block/Product/List/Related.php(84): Mage_Catalog_Block_Product_List_Related->_prepareData() #11 /var/www/master-2.2/app/code/core/Mage/Core/Block/Abstract.php(937): Mage_Catalog_Block_Product_List_Related->_beforeToHtml() #12 /var/www/master-2.2/app/code/core/Mage/Core/Block/Abstract.php(656): Mage_Core_Block_Abstract->toHtml() #13 /var/www/master-2.2/app/code/core/Mage/Core/Block/Abstract.php(600): Mage_Core_Block_Abstract->_getChildHtml('related_product...', true) #14 /var/www/master-2.2/app/design/frontend/banneredred/default/template/catalog/product/view.phtml(475): Mage_Core_Block_Abstract->getChildHtml('related_product...') #15 /var/www/master-2.2/app/code/core/Mage/Core/Block/Template.php(263): include('/var/www/master...') #16 /var/www/master-2.2/app/code/core/Mage/Core/Block/Template.php(294): Mage_Core_Block_Template->fetchView('frontend/banner...') #17 /var/www/master-2.2/app/code/core/Mage/Core/Block/Template.php(308): Mage_Core_Block_Template->renderView() #18 /var/www/master-2.2/app/code/local/Webtex/CustomerPrices/Block/Catalog/Product/View.php(60): Mage_Core_Block_Template->_toHtml() #19 /var/www/master-2.2/app/code/core/Mage/Core/Block/Abstract.php(938): Webtex_CustomerPrices_Block_Catalog_Product_View->_toHtml() #20 /var/www/master-2.2/app/code/core/Mage/Core/Block/Text/List.php(45): Mage_Core_Block_Abstract->toHtml() #21 /var/www/master-2.2/app/code/core/Mage/Core/Block/Abstract.php(938): Mage_Core_Block_Text_List->_toHtml() #22 /var/www/master-2.2/app/code/core/Mage/Core/Block/Abstract.php(656): Mage_Core_Block_Abstract->toHtml() #23 /var/www/master-2.2/app/code/core/Mage/Core/Block/Abstract.php(600): Mage_Core_Block_Abstract->_getChildHtml('content', true) #24 /var/www/master-2.2/app/design/frontend/banneredred/default/template/page/1column.phtml(57): Mage_Core_Block_Abstract->getChildHtml('content') #25 /var/www/master-2.2/app/code/core/Mage/Core/Block/Template.php(263): include('/var/www/master...') #26 /var/www/master-2.2/app/code/core/Mage/Core/Block/Template.php(294): Mage_Core_Block_Template->fetchView('frontend/banner...') #27 /var/www/master-2.2/app/code/core/Mage/Core/Block/Template.php(308): Mage_Core_Block_Template->renderView() #28 /var/www/master-2.2/app/code/core/Mage/Core/Block/Abstract.php(938): Mage_Core_Block_Template->_toHtml() #29 /var/www/master-2.2/app/code/core/Mage/Core/Model/Layout.php(590): Mage_Core_Block_Abstract->toHtml() #30 /var/www/master-2.2/app/code/local/Mage/Core/Controller/Varien/Action.php(406): Mage_Core_Model_Layout->getOutput() #31 /var/www/master-2.2/app/code/core/Mage/Catalog/Helper/Product/View.php(147): Mage_Core_Controller_Varien_Action->renderLayout() #32 /var/www/master-2.2/app/code/local/OC/LinkBySku/controllers/ProductController.php(56): Mage_Catalog_Helper_Product_View->prepareAndRender(10823, Object(OC_LinkBySku_ProductController), Object(Varien_Object)) #33 /var/www/master-2.2/app/code/local/Mage/Core/Controller/Varien/Action.php(437): OC_LinkBySku_ProductController->viewAction() #34 /var/www/master-2.2/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(262): Mage_Core_Controller_Varien_Action->dispatch('view') #35 /var/www/master-2.2/app/code/core/Mage/Core/Controller/Varien/Front.php(192): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #36 /var/www/master-2.2/app/code/core/Mage/Core/Model/App.php(381): Mage_Core_Controller_Varien_Front->dispatch() #37 /var/www/tcf/app/Mage.php(729): Mage_Core_Model_App->run(Array) #38 /var/www/tcf/index.php(83): Mage::run('', 'store') #39 {main}
Error log record number: 403947635280