0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

with tbl1 as (
  select PostId
  from Tags, PostTags
  where TagId = Id AND TagName like ('%android%')
)
Select t.PostId, p.ParentId, p.Id 
 from Posts p
 JOIN tbl1 t on (t.PostId = p.ParentId)

fork query

edited feb 5 13

created feb 5 13 anonymous