Q&A for Tridion developers and administrators
SELECT Top 4000 Questions.Id as Id, Questions.Title as Title, Questions.Body as Body, Questions.Tags as Tags, Questions.AnswerCount as AnswerCount FROM Posts AS Answers INNER JOIN Posts AS Questions ON Questions.Id = Answers.ParentId WHERE Questions.PostTypeId = 1 and (Questions.Tags like '%java%') and (Questions.Tags like '%android%') and (Questions.Tags not like '%performance%') ORDER BY Questions.Id;