Q&A about the site for administrators, end users, developers and designers for Craft CMS
SELECT q.id as 'qid', q.Title, q.Score as 'qscore', q.Tags as 'tags', q.LastActivityDate as 'qdate', q.Body as 'question', a.id as 'aid', a.Body as 'answer', a.Score as 'ascore', a.LastActivityDate as 'adate', a.CommentCount as 'acommentcount', u.Reputation as 'ureputation'
FROM Posts q
JOIN Posts as a ON a.ParentId = q.id
JOIN Users as u ON u.id = a.OwnerUserId
q.Tags LIKE '%<tornado>%' AND