ERROR - SELECT DISTINCT SQL_CALC_FOUND_ROWS
                pr.rozdil `dirname`,
                p.photos_m as icon,
                p.photos as image,
                p.pidpys as main_image_title,
                pr.weight,
                count(p.photos_m) as n_images
            FROM cms_photogalery_rozdil pr,
                 cms_photogalery p
            WHERE pr.site_id = 1
              AND p.vis
              AND p.site = 1
              AND SUBSTRING_INDEX( pr.rozdil, '/', 2 ) ='2008/Всеукраинский детско-юношеский турнир по джиу-джитсу'
              AND SUBSTRING_INDEX( pr.rozdil, '/', 3 )=pr.rozdil
              AND (pr.rozdil=p.rozdil OR pr.rozdil=SUBSTRING_INDEX( p.rozdil, '/', 3 ))
            GROUP BY `dirname`
            ORDER BY pr.weight, pr.rozdil
            LIMIT 0,10
Can't create/write to file '/tmp/#sql_537_0.MAI' (Errcode: 28 "No space left on device")