0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

SELECT
q.id, q.Title, q.Body q_body, q.parentid qpid, q.AcceptedAnswerId, q.Score q_score, q.AnswerCount, q.Tags, q.viewcount,
answers.parentid aa_pid, answers.id aa_id,
answers.body aa_body, answers.score as aa_score, answers.posttypeid, q.CreationDate 
FROM
  Posts answers
INNER JOIN Posts q
  ON answers.parentid = q.id
WHERE (answers.parentId = q.id) AND q.AnswerCount >= 1 AND (q.Tags like '%aws-%' or q.Tags like '%amazon-%')

fork query

created mar 27 23 anonymous