Q&A for science fiction and fantasy enthusiasts
concat('https://stackoverflow.com/q/', cast(P1.Id as varchar))
-- 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 '%i.stack.imgur.com%'
order by coalesce(P2.ViewCount, P1.ViewCount) desc