Untitled

                Never    
SQL
       
SELECT 
	users.first_name, 
	users.last_name, 
	photos.filename, 
	photos.year, 
	photos.description, 
	themes.name AS theme_name,
	COUNT(SELECT * FROM bookmarks WHERE photo_id = 35) AS bookmarked

FROM 
	`photos`, 
	`users`, 
	`themes` 

WHERE 
	users.facebook_id = photos.author AND 
	themes.id = photos.theme AND 
	photos.id = 35 

LIMIT 1

Raw Text