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 = 31
	AND p.max_price >= 24990
	AND p.min_price <= 132990
	AND ps2.available > 0
	AND (ps2.primary_price  >= 24990)
	AND (ps2.primary_price  <=132990)
GROUP BY p.id
ORDER BY in_stock DESC,p.name 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 = 31 AND p.max_price >= 24990 AND p.min_price <= 132990 AND ps2.available > 0 AND (ps2.primary_price >= 24990) AND (ps2.primary_price <=132990) GROUP BY p.id ORDER BY in_stock DESC,p.name ASC LIMIT 30

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

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