| USE huwiki_p;
/* Real data */
SELECT NOW() AS date,... |
6 years ago |
| USE huwiki_p;
SELECT NOW() AS date, SUM(page_len)/(1024*1024) AS 'total... |
6 years ago |
| USE huwiki_p;
SELECT NOW() AS date, SUM(page_len)/(1024*1024) AS 'total... |
6 years ago |
| USE huwiki_p;
SELECT NOW() AS date, SUM(page_len)/(1024*1024) AS 'total... |
6 years ago |
| USE huwiki_p;
SELECT NOW() AS date, SUM(page_len)/(1024*1024) AS 'total... |
6 years ago |
| USE huwiki_p;
SELECT NOW() AS date, SUM(page_len)/(1024*1024) AS 'total... |
6 years ago |
| use huwiki_p;
SELECT NOW() AS date, SUM(page_len)/(1024*1024) AS total,... |
6 years ago |
| use huwiki_p;
SELECT NOW() AS date, SUM(page_length)/(1024*1024) AS total,... |
6 years ago |
| use huwiki_p;
SELECT NOW() AS date, COUNT(page_id) AS articles,... |
6 years ago |
| use huwiki_p;
SELECT COUNT(page_id) AS articles, SUM(page_len) AS length,... |
6 years ago |
| use huwiki_p;
SELECT COUNT(page_id) AS articles, SUM(page_len) AS... |
6 years ago |
| use huwiki_p;
SELECT COUNT(page_id) AS articles, SUM(page_len) AS... |
6 years ago |
| use huwiki_p;
DESCRIBE page; |
6 years ago |
| use huwiki_p;
DESCRIBE articletext; |
6 years ago |
| use huwiki_p;
DESCRIBE article_text; |
6 years ago |
| use huwiki_p;
SELECT COUNT(*), ll_from
FROM langlinks
GROUP BY 2
... |
6 years ago |
| use huwiki_p;
/*SELECT COUNT(*), ll_from
FROM langlinks
GROUP BY 2
... |
6 years ago |
| use huwiki_p;
/*SELECT COUNT(*), ll_from
FROM langlinks
GROUP BY 2
... |
6 years ago |
| use huwiki_p;
/*SELECT COUNT(*), ll_from
FROM langlinks
GROUP BY 2
... |
6 years ago |
| use huwiki_p;
/*SELECT COUNT(*), ll_from
FROM langlinks
GROUP BY 2
... |
6 years ago |
| use huwiki_p;
/*SELECT COUNT(*), ll_from
FROM langlinks
GROUP BY 2
... |
6 years ago |
| use huwiki_p;
/*SELECT COUNT(*), ll_from
FROM langlinks
GROUP BY 2
... |
6 years ago |
| use huwiki_p;
/*SELECT COUNT(*), ll_from
FROM langlinks
GROUP BY 2
... |
6 years ago |
| use huwiki_p;
/*SELECT COUNT(*), ll_from
FROM langlinks
GROUP BY 2
... |
6 years ago |
| use huwiki_p;
SELECT COUNT(*), ll_from
FROM langlinks
GROUP BY 2
... |
6 years ago |
| use huwiki_p;
/*select count(*), ll_from from langlinks group by 2 order by... |
6 years ago |
| use huwiki_p;
/*select count(*), ll_from from langlinks group by 2 order by... |
6 years ago |
| use huwiki_p;
select count(*), ll_from from langlinks group by 2 order by 1... |
10 years ago |
| use huwiki_p;
select count(*), ll_from from langlinks group by 2 order by 1... |
10 years ago |
| use huwiki_p;
select count(*), ll_from from langlinks group by 2 order by 1... |
10 years ago |
| use huwiki_p;
select count(*), ll_from from langlinks group by 2 order by 1... |
10 years ago |
| use huwiki_p;
select count(*), ll_from from langlinks group by 2 order by 1... |
10 years ago |
| use huwiki_p;
select count(*), ll_from from langlinks group by 2 order by 1... |
10 years ago |
| select count(*), ll_from from langlinks group by 2 order by 1 desc limit 20; |
10 years ago |
| select count(*), ll_from from langlinks group by 2 order by 1 desc limit 100; |
10 years ago |
| select count(*), ll_from from langlinks group by 2 order by 1 desc limit 100; |
10 years ago |
| blank query |
10 years ago |
| USE huwiki_p;
SELECT tl_namespace, page_title FROM page, count(*) FROM... |
10 years ago |
| USE huwiki_p;
SELECT tl_namespace, page_title FROM page, count(*) FROM... |
10 years ago |
| USE huwiki_p;
SELECT tl_namespace, page_title FROM page, count(*) FROM... |
10 years ago |
| USE huwiki_p;
SELECT tl_namespace, page_title FROM page
LEFT JOIN... |
10 years ago |
| USE huwiki_p;
SELECT tl_namespace, page_title FROM page
LEFT JOIN... |
10 years ago |
| USE huwiki_p;
SELECT page_title FROM page
LEFT JOIN templatelinks ON... |
10 years ago |
| use huwiki_p;
select count(*), ll_from from langlinks group by 2 order by 1... |
10 years ago |
