CM2002 - ShowUserStatus    v1.0, 29-May-2002 © Ph. Noth

Back to main menu

---

No forecasts yet for:

SELECT UserKey, UserName, Name, Surname FROM TempUsers WHERE CM2002Game = 'pf' AND Userkey NOT IN (SELECT DISTINCT Userkey FROM CM2002Forecasts) ORDER BY UserName

query
	EMAIL	NAME	SURNAME	USERKEY	USERNAME
1	bosshardd@post.ch	Bosshard	Daniela	43	bosshardd

Records:1

Forecasts found for:

SELECT UserKey, UserName, Name, Surname FROM TempUsers WHERE CM2002Game = 'pf' AND Userkey IN (SELECT DISTINCT Userkey FROM CM2002Forecasts) ORDER BY UserName

query
	EMAIL	NAME	SURNAME	USERKEY	USERNAME
1	buehlmannre@post.ch	Bühlmann	Reto	42	buehlmannre
2	frauenfeldef@post.ch	Frauenfelder	Félix	46	frauenfeldef
3	giovannaccim@post.ch	Giovannacci	Michele	45	giovannaccim
4	haelgg@post.ch	Haelg	Guido	6	haelgg
5	info@hillenberg.ch	Hillenberg	Peter	39	hillenbergp
6	jovera@post.ch	Jover	Antoine	41	jovera
7	lstoeckli@i-s-e.com	Stoeckli	Laurent	44	lstoeckli
8	mussella@post.ch	Mussell	Andrew	40	mussella
9	nothp@post.ch	Noth	Philippe	2	pnoth
10	rossi@post.ch	Ross	Ian	38	rossi
11	vuillec@post.ch	Vuille	Charles-Henri	35	vuillec
12	wysscl@post.ch	Wyss	Claudia	37	wysscl
13	zuendm@post.ch	Zuend	Matthias	36	zuendm

Records:13

---

Back to main menu