| SELECT
page_title,
cat_pages,
cat_subcats
FROM page
JOIN categorylinks... |
11 months ago |
| -- - |
1 year ago |
| select count(page_title)
from page
where page_namespace = 14
and page_id in... |
1 year ago |
| select count(page_title)
from page
where page_namespace = 14
and... |
1 year ago |
| select count(page_title)
from page
where page_namespace = 14
and... |
1 year ago |
| select page_title
from page
where page_title rlike '^.{1,6}:'
and... |
1 year ago |
| select page_title
from page
where page_title rlike '^.{1,6}:'
limit 1000; |
1 year ago |
| select page_title
from page
where page_title rlike '^.{1,10}:'
limit 1000; |
1 year ago |
| select page_title
from page
where page_title rlike '^.{,10}:'
limit 1000; |
1 year ago |
| select page_title
from page
where page_title rlike '^[^a-zA-Z]+:'
limit 1000; |
1 year ago |
| select page_title
from page
where page_title rlike '^.+:'
limit 1000; |
1 year ago |
| select page_title
from page
where page_title rlike '^.{,6}:'
limit 1000; |
1 year ago |
| -- - |
1 year ago |
| select count(page_title)
from page
where page_namespace = 0
and... |
1 year ago |
| select count(page_title)
from page
where page_namespace = 0
and page_id not... |
1 year ago |
| select count(page_title)
from page
where page_namespace = 0
and page_id in... |
1 year ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
1 year ago |
| select page_title
from page
where page_namespace = 14
and page_id in (
... |
1 year ago |
| select page_title
from page
where page_namespace = 14
and page_id in (
... |
1 year ago |
| select page_title
from page
where page_namespace = 14
and page_id in (
... |
1 year ago |
| select COUNT(tl_from)
from templatelinks
join linktarget
on... |
1 year ago |
| select COUNT(tl_from)
from templatelinks
join linktarget
on... |
1 year ago |
| select Count(pp_page), pp_propname
from page_props
group by pp_propname; |
1 year ago |
| -- -- |
2 years ago |
| SELECT COUNT(page_title)
FROM page
WHERE page_namespace = 0
AND... |
2 years ago |
| SELECT page_title
FROM page
WHERE page_namespace = 0
AND page_is_redirect =... |
3 years ago |
| SELECT count(page_title)
FROM page
WHERE page_namespace = 0
AND... |
3 years ago |
| SELECT count(page_title)
FROM page
WHERE page_namespace = 0
AND... |
3 years ago |
| SELECT
page_id,
page_title,
page_is_redirect
FROM page
WHERE... |
3 years ago |
| SELECT
page_id,
page_title,
page_is_redirect
FROM page
WHERE... |
3 years ago |
| SELECT
page_id,
page_namespace,
page_title,
page_is_redirect
FROM... |
3 years ago |
| SELECT
page_namespace,
page_title,
rd_title,
rd_namespace
FROM... |
3 years ago |
| SELECT
page_namespace,
page_title,
rd_title,
rd_namespace
FROM... |
3 years ago |
| SELECT *
FROM page JOIN redirect
ON rd_from = page_id
WHERE page_namespace... |
3 years ago |
| SELECT *
FROM page JOIN redirect
ON rd_from = page_id
LIMIT 5;
/*
AND... |
3 years ago |
| SELECT page_id
FROM page JOIN redirect
ON rd_from = page_id
LIMIT 5;
/*
AND... |
3 years ago |
| SELECT page_id
FROM page JOIN redirect
ON rd_from = page_id
AND... |
3 years ago |
| SELECT page_id
FROM page JOIN redirect
ON rd_from = page_id
AND... |
3 years ago |
| SELECT page_id
FROM page JOIN redirect
ON rd_from = page_id
AND... |
3 years ago |
| SELECT *
FROM page JOIN redirect
ON rd_from = page_id
AND page_namespace =... |
3 years ago |
| SELECT page_id, page_namespace
FROM (SELECT * FROM page WHERE... |
3 years ago |
| SELECT page_id, page_namespace
FROM (SELECT * FROM page WHERE... |
3 years ago |
| SELECT page_id, page_namespace
FROM (SELECT * FROM page WHERE... |
3 years ago |
| SELECT *
FROM (SELECT * FROM page WHERE page_is_redirect = 1) AS page
JOIN... |
3 years ago |
| SELECT page_title
FROM (SELECT * FROM page WHERE page_is_redirect = 1) AS... |
3 years ago |
| SELECT page_title
FROM (SELECT * FROM redirect) AS page
JOIN (SELECT * FROM... |
3 years ago |
| SELECT * FROM redirect
LIMIT 10; |
3 years ago |
| SELECT * FROM page, redirect
LIMIT 10; |
3 years ago |
| SELECT * FROM redirect
LIMIT 10; |
3 years ago |
