1054. Query Error 1054: Unknown column 'ps1.status' in 'where clause'
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 ps1
ON ps1.product_id = p.id
JOIN shop_product_features pf1
ON p.id = pf1.product_id AND pf1.feature_id = 32
WHERE ps1.status
AND pf1.feature_value_id IN (685) AND (pf1.sku_id IS NULL OR pf1.sku_id = ps1.id)
AND p.status = 1
GROUP BY p.id
ORDER BY in_stock DESC,p.create_datetime DESC
LIMIT 30