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))='tezpur' AND dsaPrescool='Yes' AND C.isActive='1' AND LOWER(CT.state)='assam') ORDER BY C.dispOrder DESC, C.total_views DESC LIMIT 34240, 20
Finding your location: checking...