SELECT 
	* 
FROM 
	albums
LEFT JOIN albums_tags ON albums_tags.album_id = albums.album_id 
LEFT JOIN photos_tags ON photos_tags.tag_id = albums_tags.tag_id 
LEFT JOIN photos on photos.photo_id = photos_tags.photo_id;