Error filtering template: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'hjammugc_dreamfurnituresuk.catalog_product_entity' doesn't exist, query was: SELECT `e`.*, IFNULL(at_manufacturer.value, 0) AS `manufacturer_value`, COUNT(*) AS `product_count` FROM `catalog_product_entity` AS `e`
LEFT JOIN `catalog_product_entity_int` AS `at_manufacturer` ON at_manufacturer.entity_id = e.entity_id AND at_manufacturer.attribute_id = (
SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'manufacturer' LIMIT 1
) AND (at_manufacturer.store_id = 0 OR at_manufacturer.store_id IS NULL) WHERE (IFNULL(at_manufacturer.value, 0) IN ('5667', '213', '214', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '230', '231')) GROUP BY `manufacturer_value`
A decompression valve allows you to get every bit of air out to keep your gear snug. Vertical and horizontal compression straps help you further compact your gear for easy travel. With multiple attachment points for accessories, handles, and removable shoulder strap, this duffle is versatile enough for all your adventures.