Q&A for Ubuntu users and developers
SELECT Id,ParentId,Body,Tags,ViewCount,CreationDate FROM Posts WHERE PostTypeId = 1 and ( Tags =('java') or Tags LIKE('%<java>%') or Tags LIKE('%jpa%') or Tags LIKE('%swing%') or Tags LIKE('%spring%') or Tags LIKE('%hibernate%') or Tags LIKE('%jdbc%') or Tags LIKE('%javafx%') or Tags LIKE('%jframe%') or Tags LIKE('%android-studio%') or Tags LIKE('%java-ee%') or Tags LIKE('%java-8%') ) AND CreationDate BETWEEN'06-01-2010' and '06-30-2010' UNION ALL SELECT Id,ParentId,Body,Tags,ViewCount,CreationDate FROM Posts WHERE ParentId IN ( SELECT Id FROM Posts WHERE PostTypeId = 1 and ( Tags =('java') or Tags LIKE('%<java>%') or Tags LIKE('%jpa%') or Tags LIKE('%swing%') or Tags LIKE('%spring%') or Tags LIKE('%hibernate%') or Tags LIKE('%jdbc%') or Tags LIKE('%javafx%') or Tags LIKE('%jframe%') or Tags LIKE('%android-studio%') or Tags LIKE('%java-ee%') or Tags LIKE('%java-8%') ) AND CreationDate BETWEEN'06-01-2010' and '06-30-2010')