0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for power users of web applications

SELECT q.title, 
       CONCAT('https://stackoverflow.com/questions/', q.id) AS url, 
       q.tags, 
       q.score, 
       q.creationDate AS questionCreationDate, 
       q.body AS questionBody,          -- Added question body
       a.creationDate AS answerCreationDate,
       a.score AS answerScore, 
       a.body AS answerBody,             -- Added answer body
       u.reputation AS acceptedResponderReputation,
       a.owneruserid AS acceptedResponder, 
       v.reputation AS questionerReputation,
       q.owneruserid AS questioner
FROM posts q 
INNER JOIN posts a ON q.acceptedanswerid = a.id
INNER JOIN Users u ON a.owneruserid = u.id 
INNER JOIN Users v ON q.owneruserid = v.id
WHERE q.posttypeid = 1 
  AND a.posttypeid = 2 
  AND q.body LIKE '%code%' 
  AND q.tags LIKE '%keras%' 
  AND q.tags LIKE '%python%' 
  AND q.score > 5 
  AND a.score > 5
  AND q.creationDate BETWEEN '2021-01-01' AND '2024-12-31'
ORDER BY q.creationDate DESC;

fork query

edited nov 13

created aug 5 20 anonymous