devsecops

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

select qac.id as id, qac.body as body ,  qac.date as date
from (
select id as id, body as body , creationdate as date from posts 
where  tags like '%devops%' 

union

select res.id as id , res.bodycom as body , res.datecom as date from(select qa.q_id as id ,qa.a_id as a_id, 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 ,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 '%devops%'   )qa join comments c on qa.a_id = c.postid) res

union 

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


union

select qa.id as id , qa.a_body as body, qa.creationdate as date
from (SELECT questions.Id as id, questions.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 '%devops%'   )qa ) qac
group by qac.id,qac.body, qac.date
order by qac.id asc, qac.date

Enter Parameters

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