SELECT *
FROM page_props JOIN page ON page_id = pp_page
WHERE page_id = 3242294 |
2 years ago |
SELECT *
FROM page_props JOIN page ON page_id = pp_page
WHERE page_id = 7285016 |
2 years ago |
SELECT *
FROM page_props JOIN page ON page_id = pp_page
WHERE page_id = 7285016 |
2 years ago |
SELECT page_title FROM page where page_content_model = 'javascript' |
2 years ago |
SELECT page_title FROM page where page_content_model = 'javascript' LIMIT 100 |
2 years ago |
SELECT * FROM page where page_content_model = 'javascript' LIMIT 100 |
2 years ago |
SELECT * FROM page where page_content_model = 'javascript' LIMIT 1 |
2 years ago |
SELECT COUNT(*) FROM page where page_content_model = 'javascript' |
2 years ago |
SELECT * FROM page where page_content_model = 'javascript' LIMIT 1 |
2 years ago |
SELECT * FROM page LIMIT 1 |
2 years ago |
SELECT * FROM Page LIMIT 1 |
2 years ago |
SELECT page_id, page_title, page_len
FROM page
WHERE page_namespace = 2
... |
2 years ago |
SELECT page_id, page_title, page_len
FROM page
WHERE page_namespace = 2
... |
2 years ago |
SELECT page_id, page_title, page_len
FROM page
WHERE page_namespace = 2
... |
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 2
AND page_title LIKE... |
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 2
AND page_title LIKE '%/common.js' |
2 years ago |
SELECT page_id, page_len
FROM page
WHERE page_namespace = 2
AND... |
2 years ago |
SELECT page_id, page_len
FROM page
WHERE page_namespace = 2
AND... |
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 2
AND page_title LIKE... |
2 years ago |
SELECT COUNT(page_id)
FROM page
WHERE page_namespace = 2
AND... |
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 2
AND page_title LIKE... |
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 2
AND page_title LIKE... |
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 2
LIMIT 10 |
2 years ago |
SELECT * FROM page LIMIT 1 |
2 years ago |
SHOW TABLES; |
2 years ago |
USE `wikidatawiki_p`;
SELECT `page_title` AS "lexeme ID", `pp_value` AS... |
2 years ago |
USE `wikidatawiki_p`;
SELECT `page_title` AS "lexeme ID", `pp_value` AS... |
2 years ago |
SHOW DATABASES; |
2 years ago |
SHOW DATABASES; |
2 years ago |
SHOW DATABASES; |
2 years ago |
SHOW DATABASES; |
2 years ago |
SHOW DATABASES; |
2 years ago |
SHOW DATABASES; |
2 years ago |
SHOW DATABASES; |
2 years ago |
SHOW DATABASES; |
2 years ago |