SELECT id_category FROM category WHERE id_parent=(SELECT c.id_category FROM category c LEFT JOIN category_content cc ON cc.id_category=c.id_category WHERE lang='bg' AND alias='ekskurzii-pochivki')
    AND id_category NOT IN (SELECT id_parent FROM category) UNION SELECT id_category FROM category WHERE id_parent=(SELECT id_category FROM category WHERE id_parent=(SELECT c.id_category FROM category c LEFT JOIN category_content cc ON cc.id_category=c.id_category WHERE lang='bg' AND alias='ekskurzii-pochivki')
    AND id_category IN (SELECT id_parent FROM category))