SELECT *
FROM page
WHERE page_namespace IN (0, 14)
AND page_title... |
2 years ago |
SELECT *
FROM page
WHERE page_namespace IN (0, 14)
AND page_title... |
2 years ago |
SELECT page_title
FROM page
WHERE page_namespace IN (0, 14)
AND... |
2 years ago |
USE `eswiki_p`
SELECT page_title
FROM page
WHERE page_namespace IN (0,... |
2 years ago |
SELECT page_title
FROM page
WHERE page_namespace IN (0, 14)
AND... |
2 years ago |
SELECT page_title
FROM page
WHERE page_namespace IN (0, 14)
AND... |
2 years ago |
USE `eswiki_p`
SELECT page_title
FROM page
WHERE page_namespace IN (0,... |
2 years ago |
USE `eswiki_p`
SELECT page_title
FROM page
WHERE page_namespace IN (0,... |
2 years ago |
USE `eswiki_p`
SELECT page_title
FROM page
WHERE page_namespace IN (0,... |
2 years ago |
SHOW TABLES;
|
2 years ago |
USE `wikidatawiki_p`;
SHOW TABLES;
|
2 years ago |
SHOW TABLES;
|
2 years ago |
SELECT COUNT(page_id)
FROM page
WHERE page_namespace IN (0, 14)
AND... |
2 years ago |
SELECT page_title
FROM page
WHERE page_namespace = 14
AND page_title... |
2 years ago |
SELECT COUNT(page_id)
FROM page
WHERE page_namespace IN (0, 14)
AND... |
2 years ago |
SELECT COUNT(page_id)
FROM page
WHERE page_title REGEXP... |
2 years ago |
SELECT page_title
FROM page
WHERE page_title LIKE '%Perú%' AND page_title... |
2 years ago |
SELECT page_title
FROM page
WHERE page_title LIKE '%Perú%' AND page_title... |
2 years ago |
SELECT page_title
FROM page
WHERE page_title LIKE '%Perú%' AND page_title... |
2 years ago |
SELECT page_title
FROM page
WHERE page_title LIKE '%Perú%' AND page_title... |
2 years ago |
SELECT page_namespace
FROM page
WHERE page_id = 7285016 |
2 years ago |
SELECT page_id, page_title, page_len
FROM page
WHERE page_title LIKE... |
2 years ago |
SELECT *
FROM page
WHERE page_id = 7285016 |
2 years ago |
SELECT page_namespace, page_id, page_title
FROM page
WHERE page_title... |
2 years ago |
SELECT page_id, page_title
FROM page
WHERE page_title REGEXP... |
2 years ago |
SELECT page_id, page_title
FROM page
WHERE page_title REGEXP... |
2 years ago |
SELECT page_title
FROM page
WHERE page_namespace = 14
AND page_title... |
2 years ago |
SELECT page_title
FROM page
WHERE page_namespace = 14
AND page_title... |
2 years ago |
SELECT page_namespace, count(page_namespace) AS count
FROM page
WHERE... |
2 years ago |
SELECT page_namespace, page_id, page_title, page_len
FROM page
WHERE... |
2 years ago |
SELECT page_id, page_title, page_len
FROM page
WHERE page_title REGEXP... |
2 years ago |
SELECT page_id, page_title
FROM page
WHERE page_title REGEXP '\\bPER(U|Ú)'
|
2 years ago |
SELECT page_id, page_title
FROM page
WHERE page_title REGEXP... |
2 years ago |
SELECT page_title
FROM page
WHERE page_title like '%Edit%' and page_title... |
2 years ago |
SELECT page_title
FROM page
WHERE page_title like '%Edit%' and page_title... |
2 years ago |
describe page |
2 years ago |
SELECT page_namespace, count(page_namespace) AS count
FROM page
WHERE... |
2 years ago |
# db: eswiki_p
SELECT page_namespace, count(page_namespace) AS count
FROM... |
2 years ago |
# db: eswiki_p
SELECT page_namespace, count(page_namespace)
FROM page
... |
2 years ago |
# db: eswiki_p
SELECT COUNT(*)
FROM page
WHERE page_title REGEXP... |
2 years ago |
SELECT page_title
FROM page
WHERE page_title REGEXP '^\\b(p|P)eru' |
2 years ago |
SELECT COUNT(*)
FROM page
WHERE page_title REGEXP '^\\b(p|P)eru' |
2 years ago |
SELECT COUNT(*)
FROM page
WHERE page_title REGEXP '\\b(p|P)(e|E)(r|R)(u|U|ú|Ú)' |
2 years ago |
SELECT COUNT(*)
FROM page
WHERE page_title REGEXP '\\b(p|P)(e|E)(r|R)(u|U|ú|Ú)' |
2 years ago |
SELECT COUNT(*)
FROM page
WHERE page_title REGEXP '\\b(p|P)er(u|ú)'
|
2 years ago |
SELECT COUNT(*)
FROM page
WHERE page_title REGEXP '\\b(p|P)er(u|ú)'
|
2 years ago |
SELECT COUNT(*)
FROM page
WHERE page_title REGEXP '\\b(p|P)eru'
|
2 years ago |
SELECT COUNT(*)
FROM page
WHERE page_title REGEXP '\\b(p|P)(e|E)(r|R)(u|U|ú|Ú)'
|
2 years ago |
SELECT COUNT(*)
FROM page
WHERE page_title REGEXP '\\b(p|P)(e|E)(r|R)(u|U|ú|Ú)'
|
2 years ago |
SELECT COUNT(page_id)
FROM page
WHERE page_title REGEXP... |
2 years ago |
SELECT COUNT(page_id)
FROM page
WHERE page_title REGEXP... |
2 years ago |