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 = '631' AND ps.price < p.price AND p.product_id IN (5970,6738,14662) 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-18') AND (pd.date_end = '0000-00-00' OR pd.date_end > '2024-05-18'))) 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-18') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-05-18'))) 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 = '631' AND p.date_available <= '2024-05-18' AND ps.price < p.price AND p.product_id IN (655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,1225,1226,1227,1228,1229,1230,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1272,1273,1274,1275,1276,1277,1278,1279,1280,1281,1312,1313,1331,1332,1377,1378,1379,1380,1381,1382,1386,1387,2030,2035,2040,2045,2049,2053,2057,2068,2069,2345,2346,2347,2463,2604,3264,4272,4273,4274,4275,4276,4277,4278,4279,4511,4512,4582,4583,4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4596,4661,4665,4669,5356,5357,5358,5359,5360,5361,5362,5363,5364,5365,5367,5374,5375,5383,5384,5392,5396,5400,5404,5408,5415,5416,5424,5425,5433,5437,5441,5445,5447,5449,5528,5529,5530,5531,5532,5533,5583,5584,5585,5586,5587,5588,5589,5590,5591,5592,5593,5594,5595,5596,5597,5598,5599,5636,5637,5638,5639,5640,5970,5971,5972,5973,5974,5991,5992,5993,5994,5995,5996,5997,5998,5999,6000,6001,6002,6003,6004,6005,6006,6007,6008,6009,6010,6011,6012,6013,6014,6015,6016,6017,6018,6019,6020,6021,6022,6023,6509,6510,6526,6527,6528,6529,6530,6543,6544,6738,6739,6759,6760,6761,6762,6763,6764,6765,6766,6902,6998,6999,7000,7001,7006,7209,7212,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11625,12934,12960,12962,12964,12968,12972,12976,12980,12984,12988,12991,12993,12994,12995,12996,12997,12998,12999,13000,13001,13002,13003,13004,13005,13006,13007,13008,13014,13015,13016,13017,13033,13034,13035,13062,13063,13397,13398,13399,13400,13401,13402,13403,13404,13405,13406,13407,13408,13409,13410,13411,13412,13413,13414,13722,13748,13749,13750,13751,13752,13753,13754,13755,13923,13924,13941,13942,13943,13944,13945,13946,13947,13948,13949,13984,13985,13986,14264,14265,14266,14316,14317,14318,14319,14320,14321,14322,14323,14324,14325,14326,14327,14328,14329,14330,14331,14332,14333,14334,14335,14336,14337,14338,14339,14340,14341,14342,14343,14344,14345,14351,14352,14357,14358,14359,14364,14365,14366,14367,14372,14373,14375,14377,14380,14383,14390,14391,14398,14399,14405,14423,14475,14662,14701,14702,14703,14704,14705,14706,14707,14708,14709,14710,14711,14712,14713,14747,14748,14749,14961,15214,15215,15216,15217,15218,15601,15830,15831,16309,16310,16311) 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 Купить Водопровод ППР (FV Plast, Чехия) в интернет-магазине оборудование для водоснабжения и отопления от 497591 до 663448 руб., Рабочая среда - Отопление