NAPAKA - getPagesFromParent: Disk full (/tmp/#sql-temptable-2e9057-ffd43-457a9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

SELECT  s.*  
            FROM stran s
              LEFT JOIN pripadnost p ON (s.stranid = p.elementid)
              LEFT JOIN podatek datum ON datum.stranid = s.stranid AND datum.atributid = 18
            WHERE deleted = 0 AND s.skrij = 0 
                  AND IF(s.timelimitfrom = 0 OR (s.timelimitfrom <> 0 AND s.timelimitfrom <= UNIX_TIMESTAMP()), 1, 0) = 1
                  AND IF(s.timelimitto = 0 OR (s.timelimitto <> 0 AND s.timelimitto >= UNIX_TIMESTAMP()), 1, 0) = 1
             AND (s.parent = 7293 OR p.stranid = 7293)   
            GROUP BY s.stranid
            ORDER BY s.red ASC