Wikipedia:Sandbox

Welcome to this sandbox page, a space to experiment with editing.

You can either edit the source code ("Edit source" tab above) or use VisualEditor ("Edit" tab above). Click the "Publish changes" button when finished. You can click "Show preview" to see a preview of your edits, or "Show changes" to see what you have changed.

Anyone can edit this page and it is automatically cleared regularly (anything you write will not remain indefinitely). Click here to reset the sandbox.

You can access your personal sandbox by clicking here, or using the "Sandbox" link in the top right.Creating an account gives you access to a personal sandbox, among other benefits.

blocked

from editing.

For more info about sandboxes, see Wikipedia:About the sandbox and Help:My sandbox. New to Wikipedia? See the contributing to Wikipedia page or our tutorial. Questions? Try the Teahouse!

-- ; mysql -h tools.labsdb
SELECT rl_title_ft
FROM u2815__p.redlinks_enwiki_p
-- WHERE MATCH (rl_title_ft) AGAINST (? IN BOOLEAN MODE)
WHERE rl_title_ft REGEXP
'(?i)^(\\b(alpha|beta|gamma|delta|epsilon|zeta|eta|theta|iota|kappa|lamda|mu|nu|xi|omicron|pi|rho|sigma|tau|upsilon|phi|chi|psi|omega)\\b[.]? *){2,10}$'

-- ; sql enwiki_p
SELECT
  pl_title,
  (SELECT COUNT(*) FROM logging_logindex WHERE log_type="delete"
   AND log_namespace=0 AND log_title=pl_title) AS "Del",
  COUNT(pl_from) AS "Back links",
  SUM(pl_from_namespace=0) AS Main,
  SUM(pl_from_namespace%2=0) AS NonTalk
FROM pagelinks
WHERE pl_namespace=0 AND pl_title in (
'Alpha_Alpha_Gamma',
/* [...] */
'Zeta_Sigma_Phi'
)
GROUP BY pl_title;

