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_product_skus ps2 ON p.id = ps2.product_id WHERE p.status = 1 AND (p.name LIKE '%%' OR ps2.name LIKE '%%' OR ps2.sku LIKE '%%') GROUP BY p.id ORDER BY in_stock DESC,p.create_datetime DESC LIMIT 30
1054

Товар добавлен в корзину

Закрыть
Закрыть