use enwiki_p;
SELECT p.page_title, pp.pp_value, count(l.ll_lang)
FROM page... |
10 months ago |
use enwiki_p;
SELECT p.page_title, pp.pp_value, count(l.ll_lang)
FROM page... |
10 months ago |
use ltwiki_p;
SELECT tl_title, COUNT(*)
FROM templatelinks
WHERE... |
10 months ago |
use enwiki_p;
SELECT p.page_title, pp.pp_value, count(l.ll_lang)
FROM page... |
10 months ago |
SELECT
lt_title,
COUNT(*)
FROM templatelinks
LEFT JOIN linktarget ON... |
10 months ago |
select
p1.page_title,
p1.page_namespace,
... |
10 months ago |
select
p1.page_title,
p1.page_namespace,
... |
10 months ago |
select
p1.page_title,
p1.page_namespace,
... |
10 months ago |
SELECT page.page_title, categorylinks.cl_sortkey_prefix
FROM... |
10 months ago |
SELECT page.page_title, categorylinks.cl_sortkey_prefix
FROM... |
10 months ago |
SELECT
lt_title,
COUNT(*)
FROM templatelinks
LEFT JOIN linktarget ON... |
10 months ago |