SELECT p. *
FROM pictures p, pictures_tags pt, tags t
WHERE t.tag_title LIKE '%Zermat%'
AND t.tag_id = pt.tag_id
AND pt.picture_id = p.picture_id
ORDER BY p.picture_id DESC