ATMED=select * from temp,oly_pers where (temp.persnum = oly_pers.persnum) order by punkte desc
PWINS=#
TEMPMED=#
NATMED=#
CREPERSNUM=#
YEARMED=#
JARSPA=#
JARERG=#
NVINDEX=CREATE INDEX NAMEVORNAME ON TEMP ( NAME,VORNAME)
DISGRAPH=select * from [oly_weka] where (disziplin = '%1') and (rang = 1) order by JAHR ascending
JARDISERG=select * from [oly_weka] where (jahr = %1) and (disziplin = '%2') and (geschlecht = '%3') order by rang ascending
NATPKT=select * from temp,[oky_land] as oky_land where (temp.land = oky_land.land) and (temp.punkte > 0) order by punkte desc
YEARWETT=select * from [oly_weka] where (jahr = %1)
JARDIS=select distinct disziplin,BEZEICH from [oly_weka],[oky_dis] where (oly_weka.disziplin = oky_dis.disziplin) and (oly_weka.sportart = '%2') and (oly_weka.jahr = %1) order by bezeich
GETWEKAPERS=select * from [oly_mann],[oly_pers] where (wekanum = %1) and (oly_mann.persnum = oly_pers.persnum)
WEKADIS=select * from [oly_weka] where (disziplin = '%1') order by jahr descending,geschlecht descending,rang ascending
WEKADIS2=select * from [oly_weka] where (disziplin = '%1') and (jahr = %2) order by geschlecht descending,rang ascending
WEKADISLAND=select * from [oly_weka] where (jahr = %1) and (land = '%2') order by jahr descending, rang ascending
WEKAPERS=select * from [oly_weka] %1
QUIZQUEST=select * from [oly_quiz] where (wert = '%1') and (typ = 'F')
QUIZNUMBER=select * from [oly_quiz] where (nummer = %1)
TAGESV=select * from [oly_dis],[oky_dis],[oky_sa] where (jahr = %1) and (wekatag = %2) and (oly_dis.disziplin = oky_dis.disziplin) and (oly_dis.sportart = oky_sa.sportart) order by sportart,disziplin