SELECT * FROM comment WHERE comment_text REGEXP 'P31' LIMIT 20; |
2 years ago |
SELECT * FROM comment WHERE comment_text REGEXP 'P31' LIMIT 10; |
2 years ago |
SELECT * FROM comment WHERE comment_text REGEXP 'P31' LIMIT 1; |
2 years ago |
SELECT * FROM comment LIMIT 100; |
2 years ago |
SELECT * FROM comment LIMIT 1; |
2 years ago |
SELECT * FROM comment_id LIMIT 1; |
2 years ago |
DESCRIBE text; |
2 years ago |
DESCRIBE text; |
2 years ago |
SELECT rev_id
FROM revision
WHERE rev_parent_id = 0
AND rev_page IN... |
2 years ago |
SELECT *
FROM revision
JOIN page ON rev_page = page_id
WHERE... |
2 years ago |
SELECT *
FROM page
WHERE page_title LIKE '%Rdrg109%'
ORDER BY page_len... |
2 years ago |
SELECT page_title, page_len, page_namespace
FROM page
WHERE page_title... |
2 years ago |
SELECT page_title, page_len, page_namespace
FROM page
WHERE... |
2 years ago |
SELECT page_title, page_len, page_namespace
FROM page
WHERE... |
2 years ago |
SELECT page_title, page_len, page_namespace
FROM page
WHERE... |
2 years ago |
SELECT page_title, page_len, page_namespace
FROM page
WHERE... |
2 years ago |
SELECT page_title, page_len, page_namespace
FROM page
ORDER BY page_len... |
2 years ago |
SELECT page_title, page_len
FROM page
ORDER BY page_len DESC
LIMIT 10 |
2 years ago |
SELECT page_title, page_len
FROM page
LIMIT 10
ORDER BY page_len DESC |
2 years ago |
SELECT page_title, page_len
FROM page
LIMIT 10
ORDER BY page_len DESC |
2 years ago |
SELECT page_title, page_len
FROM page
LIMIT 10 |
2 years ago |
DESCRIBE page |
2 years ago |
SELECT CONCAT("https://es.wikipedia.org/wiki/", page_title),... |
2 years ago |
SELECT CONCAT("https://qu.wikipedia.org/wiki/", page_title),... |
2 years ago |
SELECT CONCAT("https://qu.wikipedia.org/wiki/", page_title),... |
2 years ago |
SELECT CONCAT("https://qu.wikipedia.org/wiki/", page_title),... |
2 years ago |
SELECT CONCAT("https://qu.wikipedia.org/wiki/", page_title),... |
2 years ago |
SELECT CONCAT("https://qu.wikipedia.org/wiki", page_title),... |
2 years ago |
SELECT CONCAT("https://qu.wikipedia.org/", page_title), page_namespace
FROM... |
2 years ago |
SELECT CONCAT(page_title, "A"), page_namespace
FROM page
WHERE... |
2 years ago |
SELECT page_title, page_namespace
FROM page
WHERE page_namespace != 0
LIMIT 10 |
2 years ago |
SELECT page_title, page_namespace
FROM page
LIMIT 10 |
2 years ago |
DESCRIBE page |
2 years ago |
SELECT page_title, rev_timestamp
FROM page
LIMIT 10 |
2 years ago |
SELECT page_title
FROM page
LIMIT 10 |
2 years ago |
DESCRIBE enwiki_p.actor; |
2 years ago |
DESCRIBE enwiki_p.actor; |
2 years ago |
SHOW TABLES FROM enwiki_p; |
2 years ago |
select page_title from page where page_id = 23841196
and page_namespace = 0; |
2 years ago |
SELECT * FROM blobs LIMIT 1
|
2 years ago |
SELECT * FROM blobs LIMIT 1
|
2 years ago |
SELECT * FROM blobs LIMIT 1
|
2 years ago |