Willkommen im Laufportal Calendars

Veranstaltungskalender

Jahr: 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 |

Monat: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |

Januar 2013

	-
	- Testnummer Lauf
	- Niederbayerische Strasssenlaufmeisterschaften - 4. Labertal-Lauf (Geiselhöring-Hirschling)
	- Neujahrslauf München (München)

	- Winterlaufserie München (II) (München)
	- 26. Kersbacher Dreikönigslauf (Forchheim)
	- 30. Goldbacher Winter-Crosslauf-Serie (Goldbach)
	- 30. Aichacher Dreikönigslauf (Aichach)
	- Lauinger Dreikönigslauf (Lauingen)
	- 10. Dreikönigs-Benefizlauf (Unterwurmbach)

	- Olchinger Neujahrslauf 2013 (Olching)
	- Trainingsmarathon
	- 23. Sparkassen-Staustufenlauf (Karlstadt)
	- 8. VR-Bank Winterlaufserie Coburg 2013 (Weitramsdorf)

	- 30. Goldbacher Winter-Crosslauf-Serie (Goldbach)
	- 22. Ismaninger Winterlaufserie (Ismaning Sportpark)

	- 4. Dingolfinger Stadion-Crosslauf (Dingolfing)
	- 1. Lauf zum Jura Cross Cup

	- Dinkelsbühler Stadtlauf 2013 (Dinkelsbühl)
	- 30. Goldbacher Winter-Crosslauf-Serie (Goldbach)

- Altöttinger Crosslauf (Altötting)

Legende:Online Anmeldungen möglich

(default) 50 queries took 15 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `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 1	1	1	0
2	SELECT `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` = 'calendars'	2	2	0
3	SELECT YEAR( event_date ) AS year FROM events GROUP BY YEAR( event_date )	34	34	0
4	SELECT DISTINCT assocs.name, assocs.id FROM assocs, assocs_clubs, clubs, events WHERE assocs.id = assocs_clubs.assoc_id AND clubs.id = assocs_clubs.club_id AND events.club_id = clubs.id	6	6	0
5	SELECT `Calendar`.`id`, `Calendar`.`name`, `Calendar`.`event_date`, DAY(event_date) AS event_day, `Calendar`.`geocode_id`, `Calendar`.`permit`, `Calendar`.`club_id`, `Calendar`.`kind`, `Calendar`.`range_kind` FROM `events` AS `Calendar` LEFT JOIN `clubs` AS `Club` ON (`Calendar`.`club_id` = `Club`.`id`) LEFT JOIN `geocodes` AS `Geocode` ON (`Calendar`.`geocode_id` = `Geocode`.`id`) LEFT JOIN `users` AS `User` ON (`Calendar`.`user_id` = `User`.`id`) WHERE MONTH(`Calendar`.`event_date`) = 1 AND YEAR(`Calendar`.`event_date`) = '2013' AND `Calendar`.`name` like '%%' ORDER BY `event_date` ASC	21	21	4
6	SELECT `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 (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305)	24	24	5
7	SELECT `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 (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305)	21	21	3
8	SELECT `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 (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305)	0	0	1
9	SELECT `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 (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305)	0	0	0
10	SELECT `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 (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305)	0	0	0
11	SELECT `Ecat`.`id`, `Ecat`.`name`, `EcatsEvent`.`event_id`, `EcatsEvent`.`ecat_id` FROM `ecats` AS `Ecat` JOIN `ecats_events` AS `EcatsEvent` ON (`EcatsEvent`.`event_id` IN (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305) AND `EcatsEvent`.`ecat_id` = `Ecat`.`id`)	0	0	0
12	SELECT `Eright`.`id`, `Eright`.`name`, `ErightsEvent`.`event_id`, `ErightsEvent`.`eright_id` FROM `erights` AS `Eright` JOIN `erights_events` AS `ErightsEvent` ON (`ErightsEvent`.`event_id` IN (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305) AND `ErightsEvent`.`eright_id` = `Eright`.`id`)	0	0	0
13	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` IS NULL LIMIT 1	0	0	0
14	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` IS NULL LIMIT 1	0	0	0
15	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 531 LIMIT 1	1	1	1
16	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (531)	2	2	1
17	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 224 LIMIT 1	1	1	0
18	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (224)	2	2	0
19	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 338 LIMIT 1	1	1	0
20	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (338)	1	1	0
21	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 163 LIMIT 1	1	1	0
22	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (163)	3	3	0
23	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 229 LIMIT 1	1	1	0
24	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (229)	1	1	0
25	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 164 LIMIT 1	1	1	0
26	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (164)	1	1	0
27	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 223 LIMIT 1	1	1	0
28	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (223)	1	1	0
29	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 228 LIMIT 1	1	1	0
30	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (228)	1	1	0
31	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 230 LIMIT 1	1	1	0
32	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (230)	1	1	0
33	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` IS NULL LIMIT 1	0	0	0
34	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 232 LIMIT 1	1	1	0
35	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (232)	2	2	0
36	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 231 LIMIT 1	1	1	0
37	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (231)	1	1	0
38	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 339 LIMIT 1	1	1	0
39	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (339)	1	1	0
40	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 233 LIMIT 1	1	1	0
41	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (233)	1	1	0
42	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 234 LIMIT 1	1	1	0
43	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (234)	6	6	0
44	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` IS NULL LIMIT 1	0	0	0
45	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 235 LIMIT 1	1	1	0
46	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (235)	3	3	0
47	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 340 LIMIT 1	1	1	0
48	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (340)	1	1	0
49	SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` = 236 LIMIT 1	1	1	0
50	SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (236)	3	3	0

(default) 50 queries took 15 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `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 1

