new1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

select qac.id as id, qac.title as title, qac.body as body ,  qac.date as date
from (

select id as id ,title as title, body as body, creationdate as date from posts 
where tags like '%bug%' and tags like '%bug%' and tags not like '%bug%'

union

select res.id as id , res.title as title, res.bodycom as body , res.datecom as date 
from(select qa.q_id as id ,qa.a_id as a_id, qa.title as title, qa.a_body as body, qa.creationdate as date, c.text as bodycom, c.creationdate as datecom
from (SELECT questions.Id as q_id, answers.id as a_id, questions.title as title ,questions.body as q_body, answers.body as a_body, answers.creationdate
FROM Posts answers
INNER JOIN Posts questions ON answers.parentid = questions.id
WHERE questions.body like '%bug%' and questions.tags like '%bug%' and questions.tags not like '%bug%' )qa join comments c on qa.a_id = c.postid) res

union 

select dd.id as id , dd.title as title, dd.body as body, dd.date as date from(select p.id as id , p.parentid as parentid, p.title as title, c.text as body, c.creationdate as date
from (select id , parentid , title
from posts 
where (title like '%bug%' and title like '%blame%')  ) p join comments c on p.id = c.postid) dd
where dd.parentid is null


union

select qa.id as id , qa.title as title, qa.a_body as body, qa.creationdate as date
from (SELECT questions.Id as id, questions.title as title, questions.body as q_body, answers.body as a_body, answers.creationdate
FROM Posts answers
INNER JOIN Posts questions ON answers.parentid = questions.id
WHERE questions.tags like '%bug%' and questions.tags like '%bug%' and questions.tags not like '%bug%' )qa ) qac
group by qac.id,qac.body, qac.date,qac.title
order by qac.id asc, qac.date

Enter Parameters

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