select * from pages where slug='careers-hhp' AND deleted != 1Getting Child