SELECT q.Id AS QuestionId, q.Title AS QuestionTitle, q.Bo...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- Select the columns you want to export
SELECT 
    q.Id AS QuestionId, 
    q.Title AS QuestionTitle, 
    q.Body AS QuestionBody, 
    q.Tags AS QuestionTags, 
    q.CreationDate AS QuestionDate, 
    q.AcceptedAnswerId AS AcceptedAnswerId,
    a.Id AS AnswerId, 
    a.Body AS AnswerBody, 
    a.CreationDate AS AnswerDate
-- Join the Posts table twice, once for questions and once for answers
FROM Posts q
LEFT JOIN Posts a ON q.Id = a.ParentId
-- Filter by the tags you are interested in
WHERE (q.Tags LIKE '%<post-quantum-cryptography>%' 
       OR q.Tags LIKE '%<q#>%' 
       OR q.Tags LIKE '%<quantum-computing>%' 
       OR q.Tags LIKE '%<qiskit>%' 
       OR q.Tags LIKE '%<qcl>%' 
       OR q.Tags LIKE '%<qutip>%' 
       OR q.Tags LIKE '%<qubit>%' 
       OR q.Tags LIKE '%<tensorflow-quantum>%')
  AND q.AcceptedAnswerId IS NULL
  AND (q.CreationDate BETWEEN '2008-08-01' AND '2023-08-01')
-- Order by the question date
ORDER BY q.CreationDate;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results