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