A Database Error Occurred

Error Number: 1054

Unknown column 'p2.parent_id' in 'on clause'

SELECT p2.* FROM (pages p1) JOIN pages p2 ON p2.parent_id = p1.id WHERE `p1`.`slug` = 'furnace' AND `p2`.`slug` = '04' LIMIT 1