Commissies

Commissieleden

Jan

Foto Jan

Positie:
Hoofdaanvaller
Leeftijd:
27
Lengte:
1.85
Rugnummer:
48

Harrie (Voorzitter)

Foto Harrie

Positie:
Spelverdeler
Leeftijd:
23
Lengte:
1.90
Rugnummer:
2

Wouter

Foto Wouter

Positie:
Libero
Leeftijd:
27
Lengte:
1.86
Rugnummer:
12

Rob

Foto Rob

Positie:
Diagonaal
Leeftijd:
23
Lengte:
1.85
Rugnummer:
8
(default) 35 queries took 34 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `contentgroups`449
2DESCRIBE `contentgroups_htmlpages`4413
3DESCRIBE `htmlpages`7710
4SET NAMES 'UTF8'00
5SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 LIMIT 1110
6SELECT `ContentgroupsHtmlpage`.`id`, `ContentgroupsHtmlpage`.`htmlpage_id`, `ContentgroupsHtmlpage`.`contentgroup_id`, `ContentgroupsHtmlpage`.`ordering` FROM `contentgroups_htmlpages` AS `ContentgroupsHtmlpage` WHERE `ContentgroupsHtmlpage`.`contentgroup_id` = (7) ORDER BY `ContentgroupsHtmlpage`.`ordering` ASC 12120
7SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 16 110
8SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 22 110
9SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 24 110
10SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 15 110
11SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 25 110
12SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 23 110
13SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 26 110
14SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 27 110
15SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 91 110
16SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 28 110
17SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 29 110
18SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 65 110
19SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
20SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
21SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
22SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
23SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
24SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
25SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
26SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
27SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
28SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
29SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
30SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 7 110
31SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id`, `ContentgroupsHtmlpage`.`id`, `ContentgroupsHtmlpage`.`htmlpage_id`, `ContentgroupsHtmlpage`.`contentgroup_id`, `ContentgroupsHtmlpage`.`ordering` FROM `htmlpages` AS `Htmlpage` JOIN `contentgroups_htmlpages` AS `ContentgroupsHtmlpage` ON (`ContentgroupsHtmlpage`.`contentgroup_id` = 7 AND `ContentgroupsHtmlpage`.`htmlpage_id` = `Htmlpage`.`id`) 12120
32SELECT Donitasuser.name,Donitasuser.firstname,Donitasuser.id,Donitasuser.nevobonumber,Donitasuser.position,Donitasuser.birthday, Donitasuser.length ,Donitasuser.shirtnumber,GroupsUser.groupfunction_id,Groupfunction.name FROM groups_users as GroupsUser LEFT JOIN donitasusers as Donitasuser ON (GroupsUser.user_id = Donitasuser.id) LEFT JOIN groupfunctions as Groupfunction on (GroupsUser.groupfunction_id = Groupfunction.id) WHERE GroupsUser.group_id = 1 AND GroupsUser.groupfunction_id not in (3,4)441
33SELECT `Newsitem`.`id`, `Newsitem`.`title`, `Newsitem`.`message`, `Newsitem`.`preview` FROM `newsitems` AS `Newsitem` LEFT JOIN `metagroups` AS `Metagroup` ON (`Newsitem`.`metagroup_id` = `Metagroup`.`id`) WHERE isledenonly = 0 AND (metagroup_id = 31 OR metagroup_id = 3 OR metagroup_id = 45 OR metagroup_id = 35 OR metagroup_id = 34 OR metagroup_id = 33 OR metagroup_id = 32 OR metagroup_id = 36 OR metagroup_id = 42 OR metagroup_id = 40 OR metagroup_id = 39 OR metagroup_id = 43 OR metagroup_id = 15 OR metagroup_id = 14 OR metagroup_id = 50 OR metagroup_id = 51 OR metagroup_id = 41 ) AND (enddate > now() OR enddate = "0000-00-00 00:00:00" or enddate is null or enddate < date) AND date < now() ORDER BY `date` desc LIMIT 4441
34SELECT `Attachment`.`internalfilename`, `Attachment`.`showafter`, `Attachment`.`id`, `Attachment`.`size`, `Attachment`.`filename`, `Attachment`.`title`, `Attachment`.`categorie`, `Attachment`.`isloginrequired`, `Attachment`.`isdownload`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`user_id`, `AttachmentsNewsitem`.`id`, `AttachmentsNewsitem`.`attachment_id`, `AttachmentsNewsitem`.`newsitem_id` FROM `attachments` AS `Attachment` JOIN `attachments_newsitems` AS `AttachmentsNewsitem` ON (`AttachmentsNewsitem`.`newsitem_id` IN (424, 396, 392, 388) AND `AttachmentsNewsitem`.`attachment_id` = `Attachment`.`id`) 110
35SELECT `Calendaritem`.`id`, `Calendaritem`.`calendar_id`, `Calendaritem`.`startdate`, `Calendaritem`.`enddate`, `Calendaritem`.`title`, `Calendaritem`.`info`, `Calendaritem`.`location`, `Calendaritem`.`url`, `Calendaritem`.`modified`, `Calendaritem`.`created`, `Calendar`.`id`, `Calendar`.`name` FROM `calendaritems` AS `Calendaritem` LEFT JOIN `calendars` AS `Calendar` ON (`Calendaritem`.`calendar_id` = `Calendar`.`id`) WHERE calendar_id = 1 AND ((enddate > now() or enddate = "0000-00-00 00:00:00" or enddate is null or enddate < startdate) OR (enddate is null OR enddate < now())) AND startdate > now() ORDER BY `startdate` ASC 000