Hoffe ich hab es richtig erklärt.

Schreibs auf :)

  
SELECT count(*) as numberOfPhotos  
FROM photo  
JOIN article ON photo.fk_article = article.id  
WHERE article.language = 'de' AND article.status = 'published'  

ungetestet.

Schreibr, Horst