SELECT ROUND( (tb1.dx-tb1.sx-1)/2 , 0) AS nr_node_f,tb1.*,tb2.* FROM (show_navigation AS tb1 LEFT JOIN `show_nav_details` AS tb2 ON tb1.id=tb2.uid) LEFT JOIN show_languages AS l ON l.lid=tb2.lang_id WHERE profile_id=1 AND sx BETWEEN 4 AND 27 AND l.language='en' ORDER BY sx ASC;