Find my posts with any images & return URLs to improve hover-over text for accessibility

1

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

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

Enter Parameters

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