| SELECT total, total_ve, 100 * total_ve / total AS ve_pct, total_mob, 100 *... |
3 years ago |
| USE cswiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE svwiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE ruwiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE frwiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE cswiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE cawiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE cswiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE cswiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE dewiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE skwiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE cswiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE enwiki_p;
SELECT total, total_ve, 100 * total_ve / total AS ve_pct,... |
4 years ago |
| USE enwiki_p;
SELECT total, total_ve, 100 * total_ve / total, total_mob, 100... |
4 years ago |
| USE cswiki_p;
SELECT total, total_ve, 100 * total_ve / total, total_mob, 100... |
4 years ago |
| USE cswiki_p;
SELECT total, total_ve, 100 * total_ve / total, total_mob, 100... |
4 years ago |
| USE cswiki_p;
SELECT COUNT(*) AS total, SUM(IF(VE.ct_rc_id IS NULL, 0, 1))... |
4 years ago |
| USE cswiki_p;
SELECT * FROM user_groups;
/*
SELECT COUNT(*) AS total,... |
4 years ago |
| USE cswiki_p;
SELECT COUNT(*) AS total, SUM(IF(VE.ct_rc_id IS NULL, 0, 1))... |
4 years ago |
| USE cswiki_p;
SELECT COUNT(*) AS total, SUM(IF(VE.ct_rc_id IS NULL, 0, 1))... |
4 years ago |
| USE cswiki_p;
SELECT COUNT(*) AS total, SUM(IF(VE.ct_rc_id IS NULL, 0, 1))... |
4 years ago |
| USE cswiki_p;
SELECT * FROM change_tag_def;
/*
SELECT * FROM... |
4 years ago |
| blank query |
4 years ago |
| USE cswiki_p;
SELECT pl_from, pl_title, other.page_title FROM pagelinks
LEFT... |
4 years ago |
| USE cswiki_p;
SELECT pl_from, pl_title FROM pagelinks
LEFT JOIN page AS... |
4 years ago |
| USE cswiki_p;
SELECT pl_from, missing.page_title FROM pagelinks
LEFT JOIN... |
4 years ago |
| USE cswiki_p;
SELECT pl_from, missing.page_title FROM pagelinks
LEFT JOIN... |
4 years ago |
| blank query |
4 years ago |
| /*
USE wikidatawiki_p;
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE cswiki_p;
SELECT page_title, pp_value, term_text
FROM page
JOIN... |
4 years ago |
| USE cswiki_p;
SELECT page_title, pp_value#, term_text
FROM page
JOIN... |
4 years ago |
| USE cswiki_p;
SELECT page_title, pp_value, term_text FROM page
JOIN... |
4 years ago |
| USE cswiki_p;
SELECT page_title, pp_value, term_text FROM page
JOIN... |
4 years ago |
| USE cswiki_p;
SELECT * FROM page
JOIN page_props ON pp_page = page_id AND... |
4 years ago |
| USE cswiki_p;
SELECT * FROM page
JOIN page_props ON pp_page = page_id AND... |
4 years ago |
| USE cswiki_p;
SELECT * FROM page
JOIN pageprops ON pp_page = page_id AND... |
4 years ago |
| USE cswiki_p;
SELECT * FROM page WHERE page_namespace = 0 AND page_title... |
4 years ago |
| /*
USE wikidatawiki_p;
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| /*
USE wikidatawiki_p;
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| /*
USE wikidatawiki_p;
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
SELECT term_text, GROUP_CONCAT(page_title) FROM... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbt_item_terms LIMIT 10;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
SHOW TABLES LIKE 'wb%'; |
4 years ago |
| blank query |
4 years ago |
| USE wikidatawiki_p;
SELECT actor_name, COUNT(*) AS amount,... |
4 years ago |
| USE wikidatawiki_p;
SELECT actor_name, COUNT(*) AS amount,... |
4 years ago |
| USE cswiki_p;
SELECT years.page_title AS year, people.page_title AS person,... |
4 years ago |
| USE cswiki_p;
SELECT years.page_title AS year, people.page_title AS person,... |
4 years ago |
| USE cswiki_p;
SELECT years.page_title AS year, people.page_title AS... |
4 years ago |
| USE cswiki_p;
SELECT years.page_title AS year, people.page_title AS... |
4 years ago |
| USE cswiki_p;
SELECT years.page_title AS year, people.page_title AS... |
4 years ago |
| USE cswiki_p;
SELECT years.page_title AS year, people.page_title AS... |
4 years ago |
| blank query |
4 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
4 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
5 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
5 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
5 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
7 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*)
FROM (SELECT * FROM logging... |
8 years ago |
| USE cswiki_p;
/*SELECT log_user_text, COUNT(*)
FROM logging
JOIN (SELECT *... |
8 years ago |
| USE cswiki_p;
/*SELECT log_user_text, COUNT(*)
FROM logging
JOIN (SELECT *... |
8 years ago |
| USE cswiki_p;
/*SELECT log_user_text, COUNT(*)
FROM logging
JOIN (SELECT *... |
8 years ago |
| USE cswiki_p;
/*SELECT log_user_text, COUNT(*)
FROM logging
JOIN (SELECT *... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, COUNT(*), CURRENT_TIMESTAMP()
FROM... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title),... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_user_text, count(log_title)
FROM logging
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT log_id, log_user_text, log_namespace, log_title,... |
8 years ago |
| USE cswiki_p;
SELECT log_id, log_timestamp, log_user_text, log_namespace,... |
8 years ago |
| USE cswiki_p;
SELECT * FROM logging
JOIN revision ON rev_page = log_page AND... |
8 years ago |
| USE cswiki_p;
SELECT * FROM logging
JOIN revision ON rev_page = log_page /*... |
8 years ago |
| USE cswiki_p;
SELECT * FROM logging
JOIN revision ON rev_page = log_page AND... |
8 years ago |
| USE cswiki_p;/*
SELECT * FROM logging
JOIN revision ON rev_page = log_page... |
8 years ago |
| USE cswiki_p;
SELECT * FROM logging
JOIN revision ON rev_page = page_id AND... |
8 years ago |
| USE cswiki_p;
/*SELECT * FROM logging
JOIN revision ON rev_page = page_id... |
8 years ago |
| USE cswiki_p;
/*SELECT * FROM logging
JOIN page ON page_id = log_page
JOIN... |
8 years ago |
| USE cswiki_p;
SELECT * FROM logging
WHERE log_type = "patrol"
ORDER BY... |
8 years ago |
| USE cswiki_p;
SELECT * FROM logging
ORDER BY log_timestamp DESC
LIMIT 100; |
8 years ago |
| USE cswiki_p;
SELECT * FROM logging ORDER BY log_timestamp DESC LIMIT 1; |
8 years ago |
| USE cswiki_p;
SELECT * FROM logging LIMIT 1 ORDER BY log_timestamp DESC; |
8 years ago |
| USE cswiki_p;
DESCRIBE logging; |
8 years ago |
| USE cswiki_p;
DESCRIBE logging; |
8 years ago |
| USE cswiki_p;
SHOW TABLES; |
8 years ago |
