1064 - 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 'IN (105241) && b1.mem_slno IN ('1123518','1177480','1189157','1200350','1234991'' at line 1
select c1.slno branch_slno,c1.address branch_address,c1.main_city branch_main_city, c1.city branch_city, c1.sub_city branch_sub_city, c1.branch_type, b1.mem_slno,a1.master_id,b1.classified_category, a1.comp_name, a1.pi_paid_status, a1.country, a1.postal_code, a1.address, a1.web_address, a1.address, a1.recr_file_name,a1.comp_logo,a1.image_cutting_status, a1.company_logo_size, a1.mem_oth_status, a1.city, a1.sub_city, a1.category,a1.new_mobile_phone from members_recruiter as a1 INNER JOIN branch_classified_tbl as b1 ON a1.mem_slno=b1.mem_slno INNER JOIN recruiter_branches as c1 ON b1.recruiter_branch_slno=c1.slno where a1.active_status='Y' and a1.test_status='0' && b1.classified_category='19' && c1. IN (105241) && b1.mem_slno IN ('1123518','1177480','1189157','1200350','1234991','931385','1226034','759619','947024','852720','1263843','1207711','1119734','749311','763472','744583','760090','763474','1000463','1117065') GROUP BY b1.mem_slno order by FIELD(b1.mem_slno,'1123518','1177480','1189157','1200350','1234991','931385','1226034','759619','947024','852720','1263843','1207711','1119734','749311','763472','744583','760090','763474','1000463','1117065')
