| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select now();
use wikidatawiki_p;
SELECT... |
8 years ago |
| select NOW();
use wikidatawiki_p;
SELECT concat('* {{Property... |
8 years ago |
| select NOW();
use wikidatawiki_p;
SELECT concat('* {{Property... |
8 years ago |
| select NOW();
use dewiki_p;
SELECT
concat('*',COUNT(*),'... |
8 years ago |
| use wikidatawiki_p;
select NOW(); |
8 years ago |
| use wikidatawiki_p;
NOW(); |
8 years ago |
| use wikidatawiki_p;
SELECT concat('* {{Property talk|',pl_title,'}}'),... |
8 years ago |
| use wikidatawiki_p;
SELECT pl_title, count(*)
FROM... |
8 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks
WHERE
pl_from_namespace=0 and... |
8 years ago |
| use wikidatawiki_p;
SELECT *
FROM pagelinks
WHERE
pl_from_namespace=0
... |
8 years ago |
| use wikidata_p;
show tables; |
8 years ago |
| select rev_user_text, count(p.page_id)
from page p
join revision on... |
8 years ago |
| select *#p.page_title
from page p
join revision on rev_page=p.page_id and... |
8 years ago |
| select *#p.page_title
from page p
join revision on rev_page=p.page_id and... |
8 years ago |
| select p.page_title, (select rev_timestamp
from revision
where... |
8 years ago |
| select p.page_title, (select rev_timestamp
from revision
where... |
8 years ago |
| select p.page_title, (select rev_timestamp
from revision
where... |
8 years ago |
| select rev_page, rev_timestamp
from revision r
where r.rev_parent_id=0... |
8 years ago |
| select rev_page, rev_timestamp
from revision r
where r.rev_parent_id=0... |
8 years ago |
| select rev_page, min(rev_timestamp)
from revision r
where... |
8 years ago |
| select rev_page, min(rev_timestamp)
from revision r
where... |
8 years ago |
| select *
from revision r
where r.rev_parent_id=0 and r.rev_page in... |
8 years ago |
| select *
from revision r
where r.rev_parent_id=0 and r.rev_page in... |
8 years ago |
| select r.rev_page, r.rev_timestamp
from revision r
where... |
8 years ago |
| select r.rev_page, r.rev_timestamp
from revision r
where... |
8 years ago |
| select r.rev_page, r.rev_timestamp
from revision r
where... |
8 years ago |
| select r.rev_timestamp
from revision r
where r.rev_parent_id=0... |
8 years ago |
| select p.page_title, GROUP_CONCAT((select r.rev_timestamp
from... |
8 years ago |
| select p.page_title#, GROUP_CONCAT((select r.rev_timestamp
# from... |
8 years ago |
| select p.page_title#, GROUP_CONCAT((select r.rev_timestamp
# from... |
8 years ago |
| select p.page_title, GROUP_CONCAT((select r.rev_timestamp
from... |
8 years ago |
| select p.page_title, GROUP_CONCAT((select r.rev_timestamp
from... |
8 years ago |
| select p.page_title
from page p
where p.page_namespace=0
and... |
8 years ago |
| select p.page_title
from page p
where p.page_namespace=0
and... |
8 years ago |
| select p.page_title
from page p
where p.page_namespace=0
and... |
8 years ago |
| select p.page_title
from page p
where p.page_namespace=0
and... |
8 years ago |
| select p.page_title
from page p
where p.page_namespace=0
and... |
8 years ago |
| select distinct pla.page_title
from categorylinks... |
8 years ago |
| select *
from revision
limit 15; |
8 years ago |
