SELECT p.*, IF( p.id_parent =1, p.pos, p2.pos ) AS pos1, IF( p.id_parent =1, 0, p.pos ) AS pos2 FROM `pagine` AS p LEFT JOIN `pagine` AS p2 ON ( p2.id = p.id_parent ) WHERE p.aut =2 AND p2.aut=2 AND p.level_depth IN ( 1, 2 ) ORDER BY pos1, pos2
Disk full (/var/tmp/#sql_642_0); waiting for someone to free some space...
