Anton Rademaker - Alumnitater

Over Anton Rademaker

Leeftijd:
28 jaar
Lengte:
1.88m
Studie:
Afgestudeerd Informatica, werken @ Netsupport
Favo quote:
Shoot for the moon. Even if you miss, you’ll land among the stars. - Les Brown

Donitas

Commissie:
Alumnicie
Commissie:
Alumnitaters
(default) 39 queries took 239 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `donitasusers`414111
2DESCRIBE `groups_users`4411
3DESCRIBE `groups`889
4DESCRIBE `metagroups`559
5DESCRIBE `groupfunctions`3310
6SET NAMES 'UTF8'00
7DESCRIBE `messageboards_metagroups`4410
8DESCRIBE `messageboards`4410
9DESCRIBE `notes`5510
10DESCRIBE `notes_metagroups`4410
11DESCRIBE `comments`111110
12DESCRIBE `calendars_metagroups`4410
13DESCRIBE `calendars`2210
14DESCRIBE `calendaritems`101010
15DESCRIBE `trainings`101010
16DESCRIBE `logins`4410
17DESCRIBE `logs`101010
18SELECT `Donitasuser`.`id`, `Donitasuser`.`username`, `Donitasuser`.`password`, `Donitasuser`.`displayname`, `Donitasuser`.`email`, `Donitasuser`.`website`, `Donitasuser`.`created`, `Donitasuser`.`modified`, `Donitasuser`.`address`, `Donitasuser`.`streetnumber`, `Donitasuser`.`zipcode`, `Donitasuser`.`city`, `Donitasuser`.`phonenumber`, `Donitasuser`.`mobilenumber`, `Donitasuser`.`name`, `Donitasuser`.`firstname`, `Donitasuser`.`tussenvoegsel`, `Donitasuser`.`lastname`, `Donitasuser`.`msn`, `Donitasuser`.`birthday`, `Donitasuser`.`length`, `Donitasuser`.`nevobonumber`, `Donitasuser`.`registrationtype`, `Donitasuser`.`registrationnumber`, `Donitasuser`.`position`, `Donitasuser`.`quote`, `Donitasuser`.`aboutuser`, `Donitasuser`.`userstatus`, `Donitasuser`.`receivenewsletter`, `Donitasuser`.`gg_check`, `Donitasuser`.`showsmileys`, `Donitasuser`.`showimages`, `Donitasuser`.`shirtnumber`, `Donitasuser`.`numberofpostsperpage`, `Donitasuser`.`mijndonitas`, `Donitasuser`.`old_user_id`, `Donitasuser`.`study`, `Donitasuser`.`civilstatus`, `Donitasuser`.`lastlogin`, `Donitasuser`.`logins`, `Donitasuser`.`rsskey` FROM `donitasusers` AS `Donitasuser` WHERE `Donitasuser`.`id` = 1 LIMIT 1110
19SELECT `GroupsUser`.`id`, `GroupsUser`.`user_id`, `GroupsUser`.`group_id`, `GroupsUser`.`groupfunction_id` FROM `groups_users` AS `GroupsUser` WHERE `GroupsUser`.`user_id` = (1) 330
20SELECT `Donitasuser`.`id`, `Donitasuser`.`username`, `Donitasuser`.`password`, `Donitasuser`.`displayname`, `Donitasuser`.`email`, `Donitasuser`.`website`, `Donitasuser`.`created`, `Donitasuser`.`modified`, `Donitasuser`.`address`, `Donitasuser`.`streetnumber`, `Donitasuser`.`zipcode`, `Donitasuser`.`city`, `Donitasuser`.`phonenumber`, `Donitasuser`.`mobilenumber`, `Donitasuser`.`name`, `Donitasuser`.`firstname`, `Donitasuser`.`tussenvoegsel`, `Donitasuser`.`lastname`, `Donitasuser`.`msn`, `Donitasuser`.`birthday`, `Donitasuser`.`length`, `Donitasuser`.`nevobonumber`, `Donitasuser`.`registrationtype`, `Donitasuser`.`registrationnumber`, `Donitasuser`.`position`, `Donitasuser`.`quote`, `Donitasuser`.`aboutuser`, `Donitasuser`.`userstatus`, `Donitasuser`.`receivenewsletter`, `Donitasuser`.`gg_check`, `Donitasuser`.`showsmileys`, `Donitasuser`.`showimages`, `Donitasuser`.`shirtnumber`, `Donitasuser`.`numberofpostsperpage`, `Donitasuser`.`mijndonitas`, `Donitasuser`.`old_user_id`, `Donitasuser`.`study`, `Donitasuser`.`civilstatus`, `Donitasuser`.`lastlogin`, `Donitasuser`.`logins`, `Donitasuser`.`rsskey` FROM `donitasusers` AS `Donitasuser` WHERE `Donitasuser`.`id` = 1 ORDER BY `Donitasuser`.`Position` ASC, `Donitasuser`.`lastname` ASC, `Donitasuser`.`firstname` ASC 110
21SELECT `Donitasuser`.`id`, `Donitasuser`.`username`, `Donitasuser`.`password`, `Donitasuser`.`displayname`, `Donitasuser`.`email`, `Donitasuser`.`website`, `Donitasuser`.`created`, `Donitasuser`.`modified`, `Donitasuser`.`address`, `Donitasuser`.`streetnumber`, `Donitasuser`.`zipcode`, `Donitasuser`.`city`, `Donitasuser`.`phonenumber`, `Donitasuser`.`mobilenumber`, `Donitasuser`.`name`, `Donitasuser`.`firstname`, `Donitasuser`.`tussenvoegsel`, `Donitasuser`.`lastname`, `Donitasuser`.`msn`, `Donitasuser`.`birthday`, `Donitasuser`.`length`, `Donitasuser`.`nevobonumber`, `Donitasuser`.`registrationtype`, `Donitasuser`.`registrationnumber`, `Donitasuser`.`position`, `Donitasuser`.`quote`, `Donitasuser`.`aboutuser`, `Donitasuser`.`userstatus`, `Donitasuser`.`receivenewsletter`, `Donitasuser`.`gg_check`, `Donitasuser`.`showsmileys`, `Donitasuser`.`showimages`, `Donitasuser`.`shirtnumber`, `Donitasuser`.`numberofpostsperpage`, `Donitasuser`.`mijndonitas`, `Donitasuser`.`old_user_id`, `Donitasuser`.`study`, `Donitasuser`.`civilstatus`, `Donitasuser`.`lastlogin`, `Donitasuser`.`logins`, `Donitasuser`.`rsskey` FROM `donitasusers` AS `Donitasuser` WHERE `Donitasuser`.`id` = 1 ORDER BY `Donitasuser`.`Position` ASC, `Donitasuser`.`lastname` ASC, `Donitasuser`.`firstname` ASC 110
22SELECT `Donitasuser`.`id`, `Donitasuser`.`username`, `Donitasuser`.`password`, `Donitasuser`.`displayname`, `Donitasuser`.`email`, `Donitasuser`.`website`, `Donitasuser`.`created`, `Donitasuser`.`modified`, `Donitasuser`.`address`, `Donitasuser`.`streetnumber`, `Donitasuser`.`zipcode`, `Donitasuser`.`city`, `Donitasuser`.`phonenumber`, `Donitasuser`.`mobilenumber`, `Donitasuser`.`name`, `Donitasuser`.`firstname`, `Donitasuser`.`tussenvoegsel`, `Donitasuser`.`lastname`, `Donitasuser`.`msn`, `Donitasuser`.`birthday`, `Donitasuser`.`length`, `Donitasuser`.`nevobonumber`, `Donitasuser`.`registrationtype`, `Donitasuser`.`registrationnumber`, `Donitasuser`.`position`, `Donitasuser`.`quote`, `Donitasuser`.`aboutuser`, `Donitasuser`.`userstatus`, `Donitasuser`.`receivenewsletter`, `Donitasuser`.`gg_check`, `Donitasuser`.`showsmileys`, `Donitasuser`.`showimages`, `Donitasuser`.`shirtnumber`, `Donitasuser`.`numberofpostsperpage`, `Donitasuser`.`mijndonitas`, `Donitasuser`.`old_user_id`, `Donitasuser`.`study`, `Donitasuser`.`civilstatus`, `Donitasuser`.`lastlogin`, `Donitasuser`.`logins`, `Donitasuser`.`rsskey` FROM `donitasusers` AS `Donitasuser` WHERE `Donitasuser`.`id` = 1 ORDER BY `Donitasuser`.`Position` ASC, `Donitasuser`.`lastname` ASC, `Donitasuser`.`firstname` ASC 110
23SELECT `Group`.`id`, `Group`.`alias_id`, `Group`.`type`, `Group`.`name`, `Group`.`email`, `Group`.`teamtype`, `Group`.`teamnumber`, `Group`.`photo` FROM `groups` AS `Group` WHERE `Group`.`id` = 198 110
24SELECT `Group`.`id`, `Group`.`alias_id`, `Group`.`type`, `Group`.`name`, `Group`.`email`, `Group`.`teamtype`, `Group`.`teamnumber`, `Group`.`photo` FROM `groups` AS `Group` WHERE `Group`.`id` = 179 110
25SELECT `Group`.`id`, `Group`.`alias_id`, `Group`.`type`, `Group`.`name`, `Group`.`email`, `Group`.`teamtype`, `Group`.`teamnumber`, `Group`.`photo` FROM `groups` AS `Group` WHERE `Group`.`id` = 4 110
26SELECT `Groupfunction`.`id`, `Groupfunction`.`name`, `Groupfunction`.`hasrights` FROM `groupfunctions` AS `Groupfunction` WHERE `Groupfunction`.`id` = 0 110
27SELECT `Groupfunction`.`id`, `Groupfunction`.`name`, `Groupfunction`.`hasrights` FROM `groupfunctions` AS `Groupfunction` WHERE `Groupfunction`.`id` = 0 110
28SELECT `Groupfunction`.`id`, `Groupfunction`.`name`, `Groupfunction`.`hasrights` FROM `groupfunctions` AS `Groupfunction` WHERE `Groupfunction`.`id` = 0 110
29DESCRIBE `newsitems`999
30DESCRIBE `attachments`12129
31DESCRIBE `attachments_newsitems`3310
32DESCRIBE `smileys`3310
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
35DESCRIBE `matches`272710
36DESCRIBE `clubs`4410
37DESCRIBE `sportshalls`9910
38DESCRIBE `nevobo_regions`4410
39SELECT `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