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 'AND tc_status='1' GROUP BY c.customer_id ORDER BY c.firstname ASC' at line 1
Error No: 1064
SELECT *, c.firstname as firstname,c.lastname as lastname, tc.primary_mobile as pmobile, tc.primary_phone,tc.barcode_id as barcode,tc.verified_status FROM oc_trainer_client tc LEFT JOIN oc_customer c ON (c.customer_id = tc.client_id) WHERE tc.client_id > '0' AND tc.trainer_id= AND tc_status='1' GROUP BY c.customer_id ORDER BY c.firstname ASC