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 = '491' AND ps.price < p.price AND p.product_id IN (980,985,987,989,1897,5183,5184,5864,11497,12487,12674,12891,13213,14019,14147) 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 = '491' AND p.date_available <= '2024-05-20' AND ps.price < p.price AND p.product_id IN (980,981,982,983,984,985,986,987,988,989,1897,1902,1903,1909,1911,1913,1915,1916,1918,4982,4984,4986,4988,4989,4990,4991,4992,4993,5183,5184,5185,5186,5187,5188,5189,5190,5191,5192,5193,5194,5195,5196,5197,5198,5199,5200,5201,5202,5203,5204,5205,5206,5207,5208,5209,5210,5211,5244,5245,5246,5247,5248,5249,5250,5251,5252,5253,5254,5255,5256,5257,5258,5259,5260,5261,5262,5263,5264,5265,5266,5267,5268,5269,5270,5271,5272,5273,5274,5864,5869,5871,5872,5873,5874,5875,5876,5877,5878,5879,5880,5881,5882,5883,11491,11492,11493,11494,11495,11496,11497,11498,11499,11500,11501,11502,11503,11504,11505,11506,11507,11508,11509,11510,11511,11512,11513,11514,11515,11516,11517,11518,11519,11520,11521,11522,11523,11524,11525,11526,11527,11528,12464,12468,12469,12481,12483,12484,12485,12486,12487,12673,12674,12675,12676,12677,12678,12679,12680,12681,12682,12683,12684,12685,12686,12687,12688,12689,12690,12691,12692,12693,12694,12695,12696,12697,12698,12699,12891,12892,12893,12894,12895,12896,12897,12898,12899,12900,12901,12902,12903,12904,12905,12906,12907,12908,12909,12910,12911,12912,12913,13203,13204,13205,13206,13207,13208,13209,13210,13211,13212,13213,14019,14024,14025,14036,14038,14054,14055,14056,14057,14146,14147,14148,14149,14150,14151,14152,14153,14154,14155,14156,14157,14158,14159,14160,14161,14162,14163,14164,14165,14166,14167,14168,14169,14170,14171,14204,14205,14206,14207,14208,14209,14210,14211,14212,14213,14214,14215,14216,14217,14218,14219,14220,14221,14222,14223,14224,14225,14226) 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 Купить Наружный водопровод и оборудование для скважин в интернет-магазине оборудование для водоснабжения и отопления от 2947 до 5835 руб., Рабочая среда - Холодная вода

Обратный звонок

Интернет-магазин «Universyst» - оборудование для водоснабжения и отопления из Европы

Мы принимаем к оплате:

Все Распродажа Акции

Наружный водопровод и оборудование для скважин: от 2947 до 5835 руб., Рабочая среда - Холодная вода

Сортировать:

Показывать: