[Therion] Generating list of drawers

[Andrew Atkinson]

There are lots of searches, unfortunately in old php, so the websites 
are long gone at

https://therion.speleo.sk/wiki/contrib:databasequery:install

It looks like Searches/Who might have the search you need. But might be 
useful for other things, if the php does not get in the way too much

Andrew

On 06/03/2025 16:49, Eoghan via Therion wrote:
> Hi Benedikt,
> 
> I wrote up this for you as an example.
> 
> SELECT DISTINCT p.NAME, p.SURNAME, SUM(c.LENGTH) OVER(PARTITION BY p.NAME) as sum_len FROM PERSON p JOIN TOPO t ON p.ID = t.PERSON_ID JOIN CENTRELINE c ON c.ID = t.CENTRELINE_ID;
> 
> I hope this get’s you started.
> 
> 
> Eoghan
> 
>> On 20 Feb 2025, at 13:54, Benedikt Hallinger via Therion <therion at speleo.sk> wrote:
>>
>> Hi,
>> before I dig into SQL myself, does by chance somebody already made a
>> script or SQL to generate a list showing: "who has drawn how much length
>> of the surveys".
>>
>> Something along:
>> Person A: 250m
>> Person B:  199m
>> Person C: 80m
>> ...
>>
>>
>> Thank you :)
>> _______________________________________________
>> Therion mailing list
>> Therion at speleo.sk
>> https://mailman.speleo.sk/listinfo/therion
> 
> 
> _______________________________________________
> Therion mailing list
> Therion at speleo.sk
> https://mailman.speleo.sk/listinfo/therion