› Christmas Decorations

SELECT DISTINCT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) AND (prodCat.`catID` = ?)  ORDER BY parentProd.`pd_featured` DESC, `pd_order` ASC
Array
(
    [0] => 10
)
Filters
Close

Categories

Refine by Clear All


  • Featured Collections
  • Price
    •  – 

Christmas Decorations

Sort by
Display per page 
SELECT DISTINCT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) AND (prodCat.`catID` = ?)  ORDER BY parentProd.`pd_featured` DESC, `pd_order` ASC
Array
(
    [0] => 10
)
Next 
Next 
South Crofty Collection Wheal Jane Earth Science Park
Baldhu, Truro
Cornwall TR3 6EH
+441872560200

Payments accepted through:

JCB Maestro Mastercard Visa Visa Electron

Terms & Conditions | Privacy And Cookies Policy

Free shipping

Shipping:Worldwide