SELECT * FROM Posts p JOIN Users u ON u.Id = p.OwnerUse...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- Enter Query Title
-- Enter Query Description

SELECT *

FROM Posts p
JOIN Users u ON u.Id = p.OwnerUserId
JOIN PostTags pt ON pt.PostId = p.Id
JOIN Tags t ON t.Id = pt.TagId

WHERE (p.LastEditDate < '1-May-2010' OR p.LastEditDate IS NULL)
AND p.AcceptedAnswerId IS NULL
AND u.LastAccessDate > '1-May-2010'

AND (p.title LIKE '%CFML%'
OR p.title LIKE '%ColdFusion%'
OR p.title LIKE '%Railo%'
OR p.title LIKE '%BlueDragon%'
OR p.title LIKE '%openbd%'
OR p.title LIKE '%regex%'
OR p.title LIKE '%regular expression%'

OR t.TagName IN ('CFML','ColdFusion','Railo','BlueDragon','openbd','regex'))

Enter Parameters

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