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`
Don’t let a little weather hold you back on your next adventure. The Rafter Weather Defense Duffle is made of 420-Denier water-resistant fabric that is built to withstand rugged conditions. Featuring welded seams and a roll-top closure with an extra wide opening; this duffle keeps your gear dry. A decompression valve allows you to get every bit of air out to keep your gear snug.