| SELECT log_type, COUNT(*) FROM logging
WHERE log_namespace = '2'
GROUP BY log_type
|
3 years ago |
| select log_type, count(*) from logging
/*WHERE log_type= 'thanks'
AND*/... |
3 years ago |
| select log_type, count(*) from logging
/*WHERE log_type= 'thanks'*/
AND*/... |
3 years ago |
| select log_type, count(*) from logging
WHERE log_type= 'thanks'
AND... |
3 years ago |
| select log_type count(*) from logging
WHERE log_type= 'thanks'
AND... |
3 years ago |
| select log_type, SUBSTR(log_timestamp,1,6) as AAAAMM, count(*) from... |
3 years ago |
| SELECT log_namespace, log_action, COUNT(*)
FROM logging
/* WHERE log_type =... |
3 years ago |
| SELECT log_action, COUNT(*)
FROM logging
/* WHERE log_type = 'thanks' */
|
3 years ago |
| SELECT log_type, COUNT(*)
FROM logging
/* WHERE log_type = 'thanks' */
|
3 years ago |
| SELECT log_type, COUNT(*)
FROM logging
/* WHERE log_type = 'thanks'
|
3 years ago |
| SELECT log_type, COUNT(*)
FROM logging
WHERE log_type = 'thanks'
|
3 years ago |
| USE commonswiki_p;
SELECT cat_id, cat_title, cat_pages, cat_subcats,... |
3 years ago |
| USE commonswiki_p;
SELECT cat_id, cat_title, cat_pages, cat_subcats,... |
3 years ago |
| USE commonswiki_p;
SELECT cat_id, cat_title, cat_pages, cat_subcats,... |
3 years ago |
| SELECT cat_id, cat_title, cat_pages, cat_subcats, cat_files FROM... |
3 years ago |
| SELECT cat_id, cat_title, cat_pages, cat_subcats, cat_files FROM... |
3 years ago |
| DESCRIBE category
|
3 years ago |
| SHOW TABLE category
|
3 years ago |
| SHOW TABLES
|
3 years ago |
| LIST ALL TABLES
|
3 years ago |
| USE commonswiki;
LIST ALL TABLES
|
3 years ago |
| USE commonswiki;
LIST ALL TABLES
|
3 years ago |
| LIST ALL TABLES
|
3 years ago |
| SELECT CONCAT(log_namespace,"#", log_type) as VAR1, count(*) FROM... |
3 years ago |
| SELECT CONCAT(log_namespace," # ", log_type) as VAR1, count(*) FROM... |
3 years ago |
| SELECT CONCAT(log_namespace," - ", log_type) as VAR1, count(*) FROM... |
3 years ago |
| SELECT log_type, count(log_namespace) FROM logging
WHERE log_namespace =... |
3 years ago |
| SELECT log_namespace, count(log_namespace) FROM logging
WHERE log_namespace... |
3 years ago |
| SELECT log_action, COUNT(log_action), log_namespace, count(log_namespace)... |
3 years ago |
| SELECT log_action, COUNT(log_action), page_namespace, count(log_namespace)... |
3 years ago |
| SELECT log_action, COUNT(log_action) page_namespace, count(log_namespace)... |
3 years ago |
| SELECT log_action, COUNT(log_action) page_namespace, count(log_namespace)... |
3 years ago |
| SELECT log_action, COUNT(log_action) FROM logging
GROUP BY log_action
|
3 years ago |
| SELECT COUNT(*) FROM logging
GROUP BY log_action
|
3 years ago |
| SELECT actor_id, actor_name, log_id, log_title, log_page FROM actor,... |
3 years ago |
| SELECT actor_id, actor_name, log_id, log_title, log_page FROM actor,... |
3 years ago |
| SELECT * from logging
WHERE log_actor = '1030942'
AND log_type =... |
3 years ago |
| SELECT * from logging
WHERE log_actor = '1030942'
/*AND log_action ='thanks'*/
|
3 years ago |
| SELECT * from logging
WHERE log_actor = '5575940'
/*AND log_action ='thanks'*/
|
3 years ago |
| SELECT * from logging
WHERE log_user = '5575940'
/*AND log_action ='thanks'*/
|
3 years ago |
| SELECT actor_id, actor_name, log_id, log_title, log_page FROM actor,... |
3 years ago |
| SELECT * from logging
WHERE log_user = '5575940'
/*AND log_action ='thanks'*/
|
3 years ago |
| SELECT * from actor
WHERE log_user = '5575940'
/*AND log_action ='thanks'*/
|
3 years ago |
| SELECT actor_id, actor_name, log_id, log_title, log_page FROM actor,... |
3 years ago |
| SELECT count(*) from actor
WHERE actor_name = 'Adsum1369'
/*AND log_action... |
3 years ago |
| SELECT actor_id, actor_name, log_id, log_title, log_page FROM actor,... |
3 years ago |
| SELECT actor_id, actor_name, log_id, log_title, log_page FROM actor,... |
3 years ago |
| SELECT actor_id, actor_name, log_id, log_title, log_page FROM actor,... |
3 years ago |
| SELECT actor_id, actor_name, log_id, log_title, log_page FROM actor,... |
3 years ago |
| SELECT actor_id, actor_name, log_id, log_title, log_page FROM actor,... |
3 years ago |
| SELECT actor_id, actor_name, log_id, log_title, log_page FROM actor,... |
3 years ago |
| SELECT actor_name, * FROM actor, logging
WHERE actor_id = log_user
LIMIT 500
|
3 years ago |
| SELECT log_action, COUNT(*) FROM logging
/* WHERE log_type = 'thanks'... |
3 years ago |
| SELECT log_action, COUNT(*) FROM logging
WHERE log_type = 'thanks'
GROUP BY... |
3 years ago |
| SELECT log_type, COUNT(*) FROM logging
GROUP BY log_type
|
3 years ago |
| SELECT COUNT(*) FROM logging
GROUP BY log_type
|
3 years ago |
| SELECT COUNT(*) FROM LOGGING
GROUP BY log_type
|
3 years ago |
| select * from logging
LIMIT 100 |
3 years ago |
| select * from loging
LIMIT 100 |
3 years ago |
| USE enwiki_p;
SELECT COUNT(*)
FROM enwiki_p.page
USE eswiki_p;
SELECT... |
3 years ago |
| USE enwiki_p;
SELECT COUNT(*)
FROM enwiki_p.page |
3 years ago |
| USE eswiki_p, enwiki_p;
SELECT COUNT(*)
FROM enwiki_p.page |
3 years ago |
| USE eswiki_p, enwiki_p;
SELECT COUNT(*)
FROM eswiki_p.page |
3 years ago |
| USE eswiki_p, enwiki_p;
SELECT COUNT(*)
FROM page |
3 years ago |
| USE enwiki_p;
SELECT COUNT(*)
FROM enwiki_p.page |
3 years ago |
| USE eswiki_p, enwiki_p;
SELECT COUNT(*)
FROM enwiki_p.page |
3 years ago |
| USE eswiki_p, enwiki_p;
SELECT COUNT(*) AS 'TOTAL'
FROM enwiki_p.page |
3 years ago |
| USE eswiki_p, enwiki_p;
SELECT COUNT(*) AS 'TOTAL'
FROM enwiki_p.page... |
3 years ago |
|
SELECT COUNT(*) AS 'TOTAL'
FROM enwiki_p.page
WHERE
page_is_redirect =... |
3 years ago |
|
SELECT COUNT(*) AS 'TOTAL'
FROM enwiki_p.page
WHERE
page_is_redirect =... |
3 years ago |
| USE eswiki_p;
SELECT COUNT(*) AS 'TOTAL'
FROM enwiki_p.page... |
3 years ago |
| USE eswiki_p;
SELECT COUNT(*) AS 'TOTAL'
FROM eswiki_p.page... |
3 years ago |
| USE eswiki_p;
SELECT COUNT(*) AS 'TOTAL'
FROM page
WHERE
page_is_redirect... |
3 years ago |
| USE eswiki_p;
SELECT COUNT(*) AS 'TOTAL'
FROM page
WHERE
page_is_redirect... |
3 years ago |
| USE eswiki_p;
SELECT COUNT(*) AS 'TOTAL'
FROM page
WHERE
page_is_redirect... |
3 years ago |
| USE eswiki_p
SELECT COUNT(*) AS 'TOTAL'
FROM page
WHERE
page_is_redirect =... |
3 years ago |
| USE eswiki_p;
SELECT COUNT(*) AS 'TOTAL es'
FROM page... |
3 years ago |
| USE eswiki_p;
SELECT COUNT(*) AS 'TOTAL es'
FROM page... |
3 years ago |
| USE eswiki_p;
SELECT COUNT(*) AS 'TOTAL es'
FROM page... |
3 years ago |
| USE eswiki_p;
SELECT COUNT(*) AS 'TOTAL es'
FROM page... |
3 years ago |
| USE eswiki_p;
SELECT COUNT(*) AS 'TOTAL es'
FROM page
WHERE page_is_redirect = '0' |
3 years ago |
| USE eswiki_p;
SELECT COUNT(*) AS 'TOTAL es' FROM page |
3 years ago |
|
SELECT COUNT(*) FROM page |
3 years ago |
| USE eswiki_p
SELECT COUNT(*) FROM page |
3 years ago |
