User:CBM/Sandbox5

From Wikipedia, the free encyclopedia

List of links from disambiguation pages to mathematics articles.

Format: dab page - article

select concat('* [[', dp.page_title, ']] - [[', mp.page_title, ']]') 
  from page as lp 
    join pagelinks as mathlinks on mathlinks.pl_from=lp.page_id 
    join page as mp on (mp.page_title=mathlinks.pl_title and mp.page_namespace=0) 
    join pagelinks as dablinks on (mp.page_title=dablinks.pl_title and mp.page_namespace=0)
    join page as dp on (dablinks.pl_from = dp.page_id and dp.page_namespace=0)
  where lp.page_namespace=0 and mathlinks.pl_namespace=0 and dablinks.pl_namespace = 0
    and lp.page_title like 'List_of_mathematics_articles_%'
    and not ( mp.page_title = 'Mathematics') 
    and exists (select 1 from templatelinks where tl_from=dp.page_id and tl_title = 'Disambig')  
    group by dp.page_title ;

Contents

[edit]  !

[edit] &

[edit] '

[edit] *

[edit] .

[edit] 0

[edit] 1

[edit] 2

[edit] 3

[edit] 4

[edit] 5

[edit] 6

[edit] 7

[edit] 8

[edit] A

[edit] B

[edit] C

[edit] D

[edit] E

[edit] F

[edit] G

[edit] H

[edit] I

[edit] J

[edit] K

[edit] L

[edit] M

[edit] N

[edit] O

[edit] P

[edit] Q

[edit] R

[edit] S

[edit] T

[edit] U

[edit] V

[edit] W

[edit] X

[edit] Y

[edit] Z

[edit] Č

[edit] Ḥ

[edit] ↑

[edit] ↓

[edit] ∂

[edit] ∆

[edit] ≡

[edit] ◊