SELECT dc.*, ct.cityname, st.statename, dp.dpname, dp.dschema, co.countryname FROM doctors dc INNER JOIN city ct ON dc.city = ct.cid INNER JOIN state st ON dc.state = st.sid INNER JOIN country co ON dc.isactive = co.isactive INNER JOIN department dp ON dc.department = dp.did WHERE dc.isactive = '1' AND dc.status = '1' AND dc.nameurl = 'counsellors'