How can I sort answers that comprise at least 1 picture by votes?


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for people studying math at any level and professionals in related fields

select top 1000 as [Post Link]
     , a.creationdate
     , a.score
     , len(text)-len(replace(text,' ','')) [~ word count]
from posts a
inner join posts q on = a.parentid
inner join (
select postid, 
from posthistory phi
where id = (select max(id) 
            from posthistory ph
            where ph.postid = phi.postid
            and ph.posthistorytypeid in (2,5,8))
) md on md.postid =
where a.posttypeid = 2 -- answers
and (
  md.text like '%![[]%][[]%]%' 
  --md.text like '%![%](%)%' or 
  --md.text like '%<img src="%"%'
order by 4 desc

Enter Parameters

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