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,10304,10308,10404,10419,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-06-03') AND (pd.date_end = '0000-00-00' OR pd.date_end > '2024-06-03'))) 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-06-03') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-03'))) 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-06-03' AND ps.price < p.price AND p.product_id IN (7266,7268,7283,7285,7300,7302,7317,7319,7334,7336,7351,7353,7368,7370,7385,7387,7402,7404,7419,7421,7436,7438,7453,7455,7470,7472,7487,7489,7504,7506,7521,7523,7538,7540,7555,7557,7572,7574,7589,7591,7606,7608,7623,7625,7640,7642,7657,7659,7674,7676,7691,7693,7708,7710,7725,7727,7742,7744,7759,7761,7776,7778,7793,7795,7810,7812,7827,7829,7844,7846,7861,7863,7878,7880,7895,7897,7912,7914,7929,7931,7946,7948,7963,7965,7980,7982,7997,7999,8014,8016,8031,8033,8048,8050,8065,8067,8082,8084,8099,8101,8116,8118,8133,8135,8150,8152,8167,8169,8226,8227,8232,8233,8266,8267,8272,8273,8306,8307,8312,8313,8346,8347,8352,8353,8386,8387,8392,8393,8411,8412,8413,8414,8424,8441,8459,8477,8492,8496,8512,8516,8532,8536,8551,8555,8570,8574,8589,8593,8608,8612,8628,8632,8658,8659,8664,8665,8698,8699,8704,8705,8738,8739,8744,8745,8778,8779,8784,8785,8818,8819,8824,8825,8858,8859,8864,8865,8898,8899,8904,8905,8938,8939,8944,8945,8978,8979,8984,8985,9018,9019,9024,9025,9043,9045,9047,9049,9051,9053,9063,9080,9097,9114,9131,9148,9162,9166,9181,9185,9200,9204,9219,9223,9238,9242,9257,9261,9278,9281,9298,9301,9318,9321,9338,9341,9358,9361,9385,9386,9391,9392,9425,9426,9431,9432,9465,9466,9471,9472,9505,9506,9511,9512,9545,9546,9551,9552,9570,9577,9581,9596,9600,9618,9632,9636,9651,9655,9671,9675,9691,9695,9710,9714,9729,9733,9748,9752,9767,9771,9787,9791,9817,9818,9823,9824,9857,9858,9863,9864,9897,9898,9903,9904,9937,9938,9943,9944,9977,9978,9983,9984,10017,10018,10023,10024,10057,10058,10063,10064,10097,10098,10103,10104,10137,10138,10143,10144,10177,10178,10183,10184,10203,10210,10214,10229,10233,10251,10265,10269,10284,10288,10304,10308,10324,10328,10343,10347,10362,10366,10381,10385,10400,10404,10419,10422,10448,10449,10454,10455,10488,10489,10494,10495,10528,10529,10534,10535,10568,10569,10574,10575,10608,10609,10614,10615,10648,10649,10654,10655,10688,10689,10694,10695,10728,10729,10734,10735,10768,10769,10774,10775,10808,10809,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, 2000