search

thepercival / fctoernooi

app om (voetbal) toernooien ( schema' s, wedstrijden, standen ) makkelijk mee te beheren
0 stars 0 forks source link

rondenumbers zonder rondes #41

Closed thepercival closed 4 years ago

thepercival commented 5 years ago

select rn. from roundnumbers rn where not exists ( select from rounds where rounds.numberid = rn.id ) and not exists ( select * from roundnumbers rnsub where rnsub.previousid = rn.id) order by rn.competitionid;

delete from roundnumbers where not exists ( select from rounds where rounds.numberid = roundnumbers.id ) and not exists ( select from roundnumbers rnsub where rnsub.previousid = roundnumbers.id);

dit zou niet mogen voorkomen

thepercival commented 5 years ago

werkt in de nieuwe code, sluiten wanneer naar volgende update!

thepercival commented 4 years ago

fixed