delete cat.* from categories cat where id in (select  from (select c.id from apks a right join categories c on a.category_id = c.id where category_id  is null and parent != 0) x);