User:Gmaxwell/math fu

From Wikipedia, the free encyclopedia

mysql> select concat('*',mp.page_title,' - ',ip.page_title) from page as lp join pagelinks on pl_from=lp.page_id join page as mp on (mp.page_title=pl_title and mp.page_namespace=0) join imagelinks on il_from=mp.page_id join page as ip on ip.page_title=il_to and ip.page_namespace=6 where lp.page_namespace=0 and pl_namespace=0 and lp.page_title like 'List_of_mathematics_articles%' and exists (select 1 from templatelinks where tl_from=ip.page_id and tl_namespace=10 and tl_title like 'Non-free%') and ip.page_title!='Commons-logo.svg' group by mp.page_title, ip.page_title order by mp.page_title, ip.page_title;]]


Contents

[edit] A

[edit] D

[edit] K

[edit] R

[edit] T

204 rows in set (1.20 sec)]]