[00:04:55] <wm-bb_>	 [telegram] <silente08> If I’m not mistaken, the usual breakpoints for such responsive behaviours in Wikimedia projects are 720px and 1040px
[11:40:02] <wm-bb_>	 [telegram] <partkerben> https://t.me/joinchat/AAAAAFI2Sqc3y9LGZmBR9A
[12:55:55] <wm-bb_>	 [telegram] <amire80> Thanks, but I'm failing to get the actual syntax :(
[12:55:55] <wm-bb_>	 [telegram] <amire80> I basically want to combine these two:
[12:55:57] <wm-bb_>	 [telegram] <amire80> 1. https://quarry.wmflabs.org/query/50065
[12:55:58] <wm-bb_>	 [telegram] <amire80> 2. https://quarry.wmflabs.org/query/50040 (re @Thecladis: Just use case or if in the select clause inside count instead of filtering in where clause)
[13:20:19] <wm-bb_>	 [telegram] <lucaswerkmeister> something like this, I think? https://quarry.wmflabs.org/query/50068 (re @amire80: Thanks, but I'm failing to get the actual syntax :(
[13:20:19] <wm-bb_>	 [telegram] <lucaswerkmeister> I basically want to combine these two:
[13:20:21] <wm-bb_>	 [telegram] <lucaswerkmeister> 1. https://quarry.wmflabs.org/query/50065
[13:20:22] <wm-bb_>	 [telegram] <lucaswerkmeister> 2. https://quarry.wmflabs.org/query/50040)
[13:21:19] <wm-bb_>	 [telegram] <lucaswerkmeister> (maybe sum(if(ct_rev_id is not null, 1, 0)) would be clearer but sum(ct_rev_id is not null) is shorter ^^)
[15:31:46] <wm-bb_>	 [telegram] <amire80> Looks right! Thank you! (re @lucaswerkmeister: something like this, I think? https://quarry.wmflabs.org/query/50068)
[15:32:46] <wm-bb_>	 [telegram] <amire80> I was never good with JOINs. The "left" keyword confuses me terribly. It's so meaningless. "Left" is just a relative side.
[17:55:43] <Reedy>	 I guess it's from the table names relative in the query
[17:55:56] <Reedy>	 left, all the rows from the table in the from
[17:56:03] <Reedy>	 right, all those from the join
[18:30:23] <wm-bb_>	 [telegram] <Yetkin> On enwiki, when you edit a page, a "wiki markup" section appears under the editor. trwiki used to have this as well. How to restore that feature?
[21:37:23] <wm-bb_>	 [telegram] <Thecladis> Indeed, you are basically just putting two tables next to each other. Some visual perception helps :) (re @wmtelegram_bot: [irc] <Reedy> I guess it's from the table names relative in the query)
[21:50:22] <wm-bb_>	 [telegram] <amire80> Yeah, but why is one "left" and the other "right"? It's arbitrary.
[21:52:49] <wm-bb_>	 [telegram] <amire80> I'm on the phone now, but maybe you're talking about MediaWiki:Edittools , which can be edited by administrators. Does this help? (re @Yetkin: On enwiki, when you edit a page, a "wiki markup" section appears under the editor. trwiki used to have this as well. How to restore that feature?)
[21:54:52] <Reedy>	 It's not arbitary
[21:55:00] <Reedy>	 It's LTR specific ;P
[21:55:13] <Reedy>	 SELECT * FROM foo LEFT JOIN bar on ()
[21:55:19] <Reedy>	 foo is on the LEFT
[21:55:21] <Reedy>	 bar is on the right
[21:55:39] <Reedy>	 I mean, it's same as the naming for many things
[21:55:45] <Reedy>	 It would've made sense to someone at some point