SELECT article,author,title
FROM Medium
LEFT JOIN Tags
ON Medium.article = Tags.article
WHERE Medium.author = "Sebastian Carlos"
AND Tags.tagname = "satire"
AND Medium.claps < 100


article       author             title  
------------  ----------------   -----------------
57a117b67f48  Sebastian Carlos   Why SQL is a Fad

Hmm. . .