SELECT q.title, concat('https://stackoverflow.com/questio...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

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, 
(select top 1 creationDate
from posts where posttypeid=2 and parentid=14049480
order by  creationDate asc) 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



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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results