| use jawiki_p;
select count(*) as "local article in jawiki",... |
5 years ago |
| use jawiki_p;
select count(*) as "local article in jawiki",... |
5 years ago |
| use jawiki_p;
select count(*) as "locally article in jawiki",... |
5 years ago |
| use jawiki_p;
select count(*), avg(page_len)
from page
where
not exists
(
... |
5 years ago |
| use jawiki_p;
select count(*), avg(page_len)
from page
where
not exists
(
... |
5 years ago |
| use jawiki_p;
select count(*)
from page
where
not exists
(
select *
... |
5 years ago |
| use jawiki_p;
select count(*)
from page
where
not exists
(
select *
... |
5 years ago |
| use jawiki_p;
select count(*)
from page
where
not exists
(
select *
... |
5 years ago |
| use jawiki_p;
select count(*)
from page
where
not exists
(
select *
... |
5 years ago |
| use jawiki_p;
select count(*)
from page
where
not exists
(
select *
... |
5 years ago |
| use jawiki_p;
select count(*)
from page
where
exists
(
select *
from... |
5 years ago |
| use jawiki_p;
select count(*)
from page
where
not exists
(
select *
... |
5 years ago |
| use jawiki_p;
select *
from page
where
not exists
(
select *
from... |
5 years ago |
| use jawiki_p;
select *
from page
left outer join langlinks on page_id =... |
5 years ago |
| use jawiki_p;
select *
from langlinks
limit 1000 |
5 years ago |
| use jawiki_p;
select *
from l10n_cache
limit 1000 |
5 years ago |
| use jawiki_p;
select *
from interwiki
limit 1000 |
5 years ago |
| use jawiki_p;
select *
from page
inner join user on page_title =... |
5 years ago |
| use jawiki_p;
select *
from page
inner join user on page_title =... |
5 years ago |
| use jawiki_p;
select *
from page
where page_namespace = 2
limit 10000 |
5 years ago |
| use jawiki_p;
select *
from page
where page_namespace = 2
limit 1 |
5 years ago |
| use jawiki_p;
select *
from page
where pagenamespace = 2
limit 1 |
5 years ago |
| use jawiki_p;
select *
from page
limit 1 |
5 years ago |
| use jawiki_p;
select page_title
from page
limit 1 |
5 years ago |
| use jawiki_p;
select page_title
limit 1 |
5 years ago |
| use jawiki_p;
select count(page_title)
from page
where page_namespace = 2 |
5 years ago |
| use jawiki_p;
select count(page_title)
from page
where page_namespace = 2 |
5 years ago |
| use jawiki_p;
select count(page_title)
from page
where page_namespace = 2 |
5 years ago |
| use jawiki_p;
select page_title
from page
where page_namespace = 2 |
5 years ago |
| use jawiki_p;
select distinct page_title, rev_page
from... |
5 years ago |
| use jawiki_p;
select distinct page_title, rev_page, rev_comment
from... |
5 years ago |
| use jawiki_p;
select distinct page_title, rev_page, rev_comment
from... |
5 years ago |
| use jawiki_p;
select distinct page_title, rev_page, rev_comment
from... |
5 years ago |
| use jawiki_p;
select distinct page_title, distinct rev_page, distinct... |
5 years ago |
| use jawiki_p;
select distinct rev_page, rev_comment
from... |
5 years ago |
| use jawiki_p;
select distinct rev_page, rev_comment
from... |
5 years ago |
| use jawiki_p;
select distinct rev_page
from... |
5 years ago |
| use jawiki_p;
select distinct rev_page
from... |
5 years ago |
| use jawiki_p;
select *
from revision_userindex
where
rev_user_text =... |
5 years ago |
| select "nlwiki" as wikiname, count(*) as registered_edits
from... |
5 years ago |
| select "ruwiki" as wikiname, count(*) as registered_edits
from... |
5 years ago |
| select "itwiki" as wikiname, count(*) as registered_edits
from... |
5 years ago |
| set @wikiname = "jawiki";
select @wikiname as a |
5 years ago |
| set @wikiname = "jawiki";
select @wikiname:=@wikiname as a |
5 years ago |
| set @wikiname = "jawiki"
select @wikiname:=@wikiname as a |
5 years ago |
| set @wikiname = "jawiki"
select @wikiname:=@wikiname as a |
5 years ago |
| set @wikiname = "jawiki"
select @wikiname as a |
5 years ago |
| set @wikiname = "jawiki"
select @wikiname as a |
5 years ago |
| set @wikiname = "jawiki"
select @wikiname as a |
5 years ago |
| set @wikiname = "jawiki"
select @wikiname as a |
5 years ago |
| set @wikiname = "jawiki"
select @wikiname |
5 years ago |
| set @wikiname = "jawiki"
select @wikiname |
5 years ago |
| set @wikiname = "jawiki"
select @wikiname |
5 years ago |
| set @wikiname = "jawiki"
select @wikiname |
5 years ago |
| set @wikiname = jawiki
select @wikiname |
5 years ago |
| use jawiki_p;
select *
from logging_logindex
where
log_action = "delete"... |
5 years ago |
| use jawiki_p;
select *
from logging_logindex
limit 1 |
5 years ago |
| use jawiki_p;
select tl_title, counter, page_restrictions
from page
inner... |
5 years ago |
| use jawiki_p;
select tl_title, counter
from page
inner join (
select... |
5 years ago |
| use jawiki_p;
select tl_title, counter
from page
inner join (
select... |
5 years ago |
| use jawiki_p;
select tl_title, counter
from page
inner join (
select... |
5 years ago |
| use jawiki_p;
select tl_title, count(*)
from templatelinks
where... |
5 years ago |
| use jawiki_p;
select tl.title, count(*)
from templatelinks
where... |
5 years ago |
| use jawiki_p;
select *
from templatelinks
where tl_namespace = 10
group by tl_title |
5 years ago |
| use jawiki_p;
select *
from templatelinks
limit 10 |
5 years ago |
| use jawiki_p;
select *
from temp_link
limit 10 |
5 years ago |
| use jawiki_p;
select *
from template_link
limit 10 |
5 years ago |
| use jawiki_p;
select *
from template_links
limit 10 |
5 years ago |
| use jawiki_p;
select *
from template_links
limit 10 |
5 years ago |
| use jawiki_p;
select *
from temp
limit 10 |
5 years ago |
| use jawiki_p;
select *
from template
limit 10 |
5 years ago |
| use jawiki_p;
select page_title
from page
where page_title like "%危険%" and... |
5 years ago |
| use jawiki_p;
select *
from page
where page_title like "%危険%" and... |
5 years ago |
| use jawiki_p;
select *
from page
where page like "%危険%"
/*
select... |
5 years ago |
| use jawiki_p;
select page_title
from page
inner join category on page_title... |
5 years ago |
| use jawiki_p;
select page_title
from page
inner join category on page_title... |
5 years ago |
| use jawiki_p;
select *
from page
inner join category on page_title =... |
5 years ago |
| use jawiki_p;
select *
from page
inner join category on page_title =... |
5 years ago |
| use jawiki_p;
select *
from page
inner join category on page_title =... |
5 years ago |
| use jawiki_p;/*
select *
from page
where
page_namespace = 14 and
... |
5 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 14 and
... |
5 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 14
limit 10 |
5 years ago |
| use jawiki_p;
select *
from page_title
where
page_namespace = 14
limit 10 |
5 years ago |
| use jawiki_p;
select page_title
where
page_namespace = 14
limit 10 |
5 years ago |
| use jawiki_p;
select page_title
where
page_namespace = 14... |
5 years ago |
| use jawiki_p;
select page_title
where
page_namespace = 14... |
5 years ago |
| use jawiki_p;
select *
from categorylinks
limit 10 |
5 years ago |
| use jawiki_p;
select categorylinks
limit 10 |
5 years ago |
| use jawiki_p;
select distinct page_title
from page
inner join... |
6 years ago |
| use jawiki_p;
select page_title
inner join revision_userindex on rev_page =... |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_namespace = 0... |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_namespace = 0... |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_namespace = 0... |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_namespace = 0... |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_title rlike "(.*?)_\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_title rlike "(.*?)_\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_title rlike "(.*?) \\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_title rlike "(.*?)\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_title rlike "(.*?)\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_title rlike "(.*?)\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_title rlike "(.*?)\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_title rlike "(.*?)\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_title rlike "(.*?)\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_title rlike "(.*?)\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_title rlike "(.*?)\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_tirle rlike "(.*?)\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_tirle rlike "(.*?)\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_tirle rlike "(.*?)\\\1" |
6 years ago |
| use jawiki_p;
select page_title
from page
where
page_tirle rlike "(.*?)\\\1" |
6 years ago |
| blank query |
6 years ago |
| use jawiki_p;
select u1rev.rev_page, u1rev.nedit, u1rev.nedit
from (
... |
6 years ago |
| use jawiki_p;
select u1rev.rev_page, u1rev.nedit, u1rev.nedit
from (
... |
6 years ago |
| use jawiki_p;
select u1rev.rev_page, u1rev.nedit, u1rev.nedit
from (
... |
6 years ago |
| use jawiki_p;
select u1rev.rev_page, u1rev.nedit, u1rev.nedit
from (
... |
6 years ago |
| use jawiki_p;
select u1rev.rev_page, u1rev.count( * ), u2rev.nedit
from... |
6 years ago |
| use jawiki_p;
select u1rev.rev_page, u1rev.count( * ), u2rev_nedit
from... |
6 years ago |
| use jawiki_p;
select u1rev.rev_page, u1rev.count( * ), u2rev_nedit
from... |
6 years ago |
| use jawiki_p;
select u1rev.rev_page, u1rev.count( * ), u2rev_nedit
from... |
6 years ago |
| use jawiki_p;
select u1rev.rev_page, u1rev_count( * ), u2rev_nedit
from... |
6 years ago |
| use jawiki_p;/*
select page_title, substring( pp_value from 2 ) as... |
6 years ago |
| use jawiki_p;/*
select page_title, substring( pp_value from 2 ) as... |
6 years ago |
| use jawiki_p;/*
select page_title, substring( pp_value from 2 ) as... |
6 years ago |
| use jawiki_p;/*
select page_title, substring( pp_value from 2 ) as... |
6 years ago |
| use jawiki_p;/*
select page_title, substring( pp_value from 2 ) as... |
6 years ago |
| use jawiki_p;/*
select page_title, substring( pp_value from 2 ) as... |
6 years ago |
| use jawiki_p;/*
select page_title, substring( pp_value from 2 ) as... |
6 years ago |
| use jawiki_p;/*
select page_title, substring( pp_value from 2 ) as... |
6 years ago |
| use jawiki_p;/*
select page_title, substring( pp_value from 2 ) as... |
6 years ago |
| use jawiki_p;/*
select page_title, substring( pp_value from 2 )
from... |
6 years ago |
| use jawiki_p;/*
select page_title, substring( pp_value from 2 )
from... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
left outer join page_props on page_id =... |
6 years ago |
| use jawiki_p;/*
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;/*
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;/*
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;/*
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_title regexp '[0-9]'; |
6 years ago |
| use jawiki_p;
select *
from page
where
page_title regexp "[0-9]+年?\)"; |
6 years ago |
| use jawiki_p;
SELECT * FROM page WHERE page_title REGEXP '^b'; |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0
limit 10 |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select *
from page
where
page_namespace = 0 and
page_title... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select
case linter_cat
when 1 then "Fostered... |
6 years ago |
| use jawiki_p;
select linter_cat, count(*)
from linter
group by linter_cat |
6 years ago |
| use jawiki_p;
select linter_cat, count(*)
from linter
group by linter_cat |
6 years ago |
| use jawiki_p;
select linter_cat, count(*)
from linter
group by linter_cat |
6 years ago |
| use jawiki_p;
select linter_cat, count(*)
from linter
group by linter_cat |
6 years ago |
| use jawiki_p;
select linter_cat, count(*)
from linter
group by linter_cat |
6 years ago |
| use jawiki_p;
select linter_cat, count(*)
from linter
group by linter_cat |
6 years ago |
| use jawiki_p;
select *
from linter
inner join page on linter_page = page_id... |
6 years ago |
| use jawiki_p;
select *
from linter
inner join page on linter_page = page_id... |
6 years ago |
| use jawiki_p;
select *
from linter
inner join page on linter_page = page_id... |
6 years ago |
| use jawiki_p;
select *
from linter
inner join page on linter_page = page_id... |
6 years ago |
| use jawiki_p;
select *
from linter
inner join page on linter_page = page_id... |
6 years ago |
| use jawiki_p;
select *
from linter
limit 10 |
6 years ago |
| use jawiki_p;
select tl_from
from (
select a.tl_from as tl_from,... |
6 years ago |
| use jawiki_p;
select tl_from
from (
select a.tl_from as tl_from,... |
6 years ago |
| use jawiki_p;
select *
from (
select a.tl_from, b.tl_title
from... |
6 years ago |
| use jawiki_p;
select *
from (
select a.tl_from
from templatelinks as a
... |
6 years ago |
| use jawiki_p;
select *
from (
select
a.tl_from as tl_from
from... |
6 years ago |
| use jawiki_p;
select *
from (
select
a.tl_from as tl_from
from... |
6 years ago |
| use jawiki_p;
select *
from (
select
a.tl_from as tl_from
from... |
6 years ago |
| use jawiki_p;
select *
from (
select *
from templatelinks as a
left... |
6 years ago |
| use jawiki_p;
select *
from (
select *
from templatelinks as a
left... |
6 years ago |
| use jawiki_p;
select *
from (
select *
from templatelinks as a
left... |
6 years ago |
| use jawiki_p;
select
from (
select *
from templatelinks as a
left... |
6 years ago |
| use jawiki_p;
select
from (
select *
from templatelinks as a
left outer join... |
6 years ago |
| use jawiki_p;
select *
from templatelinks
where tl_title =... |
6 years ago |
| use jawiki_p;
select *
from templatelinks
where tl_title =... |
6 years ago |
| use jawiki_p;
select *
from templatelinks
where tl_title = "Infobox... |
6 years ago |
| use jawiki_p;
select *
from templatelinks
#where tl_title = "Infobox... |
6 years ago |
| use jawiki_p;
select count(*)
from templatelinks
where tl_title = "Infobox... |
6 years ago |
| use jawiki_p;
select *
from templatelinks
limit 10
|
6 years ago |
| use jawiki_p;
select *
from templatelinks
limit 10
|
6 years ago |
| use jawiki_p;
select count(*)
from templatelinks
limit 10
|
6 years ago |
| use jawiki_p;
select count(*)
from templatelinks
where tl_from = 600280
limit 10
|
6 years ago |
| use jawiki_p;
select *
from templatelinks
limit 10
|
6 years ago |
| use jawiki_p;
select count(*)
from revision_userindex
inner join page on... |
6 years ago |
| use jawiki_p;
select rev_user_text, rev_id, rev_len
from revision
where... |
6 years ago |
| use jawiki_p;
select rev_user_text, rev_id, rev_len
from revision
where... |
6 years ago |
| use jawiki_p;
select page_id, page_title, reverse( page_title ), ... |
6 years ago |
| use jawiki_p;
select page_id, page_title, rev_user_text, rev_timestamp
from... |
6 years ago |
| use jawiki_p;
select page_id, page_title, rev_user_text, rev_timestamp
from... |
6 years ago |
| use jawiki_p;
select page_id, page_title, rev_user_text, rev_timestamp
from... |
6 years ago |
| use jawiki_p;
select page_id, page_title, rev_text_user, rev_timestamp
from... |
6 years ago |
| use jawiki_p;
/*select page_id, page_title, rev_text_user,... |
6 years ago |
| use jawiki_p;
select page_id, page_title, rev_text_user, rev_timestamp
from... |
6 years ago |
| use jawiki_p;
select *
from page
inner join (
select cat_title
from... |
6 years ago |
| use jawiki_p;
select *
from page
inner join (
select cat_title
from... |
6 years ago |
| use jawiki_p;
select *
from page
inner join (
select cat_title
from... |
6 years ago |
| use jawiki_p;
select *
from page
inner join (
select cat_title
from... |
6 years ago |
| use jawiki_p;
select *
from page
/*
select cat_title
from category
where
... |
6 years ago |
| use jawiki_p;
select *
from page
/*
select cat_title
from category
where
... |
6 years ago |
| use jawiki_p;
from page
/*
select cat_title
from category
where
cat_pages... |
6 years ago |
| use jawiki_p;
select cat_title
from category
where
cat_pages = 0 and
... |
6 years ago |
| use jawiki_p;
select*from category limit 1 |
6 years ago |
| use jawiki_p;
select*from category |
6 years ago |
| use jawiki_p;
select*from category limit 10 |
6 years ago |
| use jawiki_p;
select*from category limit 10 |
6 years ago |
| use jawiki_p;
select*from externallinks limit 10 |
6 years ago |
| use jawiki_p;
select*from externallinks limit 10 |
6 years ago |
| blank query |
6 years ago |
| use commonswiki_p;
select *
from categorylinks as second
inner join (
... |
6 years ago |
| use commonswiki_p;
select *
from categorylinks
inner join (
select *
... |
6 years ago |
| use commonswiki_p;
select *
from page
inner join categorylinks on cl_from =... |
6 years ago |
| use commonswiki_p;
select *
from page
inner join categorylinks on cl_from =... |
6 years ago |
| use commonswiki_p;
select *
from categorylinks
where cl_to = "Japan" |
6 years ago |
| use commonswiki_p;
select *
from categorylinks
limit 10
|
6 years ago |
| use commonswiki_p;
select *
from category
limit 10
|
6 years ago |
