SELECT COUNT(C.id) FROM pv_childprovider_tbl AS C INNER JOIN pv_dcservices_tbl AS S ON (C.id= S.daycareId) INNER JOIN pv_dcfacilities_tbl AS FA ON (C.id= FA.daycareId) INNER JOIN pv_cities_tbl AS CT ON (C.childcareCity= CT.name) WHERE (TRIM(LOWER(C.childcareCity))='varanasi' AND dsaHalftime='Yes' AND C.isActive='1' AND LOWER(CT.state)='uttar pradesh')
Finding your location: checking...