SQL Error : 1021 Disk full (/tmpmysql/#sql_a9a_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT c.*, COUNT(p.pic_id) AS count
FROM fsb26_album_cat AS c
LEFT JOIN fsb26_album AS p ON c.cat_id = p.pic_cat_id
WHERE cat_id <> 0
GROUP BY cat_id
ORDER BY cat_order ASC