SELECT cat1.is_petpooja, cat1.category_id, cat1.name,cat1.name_ar, cat1.description, cat1.image, cat1.priority, cat1.status, child.category_id as child_id, sibling.category_id as sibling_id FROM skcwihblr_categories AS cat1 LEFT JOIN skcwihblr_categories AS child ON child.parent_id = cat1.category_id LEFT JOIN skcwihblr_categories AS sibling ON sibling.parent_id = child.category_id WHERE cat1.parent_id >= 0 AND cat1.status = 1 AND cat1.is_petpooja = 0  AND cat1.location_id = '8549'