title

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
Id,ParentId,Body,Tags,ViewCount,CreationDate
FROM
Posts
WHERE
CreationDate
BETWEEN'10-01-2014' and '11-01-2014'
And
PostTypeId = 1 and 
(
Tags =('java') or
Tags LIKE('%<java>%') or
Tags =('swing') or
Tags LIKE('%<swing>%') or
Tags =('hibernate') or
Tags LIKE('%<hibernate>%') or
Tags =('spring') or
Tags LIKE('%<spring>%') or
Tags =('spring-boot') or
Tags LIKE('%<spring-boot>%') or
Tags =('spring-mvc') or
Tags LIKE('%<spring-mvc>%') or
Tags =('jpa') or
Tags LIKE('%<jpa>%') or
Tags =('servlets') or
Tags LIKE('%<servlets>%') or
Tags =('tomcat') or
Tags LIKE('%<tomcat>%') or
Tags =('jdbc') or
Tags LIKE('%<jdbc>%') or
Tags =('javafx') or
Tags LIKE('%<javafx>%') or
Tags =('java-ee') or
Tags LIKE('%<java-ee>%') or
Tags =('junit') or
Tags LIKE('%<junit>%') or
Tags =('android-studio') or
Tags LIKE('%<android-studio>%') or
Tags =('java-8') or
Tags LIKE('%<java-8>%') or
Tags =('jar') or
Tags LIKE('%<jar>%') or
Tags =('jframe') or
Tags LIKE('%<jframe%') 
)
UNION ALL
SELECT
Id,ParentId,Body,Tags,ViewCount,CreationDate
FROM Posts
WHERE ParentId IN
(
SELECT 
    Id
FROM
    Posts
WHERE
CreationDate
BETWEEN'10-01-2014' and '11-01-2014'
and
PostTypeId = 1 and (
Tags =('java') or
Tags LIKE('%<java>%') or
Tags =('swing') or
Tags LIKE('%<swing>%') or
Tags =('hibernate') or
Tags LIKE('%<hibernate>%') or
Tags =('spring') or
Tags LIKE('%<spring>%') or
Tags =('spring-boot') or
Tags LIKE('%<spring-boot>%') or
Tags =('spring-mvc') or
Tags LIKE('%<spring-mvc>%') or
Tags =('jpa') or
Tags LIKE('%<jpa>%') or
Tags =('servlets') or
Tags LIKE('%<servlets>%') or
Tags =('tomcat') or
Tags LIKE('%<tomcat>%') or
Tags =('jdbc') or
Tags LIKE('%<jdbc>%') or
Tags =('javafx') or
Tags LIKE('%<javafx>%') or
Tags =('java-ee') or
Tags LIKE('%<java-ee>%') or
Tags =('junit') or
Tags LIKE('%<junit>%') or
Tags =('android-studio') or
Tags LIKE('%<android-studio>%') or
Tags =('java-8') or
Tags LIKE('%<java-8>%') or
Tags =('jar') or
Tags LIKE('%<jar>%') or
Tags =('jframe') or
Tags LIKE('%<jframe%') 
))

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results