| USE nqowiki_p;
SELECT COUNT(DISTINCT rev_actor)
FROM revision; |
4 years ago |
| USE nqowiki_p;
SELECT page_len, page_title
FROM page
WHERE page_namespace = '1'; |
4 years ago |
| USE nqowiki_p;
SELECT page_len
FROM page
WHERE page_namespace = '1'; |
4 years ago |
| USE nqowiki_p;
SELECT page_len
FROM page
WHERE page_namespace = '1'... |
4 years ago |
| USE nqowiki_p;
SELECT page_len
FROM page
JOIN revision
ON page_id =... |
4 years ago |
| USE nqowiki_p;
SELECT page_len WHERE page_namespace = '1'
FROM page
JOIN... |
4 years ago |
| USE nqowiki_p;
SELECT page_len WHERE page_namespace = '1'
FROM page
JOIN... |
4 years ago |
| USE nqowiki_p;
SELECT page_len WHERE page_namespace = '1'
FROM page
JOIN... |
4 years ago |
| USE nqowiki_p;
SELECT page_len as "T" WHERE page_namespace = '1'
FROM page... |
4 years ago |
| USE nqowiki_p;
SELECT COUNT(DISTINCT(rev_actor)) AS 'U', COUNT(rev_page) AS... |
4 years ago |
| USE nqowiki_p;
SELECT COUNT(DISTINCT(rev_actor)) AS 'U', COUNT(rev_page) AS... |
4 years ago |
| USE nqowiki_p;
SELECT COUNT(DISTINCT(rev_actor)) AS 'U', COUNT(rev_page) AS... |
4 years ago |
| USE nqowiki_p;
SELECT COUNT(DISTINCT(rev_actor)) AS 'U', COUNT(rev_page) AS... |
4 years ago |
| USE nqowiki_p;
SELECT page_title, COUNT(DISTINCT(rev_actor)) AS 'U',... |
4 years ago |
| USE nqowiki_p;
SELECT page_title, COUNT(DISTINCT(rev_actor)) AS 'U',... |
4 years ago |
| USE nqowiki_p;
SELECT page_title,COUNT(DISTINCT(rev_actor)) AS 'U'
FROM... |
4 years ago |
| USE nqowiki_p;
SELECT page_title,COUNT(DISTINCT(rev_actor))
FROM page
JOIN... |
4 years ago |
| USE nqowiki_p;
SELECT page_title,COUNT(DISTINCT(rev_actor))
FROM page
JOIN... |
4 years ago |
| USE nqowiki_p;
SELECT page_title
FROM page
JOIN revision
ON page_title =... |
4 years ago |
| USE zuwiki_p;
SELECT page_title
FROM page
JOIN revision
ON page_title =... |
4 years ago |
| USE zuwiki_p;
SELECT page_title, COUNT(*)
FROM page
JOIN revision
ON... |
4 years ago |
| USE jamwiki_p;
SELECT page_title, COUNT(*)
FROM page
JOIN revision
ON... |
4 years ago |
| USE scowiki_p;
SELECT page_title, COUNT(*)
FROM page
JOIN revision
ON... |
4 years ago |
| USE nqowiki_p;
SELECT page_title, COUNT(*)
FROM page
JOIN revision
ON... |
4 years ago |
| USE nqowiki_p;
SELECT page_title, COUNT(rev_id)
FROM page
JOIN revision
ON... |
4 years ago |
| USE nqowiki_p;
SHOW TABLES; |
4 years ago |
| USE nqowiki_p;
SELECT page_title, page_len
FROM page; |
4 years ago |
| USE nqowiki_p;
SELECT page_len
FROM page; |
4 years ago |
| USE nqowiki_p;
SELECT page_title, COUNT(*) as 'E'
FROM revision
JOIN... |
4 years ago |
| USE nqowiki_p;
SELECT page_title, COUNT(*)
FROM revision
JOIN page
ON... |
4 years ago |
| USE nqowiki_p;
SELECT page_title, COUNT(*)
FROM revision
JOIN page
ON... |
4 years ago |
| USE nqowiki_p;
SELECT COUNT(*)
FROM revision
JOIN page
ON page_id =... |
4 years ago |
| USE nqowiki_p;
SELECT COUNT(rev_page)
FROM page
JOIN revision
ON page_id =... |
4 years ago |
| USE nqowiki_p;
SELECT COUNT(*)
FROM page
JOIN revision
ON page_id =... |
4 years ago |
| USE nqowiki_p;
SELECT *
FROM revision
LIMIT 10; |
4 years ago |
| USE nqowiki_p;
SELECT *
FROM page
LIMIT 10; |
4 years ago |
| USE nqowiki_p;
SHOW TABLES; |
4 years ago |
| USE nqowiki_p;
SELECT COUNT(rev_id)
FROM revision
JOIN page
ON rev_page =... |
4 years ago |
| USE nqowiki_p;
SELECT COUNT(rev_id) FROM revision GROUP by rev_actor LIMIT 10; |
4 years ago |
| USE nqowiki_p;
SELECT DISTINCT rev_actor
FROM revision
JOIN page
ON... |
4 years ago |
| USE nqowiki_p;
SELECT page_title
SELECT DISTINCT rev_actor
FROM revision... |
4 years ago |
| USE nqowiki_p;
SELECT page_title, rev_actor
FROM page
JOIN revision
ON... |
4 years ago |
| USE nqowiki_p;
SELECT rev_actor
FROM page
JOIN revision
ON rev_page =... |
4 years ago |
| USE nqowiki_p;
SELECT rev_actor
FROM page
JOIN revision
ON rev_page =... |
4 years ago |
| USE nqowiki_p;
SELECT DISTINCT COUNT(rev_actor)
FROM page
JOIN... |
4 years ago |
| USE nqowiki_p;
SELECT DISTINCT COUNT(rev_actor) as U
FROM page
JOIN... |
4 years ago |
| USE nqowiki_p;
SELECT * FROM page LIMIT 10; |
4 years ago |
