File:  [Local Repository] / wettbureau-jsf-dynamic / sql / queries.txt
Revision 1.1.1.1 (vendor branch): download - view: text, annotated - select for diffs - revision graph
Fri Apr 9 19:00:56 2021 UTC (17 months, 3 weeks ago) by burroadmin
Branches: MAIN, AllTimeFlashDreamer
CVS tags: start, HEAD


phaseoftournament: incl. phase names
------------------------------------
SELECT pot.id, t.name as tournament, pp.name as previousphase, p.name as phase
FROM phaseoftournament pot
inner join phase pp on pot.previousphase = pp.id
inner join phase p on pot.phase = p.id
inner join tournament t on pot.tournament = t.id
order by pot.id

scoreeventrating: incl. score event method and phase names:
-----------------------------------------------------------
SELECT ser.id, t.name as tournament, ser.eventname, p.name as phase, 
	sem.name as scoreeventmethod, ser.score
FROM scoreeventrating ser
inner join tournament t on ser.tournament = t.id
inner join phaseoftournament pot on ser.phaseoftournament
inner join phase p on pot.phase = p.id
inner join scoreeventmethod sem on ser.scoreeventmethod = sem.id
where pot.id = ser.phaseoftournament
order by ser.id


FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>