| SELECT
page_namespace,
page_title
FROM page
JOIN pagelinks
ON pl_from =... |
4 years ago |
| SELECT
page_namespace,
page_title
FROM page
JOIN pagelinks
ON pl_from =... |
4 years ago |
| SELECT
page_namespace,
page_title
FROM page
JOIN pagelinks
ON pl_from =... |
4 years ago |
| SELECT
page_namespace,
page_title
FROM page
JOIN pagelinks
ON pl_from =... |
4 years ago |
| select
cat_title,
cat_pages
from category |
4 years ago |
| select
cat_title,
cat_pages
from category
where cat_id <50 |
4 years ago |
| select
cl_to
from categoryli |
4 years ago |
| select
cl_to
from categorylinks
|
4 years ago |
| select
cl_to
from categoryLinks
|
4 years ago |
| SELECT
page_title,
cl_to
FROM page
JOIN
(SELECT
cl_to,
cl_from
... |
4 years ago |
| SELECT
page_namespace,
ns_name,
page_title,
COUNT(*)
FROM... |
4 years ago |
| SELECT
page_namespace,
ns_name,
page_title,
COUNT(*)
FROM... |
4 years ago |
| SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE... |
4 years ago |
| SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE... |
4 years ago |
| sELECT
page_is_redirect,
page_title,
user_name,
logs.log_timestamp,
... |
4 years ago |
| show * from meta_p |
4 years ago |
| select * from 'user'; |
4 years ago |
| select * from 'user'; |
4 years ago |
| sql enwiki_p |
4 years ago |
| show tables from enwiki_p;
|
4 years ago |
| show * from category; |
4 years ago |
| show tables from enwiki_p;
|
4 years ago |
| show tables from enwiki;
|
4 years ago |
| show databases like "%_p";
|
4 years ago |
|
SELECT CONCAT('Hi', page_title) AS talk_page
FROM page
WHERE
... |
4 years ago |
