SELECT p.Id AS [Post ID], p.Title, p.Body AS [Post Body],...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Language Learning

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

SELECT 
        p.Id AS [Post ID],
        p.Title,
        p.Body AS [Post Body],
        p.Tags,
        c.Text AS [Comment],
        c.Score AS [Comment Score],
        p.CreationDate AS [Post Creation Time]
    FROM 
        Posts p
    LEFT JOIN 
        Comments c ON p.Id = c.PostId
    WHERE 
        (p.Tags LIKE '%python%'
        OR p.Tags LIKE '%javascript%'
        OR p.Tags LIKE '%java%'
        OR p.Tags LIKE '%php%'
        OR p.Tags LIKE '%programming-language%')
        AND p.CreationDate BETWEEN '2024-04-08' AND '2024-04-14'
    ORDER BY 
        p.CreationDate DESC;

Enter Parameters

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