Vakka Tour 2020 CTP-kisa

Tourin pistetilanne.

CTP-kisan pistetilanne:

Tourin CTP palkintokertymä on 113 € ja jaetaan kahdelle eniten pisteitä keränneelle seuravast: 1. 79 € ja 2. 34 €

WordPressin tietokantavirhe: [Column 'hole' in field list is ambiguous]
SELECT c.userID, userName, name,hole,result, points,Pisteet, resCount FROM `CTP` as c join CTPkisat as ck on c.compid = ck.compid and points > 0 join (SELECT userid, sum(points) as Pisteet, count(*) as resCount FROM `CTP` where status = 'New' and points > 0 group by userid having Pisteet > 0) as cp on cp.userid = c.userid order by Pisteet desc,c.userid, date desc

SijoitusNimiKisaVäyläTulosPisteetTotal