Discover the wonderful world of Gibsons Jigsaw Puzzles, the beloved British family-owned company that has been bringing people together since 1919. For over 100 years, Gibsons has been creating beautifully illustrated puzzles designed to entertain generations.
Crafted from 100% recycled cardboard and made in the UK and Europe, the collection includes 500 piece, 1000 piece and circular jigsaw puzzles to suit every interest and skill level. Whether you're after a solo challenge, a thoughtful gift or a new family tradition, you'll find a puzzle to treasure within the Gibsons collection. From their family to yours - enjoy!
SELECT `e`.*, `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`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '5'
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (98492, 98467, 98468, 98481, 98485, 98495, 98497, 98463, 98464, 98465, 98466, 98469, 98470, 98471, 98472, 98473, 98474, 98475, 98476, 98477, 98478, 98479, 98480, 98482, 98483, 98484, 98486, 98487, 98488, 98489, 98490, 98491)) ORDER BY FIELD(e.entity_id,98492,98467,98468,98481,98485,98495,98497,98463,98464,98465,98466,98469,98470,98471,98472,98473,98474,98475,98476,98477,98478,98479,98480,98482,98483,98484,98486,98487,98488,98489,98490,98491)
