A Database Error Occurred

Error Number: 1064

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 ''painter-and-decorators', 20' at line 17

select DISTINCT(master.refid), master.* from master INNER JOIN detailscities ON master.refid = detailscities.refid INNER JOIN cities ON detailscities.city_id = cities.city_id INNER JOIN detailstrade ON master.refid = detailstrade.refid INNER JOIN services ON detailstrade.service_id = services.service_id WHERE city_url = 'nottingham' AND active = 1 AND ( LOWER(master.description) LIKE '%Nottingham%' OR LOWER(master.keywords) LIKE '%Nottingham%' OR LOWER(master.primarywork) LIKE '%Nottingham%' OR LOWER(master.company) LIKE '%Nottingham%' OR LOWER(master.refid) LIKE '%Nottingham%' ) ORDER BY RAND() LIMIT 'painter-and-decorators', 20