My Posts containing images with default text

0

Please login or register to vote for this query.

(click on this box to dismiss)

Used to find out which of your posts contain images with default text

Arqade

Q&A for passionate videogamers on all platforms

declare @UserId int = ##UserId##;

SELECT 
  Id As [Post Link],
  CASE PostTypeId WHEN 1 THEN 'Question' WHEN 2 THEN 'Answer' END AS Type,
  ViewCount 
FROM Posts WHERE 
  Posts.OwnerUserId=@UserId
  AND
  Body LIKE '%enter image description here%'
  
ORDER BY ViewCount DESC

Enter Parameters

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