Unknown column '2C4' in 'where clause'
SELECT
sp.*,
sp.url2 url, sp.name2 name, sp.text2 text, sp.title2 title, sp.keywords2 keywords, sp.description2 description,
sc.url category_url, city.name2 city_name,
svsquare.value param_square, svrooms.value param_rooms, svbath.value param_bathrooms
FROM shop_products sp
LEFT JOIN shop_categories AS sc ON sc.id = sp.category
LEFT JOIN geo_cities AS city ON city.id = sp.city
LEFT JOIN shop_product_values AS svsquare ON svsquare.product = sp.id AND svsquare.parameter = 4
LEFT JOIN shop_product_values AS svrooms ON svrooms.product = sp.id AND svrooms.parameter = 7
LEFT JOIN shop_product_values AS svbath ON svbath.product = sp.id AND svbath.parameter = 8
WHERE sp.display = 1
AND sp.category IN ('6','7','22') AND ( sp.region IN (1) OR sp.city IN (3%2C4%2C19%2C37%2C1) ) AND sp.price >= 200000
GROUP BY sp.id
ORDER BY sp.`date` DESC LIMIT 0,50
Lux Valencia Real Estate - exclusive properties in Valencia and Costa Blanca
