SELECT imgu_albums.id, imgu_albums.timestamp, imgu_albums.name ,
LEFT (imgu_albums.description, 50) as description ,
COUNT(imgu_images.id) as image_count
FROM imgu_albums
LEFT JOIN imgu_images ON imgu_albums.id = imgu_images.id
WHERE imgu_albums.user_id = {$_SESSION['user_id']}
GROUP BY imgu_albums.id