Get all tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

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

select 
  p.id,
  p.creationdate,
  p.lastactivitydate,
  p.score, 
  p.viewcount, 
  p.title,
  p.favoritecount,
  p.tags,
  p.AcceptedAnswerId
  
from 
  posts as p join posttags as pt 
  on 
    p.id = pt.postid
  join tags as t 
  on 
    pt.tagid = t.id
  left join posts as ans
  on 
    p.acceptedanswerid = ans.id
  left join users as u
  on 
    p.owneruserid = u.id
where 
  t.tagname = 'php' and 
  p.creationdate <'2021' and
  p.lastactivitydate > '2018-01-01 00:00:00' and
  p.score > 0 and
  p.viewcount>200 and
  u.upvotes>20
 
order by p.viewcount desc

Enter Parameters

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