1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for scholars and enthusiasts of literature

select
  concat('https://stackoverflow.com/q/', cast(P1.Id as varchar))
    as post_url
from
    Posts P1
      -- Answers don't have a ViewCount, so join to parent to get that
      left join Posts P2
        on P1.ParentId = P2.Id
where 
  P1.OwnerUserId = ##UserId## and
  -- this catches _all posts with images_
  --   a more targeted way to catch images with
  --   extremely low-effort (zero-effort) captions
  --   would be to look for '[enter image description here]'
  P1.Body like '%i.stack.imgur.com%'
order by coalesce(P2.ViewCount, P1.ViewCount) desc

fork query

edited oct 19 20

created oct 18 20 MichaelChirico