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, p.id
LIMIT 39Запрашиваемый ресурс недоступен.