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), q.tags,
q.score, q.creationDate, a.creationDate,
a.score, 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 a.score

fork query

edited nov 13

created aug 5 20 anonymous