Willkommen beim Nordrhein-Westfälischen Kendoverband e.V.

Archiv Aktuelles

Archiv

Bekanntmachungen

Es kommt immer wieder vor, dass Pässe nach Kyu-Prüfungen verschwinden. Wenn ihr die Pässe abgeben sollt, stellt sicher, dass ihr sie unmittelbar nach der Prüfung zurück erhaltet. Verantwortlich ist der ausrichtende Verein und nicht der NWKV.


(default) 43 queries took 141 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `nwkv_pages`10102
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';111
3SHOW FULL COLUMNS FROM `nwkv_users`11111
4SHOW FULL COLUMNS FROM `nwkv_groups`551
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_german2_ci';111
6SHOW FULL COLUMNS FROM `nwkv_people`13131
7SHOW FULL COLUMNS FROM `nwkv_clubs`17171
8SHOW FULL COLUMNS FROM `nwkv_trainings`881
9SHOW FULL COLUMNS FROM `nwkv_club_member_reports`991
10SELECT `Page`.`id`, `Page`.`slug` FROM `nwkv_pages` AS `Page` WHERE 1 = 1 29291
11SHOW FULL COLUMNS FROM `nwkv_articles`14141
12SHOW FULL COLUMNS FROM `nwkv_categories`221
13SHOW FULL COLUMNS FROM `nwkv_events`23232
14SHOW FULL COLUMNS FROM `nwkv_attachments`661
15SHOW FULL COLUMNS FROM `nwkv_galleries`881
16SHOW FULL COLUMNS FROM `nwkv_pictures`441
17SHOW FULL COLUMNS FROM `nwkv_orders`17172
18SHOW FULL COLUMNS FROM `nwkv_expenses`661
19SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`permission` FROM `nwkv_groups` AS `Group` WHERE `Group`.`id` IS NULL LIMIT 1000
20SELECT `Event`.*, if(DATEDIFF(now(),Event.created) < 3,'new',if(DATEDIFF(now(),Event.updated) < 3,'updated','old')) as status, `Event`.`id` FROM `nwkv_events` AS `Event` LEFT JOIN `nwkv_users` AS `User` ON (`Event`.`user_id` = `User`.`id`) WHERE ((`Event`.`start` > NOW()) OR (`Event`.`end` > NOW())) AND `Event`.`public` = 1 GROUP BY title ORDER BY `start` asc LIMIT 5553
21SELECT `Attachment`.`id`, `Attachment`.`file`, `Attachment`.`type`, `Attachment`.`created`, `Attachment`.`event_id`, `Attachment`.`checksum` FROM `nwkv_attachments` AS `Attachment` WHERE `Attachment`.`event_id` IN (557, 591, 550, 563, 560) 221
22SELECT `Article`.`id`, `Article`.`archive`, `Article`.`homepage`, `Article`.`title`, `Article`.`subtitle`, `Article`.`slug`, `Article`.`content`, `Article`.`links`, `Article`.`image`, `Article`.`user_id`, `Article`.`created`, `Article`.`updated`, `Article`.`category_id`, `Article`.`public`, `Category`.`id`, `Category`.`name`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`author_name`, `User`.`group_id`, `User`.`role`, `User`.`email`, `User`.`active`, `User`.`admin`, `User`.`created`, `User`.`modified` FROM `nwkv_articles` AS `Article` LEFT JOIN `nwkv_categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `nwkv_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`public` = 1 AND `Article`.`archive` <= 0 ORDER BY `Article`.`created` DESC LIMIT 55510
23SELECT `Category`.`id`, `Category`.`name` FROM `nwkv_categories` AS `Category` WHERE `Category`.`id` = 6 110
24SELECT `Category`.`id`, `Category`.`name` FROM `nwkv_categories` AS `Category` WHERE `Category`.`id` = 3 110
25SELECT `Category`.`id`, `Category`.`name` FROM `nwkv_categories` AS `Category` WHERE `Category`.`id` = 6 110
26SELECT `Category`.`id`, `Category`.`name` FROM `nwkv_categories` AS `Category` WHERE `Category`.`id` = 2 110
27SELECT `Category`.`id`, `Category`.`name` FROM `nwkv_categories` AS `Category` WHERE `Category`.`id` = 6 110
28SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`author_name`, `User`.`group_id`, `User`.`role`, `User`.`email`, `User`.`active`, `User`.`admin`, `User`.`created`, `User`.`modified` FROM `nwkv_users` AS `User` WHERE `User`.`id` = 52 110
29SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`permission` FROM `nwkv_groups` AS `Group` WHERE `Group`.`id` = 5 110
30SELECT `Person`.`id`, `Person`.`user_id`, `Person`.`club_id`, `Person`.`name`, `Person`.`street`, `Person`.`plz`, `Person`.`city`, `Person`.`phone`, `Person`.`mobile`, `Person`.`fax`, `Person`.`email`, `Person`.`website`, `Person`.`grade` FROM `nwkv_people` AS `Person` WHERE `Person`.`user_id` = 52 001
31SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`author_name`, `User`.`group_id`, `User`.`role`, `User`.`email`, `User`.`active`, `User`.`admin`, `User`.`created`, `User`.`modified` FROM `nwkv_users` AS `User` WHERE `User`.`id` = 52 110
32SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`permission` FROM `nwkv_groups` AS `Group` WHERE `Group`.`id` = 5 110
33SELECT `Person`.`id`, `Person`.`user_id`, `Person`.`club_id`, `Person`.`name`, `Person`.`street`, `Person`.`plz`, `Person`.`city`, `Person`.`phone`, `Person`.`mobile`, `Person`.`fax`, `Person`.`email`, `Person`.`website`, `Person`.`grade` FROM `nwkv_people` AS `Person` WHERE `Person`.`user_id` = 52 000
34SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`author_name`, `User`.`group_id`, `User`.`role`, `User`.`email`, `User`.`active`, `User`.`admin`, `User`.`created`, `User`.`modified` FROM `nwkv_users` AS `User` WHERE `User`.`id` = 52 110
35SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`permission` FROM `nwkv_groups` AS `Group` WHERE `Group`.`id` = 5 110
36SELECT `Person`.`id`, `Person`.`user_id`, `Person`.`club_id`, `Person`.`name`, `Person`.`street`, `Person`.`plz`, `Person`.`city`, `Person`.`phone`, `Person`.`mobile`, `Person`.`fax`, `Person`.`email`, `Person`.`website`, `Person`.`grade` FROM `nwkv_people` AS `Person` WHERE `Person`.`user_id` = 52 000
37SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`author_name`, `User`.`group_id`, `User`.`role`, `User`.`email`, `User`.`active`, `User`.`admin`, `User`.`created`, `User`.`modified` FROM `nwkv_users` AS `User` WHERE `User`.`id` = 4 000
38SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`author_name`, `User`.`group_id`, `User`.`role`, `User`.`email`, `User`.`active`, `User`.`admin`, `User`.`created`, `User`.`modified` FROM `nwkv_users` AS `User` WHERE `User`.`id` = 4 000
39SELECT `Event`.`id`, `Event`.`title`, `Event`.`slug`, `Event`.`desc`, `Event`.`start`, `Event`.`end`, `Event`.`deadline`, `Event`.`url`, `Event`.`announcement`, `Event`.`className`, `Event`.`public`, `Event`.`canceled`, `Event`.`location`, `Event`.`street`, `Event`.`coords`, `Event`.`club_id`, `Event`.`type`, `Event`.`created`, `Event`.`updated`, `Event`.`kyu_exam`, `Event`.`dan_exam`, `Event`.`shinpan`, `Event`.`user_id`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`author_name`, `User`.`group_id`, `User`.`role`, `User`.`email`, `User`.`active`, `User`.`admin`, `User`.`created`, `User`.`modified` FROM `nwkv_events` AS `Event` LEFT JOIN `nwkv_users` AS `User` ON (`Event`.`user_id` = `User`.`id`) WHERE ((DATE_ADD(`Event`.`start`,INTERVAL 1 Day) > now()) OR (`Event`.`end` > now())) AND `public` = 1 AND `kyu_exam` = 0 AND `dan_exam` = 0 AND `className` = 'squad' ORDER BY `Event`.`start` asc LIMIT 1111
40SELECT `Attachment`.`id`, `Attachment`.`file`, `Attachment`.`type`, `Attachment`.`created`, `Attachment`.`event_id`, `Attachment`.`checksum` FROM `nwkv_attachments` AS `Attachment` WHERE `Attachment`.`event_id` = (550) 001
41SELECT `Picture`.`id`, `Picture`.`gallery_id`, `Picture`.`image`, `Picture`.`created`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`desc`, `Gallery`.`created`, `Gallery`.`path`, `Gallery`.`picture_count`, `Gallery`.`public`, `Gallery`.`user_id` FROM `nwkv_pictures` AS `Picture` LEFT JOIN `nwkv_galleries` AS `Gallery` ON (`Picture`.`gallery_id` = `Gallery`.`id`) WHERE `Picture`.`id` >= (SELECT FLOOR( MAX(id) * RAND()) FROM nwkv_pictures limit 1) ORDER BY `Picture`.`id` ASC LIMIT 111100
42SELECT `Article`.`slug`, `Article`.`title`, `Article`.`subtitle`, `Article`.`created`, `Article`.`image`, if(DATEDIFF(now(),Article.created) < 3,'new',if(DATEDIFF(now(),Article.updated) < 3,'updated','old')) as status FROM `nwkv_articles` AS `Article` LEFT JOIN `nwkv_categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `nwkv_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`public` = 1 AND `Article`.`archive` = 0 AND `Article`.`homepage` = 1 ORDER BY `Article`.`created` DESC LIMIT 4441
43SELECT `Article`.`slug`, `Article`.`title`, `Article`.`subtitle`, `Article`.`created`, `Article`.`image` FROM `nwkv_articles` AS `Article` LEFT JOIN `nwkv_categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `nwkv_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`public` = 1 AND `Article`.`archive` = 0 AND `Article`.`homepage` = 1 ORDER BY `Article`.`created` DESC LIMIT 4442