Red link	Del	Backlinks	Main	NonTalk
Alpha Alpha Gamma	0	1	1	1
Alpha Beta Chi	5	13	9	13
Alpha Beta Sigma	0	1	1	1
Alpha Chi Theta	2	5	1	2
Alpha Delta Epsilon	1	3	1	3
Alpha Delta Eta	0	1	1	1
Alpha Delta Kappa	0	2	2	2
Alpha Delta Omega	0	1	1	1
Alpha Delta Tau	0	1	1	1
Alpha Delta Upsilon	0	1	1	1
Alpha Eta Theta	0	5	4	5
Alpha Gamma Nu	1	11	1	5
Alpha Gamma Xi	0	1	1	1
Alpha Iota Omicron	2	23	9	17
Alpha Kappa	1	2	1	1
Alpha Kappa Omega	1	4	1	3
Alpha Kappa Omicron	1	10	1	7
Alpha Kappa Phi	0	1	1	1
Alpha Kappa Sigma	5	5	1	1
Alpha Mu Alpha	0	2	2	2
Alpha Nu	0	3	3	3
Alpha Nu Sigma	0	4	4	4
Alpha Omicron	0	2	1	2
Alpha Omicron Sigma	0	1	1	1
Alpha Phi Epsilon	3	14	3	11
Alpha Phi Mu	0	1	1	1
Alpha Pi Phi	4	13	2	8
Alpha Pi Sigma	2	16	4	11
Alpha Psi Alpha	0	1	1	1
Alpha Psi Gamma	1	2	1	1
Alpha Rho	1	5	1	4
Alpha Rho Omega	8	7	1	2
Alpha Sigma Chi	3	7	2	3
Alpha Sigma Delta	2	4	4	4
Alpha Sigma Gamma	0	1	1	1
Alpha Sigma Omega	1	4	2	3
Alpha Sigma Sigma	5	2	1	1
Alpha Sigma Zeta	0	1	1	1
Alpha Tau Gamma	0	1	1	1
Alpha Tau Mu	0	1	1	1
Alpha Theta Gamma	3	4	2	2
Alpha Theta Omega	7	6	1	1
Alpha Theta Pi	1	1	1	1
Alpha Upsilon Nu	0	1	1	1
Alpha Zeta Gamma	0	2	1	2
Alpha Zeta Pi	0	1	1	1
Beta Alpha	0	2	1	2
Beta Chi	0	2	2	2
Beta Delta	1	2	1	1
Beta Gamma Epsilon	4	5	1	4
Beta Gamma Nu	1	1	1	1
Beta Gamma Psi	0	1	1	1
Beta Kappa Gamma	11	35	9	20
Beta Kappa Psi	1	4	3	3
Beta Kappa Sigma	0	1	1	1
Beta Omega Phi	4	20	1	13
Beta Phi	1	4	1	3
Beta Phi Omega	1	2	2	2
Beta Pi Phi	1	2	1	1
Beta Sigma	5	12	1	7
Beta Sigma Chi	2	4	2	2
Beta Sigma Epsilon	0	1	1	1
Beta Sigma Kappa	2	2	2	2
Beta Sigma Theta	2	6	1	3
Beta Tau Sigma	0	2	1	2
Beta Theta Phi	0	2	1	1
Beta Theta Tau	0	1	1	1
Beta Upsilon Delta	3	9	1	6
Beta Xi Chi	1	5	2	4
CHI CHI	3	13	1	4
Chi Alpha Epsilon	0	2	2	2
Chi Alpha Sigma	0	2	2	2
Chi Beta Psi	0	1	1	1
Chi Epsilon Sigma	0	1	1	1
Chi Kappa Psi	0	1	1	1
Chi Nu	1	4	1	3
Chi Rho Omicron	2	13	1	8
Chi Rho Sigma	0	1	1	1
Chi Sigma Omega	0	1	1	1
Chi Sigma Tau	2	46	16	37
Chi Sigma Xi	2	6	1	4
Chi Upsilon Omega	0	1	1	1
Delta Alpha Chi	1	1	1	1
Delta Alpha Nu	1	2	1	1
Delta Alpha Omega	0	3	3	3
Delta Alpha Pi	0	3	2	3
Delta Alpha Sigma	0	1	1	1
Delta Alpha Theta	1	2	1	1
Delta Chi Epsilon	2	20	10	17
Delta Chi Gamma	0	1	1	1
Delta Chi Psi	2	15	1	14
Delta Epsilon Iota	2	22	7	16
Delta Epsilon Sigma Iota	1	13	8	12
Delta Gamma Phi	2	4	1	2
Delta Gamma Pi	1	2	1	2
Delta Gamma Tau	0	1	1	1
Delta Kappa Kappa	0	1	1	1
Delta Kappa Sigma	0	1	1	1
Delta Mu	0	1	1	1
Delta Nu Tau	3	2	1	1
Delta Nu Zeta	0	1	1	1
Delta Omega Chi	1	2	1	2
Delta Phi Eta	0	1	1	1
Delta Phi Mu	2	10	2	7
Delta Phi Omicron	1	8	1	5
Delta Phi Psi	0	12	8	12
Delta Phi Upsilon	2	6	1	2
Delta Pi Omega	1	2	1	1
Delta Pi Rho	2	8	1	6
Delta Psi Alpha	1	2	1	1
Delta Psi Chi	4	7	1	6
Delta Psi Eta	0	1	1	1
Delta Rho	0	1	1	1
Delta Sigma Iota	3	24	8	18
Delta Sigma Phi.	0	1	1	1
Delta Tau	2	4	1	3
Delta Tau Kappa	0	1	1	1
Delta Tau Sigma	0	1	1	1
Epsilon Chi Nu	0	1	1	1
Epsilon Eta	0	1	1	1
Epsilon Iota Psi	0	1	1	1
Epsilon Psi Epsilon	0	1	1	1
Epsilon Sigma Phi	3	4	1	4
Epsilon Sigma Rho	3	14	2	11
Eta Epsilon Gamma	0	2	1	1
Eta Gamma Zeta	0	1	1	1
Eta Iota Mu	0	2	1	1
Eta Iota Sigma	1	11	3	11
Eta Phi	0	1	1	1
Eta Sigma Gamma	0	2	2	2
Eta Theta Psi	0	1	1	1
Gamma Alpha Mu	0	1	1	1
Gamma Alpha Rho	0	1	1	1
Gamma Beta	6	27	3	20
Gamma Beta Phi	0	2	2	2
Gamma Chi Epsilon	1	3	2	2
Gamma Delta	0	1	1	1
Gamma Delta Chi	1	11	2	7
Gamma Delta Pi	2	3	1	3
Gamma Epsilon Omega	1	9	1	8
Gamma Gamma Chi	0	1	1	1
Gamma Iota Omicron	0	1	1	1
Gamma Phi Epsilon	2	3	1	3
Gamma Phi Omega	3	13	8	11
Gamma Phi Sigma	1	5	1	4
Gamma Pi	0	1	1	1
Gamma Pi Alpha	0	1	1	1
Gamma Psi	3	5	1	3
Gamma Psi Epsilon	1	2	1	2
Gamma Sigma	1	3	2	2
Gamma Sigma Epsilon	3	10	4	6
Gamma Xi Phi	0	1	1	1
Gamma Zeta Rho	1	4	1	2
Iota Alpha	0	1	1	1
Iota Beta Kappa	0	1	1	1
Iota Delta Nu	0	1	1	1
Iota Gamma Upsilon	2	5	1	4
Iota Iota Iota	1	3	2	2
Iota Tau	0	1	1	1
Iota Tau Kappa	0	1	1	1
Iota Theta	0	2	1	2
Kappa Alpha Mu	0	2	1	2
Kappa Alpha Rho	0	1	1	1
Kappa Alpha Sigma	1	4	1	3
Kappa Beta Delta	2	2	1	1
Kappa Beta Zeta	1	2	1	1
Kappa Chi Alpha	2	3	1	1
Kappa Delta Omega	0	1	1	1
Kappa Delta Tau	0	1	1	1
Kappa Mu Kappa	0	1	1	1
Kappa Omega	1	2	1	1
Kappa Omega Kappa	0	1	1	1
Kappa Omega Sigma	2	2	1	1
Kappa Omicron Tau	0	1	1	1
Kappa Pi Beta	3	12	4	10
Kappa Psi Epsilon	3	6	1	5
Kappa Sigma Alpha	3	2	1	1
Kappa Sigma Epsilon	0	1	1	1
Kappa Sigma Theta	0	1	1	1
Kappa Tau	0	2	1	2
Kappa Tau Epsilon	1	4	2	3
Kappa Tau Gamma	1	2	1	1
Kappa Theta Chi	2	4	1	4
Kappa Theta Nu	0	1	1	1
Kappa Theta Psi	2	5	1	3
Kappa Upsilon Chi	1	14	1	9
Kappa Xi Omega	0	1	1	1
Kappa Zeta	0	1	1	1
Mu Alpha Tau	0	1	1	1
Mu Delta Alpha	0	1	1	1
Mu Iota Upsilon	0	1	1	1
Mu Kappa Upsilon	0	1	1	1
Mu Mu	0	1	1	1
Mu Omicron Gamma	1	23	13	23
Mu Omicron Zeta	3	2	1	1
Mu Phi Sigma	0	1	1	1
Mu Pi	0	27	24	27
Mu Sigma Pi	0	2	1	2
Mu Tau Beta	0	1	1	1
Mu Upsilon Delta	0	1	1	1
Nu Alpha	0	1	1	1
Nu Alpha Phi	1	17	4	10
Nu Beta Epsilon	0	2	1	2
Nu Delta Pi	0	1	1	1
Nu Gamma Alpha	0	1	1	1
Nu Phi Delta	4	29	11	21
Nu Phi Zeta	0	1	1	1
Nu Rho	0	1	1	1
Nu Sigma Phi	1	5	1	4
Nu Sigma Tau	0	1	1	1
Nu Theta Chi	0	1	1	1
Omega Alpha	0	1	1	1
Omega Beta Iota	1	10	2	9
Omega Delta	2	15	5	8
Omega Delta Epsilon	0	1	1	1
Omega Eta Epsilon	0	1	1	1
Omega Nu Eta	1	2	1	1
Omega Phi	0	1	1	1
Omega Phi Kappa	1	3	1	1
Omega Pi	4	11	1	8
Omega Psi Psi	0	2	2	2
Omega Rho Theta	0	1	1	1
Omega Sigma Psi	0	1	1	1
Omega Sigma Tau	1	3	2	3
Omega Tau Zeta	2	3	1	2
Omega Xi Delta	0	1	1	1
Omicron Chi Epsilon	0	3	1	3
Omicron Delta Gamma	0	1	1	1
Omicron Delta Pi	0	1	1	1
Omicron Kappa Upsilon	0	6	5	6
Omicron Psi Omega	0	1	1	1
Omicron Xi	1	3	1	2
Phi Alpha Nu	1	5	1	4
Phi Alpha Omicron	0	1	1	1
Phi Alpha Sigma	1	4	2	4
Phi Alpha Tau	1	11	3	10
Phi Beta Phi	0	1	1	1
Phi Chi Delta	1	4	1	3
Phi Chi Epsilon	3	12	2	9
Phi Delta Omega	0	1	1	1
Phi Delta Psi Eta	0	1	1	1
Phi Delta Sigma	3	4	2	3
Phi Epsilon Phi	0	2	2	2
Phi Gamma Mu	0	1	1	1
Phi Kappa Delta	0	2	2	2
Phi Mu Omicron	1	3	1	2
Phi Omicron Gamma	0	1	1	1
Phi Phi Delta	0	1	1	1
Phi Phi Kappa	0	1	1	1
Phi Pi Delta	0	1	1	1
Phi Pi Phi	0	2	1	2
Phi Sigma Beta	0	1	1	1
Phi Sigma Chi	9	22	10	19
Phi Sigma Theta	0	2	2	2
Phi Tau Alpha	2	1	1	1
Phi Theta Chi	0	1	1	1
Phi Zeta Tau	2	10	1	7
Pi Alpha Chi	0	1	1	1
Pi Alpha Xi	0	2	1	2
Pi Delta Epsilon	0	4	3	4
Pi Delta Theta	0	1	1	1
Pi Epsilon Tau	1	4	3	3
Pi Iota Chi	1	3	1	3
Pi Kappa Chi	1	11	2	10
Pi Kappa Psi	0	1	1	1
Pi Omega	0	1	1	1
Pi Phi Epsilon	0	1	1	1
Pi Rho Omega	0	1	1	1
Pi Sigma Kappa	0	1	1	1
Pi Tau Pi	0	1	1	1
Psi Beta Sigma	0	1	1	1
Psi Delta Chi	0	1	1	1
Psi Phi Gamma	0	1	1	1
Rho Beta Epsilon	0	1	1	1
Rho Beta Kappa	0	1	1	1
Rho Kappa	1	7	3	5
Rho Pi Alpha	0	1	1	1
Rho Sigma Kappa	0	1	1	1
Rho Sigma Phi	1	2	1	1
Rho Tau Chi	1	2	1	1
Rho Theta Sigma	0	1	1	1
Sigma Alpha Chi	0	1	1	1
Sigma Alpha Eta	0	1	1	1
Sigma Alpha Pi	3	16	8	13
Sigma Alpha Zeta	3	4	1	2
Sigma Beta Chi	0	2	2	2
Sigma Beta Tau	1	1	1	1
Sigma Delta Upsilon	1	2	1	1
Sigma Epsilon Delta	0	2	1	2
Sigma Epsilon Omega	1	2	1	1
Sigma Epsilon Rho	0	1	1	1
Sigma Gamma Phi	0	1	1	1
Sigma Iota Zeta	0	2	1	2
Sigma Nu Alpha Gamma	0	1	1	1
Sigma Omega Mu	0	1	1	1
Sigma Omega Nu	2	10	3	7
Sigma Omega Phi	5	15	1	12
Sigma Omicron Mu	0	1	1	1
Sigma Omicron Rho	0	1	1	1
Sigma Phi Chi	1	3	1	1
Sigma Phi Sigma	0	3	1	2
Sigma Phi Upsilon	0	1	1	1
Sigma Phi Zeta	2	2	2	2
Sigma Sigma	1	4	1	4
Sigma Sigma Rho	4	16	1	8
Sigma Tau Epsilon	0	1	1	1
Sigma Theta Chi	2	7	1	6
Tau Alpha Upsilon	3	8	1	6
Tau Alpha Zeta	0	1	1	1
Tau Beta Phi	0	2	1	1
Tau Delta Kappa	0	1	1	1
Tau Delta Psi	3	6	1	5
Tau Epsilon Rho	0	2	1	2
Tau Gamma Delta	0	1	1	1
Tau Kappa Beta	0	1	1	1
Tau Kappa Nu	0	1	1	1
Tau Omega	1	3	2	3
Tau Pi Phi	0	1	1	1
Tau Rho Beta	0	1	1	1
Tau Rho Omicron	0	1	1	1
Tau Sigma Phi	2	8	4	6
Theta Alpha	7	9	1	5
Theta Chi Gamma	0	1	1	1
Theta Delta Beta	1	16	1	1
Theta Gamma	0	1	1	1
Theta Nu Kappa	0	1	1	1
Theta Nu Sigma	0	1	1	1
Theta Omega Phi	1	2	1	1
Theta Phi	0	4	4	4
Theta Psi Tau	0	1	1	1
Theta Sigma Tau	1	1	1	1
Upsilon Kappa Delta	0	1	1	1
Xi Chi Sigma	1	2	1	2
Xi Delta	1	3	1	2
Xi Delta Pi	0	1	1	1
Xi Eta	0	1	1	1
Xi Omicron Pi	0	1	1	1
Xi Theta Psi	0	1	1	1
Zeta Alpha	0	1	1	1
Zeta Alpha Pi	0	1	1	1
Zeta Chi Zeta	3	11	2	8
Zeta Epsilon Tau	1	1	1	1
Zeta Gamma Delta	0	1	1	1
Zeta Iota Chi	0	1	1	1
Zeta Nu Delta	1	3	1	2
Zeta Phi Gamma	0	1	1	1
Zeta Phi Zeta	1	11	5	10
Zeta Pi Omega	1	1	1	1
Zeta Psi Zeta	0	1	1	1
Zeta Sigma Phi	2	7	1	7
Zeta mu gamma	1	4	1	3