CSCW Technology reinvention - separate pool of questions tagged 'invented'

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select reinvented.tagname reinvented, 'with' presence, ##Invented:string## invented, 
count(distinct answerer.id) nanswerers, 
cast(sum(answers.score) as float) score, 
--cast(sum(answerer.reputation) as float) reputation,
count(distinct answers.id) nanswers,
cast(sum(answers.score) as float) / count(distinct answers.id) score_per_answer
from tags reinvented, users answerer,
posts questions, posts answers, posttags ptri
where 
questions.posttypeid=1
and questions.id = ptri.postid
and ptri.tagid=reinvented.id
and questions.id=answers.parentid
and answers.posttypeid=2
and answers.owneruserid=answerer.id
and answerer.reputation between 2 and 100000
and reinvented.tagname = ##Reinvented:string## 
and ##Invented:string##  in (select tagname from tags invented, posttags pti
where invented.id=pti.tagid and pti.postid=questions.id)
group by reinvented.tagname
union
select reinvented.tagname reinvented, 'without' presence, ##Invented:string## invented, 
count(distinct answerer.id) nanswerers, 
cast(sum(answers.score) as float) score,
--cast(sum(answerer.reputation) as float) reputation, 
count(distinct answers.id) nanswers,
cast(sum(answers.score) as float) / count(distinct answers.id) score_per_answer
from tags reinvented, users answerer,
posts questions, posts answers, posttags ptri
where 
questions.posttypeid=1
and questions.id = ptri.postid
and ptri.tagid=reinvented.id
and questions.id=answers.parentid
and answers.posttypeid=2
and answers.owneruserid=answerer.id
and answerer.reputation between 2 and 100000
and reinvented.tagname = ##Reinvented:string##
and ##Invented:string## not in (select tagname from tags invented, posttags pti
where invented.id=pti.tagid and pti.postid=questions.id)
group by reinvented.tagname

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results