4

Please login or register to vote for this query.

(click on this box to dismiss)

Updated with feedback from CodeReview.SE: https://codereview.stackexchange.com/q/176680/54092

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

SELECT Id AS [Post Link]
FROM Posts
WHERE PostTypeId = 1
AND ClosedDate IS NULL
AND (Body LIKE '<p>[abcdefghijklmnopqrstuvwxyz]%'
OR Title LIKE '[abcdefghijklmnopqrstuvwxyz]%'
OR Title NOT LIKE '%?'
COLLATE Latin1_General_CS_AS)
ORDER BY Id ASC

view current version

edited nov 6 16

created nov 6 16 Gao