USE cswiki_p;
SELECT pl_title, COUNT(*) AS articles FROM pagelinks WHERE... |
8 years ago |
USE cswiki_p;
SELECT pl_title, COUNT(*) AS pages FROM pagelinks WHERE... |
8 years ago |
USE cswiki_p;
SELECT pl_title, COUNT(*) AS pocet FROM pagelinks WHERE... |
8 years ago |
USE cswiki_p;
SELECT pl_title, COUNT(pl_title) AS pocet FROM pagelinks WHERE... |
8 years ago |
USE cswiki_p;
SELECT pl_title, COUNT(*) AS pocet FROM pagelinks WHERE... |
8 years ago |
USE cswiki_p;
SELECT COUNT(DISTINCT pl_title) FROM pagelinks WHERE... |
8 years ago |
USE cswiki_p;
SELECT COUNT(DISTINCT pl_from) FROM pagelinks WHERE... |
8 years ago |
USE cswiki_p;
SELECT COUNT(*) FROM page WHERE page_namespace = 100; |
8 years ago |