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
	JOIN shop_product_features pf2
		ON p.id = pf2.product_id AND pf2.feature_id = 50
WHERE p.status = 1
	AND cp1.category_id = 28
	AND ps2.available > 0
	AND pf2.feature_value_id IN (0,49) AND (pf2.sku_id IS NULL OR pf2.sku_id = ps2.id)
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 JOIN shop_product_features pf2 ON p.id = pf2.product_id AND pf2.feature_id = 50 WHERE p.status = 1 AND cp1.category_id = 28 AND ps2.available > 0 AND pf2.feature_value_id IN (0,49) AND (pf2.sku_id IS NULL OR pf2.sku_id = ps2.id) GROUP BY p.id ORDER BY in_stock DESC,cp1.sort ASC LIMIT 30

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

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