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;]]


A[edit]

D[edit]

K[edit]

R[edit]

T[edit]

204 rows in set (1.20 sec)]]