[20:08:32] <wm-bridgebot>	 [telegram] <chicocvenancio> Does anyone currently have the SQL-fu to get both users that have identified their gender in mediawiki and those that have no set preference?
[20:08:33] <wm-bridgebot>	 [telegram] <chicocvenancio> I had one from years ago, but I can't find it and maybe the schema has changed, so I'm not sure it is worth it to try and search for it. My current query only get those with the preferences set.
[20:08:34] <wm-bridgebot>	 [telegram] <chicocvenancio> https://quarry.wmflabs.org/query/41722 this is my current query
[20:08:36] <wm-bridgebot>	 [telegram] <chicocvenancio> it shows among the 100 most prolific editors who set a gender in their preference only 6 set their gender as female in ptwiki
[20:08:37] <wm-bridgebot>	 [telegram] <chicocvenancio> this holds the same for the top 1000 with 62 choosing female
[20:08:38] <wm-bridgebot>	 [telegram] <chicocvenancio> but that query only shows the users who chose a gender, I'm looking to include those that have no set preference as well
[20:17:14] <wm-bridgebot>	 [telegram] <chicocvenancio> Does anyone currently have the SQL-fu to get both users that have identified their gender in mediawiki and those that have no set preference?
[20:17:18] <wm-bridgebot>	 [telegram] <chicocvenancio> I had one from years ago, but I can't find it and maybe the schema has changed, so I'm not sure it is worth it to try and search for it. My current query only get those with the preferences set.
[20:17:18] <wm-bridgebot>	 [telegram] <chicocvenancio> https://quarry.wmflabs.org/query/41722 this is my current query
[20:17:21] <wm-bridgebot>	 [telegram] <chicocvenancio> it shows among the 100 most prolific editors who set a gender in their preference only 6 set their gender as female in ptwiki
[20:17:23] <wm-bridgebot>	 [telegram] <chicocvenancio> this holds the same for the top 1000 with 62 choosing female
[20:17:26] <wm-bridgebot>	 [telegram] <chicocvenancio> but that query only shows the users who chose a gender, I'm looking to include those that have no set preference as well
[20:17:28] <wm-bridgebot>	 [telegram] <chicocvenancio> done at https://quarry.wmflabs.org/query/41741
[20:17:46] <wm-bridgebot>	 [telegram] <chicocvenancio> Does anyone currently have the SQL-fu to get both users that have identified their gender in mediawiki and those that have no set preference?
[20:17:47] <wm-bridgebot>	 [telegram] <chicocvenancio> I had one from years ago, but I can't find it and maybe the schema has changed, so I'm not sure it is worth it to try and search for it. My current query only get those with the preferences set.
[20:17:48] <wm-bridgebot>	 [telegram] <chicocvenancio> https://quarry.wmflabs.org/query/41722 this is my current query
[20:17:49] <wm-bridgebot>	 [telegram] <chicocvenancio> it shows among the 100 most prolific editors who set a gender in their preference only 6 set their gender as female in ptwiki
[20:17:51] <wm-bridgebot>	 [telegram] <chicocvenancio> this holds the same for the top 1000 with 62 choosing female
[20:17:52] <wm-bridgebot>	 [telegram] <chicocvenancio> but that query only shows the users who chose a gender, I'm looking to include those that have no set preference as well
[20:17:55] <wm-bridgebot>	 [telegram] <chicocvenancio> ☑️done at https://quarry.wmflabs.org/query/41741