0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of Wolfram Mathematica

select
  'http://mathematica.stackexchange.com/q/' + cast(p.id as varchar(max)) as post,
  coalesce(p.title, q.title) as title,
  t.name as post_type,  
  coalesce(p.viewcount, q.viewcount) as views
from posts as p
join posttypes as t
on p.posttypeid = t.id

left join posts as q
on p.parentid = q.id

where p.body like '%reference.wolfram.com/mathematica%'
order by 4 desc
;

fork query

edited mar 26 15

created mar 26 15 anonymous