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`
Adjustable sternum and shoulder straps, multiple pockets, and compression straps to stabilize your load keep you prepped for any adventure. Also compatible with our 2L