1054. Query Error 1054: Unknown column 'ps1.status' in 'where clause'
Query: SELECT p.*,p.id,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 (ps1.count IS NULL OR ps1.count > 0)
AND pf1.feature_value_id IN (844) AND (pf1.sku_id IS NULL OR pf1.sku_id = ps1.id)
AND (p.count > 0 || p.count IS NULL)
AND p.status = 1
GROUP BY p.id
ORDER BY p.create_datetime DESC
LIMIT 30