Query:SELECT a.*,b.shortname as locname FROM cl_listings a,cl_locations b,cl_users e ,cl_payment c where a.status='active' and b.id=a.locid and (a.adtitle like '%Goldy's Fitness Club and Gym%' or a.addesc like '%Goldy's Fitness Club and Gym%' or a.keyword like '%Goldy's Fitness Club and Gym%') and e.id=a.userid and e.status='active' and a.payment_id=c.id and c.status='paid' and a.payment_id>2 order by RAND()
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 's Fitness Club and Gym%' or a.addesc like '%Goldy's Fitness Club and Gym%' or a.' at line 1