{"totalData":3803,"code":3803,"data":[{"sn":1,"labname":"'WESTERN INDIA CORRUGATED BOX MANUFACTURERS' ASSOCIATION R&D CENTRE","linkopen_span":"8597","address":"138, MITTAL INDUSTRIAL ESTATE NO 3,M VASANJI ROAD, ANDHERI EAST\nMumbai\nMAHARASHTRA\nINDIA","telephone":"9664206924","fax":"","email":"wicmaoffice@gmail.com","contact_person":"MANOJ DINKAR RAHATE","lab_registration_code":"T-5840","certificate_no":"TC-4145","issue_date":"24-05-2023","expiry_date":"23-05-2025","certificateURL":"https:\/\/nablwp.qci.org.in\/CertificateScope?x=zi7fxDLSQ7h4kJrgbtVmSw==","extend_date":"","lab_address1":"138, MITTAL INDUSTRIAL ESTATE NO 3,M VASANJI ROAD, ANDHERI EAST","city":"Mumbai","state":"MAHARASHTRA","country":"INDIA"},{"sn":2,"labname":"1600 KV ULTRA HIGH VOLTAGE RESEARCH CENTRE,CG POWER & INDUSTRIAL SOLUTIONS LTD.,SWITCHGEAR DIVISION.","linkopen_span":"4426","address":"A-3, MIDC, AMBAD,\nNashik\nMAHARASHTRA\nINDIA","telephone":"9822856818","fax":"","email":"shailesh.joshi@cgglobal.com","contact_person":"SHAILESH JOSHI","lab_registration_code":"T-3204","certificate_no":"TC-13276","issue_date":"15-03-2024","expiry_date":"14-03-2026","certificateURL":"https:\/\/nablwp.qci.org.in\/CertificateScope?x=ghqMd5y8LE4YjmDic\/ujIg==","extend_date":"","lab_address1":"A-3, MIDC, AMBAD,","city":"Nashik","state":"MAHARASHTRA","country":"INDIA"},{"sn":3,"labname":"5G TEST LAB, HARMAN CONNECTED SERVICES CORPORATION INDIA PVT. LTD.","linkopen_span":"13605","address":"BUILDING NO. 10C, 2ND FLOOR, DLF CYBER CITY, DLF PHASE 2\nGurugram\nHARYANA\nINDIA","telephone":"9741350333","fax":"","email":"Simanchal.Panda@harman.com","contact_person":"SIMANCHAL PANDA","lab_registration_code":"T-8351","certificate_no":"TC-12517","issue_date":"02-11-2023","expiry_date":"01-11-2025","certificateURL":"https:\/\/nablwp.qci.org.in\/CertificateScope?x=HHQQtLOHvZMm0pHkZ99tFg==","extend_date":"","lab_address1":"BUILDING NO. 10C, 2ND FLOOR, DLF CYBER CITY, DLF PHASE 2","city":"Gurugram","state":"HARYANA","country":"INDIA"},{"sn":4,"labname":"A & D INSTRUMENTS INDIAPRIVATE LIMITED (CALIBRATION DIVISION )","linkopen_span":"13465","address":"PLOT NO. D-48, UDYOG VIHAR, PHASE-V\nGurugram\nHARYANA\nINDIA","telephone":"9560912200","fax":"","email":"cal-lab@aanddindia.in","contact_person":"ANIL KUMAR PS","lab_registration_code":"C-2041","certificate_no":"CC-3722","issue_date":"05-10-2023","expiry_date":"04-10-2025","certificateURL":"https:\/\/nablwp.qci.org.in\/CertificateScope?x=8aP7Or0MU2eLJUWRSIFmOA==","extend_date":"","lab_address1":"PLOT NO. D-48, UDYOG VIHAR, PHASE-V","city":"Gurugram","state":"HARYANA","country":"INDIA"},{"sn":5,"labname":"A G DIAGNOSTICS PVT. LTD.","linkopen_span":"6301","address":"NAYANTARA BUILDING. CTS NO89\/FP147, BHANDARKAR ROAD\nPune\nMAHARASHTRA\nINDIA","telephone":"9822066421","fax":"020-67636763","email":"manisha@agdiagnostics.com","contact_person":"MANISHA PATWARDHAN","lab_registration_code":"M-1661","certificate_no":"MC-3143","issue_date":"06-03-2024","expiry_date":"05-03-2026","certificateURL":"https:\/\/nablwp.qci.org.in\/CertificateScope?x=O9ySSGUdxextpDgCy2TYtA==","extend_date":"","lab_address1":"NAYANTARA BUILDING. CTS NO89\/FP147, BHANDARKAR ROAD","city":"Pune","state":"MAHARASHTRA","country":"INDIA"},{"sn":6,"labname":"A ONE DIAGNOSTICS","linkopen_span":"13365","address":"1-8-101, GROUND FLOOR, RADHA SUDHA BUILDING, ALWAL, MEDCHAL MALKAJGIRI\nHyderabad\nTELANGANA\nINDIA","telephone":"8096797707","fax":"","email":"diagnosticsaone@gmail.com","contact_person":"B SRIDHAR","lab_registration_code":"M-3641","certificate_no":"MC-5935","issue_date":"29-08-2023","expiry_date":"28-08-2025","certificateURL":"https:\/\/nablwp.qci.org.in\/CertificateScope?x=O1horTfOwq8xzjOW57Xp3g==","extend_date":"","lab_address1":"1-8-101, GROUND FLOOR, RADHA SUDHA BUILDING, ALWAL, MEDCHAL MALKAJGIRI","city":"Hyderabad","state":"TELANGANA","country":"INDIA"},{"sn":7,"labname":"A-STAR TESTING & INSPECTION PRIVATE LIMITED","linkopen_span":"13622","address":"NO. 3\/11, JM BUILDING, 2ND FLOOR, ARCOT ROAD, KARAMBAKKAM, PORUR\nChennai\nTAMIL NADU\nINDIA","telephone":"9952015708","fax":"","email":"admin@astartesting.co.in","contact_person":"SUDHIR KUMAR P","lab_registration_code":"T-7895","certificate_no":"TC-12526","issue_date":"04-11-2023","expiry_date":"03-11-2025","certificateURL":"https:\/\/nablwp.qci.org.in\/CertificateScope?x=9y8vTHWAeEPxetYJ6fADBg==","extend_date":"","lab_address1":"NO. 3\/11, JM BUILDING, 2ND FLOOR, ARCOT ROAD, KARAMBAKKAM, PORUR","city":"Chennai","state":"TAMIL NADU","country":"INDIA"},{"sn":8,"labname":"A.K. DIAGNOSTIC CENTRE (LABORATORY DIVISION)","linkopen_span":"13358","address":"A-45, SHASTRI NAGAR\nJaipur\nRAJASTHAN\nINDIA","telephone":"9829079097","fax":"","email":"drabhaybhargava@yahoo.com","contact_person":"ABHAY BHARGAVA","lab_registration_code":"M-4304","certificate_no":"MC-5965","issue_date":"08-09-2023","expiry_date":"07-09-2025","certificateURL":"https:\/\/nablwp.qci.org.in\/CertificateScope?x=GHDltwalGY2dxZj3rkWB+Q==","extend_date":"","lab_address1":"A-45, SHASTRI NAGAR","city":"Jaipur","state":"RAJASTHAN","country":"INDIA"},{"sn":9,"labname":"A.K. GEO MATERIAL LABORATORY","linkopen_span":"13425","address":"DHOTI, SHAHPUR ROAD, WAIDHAN\nSingrauli\nMADHYA PRADESH\nINDIA","telephone":"9755876208","fax":"","email":"akgml2020@gmail.com","contact_person":"SUMIT SHAH","lab_registration_code":"T-8374","certificate_no":"TC-12303","issue_date":"21-09-2023","expiry_date":"20-09-2025","certificateURL":"https:\/\/nablwp.qci.org.in\/CertificateScope?x=3ZWD6tG1tNAV6WWsTUr4HQ==","extend_date":"","lab_address1":"DHOTI, SHAHPUR ROAD, WAIDHAN","city":"Singrauli","state":"MADHYA PRADESH","country":"INDIA"},{"sn":10,"labname":"A4 TESTING LAB","linkopen_span":"13185","address":"PLOT 1C, PRAGATI NAGAR, TAKROHI, INDIRA NAGAR\nLucknow\nUTTAR PRADESH\nINDIA","telephone":"7705003224","fax":"","email":"a4testinglab@gmail.com","contact_person":"ANUNJAY CHAUHAN","lab_registration_code":"T-8330","certificate_no":"TC-12113","issue_date":"18-08-2023","expiry_date":"17-08-2025","certificateURL":"https:\/\/nablwp.qci.org.in\/CertificateScope?x=DC0cdA+gw9StWXGQuVhKBg==","extend_date":"","lab_address1":"PLOT 1C, PRAGATI NAGAR, TAKROHI, INDIRA NAGAR","city":"Lucknow","state":"UTTAR PRADESH","country":"INDIA"}],"pagelast":381,"extdata":0,"qry":"SELECT DiSTINCT l.id,l.lab_registration_code,l.lab_name,despln.category_name,l.lab_address as lab_address1,city.name as lab_city,s.name as lab_state,ctry.name as lab_country,CONCAT_WS(\"\\n\",l.lab_address,city.name,s.name,ctry.name) as lab_address,l.phone,l.fax,l.emailid,l.contact_person,c.id as cid,c.certificate_no,c.certificate_file2,c.faclity_id,c.issue_date,c.expiry_date,c.extend_date,if(c.save_type=\"web\",CONCAT(\"https:\/\/nabl-india.org\/nabl\/file_download1.php?filename=\",c.certificate_file),c.certificate_file) as certificateURL FROM laboratory_tbl as l inner join lab_certificate_tbl as c on(c.lab_id=l.id AND c.id=(select max(cdd.id) from lab_certificate_tbl As cdd where cdd.lab_id=l.id AND cdd.status=1 ) ) inner join certificate_sub_group_tbl as csub on(c.id=csub.certificate_id) inner join lab_category_tbl as despln on(despln.id=c.faclity_id) LEFT JOIN cities As city ON (l.city=city.id) LEFT JOIN states As s ON (l.state=s.id) LEFT JOIN country As ctry ON (l.country=ctry.id) LEFT JOIN zone_tbl As z ON (l.zone=z.id) WHERE 1 AND l.status=1 AND c.status=1 AND c.is_apiarchive=0 AND (c.expiry_date>=\"2025-05-05\" or c.extend_date>=\"2025-05-05\")  ORDER BY l.lab_name limit 0,10","pagination":[{"pageUrl":1,"pageText":"Start"},{"pageUrl":1,"pageText":1},{"pageUrl":2,"pageText":2},{"pageUrl":3,"pageText":3},{"pageUrl":4,"pageText":4},{"pageUrl":5,"pageText":5},{"pageUrl":6,"pageText":6},{"pageUrl":7,"pageText":7},{"pageUrl":8,"pageText":8},{"pageUrl":9,"pageText":9},{"pageUrl":381,"pageText":"Last"}]}