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