Select another state

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 wear') ) ORDER BY current_plan_package DESC' at line 12 SELECT current_plan_package,business_name, business_id, big_description, small_description, address1, address2, building_name, area, city, nearest_busstop, state, country, zipcode, seo_url FROM bd_business_description WHERE mirror='0' AND status='1' AND state='Lagos' AND country='Nigeria' AND business_id IN( SELECT business_id FROM bd_business_category WHERE category_id IN (SELECT CategoryID FROM bd_category WHERE Name='Men's wear') ) ORDER BY current_plan_package DESC