Remaining posts with default alt-text

1

Please login or register to vote for this query.

(click on this box to dismiss)

Mi Yodeya

Q&A for those who base their lives on Jewish law and tradition and anyone interested in learning more

SELECT 
    Id
  , Id AS [Post Link]
  , OwnerUserId AS [User Link]
  , CreationDate
  , LastActivityDate
FROM Posts
WHERE 
      (
          Body LIKE '%alt text%'
       OR Body LIKE '%enter image description here%'
      )
  AND 
      (
          Title IS NULL
       OR Title NOT LIKE '%alt text%' -- Exclude meta post discussing alt texts
      )
ORDER BY Id ASC -- In order by immutable Id, to facilitate cooperation

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results