SELECT ROUND( ((IF(tb1.dx>tb1.sx,tb1.dx-tb1.sx,1)-1)/2) , 0) AS nr_node_f,tb1.*,tb2.*, (SELECT parent.id FROM auto_navigation AS node, auto_navigation AS parent WHERE parent.sx < node.sx AND parent.dx > node.dx AND node.id = tb1.id ORDER BY ( parent.dx - parent.sx ) ASC LIMIT 1) AS parent_id FROM (auto_navigation AS tb1 LEFT JOIN `auto_nav_details` AS tb2 ON tb1.id=tb2.uid) LEFT JOIN auto_languages AS l ON l.lid=tb2.lang_id WHERE profile_id=1 AND sx BETWEEN 1 AND 10 AND l.language='it' ORDER BY sx ASC;