0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who like playing board games, designing board games or modifying the rules of existing board games

SELECT 
    p.Id,
    p.AcceptedAnswerId,
    p.CreationDate,
    p.Score,
    p.ViewCount,
    p.Body,
    p.Title, 
    p.Tags, 
    p.AnswerCount,
    p.CommentCount,
    p.FavoriteCount,
    p.ClosedDate
FROM 
    Posts p
WHERE 
    p.PostTypeId = 1 -- Only questions
    AND (
        -- Search by tags associated with quantum computing and programming
        p.Tags LIKE '%<quantum-computing>%'
        OR p.Tags LIKE '%<quantum-programming>%'
        OR p.Tags LIKE '%<qiskit>%'
        OR p.Tags LIKE '%<pennylane>%'
        OR p.Tags LIKE '%<quantum-algorithms>%'
        OR p.Tags LIKE '%<quantum-machine-learning>%'
        OR p.Tags LIKE '%<quantum-error-correction>%'
        OR p.Tags LIKE '%<quantum-hardware>%'

        -- Search in title for quantum-related keywords
        OR p.Title LIKE '%quantum%'
        OR p.Title LIKE '%qiskit%'
        OR p.Title LIKE '%pennylane%'
        OR p.Title LIKE '%quantum software%'
        OR p.Title LIKE '%quantum programming%'
        OR p.Title LIKE '%quantum development%'
        OR p.Title LIKE '%quantum code%'
        
        -- Search in body for quantum-related keywords
        OR p.Body LIKE '%quantum%'
        OR p.Body LIKE '%qiskit%'
        OR p.Body LIKE '%pennylane%'
        OR p.Body LIKE '%quantum software%'
        OR p.Body LIKE '%quantum programming%'
        OR p.Body LIKE '%quantum development%'
        OR p.Body LIKE '%quantum code%'
    )
ORDER BY 
    p.CreationDate DESC;

fork query

edited dec 8

created nov 26 anonymous