SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
GROUP BY page_namespace ;
#... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace, page_is_redirect count(page_id)
FROM page
WHERE (... |
2 years ago |
SELECT page_namespace, page_is_redirect count(page_id)
FROM page
WHERE... |
2 years ago |
SELECT page_namespace, page_is_redirect count(page_id)
FROM page
WHERE... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace, count(page_id)
FROM page
WHERE page_is_redirect = 0... |
2 years ago |
SELECT page_namespace count(page_id)
FROM page
WHERE page_is_redirect = 0 #... |
2 years ago |
SELECT count(page_id)
FROM page where page_is_redirect = 0 and page_namespace = 0 ; |
2 years ago |
SELECT page_namespace count(page_id)
FROM page where page_is_redirect = 0 ; |
2 years ago |
SELECT page_namespace count(page_id)
FROM page where page_is_redirect = '0' ; |
2 years ago |
SELECT page_namespace count(page_id)
FROM page; |
2 years ago |
USE enwiki_p;
SELECT count(page_id)
FROM
page
WHERE
page_namespace = 0
; |
2 years ago |