Q&A for professional and enthusiast programmers
SELECT id as [Post Link], * FROM posts join posttags on posts.id = posttags.postid where posttags.tagid = 4 AND Body LIKE '%pacman%' ORDER BY CreationDate DESC