Unnamed

SELECT COUNT(images_view_log.*) as total_views
FROM images
LEFT JOIN images_view_log ON (images_view_log.image_id=images.id)
GROUP BY images.member_id,
	images.views,
	images.description,
	images.filename
ORDER BY images.added DESC LIMIT 50