Destroyed ships stats page broken

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Main > Stats > Destroyed ships (under Pilot statistics or Corp statistics 
sections)

What is the expected output? What do you see instead?

The alliance_detail page will not display queried information for 
corp_kills_class or kills_class Subpage

What version of the product are you using? On what operating system?
r515

Please provide any additional information below.
Reference: 

http://eve-usf.com/killboard/?
a=alliance_detail&all_id=499&view=corp_kills_class

and 

http://eve-usf.com/killboard/?a=alliance_detail&all_id=499&view=kills_class

Original issue reported on code.google.com by zendo...@icqmail.com on 12 Feb 2010 at 4:51

[GoogleCodeExporter]

I suspect the page is actually working, it's just that the db query takes so 
long that 
it times out. On my board I have problems, but purely due to that. I will have 
a look 
at it but I think the outcome may actually be that I disable that function. It 
works 
for small numbers of kills but it quickly becomes expensive to scan the whole 
db 40 
times to work out those numbers.

Original comment by kovellia on 12 Feb 2010 at 9:09

• Changed state: Accepted
• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Issue has been fixed with inner-join revision.

Original comment by zendo...@icqmail.com on 20 Feb 2010 at 4:45

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

There were two problems. The queries can run very, very slowly (or just slowly 
at the 
best of times) which can cause timeouts. In your case the main problem was a 
reuse of a 
table alias when pods were not shown.

I'm marking this as fixed. The slowness issue is part of a more general problem 
that 
some queries are too slow for use on a large killboard. That slowness issue 
still 
exists but will be dealt with as part of the larger problem.

Original comment by kovellia on 21 Feb 2010 at 1:53

• Changed state: Fixed
• Added labels: ****
• Removed labels: ****