Query Error 1054: Unknown column 'ps1.id' in 'field list'
Query: SELECT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock,GROUP_CONCAT(DISTINCT ps1.id) AS sku_ids
FROM shop_product p
	JOIN shop_category_products cp1
		ON p.id = cp1.product_id
	JOIN shop_product_skus ps2
		ON ps2.product_id = p.id
WHERE p.status = 1
	AND cp1.category_id = 42
	AND p.max_price >= 20990
	AND p.min_price <= 56990
	AND ps2.available > 0
	AND (ps2.primary_price  >= 20990)
	AND (ps2.primary_price  <=56990)
GROUP BY p.id
ORDER BY in_stock DESC,cp1.sort ASC
LIMIT 30

Query Error 1054: Unknown column 'ps1.id' in 'field list' Query: SELECT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock,GROUP_CONCAT(DISTINCT ps1.id) AS sku_ids FROM shop_product p JOIN shop_category_products cp1 ON p.id = cp1.product_id JOIN shop_product_skus ps2 ON ps2.product_id = p.id WHERE p.status = 1 AND cp1.category_id = 42 AND p.max_price >= 20990 AND p.min_price <= 56990 AND ps2.available > 0 AND (ps2.primary_price >= 20990) AND (ps2.primary_price <=56990) GROUP BY p.id ORDER BY in_stock DESC,cp1.sort ASC LIMIT 30

1054. Запрошенный ресурс недоступен.

Этот веб-сайт использует cookie-файлы.
При использовании данного сайта вы подтверждаете свое согласие на использование cookie-файлов в соответствии с нашей политикой приватности.