SELECT `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` = 'calendars'

SELECT YEAR( event_date ) AS year FROM events GROUP BY YEAR( event_date )

SELECT DISTINCT assocs.name, assocs.id FROM assocs, assocs_clubs, clubs, events WHERE assocs.id = assocs_clubs.assoc_id AND clubs.id = assocs_clubs.club_id AND events.club_id = clubs.id

SELECT `Calendar`.`id`, `Calendar`.`name`, `Calendar`.`event_date`, DAY(event_date) AS event_day, `Calendar`.`geocode_id`, `Calendar`.`permit`, `Calendar`.`club_id`, `Calendar`.`kind`, `Calendar`.`range_kind` FROM `events` AS `Calendar` LEFT JOIN `clubs` AS `Club` ON (`Calendar`.`club_id` = `Club`.`id`) LEFT JOIN `geocodes` AS `Geocode` ON (`Calendar`.`geocode_id` = `Geocode`.`id`) LEFT JOIN `users` AS `User` ON (`Calendar`.`user_id` = `User`.`id`) WHERE MONTH(`Calendar`.`event_date`) = 1 AND YEAR(`Calendar`.`event_date`) = '2013' AND `Calendar`.`name` like '%%' ORDER BY `event_date` ASC

SELECT `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 (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305)

SELECT `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 (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305)

SELECT `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 (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305)

SELECT `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 (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305)

SELECT `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 (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305)

SELECT `Ecat`.`id`, `Ecat`.`name`, `EcatsEvent`.`event_id`, `EcatsEvent`.`ecat_id` FROM `ecats` AS `Ecat` JOIN `ecats_events` AS `EcatsEvent` ON (`EcatsEvent`.`event_id` IN (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305) AND `EcatsEvent`.`ecat_id` = `Ecat`.`id`)

SELECT `Eright`.`id`, `Eright`.`name`, `ErightsEvent`.`event_id`, `ErightsEvent`.`eright_id` FROM `erights` AS `Eright` JOIN `erights_events` AS `ErightsEvent` ON (`ErightsEvent`.`event_id` IN (767, 766, 608, 292, 407, 236, 298, 237, 291, 297, 299, 293, 301, 300, 408, 302, 303, 410, 304, 409, 305) AND `ErightsEvent`.`eright_id` = `Eright`.`id`)

SELECT `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` FROM `geocodes` AS `Geocode` WHERE `Geocode`.`id` IS NULL LIMIT 1

SELECT `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` FROM `events` AS `Event` WHERE `Event`.`geocode_id` = (531)