Query Run
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT Distinct a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT a.actor_name AS username, b.babel_lang as language_used,... 11 months ago
SELECT a.actor_name username, b.babel_lang as language_used, b.babel_level... 11 months ago
SELECT a.actor_name username, b.babel_lang as language_used, b.babel_level... 11 months ago
SELECT a.actor_name username, b.babel_lang as language_used, b.babel_level... 11 months ago
SELECT a.actor_name username, b.babel_lang as language_used, b.babel_level... 11 months ago
SELECT a.actor_name username, b.babel_lang as language_used, b.babel_level... 11 months ago
SELECT a.actor_name username, b.babel_language as language_used,... 11 months ago
SELECT a.actor_user username, b.babel_user as babel_user FROM actor a JOIN... 11 months ago
SELECT COUNT(DISTINCT a.actor_user) FROM actor a JOIN babel b ON... 11 months ago
SELECT COUNT(DISTINCT a.actor_user) FROM actor a JOIN babel b ON... 11 months ago
SELECT COUNT(DISTINCT b.babel_user) AS has_babel_count FROM actor LEFT... 11 months ago
SELECT COUNT(DISTINCT r.rev_actor) AS distinct_user_count, COUNT(DISTINCT... 11 months ago
SELECT COUNT(DISTINCT r.rev_actor) AS distinct_user_count, COUNT(DISTINCT... 11 months ago
SELECT COUNT(DISTINCT r.rev_actor) AS distinct_user_count, COUNT(DISTINCT... 11 months ago
SELECT COUNT(DISTINCT r.rev_actor) AS distinct_user_count, COUNT(DISTINCT... 1 year ago
SELECT COUNT(DISTINCT r.rev_actor) AS... 1 year ago
SELECT DISTINCT r.rev_actor AS userid, a.actor_name AS username FROM... 1 year ago
SELECT* FROM change_tag_def 1 year ago
SELECT* FROM change_tag_def WHERE ctd_name = 'contenttranslation'; 1 year ago
DESC change_tag_def; 1 year ago
SELECT * FROM change_tag_def WHERE ctd_name = 'contenttranslation'; 1 year ago
SELECT DISTINCT r.rev_actor AS userid, a.actor_name AS username FROM... 1 year ago
SHOW TABLES; 1 year ago
SELECT COUNT(DISTINCT actor_name) FROM actor a JOIN babel b ON a.actor_user... 1 year ago
SELECT actor_name, babel_lang, babel_level FROM actor a JOIN babel b ON... 1 year ago
SELECT actor_name, babel_lang, babel_level FROM actor a JOIN babel b ON... 1 year ago
SELECT actor_name, babel_lang, babel_level FROM actor a JOIN babel b ON... 1 year ago
SELECT actor_name, babel_lang, babel_level FROM actor a JOIN babel b ON... 1 year ago
SELECT actor_name, babel_lang, babel_level FROM actor a JOIN babel b ON... 1 year ago
SELECT actor_name, babel_lang, babel_level FROM actor a JOIN babel b ON... 1 year ago
SELECT actor_name, babel_lang, babel_level FROM actor a JOIN babel b ON... 1 year ago
desc actor; 1 year ago
SELECT actor_name, babel_lang, babel_level FROM actor a JOIN babel b ON... 1 year ago
SELECT actor_name, babel_lang, babel_level FROM actor a JOIN babel b ON... 1 year ago
SELECT user_name FROM user WHERE user_id = "12020623" 1 year ago
desc user; 1 year ago
desc revision; 1 year ago
SELECT COUNT(r.rev_page) AS translation_count FROM revision r JOIN... 1 year ago
SELECT COUNT(r.rev_page) AS translation_count FROM revision r JOIN... 1 year ago
WITH babel_translations AS ( SELECT DISTINCT r.rev_page, r.rev_actor ... 1 year ago
WITH babel_translators AS ( SELECT DISTINCT r.rev_actor FROM... 1 year ago
SELECT COUNT(r.rev_page) AS translation_count FROM revision r JOIN... 1 year ago
SELECT COUNT(DISTINCT r.rev_page) AS translation_count, ... 1 year ago
SELECT COUNT(DISTINCT r.rev_actor) AS num_translators FROM revision r JOIN... 1 year ago
SELECT COUNT(DISTINCT r.rev_actor) AS num_translators FROM revision r JOIN... 1 year ago
SELECT COUNT(DISTINCT r.rev_actor) AS num_translators FROM revision r JOIN... 1 year ago
SELECT gt.gt_country AS country, COUNT(*) AS translator_count FROM geo_tags... 1 year ago
desc change_tag; 1 year ago
show tables; 1 year ago
desc geo_tags; 1 year ago
desc geo_tags; 1 year ago
desc geo_tags; 1 year ago
desc geo_tags; 1 year ago
desc geo_tags; 1 year ago
desc geo_tags; 1 year ago
desc geo_tags; 1 year ago
desc geo_tags; 1 year ago
show table; 1 year ago
show table; 1 year ago
show table; 1 year ago
show tables; 1 year ago
SELECT gt_country, COUNT(DISTINCT ct_rev_id) AS translator_count FROM... 1 year ago
SELECT gt_country, COUNT(DISTINCT ct_rev_id) AS translator_count FROM... 1 year ago