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 (614) 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