Gastenboek G.S.V.V. Donitas

Laatste wijziging: 2011-08-19 18:05:57

Notities

  • :knuffel:
  • :stupid:
  • :banana:
  • :woei:
  • :deal:
  • :brow:
  • :hug:
  • :bed:
  • :aai:
  • _O_
  • O-)
  • :Y)
  • ^O^
  • }:|
  • 8)7
  • 8-)
  • ;((
  • |:(
  • %O
  • %D
  • %L
  • %H
  • %J
  • %M
  • %P
  • :Y
  • %G
  • %N
  • %Z
  • :N
  • O+
  • :)
  • :(
  • :s
  • %R
  • %S
  • ;)
  • :$
  • :W
  • :X
  • :D
  • ;(
  • :r
  • :*
  • :O
  • :9
  • %B
  • %F
  • %V
  • %K
  • %W
  • :{
  • *;
  • :z
  • :P

Wie hebben toegang tot dit prikbord?

(default) 41 queries took 277 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `metagroups`5510
2DESCRIBE `groups`889
3DESCRIBE `groups_users`4410
4DESCRIBE `donitasusers`414111
5SET NAMES 'UTF8'00
6DESCRIBE `groupfunctions`3310
7DESCRIBE `messageboards_metagroups`449
8DESCRIBE `messageboards`4410
9DESCRIBE `notes`5510
10DESCRIBE `notes_metagroups`4410
11DESCRIBE `comments`111110
12DESCRIBE `calendars_metagroups`4410
13DESCRIBE `calendars`2210
14DESCRIBE `calendaritems`101010
15SELECT `Metagroup`.`id`, `Metagroup`.`group_id`, `Metagroup`.`groupfunction_id`, `Metagroup`.`name`, `Metagroup`.`isvisible`, `Group`.`id`, `Group`.`alias_id`, `Group`.`type`, `Group`.`name`, `Group`.`email`, `Group`.`teamtype`, `Group`.`teamnumber`, `Group`.`photo`, `Groupfunction`.`id`, `Groupfunction`.`name`, `Groupfunction`.`hasrights` FROM `metagroups` AS `Metagroup` LEFT JOIN `groups` AS `Group` ON (`Metagroup`.`group_id` = `Group`.`id`) LEFT JOIN `groupfunctions` AS `Groupfunction` ON (`Metagroup`.`groupfunction_id` = `Groupfunction`.`id`) WHERE `Metagroup`.`id` = 1 LIMIT 1110
16SELECT `MessageboardsMetagroup`.`id`, `MessageboardsMetagroup`.`messageboard_id`, `MessageboardsMetagroup`.`metagroup_id`, `MessageboardsMetagroup`.`rights` FROM `messageboards_metagroups` AS `MessageboardsMetagroup` WHERE `MessageboardsMetagroup`.`metagroup_id` = (1) 110
17SELECT `CalendarsMetagroup`.`id`, `CalendarsMetagroup`.`calendar_id`, `CalendarsMetagroup`.`metagroup_id`, `CalendarsMetagroup`.`rights` FROM `calendars_metagroups` AS `CalendarsMetagroup` WHERE `CalendarsMetagroup`.`metagroup_id` = (1) 110
18SELECT `NotesMetagroup`.`id`, `NotesMetagroup`.`note_id`, `NotesMetagroup`.`metagroup_id`, `NotesMetagroup`.`rights` FROM `notes_metagroups` AS `NotesMetagroup` WHERE `NotesMetagroup`.`metagroup_id` = (1) 110
19DESCRIBE `smileys`339
20SELECT `Note`.`id`, `Note`.`name`, `Note`.`message`, `Note`.`modified`, `Note`.`originalmessage`, `Messageboard`.`id`, `Messageboard`.`name`, `Messageboard`.`note_id`, `Messageboard`.`calendar_id` FROM `notes` AS `Note` LEFT JOIN `messageboards` AS `Messageboard` ON (`Messageboard`.`note_id` = `Note`.`id`) WHERE `Note`.`id` = 1 LIMIT 1110
21SELECT `NotesMetagroup`.`id`, `NotesMetagroup`.`note_id`, `NotesMetagroup`.`metagroup_id`, `NotesMetagroup`.`rights` FROM `notes_metagroups` AS `NotesMetagroup` WHERE `NotesMetagroup`.`note_id` = (1) 110
22DESCRIBE `commentstats`449
23DESCRIBE `newsitems`999
24DESCRIBE `attachments`12129
25DESCRIBE `attachments_newsitems`3310
26DESCRIBE `photos`131310
27DESCRIBE `photoalbums`101010
28DESCRIBE `photo_votes`6611
29DESCRIBE `logs`101012
30SHOW COLUMNS FROM comments LIKE 'on_type'1110
31SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` WHERE `Comment`.`on_id` = 1 AND `Comment`.`on_type` = 'messageboard' 110
32SELECT `Comment`.`id`, `Comment`.`on_type`, `Comment`.`on_id`, `Comment`.`flickr_id`, `Comment`.`message`, `Comment`.`user_id`, `Comment`.`displayname`, `Comment`.`email`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`ip` FROM `comments` AS `Comment` WHERE `Comment`.`on_id` = 1 AND `Comment`.`on_type` = 'messageboard' ORDER BY `Comment`.`created` desc LIMIT 30000
33SHOW COLUMNS FROM comments LIKE 'on_type'119
34SELECT `Smiley`.`id`, `Smiley`.`tag`, `Smiley`.`image` FROM `smileys` AS `Smiley` WHERE 1 = 1 ORDER BY char_length(tag) desc 55550
35SELECT `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
36SELECT `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 (418, 396, 392, 388) AND `AttachmentsNewsitem`.`attachment_id` = `Attachment`.`id`) 110
37DESCRIBE `matches`272710
38DESCRIBE `clubs`4410
39DESCRIBE `sportshalls`9910
40DESCRIBE `nevobo_regions`449
41SELECT `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