0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for project managers

SELECT 
    CONCAT('https://stackoverflow.com/questions/', p.Id) AS url, 
    p.Title, 
    'tensorflow' AS tag
FROM 
    Posts p 
WHERE
    p.Tags LIKE '%<tensorflow>%'
    AND p.Tags NOT LIKE '%<keras>%'
    AND p.Tags NOT LIKE '%<pytorch>%'
    AND LOWER(p.Title) NOT LIKE '%how%'
    AND LOWER(p.Title) NOT LIKE '%install%'
    AND LOWER(p.Title) NOT LIKE '%build%'
    AND p.AcceptedAnswerId IS NOT NULL
ORDER BY 
    p.ViewCount DESC;

fork query

created may 28 anonymous