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)