| select iwl_prefix, count(distinct page_id, iwl_title) as cnt from iwlinks... |
5 years ago |
| select iwl_prefix, count(distinct page_id, iwl_title) as cnt from iwlinks... |
5 years ago |
| select iwl_prefix, count(distinct page_id, iwl_title) as cnt from iwlinks... |
5 years ago |
| select iwl_prefix, count(distinct page_id, iwl_title) as cnt from iwlinks... |
5 years ago |
| select iwl_prefix, concat(page_id, '::', iwl_title), count(*) as cnt from... |
5 years ago |
| select count(distinct page_id, iwl_prefix, iwl_title) from iwlinks
right... |
5 years ago |
| select count(distinct page_id, iwl_prefix, iwl_title) from iwlinks
right... |
5 years ago |
| select count distinct page_id, iwl_prefix, iwl_title from iwlinks
right... |
5 years ago |
| select page_id, iwl_prefix, iwl_title from iwlinks
right join page on... |
5 years ago |
| select page_id, page_latest, iwl_prefix, iwl_title from iwlinks
right join... |
5 years ago |
| select page_id, page_latest, iwl_prefix, iwl_title from iwlinks
right join... |
5 years ago |
| -- select site_group, count(*) from sites group by site_group order by... |
5 years ago |
| -- select site_group, count(*) from sites group by site_group order by... |
5 years ago |
| -- select site_group, count(*) from sites group by site_group order by... |
5 years ago |
| 'select site_group, count(*) from sites group by site_group order by... |
5 years ago |
| select site_group, count(*) from sites group by site_group order by count(*) desc; |
5 years ago |
| select page_id, page_latest, iwl_prefix, iwl_title from iwlinks
right join... |
5 years ago |
| select * from site_identifiers where si_key = 'doi'; |
5 years ago |
| select * from site_identifiers; |
5 years ago |
| select * from interwiki; |
5 years ago |
| select * from interwikimap; |
5 years ago |
| show tables; |
5 years ago |
| select * from sites; |
5 years ago |
| select * from interwiki; |
5 years ago |
| select * from sites where site_domain like 'doi%'; |
5 years ago |
| select * from sites where site_id = 'doi'; |
5 years ago |
| select page_id, page_latest, iwl_prefix, iwl_title from iwlinks
right join... |
5 years ago |
| select page_id, page_latest from iwlinks
right join page on... |
5 years ago |
| select page_id, page_namespace from iwlinks
right join page on... |
5 years ago |
| select * from iwlinks where iwl_from = 20268732; |
5 years ago |
| select * from iwlinks where iw_from = 20268732; |
5 years ago |
| select * from pagelinks where pl_from = 20268732; |
5 years ago |
| select site_domain, count(*) from sites group by site_domain order by count(*) desc; |
5 years ago |
| select site_domain, count(*) from sites group by site_domain sort by count(*) desc; |
5 years ago |
| select * from sites where site_domain = 'en.wikipedia.org'; |
5 years ago |
| select * from sites limit 100; |
5 years ago |
| select * from archive limit 100; |
5 years ago |
| select * from text limit 100; |
5 years ago |
| select * from sites text 100; |
5 years ago |
| select * from sites limit 100; |
5 years ago |
| select count(*) from sites limit 100; |
5 years ago |
| select * from sites limit 100; |
5 years ago |
| select * from interwiki limit 100; |
5 years ago |
| select * from redirect where rd_interwiki != '' limit 100; |
5 years ago |
| select * from redirect where rd_interwiki is not null limit 100; |
5 years ago |
| select * from redirect limit 100; |
5 years ago |
