[13:24:06] <wm-bb_>	 [telegram] <amire80> A question for people who know SQL (I know SQL not so well): I've just made this query: https://quarry.wmflabs.org/query/50040 . It is suppose to show how many mobile revisions were made per day in the Hebrew Wikipedia.
[13:24:07] <wm-bb_>	 [telegram] <amire80> Is it possible to show three columns: day, mobile revisions, and total revisions, which would show the total number of revisions on that day, and to do it in one query? One column is supposed to be filtered with two more where conditions, and there other is only filtered by timestamp. I don't know how to do it in one query, or if it's even possible.
[14:54:36] <wm-bb_>	 [telegram] <Thecladis> Yes, it is
[14:55:34] <wm-bb_>	 [telegram] <Thecladis> Just use case or if in the select clause inside count instead of filtering in where clause
[14:56:02] <wm-bb_>	 [telegram] <Thecladis> For mobile, and no filtering/no conditions for the rest
[17:26:07] <wm-bb_>	 [telegram] <Yetkin> Anyone that worked with TemplateStyles before?
[17:33:38] <wm-bb_>	 [telegram] <Thecladis> Better ask your question :)
[17:36:30] <wm-bb_>	 [telegram] <Yetkin> Created this but as far as I can see, it does not function
[17:36:41] <wm-bb_>	 [telegram] <Yetkin> https://tr.wikipedia.org/wiki/%C5%9Eablon:T%C3%BCrkiye_haritas%C4%B1-TOC/styles.css
[17:38:26] <wm-bb_>	 [telegram] <jhsoby> As far as I can tell, it's not included in the main template (re @Yetkin: Created this but as far as I can see, it does not function)
[17:40:12] <wm-bb_>	 [telegram] <jhsoby> <templatestyles src="Türkiye haritası-TOC/styles.css" />
[17:40:55] <wm-bb_>	 [telegram] <Yetkin> added, same result
[17:45:45] <wm-bb_>	 [telegram] <jhsoby> Yetkin It's working
[17:46:24] <wm-bb_>	 [telegram] <jhsoby> What that code does is to hide it only if the window (the entire window) is less than 300px wide. In this context, 300px is very little. I am not even able to resize my browser window to be that small
[17:47:27] <wm-bb_>	 [telegram] <jhsoby> So to check that it works, I had to inspect element and change 300px to something bigger like 600px, and then I can verify that it does work as it should. It's just that the 300px threshold is very small
[17:48:21] <wm-bb_>	 [telegram] <jhsoby> For reference, the Wikipedia logo is something like 165px wide, so if you resize the browser window and there's still room for one more logo next to the one you can see, that's already bigger than 300px
[18:05:10] <wm-bb_>	 [telegram] <Yetkin> Yes, I can see it works now. Thanks 😊 (re @jhsoby: For reference, the Wikipedia logo is something like 165px wide, so if you resize the browser window and there's still room for one more logo next to the one you can see, that's already bigger than 300px)