Is there any way to show all screenshots I have posted on SO?

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackoverflow.com/questions/397563

Stack Overflow

Q&A for professional and enthusiast programmers

select concat( 
         '<a href="https://stackoverflow.com/q/'
       , id
       , '">'
       , title
       , '</a><br>'
       , left(img, convert(int, charindex('>', img, 36)) )
       , '<br>')
 --  , charindex('>',img, 36)
from
(
select substring(
         p.body, 
         convert(int, patindex(N'%<img src="https://i.stack.imgur.com/%', p.body)),
         len(p.body)) img
      , q.title
      , p.id
from posts p
inner join posts q on q.id = coalesce(p.parentid, p.id)
where p.owneruserid = 3437787
and p.body like '%<img src="https://i.stack.imgur.com/%" alt="%>%'
) data

Enter Parameters

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