| SELECT
rev_id as "rev_id", rev_timestamp as "B"from revision
limit 100
;
|
3 years ago |
| SELECT
rev_id as rev_id", rev_timestamp from revision
limit 100
;
|
3 years ago |
| SELECT
rev_id rev_timestamp from revision
limit 100
;
|
3 years ago |
| SELECT
rev_id, rev_timesptamp from revision
limit 100
;
|
3 years ago |
| SELECT
count(*) from revision
WHERE
rev_timestamp = MIN(rev_timestamp)
;
|
3 years ago |
| SELECT
count(*) from revision
;
|
3 years ago |
| SELECT
count(rev_id) from revision
;
|
3 years ago |
| SELECT
count(rev_id) from eevision
;
|
3 years ago |
| SELECT
count(page_id), page_is_redirect from page,
count(rev_id) from... |
3 years ago |
| SELECT
count(page_id), page_is_redirect from page,
count(rev_id) from... |
3 years ago |
| SELECT
count(page_id) from page,
count(rev_id) from... |
3 years ago |
| SELECT
count(*) from page
WHERE
rev_id = page_id
AND... |
3 years ago |
| SELECT
count(*) FROM page,
rev_timestamp FROM revision
WHERE
rev_id =... |
3 years ago |
| SELECT
count(*) FROM page,
rev_timestamp FROM revision
WHERE
rev_id =... |
3 years ago |
| SELECT
count(*) FROM page,
SUBSTR(rev_timestamp,1,6) FROM revision... |
3 years ago |
| SELECT
count(*) FROM page,
SUBSTR(rev_timestamp,1,6) FROM revision... |
3 years ago |
| SELECT
count(*) FROM page AS "TOTAL ARTICULOS" ,
... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS" FROM page,
... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS" FROM page
... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS" FROM page
... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS" FROM page
... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS" FROM page
... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS",
MIN(SUBSTR(rev_timestamp,1,6))... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS",
MIN(SUBSTR(page_touched,1,6)) AS... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS",
MIN(SUBSTR(page_touched,1,6)) AS... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS",
SUBSTR(page_touched,1,6) AS... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS",
SUBSTR(page_touched,1,6) AS... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS",
SUBSTR(page_touched,1,6) AS... |
3 years ago |
| SELECT
count(*) AS "TOTAL ARTICULOS"
SUBSTR(page_touched,1,6) AS... |
3 years ago |
| SELECT
count(*) as "TOTAL ARTICULOS"
FROM
page
WHERE
page_is_redirect =... |
3 years ago |
| SELECT
count(*) as TOTAL ARTICULOS
FROM
page
WHERE
page_is_redirect =... |
3 years ago |
| select "1.679.506", count(*) as TOTAL , (count(*)-1679506) as DIFERENCIA... |
3 years ago |
| select "1.679.506", count(*) as TOTAL , (TOTAL-1679506) as DIFERENCIA from... |
3 years ago |
| select "1.670.735", count(*) as TOTAL from page where page_is_redirect = 0... |
3 years ago |
| select count(*) as TOTAL from page where page_is_redirect = 0 and... |
3 years ago |
| select page_namespace, count(*) as TOTAL from page where page_is_redirect =... |
3 years ago |
| select page_namespace, count(*) as TOTAL from page where page_is_redirect =... |
3 years ago |
| select page_namespace, count(*) as TOTAL from page where page_is_redirect =... |
3 years ago |
| select count(*) from page where page_is_redirect = 0 and page_namespace in... |
3 years ago |
| select count(*) from page where page_namespace in (0,104);
;
|
3 years ago |
| select page_namespace, count(*) from page where page_namespace in (0,104);
;
|
3 years ago |
| select page_namespace, count(*) from page where page_is_redirect = 0 and... |
3 years ago |
| SELECT
page_namespace,
count(*) as TOTAL
FROM page
WHERE
page_is_new... |
3 years ago |
| SELECT
page_namespace,
count(*) as TOTAL
FROM page
GROUP... |
3 years ago |
| SELECT
page_namespace,
count(*) as TOTAL
FROM page
WHERE
page_is_new... |
3 years ago |
| SELECT
page_namespace,
count(*)
FROM page
WHERE
page_is_new = "1"
... |
3 years ago |
| SELECT
page_namespace,
count(*)
FROM page
WHERE
page_is_new = "1"
... |
3 years ago |
| SELECT
count(*)
FROM page
WHERE
page_is_new = "1"
AND
... |
3 years ago |
| SELECT
count(*)
FROM page
WHERE
page_is_new = "1"
;
|
3 years ago |
| SELECT
count(*)
FROM page
WHERE
page_is_new = "1"
AND
... |
3 years ago |
| SELECT
count(DISTINCT page_title) ,
SUBSTR(page_touched,1,6)
FROM page... |
3 years ago |
| SELECT
count(DISTINCT page_title) ,
SUBSTR(page_touched,1,4)
FROM page... |
3 years ago |
| SELECT
count(DISTINCT page_title) ,
SUBSTR(page_touched,1,8)
FROM page... |
3 years ago |
| SELECT
count(DISTINCT page_title) ,
SUBSTR(page_touched,1,8)
FROM page... |
3 years ago |
| SELECT
DISTINCT page_title ,
SUBSTR(page_touched,1,8)
FROM page... |
3 years ago |
| SELECT
DISTINCT page_title
SUBSTR(page_touched,1,8)
FROM page... |
3 years ago |
| SELECT
SUBSTR(page_touched,1,8) ,
DISTINCT page_title
FROM page... |
3 years ago |
| SELECT
SUBSTR(page_touched,1,8) ,
DISTINCT COUNT(page_title)
FROM page... |
3 years ago |
| SELECT
SUBSTR(page_touched,1,8) ,
COUNT(*)
FROM page... |
3 years ago |
| SELECT
SUBSTR(page_touched,1,8) ,
COUNT(*)
FROM page... |
3 years ago |
| SELECT
SUBSTR(page_touched,1,6) ,
COUNT(*)
FROM page... |
3 years ago |
| SELECT
SUBSTR(page_touched,1,6) ,
COUNT(*)
FROM page... |
3 years ago |
| select substr(page_touched,1,4),count(*) from page where page_is_new = "1"... |
3 years ago |
| select substr(page_touched,1,4),count(*) from page where page_is_new = "1"... |
3 years ago |
| select substr(page_touched,1,4),count(*) from page where page_is_new = "1"... |
3 years ago |
| select substr(page_touched,1,4),count(*) from page where page_is_new = "1"... |
3 years ago |
| select count(*) from page where page_is_new = "1" and
(page_touched >=... |
3 years ago |
| select *, count(*) from page where page_is_new = "1" and
(page_touched >=... |
3 years ago |
| select *, count(*) from page where page_is_new = "1"
limit 100;
|
3 years ago |
| select page_namespace, count(*) from page where page_is_new = "1" group by... |
3 years ago |
| select page_namespace, count(*) from page group by page_namespace;
|
3 years ago |
| select page_namespace, count(*) from page where page_is_new = "1" group by... |
3 years ago |
| select count(*) from page where page_is_new = "1" group by page_namespace;
|
3 years ago |
| select count(*) from page and page_is_new = "1" group by page_namespace;
|
3 years ago |
| select count(*) from page where page_namespace in (0, 4, 14, 104) and... |
3 years ago |
| select count(*) from page where page_namespace in (0, 4, 14, 104) and... |
3 years ago |
| select count(*) from page where page_namespace in (0, 14, 104) and... |
3 years ago |
| select count(*) from page where page_namespace in (0, 104) and page_is_new =... |
3 years ago |
| select distinct count(page_title) from page where page_is_new = "1" group... |
3 years ago |
| select distinct count(page_title) from page where page_namespace in (0) and... |
3 years ago |
| select distinct count(page_title) from page where page_namespace in (0)... |
3 years ago |
| select distinct count(page_title) from page ;
|
3 years ago |
| select distinct count(page_title) from page where page_namespace in (0, 4,... |
3 years ago |
| select count(*) from page where page_namespace in (0, 4) group by page_namespace;
|
3 years ago |
| select count(*) from page where page_namespace in (0, 104) group by page_namespace;
|
3 years ago |
| select count(*) from page where page_namespace in (104);
|
3 years ago |
| select count(*) from page where page_namespace in (0);
|
3 years ago |
| select count(*) from page where page_namespace in (0, 104);
|
3 years ago |
| select count(*)) from page where page_namespace in (0, 104);
|
3 years ago |
| DESCRIBE text;
|
3 years ago |
| SELECT COUNT(*) FROM pagecontent
|
3 years ago |
| SELECT COUNT(*) FROM text
|
3 years ago |
| SELECT COUNT(*) FROM page
|
3 years ago |
| SELECT COUNT(*) FROM page
WHERE page_is_new = '1'
|
3 years ago |
| DESCRIBE page
|
3 years ago |
| DESCRIBE text
|
3 years ago |
| SELECT COUNT(*) FROM text
|
3 years ago |
| SELECT COUNT(*)
FROM text
WHERE old_text LIKE "trabajo";
|
3 years ago |
|
select sum(page_len) from page where page_namespace in (0, 104);
|
3 years ago |
| SELECT COUNT(*)
FROM text
WHERE old_text LIKE "trabajo"; |
3 years ago |
| SELECT COUNT(*)
FROM text
WHERE old_text LIKE "trabajo"; |
3 years ago |
| SELECT COUNT(*)
FROM pages
WHERE old_text LIKE "trabajo"; |
3 years ago |
