<pre>select ud.username,
                   ug.*,
                   UNIX_TIMESTAMP(ug.change_date) as change_date,
                   count(ugp.id) as num_of_pic
            from usergallery ug,
                 phpbb3_users ud,
                 usergallery_picture ugp
            where ug.board_user_id = ud.user_id
              and ug.id = ugp.usergallery_id
              and ug.board_user_id = 73
              and ug.deleted = 0
              and ugp.deleted = 0
            group by ug.id
            order by ug.sort_order</pre>Disk full (/tmp/#sql_4c3_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br><br>/galerie/user/show_items.php