Tussenstand pubquiz

2012-01-15 23:36:00, geplaatst door Accie

De tussenstand van de pubquiz is weer bijgewerkt.


Bijlages

  • :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

(default) 37 queries took 280 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `newsitems`999
2DESCRIBE `metagroups`559
3DESCRIBE `groups`8810
4DESCRIBE `groups_users`4410
5DESCRIBE `donitasusers`414111
6SET NAMES 'UTF8'00
7DESCRIBE `groupfunctions`3310
8DESCRIBE `messageboards_metagroups`4410
9DESCRIBE `messageboards`4410
10DESCRIBE `notes`5510
11DESCRIBE `notes_metagroups`4410
12DESCRIBE `comments`111110
13DESCRIBE `calendars_metagroups`4410
14DESCRIBE `calendars`2210
15DESCRIBE `calendaritems`101010
16DESCRIBE `attachments`121210
17DESCRIBE `attachments_newsitems`3310
18DESCRIBE `smileys`3311
19DESCRIBE `logs`101010
20SELECT `Newsitem`.`id`, `Newsitem`.`title`, `Newsitem`.`preview`, `Newsitem`.`message`, `Newsitem`.`date`, `Newsitem`.`enddate`, `Newsitem`.`metagroup_id`, `Newsitem`.`isledenonly`, `Newsitem`.`isimportant`, `Metagroup`.`id`, `Metagroup`.`group_id`, `Metagroup`.`groupfunction_id`, `Metagroup`.`name`, `Metagroup`.`isvisible` FROM `newsitems` AS `Newsitem` LEFT JOIN `metagroups` AS `Metagroup` ON (`Newsitem`.`metagroup_id` = `Metagroup`.`id`) WHERE `Newsitem`.`id` = 416 AND `date` > '1329979771' AND `isledenonly` = 0 LIMIT 1110
21SELECT `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` = 416 AND `AttachmentsNewsitem`.`attachment_id` = `Attachment`.`id`) 110
22DESCRIBE `commentstats`449
23DESCRIBE `photos`131310
24DESCRIBE `photoalbums`101010
25DESCRIBE `photo_votes`6610
26SHOW COLUMNS FROM comments LIKE 'on_type'1110
27SELECT `Smiley`.`id`, `Smiley`.`tag`, `Smiley`.`image` FROM `smileys` AS `Smiley` WHERE 1 = 1 ORDER BY char_length(tag) desc 55550
28SHOW COLUMNS FROM comments LIKE 'on_type'119
29SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` WHERE `Comment`.`on_id` = 416 AND `Comment`.`on_type` = 'newsitem' 110
30SELECT `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` = 416 AND `Comment`.`on_type` = 'newsitem' ORDER BY `Comment`.`created` desc LIMIT 30000
31SELECT `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
32SELECT `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
33DESCRIBE `matches`272710
34DESCRIBE `clubs`449
35DESCRIBE `sportshalls`9911
36DESCRIBE `nevobo_regions`4410
37SELECT `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 001