Notice: Error: Unknown column 'product_id' in 'field list'
Error No: 1054
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT COUNT(DISTINCT IF(hpl.parent_id IS NOT NULL AND h2s.store_id IS NOT NULL AND hph.pid IS NOT NULL, hpl.parent_id, p.product_id)) AS total FROM df_product_to_category p2c LEFT JOIN df_product p ON p2c.product_id = p.product_id LEFT JOIN df_product_description pd ON p.product_id = pd.product_id LEFT JOIN df_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN df_hpmodel_product_hidden hph ON (p.product_id = hph.pid) LEFT JOIN df_hpmodel_links hpl ON (p.product_id = hpl.product_id) LEFT JOIN df_hpmodel_to_store h2s ON (hpl.type_id = h2s.type_id AND h2s.store_id = '0') WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p2c`.`category_id` IN(93) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `p2c`.`category_id` IN(93)) AS `tmp` WHERE ( `mf_price` > 299999 AND `mf_price` < 10000001) in /var/www/www-root/data/www/nice-office.ru/system/library/db/mysqli.php on line 44Notice: Trying to get property of non-object in /var/www/www-root/data/www/nice-office.ru/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 1200Notice: Error: Unknown column 'mf_price' in 'where clause'
Error No: 1054
SELECT * FROM(SELECT IF(hpl.parent_id IS NOT NULL AND h2s.store_id IS NOT NULL AND hph.pid IS NOT NULL, hpl.parent_id, p.product_id) AS product_id, (SELECT price FROM df_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM df_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM df_product_to_category p2c LEFT JOIN df_product p ON p2c.product_id = p.product_id LEFT JOIN df_product_description pd ON p.product_id = pd.product_id LEFT JOIN df_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN df_hpmodel_product_hidden hph ON (p.product_id = hph.pid) LEFT JOIN df_hpmodel_links hpl ON (p.product_id = hpl.product_id) LEFT JOIN df_hpmodel_to_store h2s ON (hpl.type_id = h2s.type_id AND h2s.store_id = '0') WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p2c`.`category_id` IN(93) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `p2c`.`category_id` IN(93) GROUP BY IF(hpl.parent_id IS NOT NULL AND h2s.store_id IS NOT NULL AND hph.pid IS NOT NULL, hpl.parent_id, p.product_id) ORDER BY p.sort_order ASC , (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) ASC, LCASE(pd.name) ASC) AS `tmp` WHERE ( `mf_price` > 299999 AND `mf_price` < 10000001) LIMIT 0,27 in /var/www/www-root/data/www/nice-office.ru/system/library/db/mysqli.php on line 44Notice: Trying to get property of non-object in /var/www/www-root/data/www/nice-office.ru/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 315Warning: Invalid argument supplied for foreach() in /var/www/www-root/data/www/nice-office.ru/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 315 Кабинет руководителя премиум класса - купить в Челябинске. Дорого.
Хотите, мы Вам перезвоним?