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 `Assoc`.`id`, `Assoc`.`sign`, `Assoc`.`name`, `Assoc`.`created`, `Assoc`.`modified` FROM `assocs` AS `Assoc` WHERE `Assoc`.`id` = 34 LIMIT 1 | | 1 | 1 | 0 |
6 | SELECT `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`, `AssocsClub`.`club_id`, `AssocsClub`.`assoc_id` FROM `clubs` AS `Club` JOIN `assocs_clubs` AS `AssocsClub` ON (`AssocsClub`.`assoc_id` = 34 AND `AssocsClub`.`club_id` = `Club`.`id`) | | 2 | 2 | 0 |
7 | 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`) = 10 AND YEAR(`Calendar`.`event_date`) = '2016' AND `Calendar`.`name` like '%%' ORDER BY `event_date` ASC | | 45 | 45 | 4 |
8 | 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 (1723, 2399, 2400, 2401, 1737, 2405, 2409, 2402, 2403, 2404, 2408, 2406, 2407, 2514, 1731, 2410, 2411, 2412, 2417, 2416, 2415, 2414, 2413, 1672, 2418, 2419, 2420, 2423, 2422, 2421, 2424, 2498, 2534, 2428, 2427, 2425, 2426, 2429, 2432, 2431, 2430, 2433, 2435, 2436, 2434) | | 56 | 56 | 1 |
9 | 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 (1723, 2399, 2400, 2401, 1737, 2405, 2409, 2402, 2403, 2404, 2408, 2406, 2407, 2514, 1731, 2410, 2411, 2412, 2417, 2416, 2415, 2414, 2413, 1672, 2418, 2419, 2420, 2423, 2422, 2421, 2424, 2498, 2534, 2428, 2427, 2425, 2426, 2429, 2432, 2431, 2430, 2433, 2435, 2436, 2434) | | 45 | 45 | 1 |
10 | 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 (1723, 2399, 2400, 2401, 1737, 2405, 2409, 2402, 2403, 2404, 2408, 2406, 2407, 2514, 1731, 2410, 2411, 2412, 2417, 2416, 2415, 2414, 2413, 1672, 2418, 2419, 2420, 2423, 2422, 2421, 2424, 2498, 2534, 2428, 2427, 2425, 2426, 2429, 2432, 2431, 2430, 2433, 2435, 2436, 2434) | | 1 | 1 | 0 |
11 | 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 (1723, 2399, 2400, 2401, 1737, 2405, 2409, 2402, 2403, 2404, 2408, 2406, 2407, 2514, 1731, 2410, 2411, 2412, 2417, 2416, 2415, 2414, 2413, 1672, 2418, 2419, 2420, 2423, 2422, 2421, 2424, 2498, 2534, 2428, 2427, 2425, 2426, 2429, 2432, 2431, 2430, 2433, 2435, 2436, 2434) | | 0 | 0 | 0 |
12 | 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 (1723, 2399, 2400, 2401, 1737, 2405, 2409, 2402, 2403, 2404, 2408, 2406, 2407, 2514, 1731, 2410, 2411, 2412, 2417, 2416, 2415, 2414, 2413, 1672, 2418, 2419, 2420, 2423, 2422, 2421, 2424, 2498, 2534, 2428, 2427, 2425, 2426, 2429, 2432, 2431, 2430, 2433, 2435, 2436, 2434) | | 4 | 4 | 1 |
13 | 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 (1723, 2399, 2400, 2401, 1737, 2405, 2409, 2402, 2403, 2404, 2408, 2406, 2407, 2514, 1731, 2410, 2411, 2412, 2417, 2416, 2415, 2414, 2413, 1672, 2418, 2419, 2420, 2423, 2422, 2421, 2424, 2498, 2534, 2428, 2427, 2425, 2426, 2429, 2432, 2431, 2430, 2433, 2435, 2436, 2434) AND `EcatsEvent`.`ecat_id` = `Ecat`.`id`) | | 2 | 2 | 0 |
14 | 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 (1723, 2399, 2400, 2401, 1737, 2405, 2409, 2402, 2403, 2404, 2408, 2406, 2407, 2514, 1731, 2410, 2411, 2412, 2417, 2416, 2415, 2414, 2413, 1672, 2418, 2419, 2420, 2423, 2422, 2421, 2424, 2498, 2534, 2428, 2427, 2425, 2426, 2429, 2432, 2431, 2430, 2433, 2435, 2436, 2434) AND `ErightsEvent`.`eright_id` = `Eright`.`id`) | | 9 | 9 | 0 |
15 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 570 | | 0 | 0 | 0 |
16 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 93 | | 0 | 0 | 0 |
17 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 3056 | | 0 | 0 | 0 |
18 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 3058 | | 0 | 0 | 0 |
19 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 35 | | 0 | 0 | 0 |
20 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 1053 | | 0 | 0 | 0 |
21 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 908 | | 0 | 0 | 0 |
22 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 794 | | 0 | 0 | 0 |
23 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 4049 | | 0 | 0 | 0 |
24 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 1709 | | 0 | 0 | 0 |
25 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 11219 | | 0 | 0 | 0 |
26 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 910 | | 0 | 0 | 0 |
27 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 913 | | 0 | 0 | 0 |
28 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 6316 | | 0 | 0 | 0 |
29 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 3050 | | 0 | 0 | 0 |
30 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 924 | | 0 | 0 | 0 |
31 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 534 | | 0 | 0 | 0 |
32 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 173 | | 0 | 0 | 0 |
33 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 167 | | 0 | 0 | 0 |
34 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 1224 | | 0 | 0 | 0 |
35 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 344 | | 0 | 0 | 0 |
36 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 919 | | 0 | 0 | 0 |
37 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 925 | | 0 | 0 | 0 |
38 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 928 | | 0 | 0 | 0 |
39 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 5283 | | 0 | 0 | 0 |
40 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 938 | | 0 | 0 | 0 |
41 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 42 | | 0 | 0 | 0 |
42 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 5289 | | 0 | 0 | 0 |
43 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 8197 | | 0 | 0 | 0 |
44 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 5287 | | 0 | 0 | 0 |
45 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 939 | | 0 | 0 | 0 |
46 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 7411 | | 0 | 0 | 0 |
47 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 722 | | 0 | 0 | 0 |
48 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 1006 | | 0 | 0 | 0 |
49 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 973 | | 0 | 0 | 0 |
50 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 936 | | 0 | 0 | 0 |
51 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 1271 | | 0 | 0 | 0 |
52 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 941 | | 0 | 0 | 0 |
53 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 281 | | 0 | 0 | 0 |
54 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 5293 | | 0 | 0 | 0 |
55 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 1467 | | 0 | 0 | 0 |
56 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 1052 | | 0 | 0 | 0 |
57 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 946 | | 0 | 0 | 0 |
58 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 942 | | 0 | 0 | 0 |
59 | SELECT * FROM assocs_clubs WHERE assocs_clubs.assoc_id = 34 AND assocs_clubs.club_id = 914 | | 0 | 0 | 0 |