1052. Query Error 1052: Column 'price' in where clause is ambiguous Query: SELECT p.*,p.id 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 = 4 JOIN shop_category_products cp1 ON p.id = cp1.product_id WHERE ps1.available > 0 AND ps1.status AND pf1.feature_value_id IN (61) AND (pf1.sku_id IS NULL OR pf1.sku_id = ps1.id) AND p.status = 1 AND cp1.category_id IN(15,43,44,45,46,47,48,49,51,54,55,56,57,474,475,476,477,576,577,726,794,795,796,797,798,800,801,802,804,805,806,856,867,935,936,937,938,939,940,941,942,943,944,954,955,956,958,959,960,961,962,965,966,967,968,969,970,971,1005,1007,1010,1024,1100,1101,1147,1152,1153,1177,1212,1254,1265,1266,1390,1391,1392,1393,1394,1395,1396) AND price IS NOT NULL AND price > 0.0 AND count IS NOT NULL AND count > 0.0 GROUP BY p.id ORDER BY p.price ASC, p.id LIMIT 3