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) 32 queries took 110 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Page`.`id`, `Page`.`slug` FROM `nwkv_pages` AS `Page` WHERE 1 = 1 29291
2SHOW FULL COLUMNS FROM `nwkv_galleries`882
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';111
4SHOW FULL COLUMNS FROM `nwkv_pictures`442
5SHOW FULL COLUMNS FROM `nwkv_orders`17177
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_german2_ci';113
7SHOW FULL COLUMNS FROM `nwkv_expenses`662
8SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`permission` FROM `nwkv_groups` AS `Group` WHERE `Group`.`id` IS NULL LIMIT 1002
9SELECT `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 5554
10SELECT `Attachment`.`id`, `Attachment`.`file`, `Attachment`.`type`, `Attachment`.`created`, `Attachment`.`event_id`, `Attachment`.`checksum` FROM `nwkv_attachments` AS `Attachment` WHERE `Attachment`.`event_id` IN (550, 563, 560, 553, 592) 221
11SELECT `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 5552
12SELECT `Category`.`id`, `Category`.`name` FROM `nwkv_categories` AS `Category` WHERE `Category`.`id` = 6 110
13SELECT `Category`.`id`, `Category`.`name` FROM `nwkv_categories` AS `Category` WHERE `Category`.`id` = 3 110
14SELECT `Category`.`id`, `Category`.`name` FROM `nwkv_categories` AS `Category` WHERE `Category`.`id` = 6 114
15SELECT `Category`.`id`, `Category`.`name` FROM `nwkv_categories` AS `Category` WHERE `Category`.`id` = 2 111
16SELECT `Category`.`id`, `Category`.`name` FROM `nwkv_categories` AS `Category` WHERE `Category`.`id` = 6 110
17SELECT `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 111
18SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`permission` FROM `nwkv_groups` AS `Group` WHERE `Group`.`id` = 5 111
19SELECT `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
20SELECT `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 111
21SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`permission` FROM `nwkv_groups` AS `Group` WHERE `Group`.`id` = 5 110
22SELECT `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
23SELECT `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
24SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`permission` FROM `nwkv_groups` AS `Group` WHERE `Group`.`id` = 5 111
25SELECT `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 002
26SELECT `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 001
27SELECT `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
28SELECT `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 1113
29SELECT `Attachment`.`id`, `Attachment`.`file`, `Attachment`.`type`, `Attachment`.`created`, `Attachment`.`event_id`, `Attachment`.`checksum` FROM `nwkv_attachments` AS `Attachment` WHERE `Attachment`.`event_id` = (550) 001
30SELECT `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 11163
31SELECT `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
32SELECT `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 4441