[19:21:51] <reosarevok>	 nikki: I have a query that someone at WMEE made that times out whenever you try to add labels even with the old select ... with trick, even with limit 10 :/
[19:22:16] <reosarevok>	 https://www.irccloud.com/pastebin/pQZD1U8S/
[19:22:29] <reosarevok>	 Is it because of the datetime filters you think?
[19:26:02] <nikki>	 reosarevok: "Error fetching paste" :/
[19:26:17] <reosarevok>	 Huh, irccloud paste keeps doing this
[19:26:35] <reosarevok>	 https://pastebin.com/T0wsV7wD
[21:32:52] <nikki>	 reosarevok: oh, oops, sorry, got distracted. firstly, do you know you can use the chain symbol above the run button to get a short url for the query? :)
[21:34:26] <nikki>	 the biggest problem with the query is that %items returns ?person ?born ?died and ?sitelinks, and then you look for optional labels for ?item... which means you're telling it to find all estonian labels in the entire database
[21:35:47] <nikki>	 and a smaller problem with trying to use limit 10 like that is that you left in the order by, so it still has to fetch all the results in order to sort them and only return the first 10
[21:36:08] <nikki>	 anyway replacing ?item with ?person gives me 26.5k results in 44 seconds
[21:36:27] <nikki>	 (oh and I commented out the limit and order by it seems)