[04:00:08] <grrrit-wm>	 (PS1) Santhosh: Fix syntax errors in the sql query [analytics/limn-language-data] - https://gerrit.wikimedia.org/r/224220
[04:06:29] <grrrit-wm>	 (PS2) Santhosh: Fix syntax errors in the sql query [analytics/limn-language-data] - https://gerrit.wikimedia.org/r/224220
[04:25:43] <grrrit-wm>	 (CR) KartikMistry: [C: 2] Fix syntax errors in the sql query [analytics/limn-language-data] - https://gerrit.wikimedia.org/r/224220 (owner: Santhosh)
[04:25:48] <grrrit-wm>	 (Merged) jenkins-bot: Fix syntax errors in the sql query [analytics/limn-language-data] - https://gerrit.wikimedia.org/r/224220 (owner: Santhosh)
[08:43:54] <wikibugs>	 Quarry: Add a list/table of popular queries - https://phabricator.wikimedia.org/T71266#1447112 (Edgars2007) @He7d3r can think of some reasons, why also this won't be good (recent ones probably have less page views; if the link to query is on WP:VPT or similar help page just for asking help etc.). But this is...
[09:31:00] <wikibugs>	 Quarry: Add a list/table of popular queries - https://phabricator.wikimedia.org/T71266#1447161 (yuvipanda) We could have a 'featured query' section that is manually curated
[09:36:27] <wikibugs>	 Quarry: Add a list/table of popular queries - https://phabricator.wikimedia.org/T71266#1447176 (Edgars2007) Yeah, that would be nice
[09:45:18] <wikibugs>	 Quarry: Add a list/table of popular queries - https://phabricator.wikimedia.org/T71266#1447192 (eranroz) Other possible metrics for featured queries: * links to queries from externallinks table * most stared queries (manually - similar in some sense to featured query yuvi suggested above)
[09:57:49] <wikibugs>	 Quarry: Add a list/table of popular queries - https://phabricator.wikimedia.org/T71266#1447202 (Edgars2007) >>! In T71266#1447192, @eranroz wrote: > * links to queries from externallinks table  If I put in some Wikipedia link to query like [[quarry:query/896]], this won't be recorded in externallinks table....
[10:07:19] <wikibugs>	 Quarry: Add a list/table of popular queries - https://phabricator.wikimedia.org/T71266#1447207 (eranroz) ``` select iwl_title, count(*) from iwlinks where iwl_prefix ='quarry' group by iwl_title order by count(*) desc limit 5; ``` but unfortunately even in enwiki the most "popular" query have count of 3 :)