Unknown column '2C4' in 'where clause'
SELECT
sp.*,
sp.url3 url, sp.name3 name, sp.text3 text, sp.title3 title, sp.keywords3 keywords, sp.description3 description,
sc.url category_url, city.name3 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.forGrupoHR7 = 1
GROUP BY sp.id
ORDER BY sp.`date` DESC LIMIT 0,50
Valencia property for sale - Grupo HR7 Real Estate Valencia
