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


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

  concat('', cast(P1.Id as varchar))
    as post_url
    Posts P1
      -- Answers don't have a ViewCount, so join to parent to get that
      left join Posts P2
        on P1.ParentId = P2.Id
  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 ''
order by coalesce(P2.ViewCount, P1.ViewCount) desc

Enter Parameters

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