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