SELECT DISTINCT C.id, C.* 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) LEFT JOIN pv_cities_tbl AS CT ON (C.childcareCity= CT.name) LEFT JOIN pv_areas_tbl AS CA ON (C.childcareArea= CA.area) WHERE (TRIM(LOWER(C.childcareCity))='bangalore' AND TRIM(LOWER(C.childcareArea))='devarabisanahalli' AND dsaFulltime='Yes' AND C.isActive='1' AND LOWER(CT.state)='karnataka') ORDER BY C.dispOrder DESC, C.total_views DESC LIMIT 0, 20
Finding your location: checking...