1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22:

"SELECT `personen`.`name` AS `lastname`, `personen`.`vorname` AS firstname , 
	YEAR( `personen`.`geburtstag` ) AS `age-group` , 
	`ranglisteergo`.`korpgewicht` AS `weight`, 
	`ranglisteergo`.`korpgrosse` AS `height`, 
	`ranglisteergo`.`zeit` AS `time`,
	`ranglisteergo`.`watt` AS `watt`,
	DATE_FORMAT( `ranglisteergo`.`testdatum` , '%d.%m.%Y' ) AS `testdate`,
	IF (
		`ranglisteergo`.`testort_other` != '', `ranglisteergo`.`testort_other` , `stuetzpunkt`.`name`
	) AS `testcity`,
	`ranglisteergo`.`prel`,
	`ranglisteergo`.`pindex`
	FROM `personen` , `ranglisteergo`, `stuetzpunkt` 
	WHERE 1 
	AND YEAR(`geburtstag`) >= '1988' 
	AND `geburtstag` <= '1989-12-31' 
	AND `personen`.`id` = `ranglisteergo`.`personen` 
	AND `stuetzpunkt`.`id` = `ranglisteergo`.`testort`
	AND `personen`.`geschlecht` =1 
	AND `testdatum` >= '2004-01-01' 
	AND `testdatum` <= '2004-12-31' 
	ORDER BY `pindex` DESC,`prel` DESC"