[go] wild goose chase

[Chris Mungall]

IC	5167
IDA	71050
IEA	15687382
IEP	4598
IGC	4
IGI	8311
IMP	61549
IPI	17043
ISS	196643
NAS	25656
ND	132192
NR	1185
RCA	103792
TAS	44564

This is the 2007-10 release database

If goose times out you can always try switching mirror from EBI/ 
Berkeley.


On Nov 5, 2007, at 1:14 PM, Seth Carbon wrote:

> I believe that this is the query that you want--since every bit of
> evidence is going to belong to an association, there is no need for a
> join. It also runs fairly quickly (30s):
>
>
> SELECT evidence.code, count(*) AS evidence_count
> FROM evidence
> GROUP BY evidence.code;
>
>
> Cheers,
>
> -Seth
>
>
> On Mon, 2007-11-05 at 12:57 -0800, Sue Rhee wrote:
>> I've been trying to do a couple of SQLs using Goose and it's  
>> timing out.
>> Can someone please run the following SQL for me please?
>>
>> SELECT evidence.code, count(distinct association.id) AS
>> evidence__association_count FROM association, evidence where
>> evidence.association_id = association.id GROUP BY evidence.code
>>
>> Thanks,
>> Sue
>>
>>
>