1 | SHOW FULL COLUMNS FROM `aros` | | 7 | 7 | 1 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 |
3 | SHOW FULL COLUMNS FROM `acos` | | 7 | 7 | 1 |
4 | SHOW FULL COLUMNS FROM `aros_acos` | | 7 | 7 | 0 |
5 | SHOW FULL COLUMNS FROM `events` | | 41 | 41 | 0 |
6 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 |
7 | SHOW FULL COLUMNS FROM `clubs` | | 17 | 17 | 0 |
8 | SHOW FULL COLUMNS FROM `users` | | 23 | 23 | 1 |
9 | SHOW FULL COLUMNS FROM `groups` | | 4 | 4 | 1 |
10 | SHOW FULL COLUMNS FROM `regis` | | 40 | 40 | 1 |
11 | SHOW FULL COLUMNS FROM `agegroups` | | 18 | 18 | 1 |
12 | SHOW FULL COLUMNS FROM `heats` | | 24 | 24 | 1 |
13 | SHOW FULL COLUMNS FROM `geocodes` | | 16 | 16 | 1 |
14 | SHOW FULL COLUMNS FROM `series` | | 17 | 17 | 1 |
15 | SHOW FULL COLUMNS FROM `sheets` | | 22 | 22 | 1 |
16 | SHOW FULL COLUMNS FROM `certificates` | | 15 | 15 | 1 |
17 | SHOW FULL COLUMNS FROM `certificatelines` | | 16 | 16 | 1 |
18 | SHOW FULL COLUMNS FROM `ecats` | | 2 | 2 | 1 |
19 | SHOW FULL COLUMNS FROM `announces` | | 88 | 88 | 1 |
20 | SHOW FULL COLUMNS FROM `conflicts` | | 8 | 8 | 1 |
21 | SHOW FULL COLUMNS FROM `ecats_announces` | | 2 | 2 | 1 |
22 | SHOW FULL COLUMNS FROM `ecats_events` | | 2 | 2 | 0 |
23 | SHOW FULL COLUMNS FROM `ecats_certificates` | | 2 | 2 | 0 |
24 | SHOW FULL COLUMNS FROM `teams` | | 13 | 13 | 0 |
25 | SHOW FULL COLUMNS FROM `agegroups_teams` | | 2 | 2 | 0 |
26 | SHOW FULL COLUMNS FROM `eventreports` | | 46 | 46 | 0 |
27 | SHOW FULL COLUMNS FROM `regioptions` | | 5 | 5 | 0 |
28 | SHOW FULL COLUMNS FROM `erights` | | 2 | 2 | 0 |
29 | SHOW FULL COLUMNS FROM `erights_events` | | 2 | 2 | 0 |
30 | SHOW FULL COLUMNS FROM `charges` | | 7 | 7 | 0 |
31 | SHOW FULL COLUMNS FROM `biathlons` | | 10 | 10 | 0 |
32 | SHOW FULL COLUMNS FROM `relays` | | 11 | 11 | 0 |
33 | SHOW FULL COLUMNS FROM `discis` | | 8 | 8 | 0 |
34 | SHOW FULL COLUMNS FROM `splittimes` | | 8 | 8 | 0 |
35 | SHOW FULL COLUMNS FROM `scores` | | 14 | 14 | 1 |
36 | SHOW FULL COLUMNS FROM `assocs` | | 5 | 5 | 0 |
37 | SHOW FULL COLUMNS FROM `assocs_clubs` | | 2 | 2 | 1 |
38 | SHOW FULL COLUMNS FROM `assocs_users` | | 2 | 2 | 0 |
39 | SHOW FULL COLUMNS FROM `reservations` | | 6 | 6 | 0 |
40 | SHOW FULL COLUMNS FROM `reservationmembers` | | 13 | 13 | 0 |
41 | SHOW FULL COLUMNS FROM `alliances_clubs` | | 2 | 2 | 0 |
42 | SHOW FULL COLUMNS FROM `settings` | | 12 | 12 | 0 |
43 | 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 |
44 | SHOW FULL COLUMNS FROM `banners` | | 9 | 9 | 0 |
45 | 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 |
46 | SELECT YEAR( event_date ) AS year FROM events GROUP BY YEAR( event_date ) | | 34 | 34 | 0 |
47 | 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 |
48 | SELECT `Assoc`.`id`, `Assoc`.`sign`, `Assoc`.`name`, `Assoc`.`created`, `Assoc`.`modified` FROM `assocs` AS `Assoc` WHERE `Assoc`.`id` = 25 LIMIT 1 | | 1 | 1 | 0 |
49 | 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` = 25 AND `AssocsClub`.`club_id` = `Club`.`id`) | | 2 | 2 | 0 |
50 | 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`) = 2 AND YEAR(`Calendar`.`event_date`) = '2007' AND `Calendar`.`name` like '%%' ORDER BY `event_date` ASC | | 0 | 0 | 4 |