Posts that probably need editing

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

Internet of Things Meta

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 Posts.Id AS [Post Link], PostTypes.Name
FROM Posts
INNER JOIN PostTypes
ON Posts.PostTypeId = PostTypes.Id
WHERE
ClosedDate IS NULL AND
(
  (
    PostTypeId = 1 AND
    (
      Title LIKE '[abcdefghijklmnopqrstuvwxyz]%' OR
      Title NOT LIKE '%?'
      COLLATE Latin1_General_CS_AS
    )
  )
  OR
  (
    PostTypeId NOT IN (1, 6) AND 
    (
      Body LIKE '%<p>[abcdefghijklmnopqrstuvwxyz]%' OR
      Body LIKE '%. [abcdefghijklmnopqrstuvwxyz]%'
      COLLATE Latin1_General_CS_AS
    )
  )
)
ORDER BY PostTypes.Id ASC

Enter Parameters

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