[08:49:35] <Worf>	 I'm trying to install Semantic Mediawiki but i fail to get it working. To be precise: the step "Verify annotation usage" ( http://semantic-mediawiki.org/wiki/Help:Testing ) fails. Any Ideas?
[09:30:59] <magioladitis>	 Can I get a list of pages with 0 length?
[09:31:41] <magioladitis>	 We get a lot of complains of people who blank pages while editing via AWB
[09:31:55] <magioladitis>	 and a suggestion is to add a check in the code
[09:32:23] <magioladitis>	 We could add to LoadSuccessApi in Main
[09:32:35] <magioladitis>	 but I need to know if there are many page already blank
[09:32:38] <magioladitis>	 for some reason
[09:33:34] <valhallasw`cloud>	 magioladitis: SELECT * FROM revision WHERE rev_len=0; or something like that
[09:34:09] <magioladitis>	 valhallasw`cloud: thanks
[09:34:52] <magioladitis>	 valhallasw`cloud: hm... this will require I download the full dump from the server?
[09:35:00] <magioladitis>	 I hope not
[09:35:07] <valhallasw`cloud>	 no, should be possible on tool labs
[09:36:02] <magioladitis>	 OK then I ll try it
[09:36:14] <valhallasw`cloud>	 ...there was a web tool for this, but I can't find it
[09:36:45] <valhallasw`cloud>	 ah there we go
[09:36:46] <valhallasw`cloud>	 http://quarry.wmflabs.org/
[09:37:25] <magioladitis>	 Great! thanks!
[09:38:27] <valhallasw`cloud>	 magioladitis: http://quarry.wmflabs.org/query/385
[09:39:13] <magioladitis>	 :)
[09:39:35] <magioladitis>	 I bet it's going to take a while
[09:39:53] <valhallasw`cloud>	 yeah, might not be the most efficient query ever :-p
[09:39:58] <valhallasw`cloud>	 oh, there we are
[09:43:24] <magioladitis>	 valhallasw`cloud: it show a lot of deleted pages
[09:44:06] <valhallasw`cloud>	 magioladitis: no, it doesn't. Just a lot of non-main namespace pages
[09:44:27] <valhallasw`cloud>	 re-running for just namespace 0...
[09:44:51] <magioladitis>	 I get also
[09:44:52] <magioladitis>	 68811	2	Q		81	0	0	0.16660315093268
[09:45:04] <magioladitis>	 Q seems fine
[09:45:23] <magioladitis>	 70899	2	Sgall		14	0	1	0.15179363931696302	
[09:45:31] <valhallasw`cloud>	 magioladitis: namespace *2*
[09:45:35] <magioladitis>	 Sgall does not exist and never existed
[09:46:03] <valhallasw`cloud>	 which is User
[09:46:06] <magioladitis>	 aha
[09:46:08] <magioladitis>	 my mistake then
[09:50:10] <valhallasw`cloud>	 magioladitis: the version that filters on NS 0 is now running, but it's probably slower :-p
[09:50:29] <magioladitis>	 checking from the version you sent me I see no pages in NS 0
[09:50:32] <magioladitis>	 and 60 in NS 1