Free iPhone App!
Directory / LocatorsOregon Medical Marijuana Industry Services
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 '.country_id, scountry.country_name FROM josimed_subsite_county c' at line 3 SQL=SELECT cnt.county_id, cnt.county_name, cnt.county_state_id, state.state_name scountry.country_id, scountry.country_name FROM josimed_subsite_county cnt join josimed_subsite_state state ON state.state_id = cnt.county_state_id join josimed_subsite_country scountry ON state.state_country_id = scountry.country_id WHERE cnt.county_published = '1' AND cnt.county_state_id = 37 AND (cnt.county_id IN ( SELECT i.is_county_id FROM josimed_subsite_industry_services i Where i.is_published = 1 AND i.is_approved = 1 AND i.category = 5 ))
