Notice: Error: Unknown column 'ps.price' in 'where clause'
Error No: 1054
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1671' AND ps.price < p.price AND p.product_id IN (7897,7965,8033,8050,8067,8135,8152,9261,9675,9791,10288,10308,10404,10422) in /var/www/universyst.net/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/universyst.net/system/storage/modification/catalog/model/catalog/product.php on line 630Notice: Error: Unknown column 'ps.price' in 'where clause'
Error No: 1054
SELECT p.product_id, p.price, (SELECT MIN(pd.price) FROM oc_product_discount pd WHERE pd.product_id = p.product_id AND pd.customer_group_id = '1' AND pd.quantity > '0' AND ((pd.date_start = '0000-00-00' OR pd.date_start < '2024-05-20') AND (pd.date_end = '0000-00-00' OR pd.date_end > '2024-05-20'))) AS discount, (SELECT MIN(ps.price) FROM oc_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 < '2024-05-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-05-20'))) AS special FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p2s.store_id = '0' AND p.status = '1' AND p.price > '0' AND p2c.category_id = '1671' AND p.date_available <= '2024-05-20' AND ps.price < p.price AND p.product_id IN (7268,7285,7302,7319,7336,7353,7370,7387,7404,7421,7438,7455,7472,7489,7506,7523,7540,7557,7574,7591,7608,7625,7642,7659,7676,7693,7710,7727,7744,7761,7778,7795,7812,7829,7846,7863,7880,7897,7914,7931,7948,7965,7982,7999,8016,8033,8050,8067,8084,8101,8118,8135,8152,8169,8232,8233,8272,8273,8312,8313,8352,8353,8392,8393,8424,8441,8459,8477,8496,8516,8536,8555,8574,8593,8612,8632,8664,8665,8704,8705,8744,8745,8784,8785,8824,8825,8864,8865,8904,8905,8944,8945,8984,8985,9024,9025,9063,9080,9097,9114,9131,9148,9166,9185,9204,9223,9242,9261,9281,9301,9321,9341,9361,9391,9392,9431,9432,9471,9472,9511,9512,9551,9552,9581,9600,9618,9636,9655,9675,9695,9714,9733,9752,9771,9791,9823,9824,9863,9864,9903,9904,9943,9944,9983,9984,10023,10024,10063,10064,10103,10104,10143,10144,10183,10184,10214,10233,10251,10269,10288,10308,10328,10347,10366,10385,10404,10422,10454,10455,10494,10495,10534,10535,10574,10575,10614,10615,10654,10655,10694,10695,10734,10735,10774,10775,10814,10815) ORDER BY p.price in /var/www/universyst.net/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/universyst.net/catalog/model/catalog/ocfilter.php on line 198Warning: Invalid argument supplied for foreach() in /var/www/universyst.net/catalog/model/catalog/ocfilter.php on line 198 Купить Отопительные приборы в интернет-магазине оборудование для водоснабжения и отопления от 36702 до 51993 руб., Ширина, см - 2600