Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id`' at line 2
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM( INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 2 INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` SELECT COUNT(*) AS total FROM ( SELECT p.product_id, p.sort_order, "1" AS match_filters FROM `oc_product` AS p INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id) p2s.store_id = '2' AND `p2c`.`category_id` IN(1) GROUP BY p.product_id HAVING match_filters = 1) AS t) AS `tmp` in /home/timecomu/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/timecomu/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 600Notice: Error: Duplicate column name 'sort_order'
Error No: 1060
SELECT * FROM(SELECT p.product_id, p.sort_order, "1" AS match_filters, pp.sort_order FROM `oc_product` AS p INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id) INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id) INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id) WHERE (FIND_IN_SET( 1454, `p`.`mfilter_values` )) AND `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` IN(1) AND p2s.store_id = '2' AND `p2c`.`category_id` IN(1) AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1 ORDER BY pp.sort_order ASC, pd.name ASC ) AS `tmp` LIMIT 0, 15 in /home/timecomu/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/timecomu/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 121Warning: Invalid argument supplied for foreach() in /home/timecomu/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 121 Весь каталог наручных часов Time24