28. Wertinger Stadtlauf, Wertingen am 14.06.2014

TSV Wertingen

Veranstaltungsart: Lauf

Wettbewerb: Strasse

Beginn: 17.30 Uhr










(default) 66 queries took 34 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `aros`771
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
3SHOW FULL COLUMNS FROM `acos`770
4SHOW FULL COLUMNS FROM `aros_acos`770
5SHOW FULL COLUMNS FROM `events`41411
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
7SHOW FULL COLUMNS FROM `clubs`17171
8SHOW FULL COLUMNS FROM `users`23230
9SHOW FULL COLUMNS FROM `groups`441
10SHOW FULL COLUMNS FROM `regis`40401
11SHOW FULL COLUMNS FROM `agegroups`18180
12SHOW FULL COLUMNS FROM `heats`24241
13SHOW FULL COLUMNS FROM `charges`770
14SHOW FULL COLUMNS FROM `biathlons`10100
15SHOW FULL COLUMNS FROM `relays`11110
16SHOW FULL COLUMNS FROM `discis`880
17SHOW FULL COLUMNS FROM `teams`13131
18SHOW FULL COLUMNS FROM `agegroups_teams`220
19SHOW FULL COLUMNS FROM `splittimes`880
20SHOW FULL COLUMNS FROM `scores`14140
21SHOW FULL COLUMNS FROM `assocs`550
22SHOW FULL COLUMNS FROM `assocs_clubs`220
23SHOW FULL COLUMNS FROM `assocs_users`220
24SHOW FULL COLUMNS FROM `reservations`660
25SHOW FULL COLUMNS FROM `reservationmembers`13130
26SHOW FULL COLUMNS FROM `alliances_clubs`221
27SHOW FULL COLUMNS FROM `geocodes`16161
28SHOW FULL COLUMNS FROM `series`17171
29SHOW FULL COLUMNS FROM `sheets`22221
30SHOW FULL COLUMNS FROM `certificates`15151
31SHOW FULL COLUMNS FROM `certificatelines`16161
32SHOW FULL COLUMNS FROM `ecats`221
33SHOW FULL COLUMNS FROM `announces`88881
34SHOW FULL COLUMNS FROM `conflicts`881
35SHOW FULL COLUMNS FROM `ecats_announces`221
36SHOW FULL COLUMNS FROM `ecats_events`220
37SHOW FULL COLUMNS FROM `ecats_certificates`220
38SHOW FULL COLUMNS FROM `eventreports`46461
39SHOW FULL COLUMNS FROM `regioptions`551
40SHOW FULL COLUMNS FROM `erights`221
41SHOW FULL COLUMNS FROM `erights_events`220
42SHOW FULL COLUMNS FROM `settings`12121
43SELECT `Setting`.`id`, `Setting`.`announce_email`, `Setting`.`announce_admonition`, `Setting`.`bcc_email`, `Setting`.`disclaimer`, `Setting`.`terms`, `Setting`.`pay_info`, `Setting`.`news`, `Setting`.`type_of_competitions`, `Setting`.`kind_of_event`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1110
44SHOW FULL COLUMNS FROM `banners`991
45SELECT `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' 330
46select 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 = 961111
47select 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.paid > 0 and regis.entry_fee > 0 and discis.agegroup_id = agegroups.id and agegroups.heat_id = heats.id and events.id = heats.event_id and events.id = 961111
48select 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 = 961110
49SELECT `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`.`specialjudgment`, `Event`.`specialjudgmenttxt`, `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`.`kind`, `Club`.`filename`, `Club`.`autorelease_event`, `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`.`logo`, `Serie`.`logos_top`, `Serie`.`logos_middle`, `Serie`.`logos_down`, `Serie`.`logo_edge_length`, `Serie`.`infoline1`, `Serie`.`infoline2`, `Serie`.`infoline3`, `Serie`.`infoline4`, `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` = 961 LIMIT 1111
50SELECT `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`.`caption_st`, `Heat`.`timestamp_start`, `Heat`.`time_measurement`, `Heat`.`max_regi`, `Heat`.`contingent_price`, `Heat`.`first_measuring`, `Heat`.`last_measuring`, `Heat`.`created`, `Heat`.`modified` FROM `heats` AS `Heat` WHERE `Heat`.`event_id` = (961) 110
51SELECT `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`, `Sheet`.`logos_top`, `Sheet`.`logos_middle`, `Sheet`.`logos_down`, `Sheet`.`logo_edge_length`, `Sheet`.`stretch_chef`, `Sheet`.`timekeeping`, `Sheet`.`competition_office` FROM `sheets` AS `Sheet` WHERE `Sheet`.`event_id` = (961) 110
52SELECT `Certificate`.`id`, `Certificate`.`descr`, `Certificate`.`orient`, `Certificate`.`filename`, `Certificate`.`type`, `Certificate`.`size`, `Certificate`.`event_id`, `Certificate`.`txt`, `Certificate`.`kind`, `Certificate`.`blockmovex`, `Certificate`.`blockmovey`, `Certificate`.`sex`, `Certificate`.`specialkz`, `Certificate`.`created`, `Certificate`.`modified` FROM `certificates` AS `Certificate` WHERE `Certificate`.`event_id` = (961) 000
53SELECT `Team`.`id`, `Team`.`event_id`, `Team`.`name`, `Team`.`mode`, `Team`.`cnt`, `Team`.`idx`, `Team`.`cntTeams`, `Team`.`championtime`, `Team`.`genderspecification`, `Team`.`male`, `Team`.`female`, `Team`.`created`, `Team`.`modified` FROM `teams` AS `Team` WHERE `Team`.`event_id` = (961) 001
54SELECT `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` = (961) 000
55SELECT `Regioption`.`id`, `Regioption`.`event_id`, `Regioption`.`title`, `Regioption`.`created`, `Regioption`.`modified` FROM `regioptions` AS `Regioption` WHERE `Regioption`.`event_id` = (961) 000
56SELECT `Ecat`.`id`, `Ecat`.`name`, `EcatsEvent`.`event_id`, `EcatsEvent`.`ecat_id` FROM `ecats` AS `Ecat` JOIN `ecats_events` AS `EcatsEvent` ON (`EcatsEvent`.`event_id` = 961 AND `EcatsEvent`.`ecat_id` = `Ecat`.`id`) 000
57SELECT `Eright`.`id`, `Eright`.`name`, `ErightsEvent`.`event_id`, `ErightsEvent`.`eright_id` FROM `erights` AS `Eright` JOIN `erights_events` AS `ErightsEvent` ON (`ErightsEvent`.`event_id` = 961 AND `ErightsEvent`.`eright_id` = `Eright`.`id`) 000
58SELECT `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`.`specialjudgment`, `Event`.`specialjudgmenttxt`, `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`.`kind`, `Club`.`filename`, `Club`.`autorelease_event`, `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`.`logo`, `Serie`.`logos_top`, `Serie`.`logos_middle`, `Serie`.`logos_down`, `Serie`.`logo_edge_length`, `Serie`.`infoline1`, `Serie`.`infoline2`, `Serie`.`infoline3`, `Serie`.`infoline4`, `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 1010106
59SELECT `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`.`caption_st`, `Heat`.`timestamp_start`, `Heat`.`time_measurement`, `Heat`.`max_regi`, `Heat`.`contingent_price`, `Heat`.`first_measuring`, `Heat`.`last_measuring`, `Heat`.`created`, `Heat`.`modified` FROM `heats` AS `Heat` WHERE `Heat`.`event_id` IN (4941, 4935, 4946, 4962, 4953, 4945, 4965, 4957, 4947, 4963) 52520
60SELECT `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`, `Sheet`.`logos_top`, `Sheet`.`logos_middle`, `Sheet`.`logos_down`, `Sheet`.`logo_edge_length`, `Sheet`.`stretch_chef`, `Sheet`.`timekeeping`, `Sheet`.`competition_office` FROM `sheets` AS `Sheet` WHERE `Sheet`.`event_id` IN (4941, 4935, 4946, 4962, 4953, 4945, 4965, 4957, 4947, 4963) 10100
61SELECT `Certificate`.`id`, `Certificate`.`descr`, `Certificate`.`orient`, `Certificate`.`filename`, `Certificate`.`type`, `Certificate`.`size`, `Certificate`.`event_id`, `Certificate`.`txt`, `Certificate`.`kind`, `Certificate`.`blockmovex`, `Certificate`.`blockmovey`, `Certificate`.`sex`, `Certificate`.`specialkz`, `Certificate`.`created`, `Certificate`.`modified` FROM `certificates` AS `Certificate` WHERE `Certificate`.`event_id` IN (4941, 4935, 4946, 4962, 4953, 4945, 4965, 4957, 4947, 4963) 990
62SELECT `Team`.`id`, `Team`.`event_id`, `Team`.`name`, `Team`.`mode`, `Team`.`cnt`, `Team`.`idx`, `Team`.`cntTeams`, `Team`.`championtime`, `Team`.`genderspecification`, `Team`.`male`, `Team`.`female`, `Team`.`created`, `Team`.`modified` FROM `teams` AS `Team` WHERE `Team`.`event_id` IN (4941, 4935, 4946, 4962, 4953, 4945, 4965, 4957, 4947, 4963) 000
63SELECT `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 (4941, 4935, 4946, 4962, 4953, 4945, 4965, 4957, 4947, 4963) 000
64SELECT `Regioption`.`id`, `Regioption`.`event_id`, `Regioption`.`title`, `Regioption`.`created`, `Regioption`.`modified` FROM `regioptions` AS `Regioption` WHERE `Regioption`.`event_id` IN (4941, 4935, 4946, 4962, 4953, 4945, 4965, 4957, 4947, 4963) 000
65SELECT `Ecat`.`id`, `Ecat`.`name`, `EcatsEvent`.`event_id`, `EcatsEvent`.`ecat_id` FROM `ecats` AS `Ecat` JOIN `ecats_events` AS `EcatsEvent` ON (`EcatsEvent`.`event_id` IN (4941, 4935, 4946, 4962, 4953, 4945, 4965, 4957, 4947, 4963) AND `EcatsEvent`.`ecat_id` = `Ecat`.`id`) 110
66SELECT `Eright`.`id`, `Eright`.`name`, `ErightsEvent`.`event_id`, `ErightsEvent`.`eright_id` FROM `erights` AS `Eright` JOIN `erights_events` AS `ErightsEvent` ON (`ErightsEvent`.`event_id` IN (4941, 4935, 4946, 4962, 4953, 4945, 4965, 4957, 4947, 4963) AND `ErightsEvent`.`eright_id` = `Eright`.`id`) 880