| use eswiki_p;
SELECT COUNT(*) AS TOTAL_PAG, page_id, page_title,... |
3 years ago |
| use eswiki_p;
SELECT COUNT(*) AS TOTAL_PAG, page_id, page_title,... |
3 years ago |
| use eswiki_p;
SELECT COUNT(*) AS TOTAL_PAG, page_id, page_title,... |
3 years ago |
| use eswiki_p;
SELECT COUNT(*) AS TOTAL_PAG, page_id, page_title,... |
3 years ago |
| use eswiki_p;
SELECT page_id, page_title, page_namespace
FROM page
INNER... |
3 years ago |
| use eswiki_p;
SELECT page_id, page_title, page_namespace
FROM page
INNER... |
3 years ago |
| USE eswiki_p;
SELECT *
FROM page
WHERE page_title = 'Garroticos'
; |
3 years ago |
| USE eswiki_p;
SELECT *
FROM page
WHERE page_name = 'Garroticos'
; |
3 years ago |
| USE eswiki_p;
SELECT *
FROM page
WHERE page_title='Países'
; |
3 years ago |
| USE eswiki_p;
SELECT *
FROM page
WHERE page_title='Anexo:Países'
; |
3 years ago |
| USE eswiki_p;
SELECT count(*)
FROM page
WHERE page_title='Anexo:Países'
; |
3 years ago |
| USE eswiki_p;
SELECT count(*)
FROM pages
WHERE page_title='Anexo:Países'
; |
3 years ago |
| USE eswiki_p;
SELECT count(distinct(page_id))
FROM pagelinks
INNER JOIN page... |
3 years ago |
| USE eswiki_p;
SELECT count(distinct(page_id))
FROM pagelinks
INNER JOIN page... |
3 years ago |
| USE eswiki_p;
SELECT count(distinct(page_id))
FROM pagelinks
INNER JOIN page... |
3 years ago |
| USE exwiki_p;
SELECT count(distinct(page_id))
FROM pagelinks
INNER JOIN page... |
3 years ago |
| USE exwiki_p:
FROM pagelinks
INNER JOIN page ON pl_from = page_id
WHERE... |
3 years ago |
