use wikidatawiki_p;
SELECT now();
SELECT term_text, count(*)
from wb_terms... |
8 years ago |
use wikidatawiki_p;
SELECT concat('Q',term_entity_id)
from wb_terms
WHERE... |
8 years ago |
use wikidatawiki_p;
SELECT concat('Q',term_entity_id)
from wb_terms
WHERE... |
8 years ago |
use enwiki_p;
SELECT
Concat('[[Template:',tl_title,']]'),
COUNT(*)
FROM... |
8 years ago |
use lvwiki_p;
SELECT
Concat('[[Veidne:',tl_title,']]'),
COUNT(*)
FROM... |
8 years ago |
use lvwiki_p;
SELECT
Concat('[[Veidne:',tl_title,']]'),
COUNT(*)
FROM... |
8 years ago |
use lvwiki_p;
SELECT
Concat('[[Veidne:',tl_title,']]'),
COUNT(*)
FROM... |
8 years ago |
use lvwiki_p;
SELECT
Concat('[[Veidne:',tl_title,']]'),
COUNT(*)
FROM... |
8 years ago |
use lvwiki_p;
SELECT
Concat('[[Veidne:',tl_title,']]'),
COUNT(*)
FROM... |
8 years ago |
blank query |
8 years ago |
select concat('# [[',REPLACE(pl.pl_title, '_', ' '),']]'), (select... |
8 years ago |
select concat('# [[',REPLACE(pl.pl_title, '_', ' '),']]'), (select... |
8 years ago |
select pl.pl_title, (select rev_timestamp
from revision
where... |
8 years ago |
select pl.pl_title, (select rev_timestamp
from revision
where... |
8 years ago |
select pl.pl_title, (select rev_timestamp
from revision
where... |
8 years ago |
select pl.pl_title, (select rev_timestamp
from revision
where... |
8 years ago |