System Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-5,10' at line 11
Please notify help@circumerro.com with this message and following information.
SELECT distinct(p.rec_id), p.*
, t.name as type_name
, s.name as status_name
, r.name as region_name
FROM properties AS p
LEFT JOIN property_attribs as t ON p.type = t.value
LEFT JOIN property_attribs as s ON p.status = s.value
LEFT JOIN property_attribs as r ON p.region = r.rec_id
WHERE p.active = 'yes'
AND p.attributes LIKE '%125%'
ORDER BY p.price LIMIT -5,10
Lowcountry Real Estate 820 Bay Street Beaufort, SC 29902 Office: 843-521-4200 Fax: 843-521-4203 Cell: 843-812-5000 Toll Free: 800-452-0226