Top HR Consultant and Staffing Solutions Companies in Nagapur (17 results)
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 (102393) && b1.mem_slno IN ('632685','632751','679183','315019','692477','475' 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='11' && c1. IN (102393) && b1.mem_slno IN ('632685','632751','679183','315019','692477','475679','328095','973185','486889','359286','277659','275728','831518','679151','679147','689751','666590') GROUP BY b1.mem_slno order by FIELD(b1.mem_slno,'632685','632751','679183','315019','692477','475679','328095','973185','486889','359286','277659','275728','831518','679151','679147','689751','666590')
