Donitas D5 - Dovo D1 (2-3)

Nevobo code
DPA FD
Datum:
2011-10-15 00:00:00
Lokatie:
,
Veld:
Uitslag:
2-3 (21-25,18-25,25-20,25-23,11-15)
(default) 27 queries took 221 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `matches`272710
2DESCRIBE `clubs`449
3SET NAMES 'UTF8'00
4DESCRIBE `sportshalls`9910
5DESCRIBE `nevobo_regions`4410
6DESCRIBE `donitasusers`414111
7DESCRIBE `groups_users`4410
8DESCRIBE `groups`8810
9DESCRIBE `metagroups`5510
10DESCRIBE `groupfunctions`3310
11DESCRIBE `messageboards_metagroups`4411
12DESCRIBE `messageboards`4410
13DESCRIBE `notes`5510
14DESCRIBE `notes_metagroups`4410
15DESCRIBE `comments`111110
16DESCRIBE `calendars_metagroups`4410
17DESCRIBE `calendars`2210
18DESCRIBE `calendaritems`101010
19SELECT `Match`.`id`, `Match`.`random`, `Match`.`code`, `Match`.`cluba`, `Match`.`clubb`, `Match`.`teama`, `Match`.`teamb`, `Match`.`donitasteam`, `Match`.`startingtime`, `Match`.`pointsa`, `Match`.`pointsb`, `Match`.`sportshall`, `Match`.`field`, `Match`.`set1a`, `Match`.`set1b`, `Match`.`set2a`, `Match`.`set2b`, `Match`.`set3a`, `Match`.`set3b`, `Match`.`set4a`, `Match`.`set4b`, `Match`.`set5a`, `Match`.`set5b`, `Match`.`region`, `Match`.`checked`, `Match`.`created`, `Match`.`modified`, `ClubA`.`id`, `ClubA`.`name`, `ClubA`.`region2`, `ClubA`.`checked`, `ClubB`.`id`, `ClubB`.`name`, `ClubB`.`region2`, `ClubB`.`checked`, `Sporthall`.`id`, `Sporthall`.`name`, `Sporthall`.`street`, `Sporthall`.`zipcode`, `Sporthall`.`city`, `Sporthall`.`phone`, `Sporthall`.`checked`, `Sporthall`.`modified`, `Sporthall`.`created` FROM `matches` AS `Match` LEFT JOIN `clubs` AS `ClubA` ON (`Match`.`cluba` = `ClubA`.`id`) LEFT JOIN `clubs` AS `ClubB` ON (`Match`.`clubb` = `ClubB`.`id`) LEFT JOIN `sportshalls` AS `Sporthall` ON (`Match`.`sportshall` = `Sporthall`.`id`) WHERE `Match`.`id` = 2 LIMIT 1111
20DESCRIBE `newsitems`999
21DESCRIBE `attachments`12129
22DESCRIBE `attachments_newsitems`3310
23DESCRIBE `smileys`3310
24DESCRIBE `logs`101010
25SELECT `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
26SELECT `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
27SELECT `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