Error 253: 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 'AND ct.id=ctt.clinictype_id AND ctt.language_id=1' at line 12
SELECT clinic.id as clinic_id, store_id, clinic.active, clinic.goal_name, DATE_FORMAT(clinic.start_date, '%M %e, %y') as start_date, DATE_FORMAT(clinic.goal_date, '%M %e, %Y') as goal_date, clinic.start_date as raw_start_date, clinic.goal_date as raw_goal_date, clinic.end_date, store.city, store.prov, store.address1, ctt.name as clinicName, store.name as storeName, ctt.description as clinicDescription FROM clinic, store, clinictype as ct,clinictype_trans as ctt WHERE clinic.store_id=store.id AND clinic.active=1 AND clinic.clinictype_id = ct.id AND clinic.id= AND ct.id=ctt.clinictype_id AND ctt.language_id=1