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) WHERE (TRIM(LOWER(C.childcareCity))='panchkoshi road' AND dsaPrescool='Yes' AND C.isActive='1' AND LOWER(CT.state)='agra') ORDER BY C.dispOrder DESC, C.total_views DESC LIMIT 28160, 20
Finding your location: checking...