Chamer Stadtlauf am 30.06.2013

ASV Cham

VA-Nummer: 400999913536

VE-Nummer: 3206

Beginn: 08:45


Kreismeisterschaft


Liebe Läufer,

liebe Teilnehmer am Chamer Stadtlauf,

die Zieleinläufe sind mit unseren Backupsystem ausgewertet.

Die Ergebnislisten stehen zum Abruf bereit.

Einige Teilnehmer sind aber nicht gewertet worden da sie im verkehrten Lauf gestartet oder eine andere Strecke gelaufen sind.

 

Alfred Lippert

Sportprogramme

 

 

Hier gibt es Bilder vom Zieleinlauf

 


Ausschreibung des Veranstalters

Sie müssen sich im Laufportal anmelden, damit Sie die Listen und Urkunden einsehen bzw. ausdrucken können!

(default) 55 queries took 36 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`771
2DESCRIBE `acos`770
3DESCRIBE `aros_acos`770
4DESCRIBE `events`39391
5DESCRIBE `clubs`15151
6DESCRIBE `users`23231
7DESCRIBE `groups`440
8DESCRIBE `regis`29291
9DESCRIBE `agegroups`17171
10DESCRIBE `heats`17171
11DESCRIBE `charges`770
12DESCRIBE `discis`881
13DESCRIBE `teams`10101
14DESCRIBE `agegroups_teams`221
15DESCRIBE `relays`771
16DESCRIBE `splittimes`661
17DESCRIBE `scores`14141
18DESCRIBE `assocs`551
19DESCRIBE `assocs_clubs`220
20DESCRIBE `assocs_users`220
21DESCRIBE `geocodes`16161
22DESCRIBE `series`880
23DESCRIBE `sheets`15151
24DESCRIBE `certificates`13131
25DESCRIBE `certificatelines`16161
26DESCRIBE `eventreports`46461
27DESCRIBE `ecats`220
28DESCRIBE `announces`88881
29DESCRIBE `conflicts`880
30DESCRIBE `ecats_announces`220
31DESCRIBE `ecats_events`220
32DESCRIBE `erights`220
33DESCRIBE `erights_events`220
34DESCRIBE `settings`10101
35SELECT `Setting`.`id`, `Setting`.`announce_email`, `Setting`.`announce_admonition`, `Setting`.`bcc_email`, `Setting`.`disclaimer`, `Setting`.`terms`, `Setting`.`pay_info`, `Setting`.`news`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1110
36DESCRIBE `banners`991
37SELECT `Banner`.`id`, `Banner`.`filename`, `Banner`.`type`, `Banner`.`size`, `Banner`.`url`, `Banner`.`view`, `Banner`.`pos`, `Banner`.`created`, `Banner`.`modified` FROM `banners` AS `Banner` WHERE `Banner`.`view` = 'events' 440
38select count(*) from users, clubs, regis, agegroups, discis, heats, events where clubs.id = users.club_id and users.id = regis.user_id and regis.agegroup_id = agegroups.id and discis.agegroup_id = agegroups.id and agegroups.heat_id = heats.id and events.id = heats.event_id and events.id = 270116
39select count(*) from users, clubs, regis, agegroups, discis, heats, events where clubs.id = users.club_id and users.id = regis.user_id and regis.agegroup_id = agegroups.id and (regis.millsek > 0 or regis.millsekn > 0) and discis.agegroup_id = agegroups.id and agegroups.heat_id = heats.id and events.id = heats.event_id and events.id = 270114
40SELECT `Event`.`id`, `Event`.`number`, `Event`.`name`, `Event`.`event_date`, `Event`.`notes`, `Event`.`start`, `Event`.`club_id`, `Event`.`email`, `Event`.`quicklink`, `Event`.`downloadlink`, `Event`.`uploadlink`, `Event`.`geocode_id`, `Event`.`kmllink`, `Event`.`profile`, `Event`.`regi_cutoff`, `Event`.`payment_method`, `Event`.`cnt_st`, `Event`.`mode_time_display`, `Event`.`mode_place`, `Event`.`user_id`, `Event`.`serie_id`, `Event`.`permit`, `Event`.`kind`, `Event`.`range_kind`, `Event`.`catogory`, `Event`.`vermessprotdate`, `Event`.`county`, `Event`.`region`, `Event`.`championshipname`, `Event`.`picturelink`, `Event`.`tag`, `Event`.`blvlogo`, `Event`.`timemode`, `Event`.`seriecaption`, `Event`.`cutofftxt`, `Event`.`regiinfotxt`, `Event`.`dress_size`, `Event`.`created`, `Event`.`modified`, `Club`.`id`, `Club`.`name`, `Club`.`street`, `Club`.`zipcode`, `Club`.`place`, `Club`.`phone`, `Club`.`fax`, `Club`.`email_address`, `Club`.`homepage`, `Club`.`created`, `Club`.`modified`, `Club`.`clubnr`, `Club`.`filename`, `Club`.`type`, `Club`.`size`, `Geocode`.`id`, `Geocode`.`key`, `Geocode`.`lng`, `Geocode`.`lat`, `Geocode`.`address1`, `Geocode`.`address2`, `Geocode`.`address3`, `Geocode`.`address4`, `Geocode`.`town`, `Geocode`.`county`, `Geocode`.`region`, `Geocode`.`postcode`, `Geocode`.`country`, `Geocode`.`provider`, `Geocode`.`modified`, `Geocode`.`created`, `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`sex`, `User`.`year`, `User`.`street`, `User`.`zipcode`, `User`.`place`, `User`.`phone`, `User`.`fax`, `User`.`email_address`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`club_id`, `User`.`startpass_no`, `User`.`startpass_no_btv`, `User`.`dress_size`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`lastlogin`, `User`.`hidename`, `Serie`.`id`, `Serie`.`name`, `Serie`.`mode`, `Serie`.`min_cnt_regis`, `Serie`.`max_cnt_regis`, `Serie`.`points_per_place`, `Serie`.`created`, `Serie`.`modified` FROM `events` AS `Event` LEFT JOIN `clubs` AS `Club` ON (`Event`.`club_id` = `Club`.`id`) LEFT JOIN `geocodes` AS `Geocode` ON (`Event`.`geocode_id` = `Geocode`.`id`) LEFT JOIN `users` AS `User` ON (`Event`.`user_id` = `User`.`id`) LEFT JOIN `series` AS `Serie` ON (`Event`.`serie_id` = `Serie`.`id`) WHERE `Event`.`id` = 270 LIMIT 1111
41SELECT `Heat`.`id`, `Heat`.`event_id`, `Heat`.`name`, `Heat`.`notes`, `Heat`.`autonumber`, `Heat`.`number_from`, `Heat`.`number_to`, `Heat`.`relay`, `Heat`.`relaydiscis`, `Heat`.`relaycnt`, `Heat`.`relaymode`, `Heat`.`serie`, `Heat`.`champion`, `Heat`.`alternative_ag`, `Heat`.`cnt_st`, `Heat`.`created`, `Heat`.`modified` FROM `heats` AS `Heat` WHERE `Heat`.`event_id` = (270) 660
42SELECT `Sheet`.`id`, `Sheet`.`name`, `Sheet`.`event_id`, `Sheet`.`colhead`, `Sheet`.`colheadtxt`, `Sheet`.`coltabhead`, `Sheet`.`coltabheadtxt`, `Sheet`.`coltabbodyeve`, `Sheet`.`coltabbodyevetxt`, `Sheet`.`coltabbodyodd`, `Sheet`.`coltabbodyoddtxt`, `Sheet`.`txthead`, `Sheet`.`txtfooter`, `Sheet`.`created`, `Sheet`.`modified` FROM `sheets` AS `Sheet` WHERE `Sheet`.`event_id` = (270) 110
43SELECT `Certificate`.`id`, `Certificate`.`descr`, `Certificate`.`orient`, `Certificate`.`filename`, `Certificate`.`type`, `Certificate`.`size`, `Certificate`.`event_id`, `Certificate`.`txt`, `Certificate`.`kind`, `Certificate`.`blockmovex`, `Certificate`.`blockmovey`, `Certificate`.`created`, `Certificate`.`modified` FROM `certificates` AS `Certificate` WHERE `Certificate`.`event_id` = (270) 110
44SELECT `Team`.`id`, `Team`.`event_id`, `Team`.`name`, `Team`.`mode`, `Team`.`cnt`, `Team`.`idx`, `Team`.`cntTeams`, `Team`.`championtime`, `Team`.`created`, `Team`.`modified` FROM `teams` AS `Team` WHERE `Team`.`event_id` = (270) 000
45SELECT `Eventreport`.`id`, `Eventreport`.`event_id`, `Eventreport`.`title`, `Eventreport`.`club_name`, `Eventreport`.`first_name`, `Eventreport`.`last_name`, `Eventreport`.`sex`, `Eventreport`.`year`, `Eventreport`.`street`, `Eventreport`.`zip`, `Eventreport`.`town`, `Eventreport`.`phone`, `Eventreport`.`fax`, `Eventreport`.`email`, `Eventreport`.`homepage`, `Eventreport`.`time`, `Eventreport`.`event_date`, `Eventreport`.`etown`, `Eventreport`.`county`, `Eventreport`.`club_number`, `Eventreport`.`0bis15m`, `Eventreport`.`0bis15w`, `Eventreport`.`0bis15g`, `Eventreport`.`16bis19m`, `Eventreport`.`16bis19w`, `Eventreport`.`16bis19g`, `Eventreport`.`20bis29m`, `Eventreport`.`20bis29w`, `Eventreport`.`20bis29g`, `Eventreport`.`30bis49m`, `Eventreport`.`30bis49w`, `Eventreport`.`30bis49g`, `Eventreport`.`50bis99m`, `Eventreport`.`50bis99w`, `Eventreport`.`50bis99g`, `Eventreport`.`gestamt`, `Eventreport`.`gemeldet`, `Eventreport`.`extAth`, `Eventreport`.`leitung`, `Eventreport`.`aufsicht`, `Eventreport`.`helfer`, `Eventreport`.`kampfrichter`, `Eventreport`.`comment`, `Eventreport`.`vermessprotdate`, `Eventreport`.`created`, `Eventreport`.`modified` FROM `eventreports` AS `Eventreport` WHERE `Eventreport`.`event_id` = (270) 110
46SELECT `Ecat`.`id`, `Ecat`.`name`, `EcatsEvent`.`event_id`, `EcatsEvent`.`ecat_id` FROM `ecats` AS `Ecat` JOIN `ecats_events` AS `EcatsEvent` ON (`EcatsEvent`.`event_id` = 270 AND `EcatsEvent`.`ecat_id` = `Ecat`.`id`) 110
47SELECT `Eright`.`id`, `Eright`.`name`, `ErightsEvent`.`event_id`, `ErightsEvent`.`eright_id` FROM `erights` AS `Eright` JOIN `erights_events` AS `ErightsEvent` ON (`ErightsEvent`.`event_id` = 270 AND `ErightsEvent`.`eright_id` = `Eright`.`id`) 000
48SELECT `Event`.`id`, `Event`.`number`, `Event`.`name`, `Event`.`event_date`, `Event`.`notes`, `Event`.`start`, `Event`.`club_id`, `Event`.`email`, `Event`.`quicklink`, `Event`.`downloadlink`, `Event`.`uploadlink`, `Event`.`geocode_id`, `Event`.`kmllink`, `Event`.`profile`, `Event`.`regi_cutoff`, `Event`.`payment_method`, `Event`.`cnt_st`, `Event`.`mode_time_display`, `Event`.`mode_place`, `Event`.`user_id`, `Event`.`serie_id`, `Event`.`permit`, `Event`.`kind`, `Event`.`range_kind`, `Event`.`catogory`, `Event`.`vermessprotdate`, `Event`.`county`, `Event`.`region`, `Event`.`championshipname`, `Event`.`picturelink`, `Event`.`tag`, `Event`.`blvlogo`, `Event`.`timemode`, `Event`.`seriecaption`, `Event`.`cutofftxt`, `Event`.`regiinfotxt`, `Event`.`dress_size`, `Event`.`created`, `Event`.`modified`, `Club`.`id`, `Club`.`name`, `Club`.`street`, `Club`.`zipcode`, `Club`.`place`, `Club`.`phone`, `Club`.`fax`, `Club`.`email_address`, `Club`.`homepage`, `Club`.`created`, `Club`.`modified`, `Club`.`clubnr`, `Club`.`filename`, `Club`.`type`, `Club`.`size`, `Geocode`.`id`, `Geocode`.`key`, `Geocode`.`lng`, `Geocode`.`lat`, `Geocode`.`address1`, `Geocode`.`address2`, `Geocode`.`address3`, `Geocode`.`address4`, `Geocode`.`town`, `Geocode`.`county`, `Geocode`.`region`, `Geocode`.`postcode`, `Geocode`.`country`, `Geocode`.`provider`, `Geocode`.`modified`, `Geocode`.`created`, `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`sex`, `User`.`year`, `User`.`street`, `User`.`zipcode`, `User`.`place`, `User`.`phone`, `User`.`fax`, `User`.`email_address`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`club_id`, `User`.`startpass_no`, `User`.`startpass_no_btv`, `User`.`dress_size`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`lastlogin`, `User`.`hidename`, `Serie`.`id`, `Serie`.`name`, `Serie`.`mode`, `Serie`.`min_cnt_regis`, `Serie`.`max_cnt_regis`, `Serie`.`points_per_place`, `Serie`.`created`, `Serie`.`modified` FROM `events` AS `Event` LEFT JOIN `clubs` AS `Club` ON (`Event`.`club_id` = `Club`.`id`) LEFT JOIN `geocodes` AS `Geocode` ON (`Event`.`geocode_id` = `Geocode`.`id`) LEFT JOIN `users` AS `User` ON (`Event`.`user_id` = `User`.`id`) LEFT JOIN `series` AS `Serie` ON (`Event`.`serie_id` = `Serie`.`id`) WHERE `Event`.`event_date` > now() ORDER BY `Event`.`event_date` ASC LIMIT 1010103
49SELECT `Heat`.`id`, `Heat`.`event_id`, `Heat`.`name`, `Heat`.`notes`, `Heat`.`autonumber`, `Heat`.`number_from`, `Heat`.`number_to`, `Heat`.`relay`, `Heat`.`relaydiscis`, `Heat`.`relaycnt`, `Heat`.`relaymode`, `Heat`.`serie`, `Heat`.`champion`, `Heat`.`alternative_ag`, `Heat`.`cnt_st`, `Heat`.`created`, `Heat`.`modified` FROM `heats` AS `Heat` WHERE `Heat`.`event_id` IN (2585, 2673, 2674, 2541, 2675, 2676, 2532, 2677, 2678, 2679) 15150
50SELECT `Sheet`.`id`, `Sheet`.`name`, `Sheet`.`event_id`, `Sheet`.`colhead`, `Sheet`.`colheadtxt`, `Sheet`.`coltabhead`, `Sheet`.`coltabheadtxt`, `Sheet`.`coltabbodyeve`, `Sheet`.`coltabbodyevetxt`, `Sheet`.`coltabbodyodd`, `Sheet`.`coltabbodyoddtxt`, `Sheet`.`txthead`, `Sheet`.`txtfooter`, `Sheet`.`created`, `Sheet`.`modified` FROM `sheets` AS `Sheet` WHERE `Sheet`.`event_id` IN (2585, 2673, 2674, 2541, 2675, 2676, 2532, 2677, 2678, 2679) 10100
51SELECT `Certificate`.`id`, `Certificate`.`descr`, `Certificate`.`orient`, `Certificate`.`filename`, `Certificate`.`type`, `Certificate`.`size`, `Certificate`.`event_id`, `Certificate`.`txt`, `Certificate`.`kind`, `Certificate`.`blockmovex`, `Certificate`.`blockmovey`, `Certificate`.`created`, `Certificate`.`modified` FROM `certificates` AS `Certificate` WHERE `Certificate`.`event_id` IN (2585, 2673, 2674, 2541, 2675, 2676, 2532, 2677, 2678, 2679) 110
52SELECT `Team`.`id`, `Team`.`event_id`, `Team`.`name`, `Team`.`mode`, `Team`.`cnt`, `Team`.`idx`, `Team`.`cntTeams`, `Team`.`championtime`, `Team`.`created`, `Team`.`modified` FROM `teams` AS `Team` WHERE `Team`.`event_id` IN (2585, 2673, 2674, 2541, 2675, 2676, 2532, 2677, 2678, 2679) 000
53SELECT `Eventreport`.`id`, `Eventreport`.`event_id`, `Eventreport`.`title`, `Eventreport`.`club_name`, `Eventreport`.`first_name`, `Eventreport`.`last_name`, `Eventreport`.`sex`, `Eventreport`.`year`, `Eventreport`.`street`, `Eventreport`.`zip`, `Eventreport`.`town`, `Eventreport`.`phone`, `Eventreport`.`fax`, `Eventreport`.`email`, `Eventreport`.`homepage`, `Eventreport`.`time`, `Eventreport`.`event_date`, `Eventreport`.`etown`, `Eventreport`.`county`, `Eventreport`.`club_number`, `Eventreport`.`0bis15m`, `Eventreport`.`0bis15w`, `Eventreport`.`0bis15g`, `Eventreport`.`16bis19m`, `Eventreport`.`16bis19w`, `Eventreport`.`16bis19g`, `Eventreport`.`20bis29m`, `Eventreport`.`20bis29w`, `Eventreport`.`20bis29g`, `Eventreport`.`30bis49m`, `Eventreport`.`30bis49w`, `Eventreport`.`30bis49g`, `Eventreport`.`50bis99m`, `Eventreport`.`50bis99w`, `Eventreport`.`50bis99g`, `Eventreport`.`gestamt`, `Eventreport`.`gemeldet`, `Eventreport`.`extAth`, `Eventreport`.`leitung`, `Eventreport`.`aufsicht`, `Eventreport`.`helfer`, `Eventreport`.`kampfrichter`, `Eventreport`.`comment`, `Eventreport`.`vermessprotdate`, `Eventreport`.`created`, `Eventreport`.`modified` FROM `eventreports` AS `Eventreport` WHERE `Eventreport`.`event_id` IN (2585, 2673, 2674, 2541, 2675, 2676, 2532, 2677, 2678, 2679) 330
54SELECT `Ecat`.`id`, `Ecat`.`name`, `EcatsEvent`.`event_id`, `EcatsEvent`.`ecat_id` FROM `ecats` AS `Ecat` JOIN `ecats_events` AS `EcatsEvent` ON (`EcatsEvent`.`event_id` IN (2585, 2673, 2674, 2541, 2675, 2676, 2532, 2677, 2678, 2679) AND `EcatsEvent`.`ecat_id` = `Ecat`.`id`) 220
55SELECT `Eright`.`id`, `Eright`.`name`, `ErightsEvent`.`event_id`, `ErightsEvent`.`eright_id` FROM `erights` AS `Eright` JOIN `erights_events` AS `ErightsEvent` ON (`ErightsEvent`.`event_id` IN (2585, 2673, 2674, 2541, 2675, 2676, 2532, 2677, 2678, 2679) AND `ErightsEvent`.`eright_id` = `Eright`.`id`) 550