Notice: Error: Table 'midteksj_oc-newsite.ti9jo39em_bf_filter' doesn't exist
Error No: 1146
SELECT p.product_id, p.sort_order, "1" AS match_filters, pp.quantity, pp.stock_status_id, pp.date_added FROM `ti9jo39em_product` AS p INNER JOIN `ti9jo39em_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `ti9jo39em_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN `ti9jo39em_product_to_category` AS p2c ON (p.product_id = p2c.product_id) INNER JOIN `ti9jo39em_category_path` AS cp ON (cp.category_id = p2c.category_id) INNER JOIN `ti9jo39em_product_description` AS pd ON (pd.product_id = p.product_id) INNER JOIN `ti9jo39em_product` AS pp ON (pp.product_id = p.product_id) WHERE p2s.store_id = '0' AND (p.quantity > 0 OR (p.quantity = 0 AND p.restock_in_future = 1)) AND cp.path_id = '36636' AND pd.language_id = '1' GROUP BY p.product_id HAVING match_filters = 1 ORDER BY CASE WHEN pp.quantity > 0 THEN 10 WHEN pp.quantity = 0 AND pp.stock_status_id = 8 THEN 9 WHEN pp.quantity = 0 AND pp.stock_status_id = 9 THEN 8 WHEN pp.quantity = 0 AND pp.stock_status_id = 10 THEN 7 WHEN pp.quantity = 0 AND pp.stock_status_id = 5 THEN 5 END DESC, pp.date_added DESC LIMIT 17856, 16 in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 324Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 324 Toshiba E-Studio 162D | MIDTeks