| use hewiki_p;
select distinct(pl_title) from page inner join pagelinks
on... |
8 years ago |
| use hewiki_p;
select distinct(pl_title), page_title from page inner join... |
8 years ago |
| use hewiki_p;
select distinct(pl_title) from page inner join pagelinks
on... |
8 years ago |
| use hewiki_p;
select distinct(pl_title) from page inner join pagelinks
on... |
8 years ago |
| use hewiki_p;
select distinct(pl_title) inner join pagelinks
on page_id =... |
8 years ago |
| use hewiki_p;
select page_title, pl_namespace, pl_title from page inner join... |
8 years ago |
| use wikidatawiki_p;
select * from page_props limit 10;
show tables
|
8 years ago |
| use wikidatawiki_p;
select * from page_props where page_namespace = 0 limit... |
8 years ago |
| use wikidatawiki_p;
select * from page where page_namespace = 0 limit... |
8 years ago |
| use wikidatawiki_p;
select * from page where page_namespace = 0 limit 10 |
8 years ago |
| use wikidatawiki_p;
select * from page where page_namespace = 0 limit 1 |
8 years ago |
| use wikidatawiki_p;
select * from page limit 1 |
8 years ago |
| use wikidata_p;
select * from page limit 1 |
8 years ago |
| use hewiki_p;
select * from page
where page_title =... |
8 years ago |
| use hewiki_p;
select * from redirect inner join page
on rd_from =... |
8 years ago |
| use hewiki_p;
select * from redirect
where rd_title = "ליפסקו" |
8 years ago |
| use hewiki_p;
describe povwatch_log;
describe povwatch_subscribers;
select... |
8 years ago |
| use hewiki_p;
describe povwatch_log;
describe povwatch_subscribers;
select *... |
8 years ago |
| use hewiki;
describe povwatch_log;
describe povwatch_subscribers;
select *... |
8 years ago |
| DESCRIBE hewiki_p.povwatch_log;DESCRIBE hewiki_p.povwatch_subscribers; |
8 years ago |
| show tables from hewiki_p; |
8 years ago |
| DESCRIBE hewiki_p.povwatch; |
8 years ago |
