0

Please login or register to vote for this query.

(click on this box to dismiss)

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 for questions and LEFT JOIN for answers
FROM Posts q
LEFT JOIN Posts a ON q.AcceptedAnswerId = a.Id
-- 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>%')
-- Filter by the date range you want
AND (q.CreationDate BETWEEN '2008-08-01' AND '2023-08-01')
-- Order by the question date
ORDER BY q.CreationDate;

fork query

created may 25 anonymous