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;
Unable to query MySQL! Please contact Administrator
MySQL Error: Disk full (/var/tmp/#sql_3cab_0); waiting for someone to free some space...