0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to improve their interpersonal communication skills

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, firstAnswer.creationDate as FirstAnswerCreationDate
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

inner join (select top 1 parentid,creationDate
from posts where posttypeid=2 and parentid=14049480
order by  creationDate asc) firstAnswer on q.id=firstAnswer.parentid

where q.posttypeid = 1 and q.id=14049480
 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
order by a.score

fork query

edited aug 5

created aug 5 anonymous