#> GENERAL MESSAGES
#> DATABASE
Querycount: 50
Queries:
* SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'
* SELECT l.`tag` AS `_tag`, l.`name` AS `_name`, l.`dutch` AS `_dutch`, l.`enabled` AS `_enabled`, l.`order` AS `_order` FROM `languages` AS l WHERE `enabled` = 1 ORDER BY l.`order` ASC
* SELECT d.`hostname` AS `_hostname`, d.`lang` AS `_lang`, d.`siteid` AS `_siteid`, d.`locale` AS `_locale`, d.`UAcode` AS `_UAcode`, d.`title` AS `_title`, d.`enabled` AS `_enabled`, d.`default` AS `_default`, d.`priority` AS `_priority`, d.`subroot` AS `_subroot` FROM `domains` AS d WHERE `siteid` <> 0 AND (`default` = 1 OR `enabled` = 1) ORDER BY `priority`, `hostname` ASC
* SELECT s.`id` AS `_id`, s.`name` AS `_name`, s.`organisation` AS `_organisation`, s.`southwest` AS `_southwest`, s.`northeast` AS `_northeast`, s.`phone` AS `_phone`, s.`theme` AS `_theme` FROM `sites` AS s WHERE `id` = 1 LIMIT 1
* INSERT INTO `sessions` (`checkstring`,`startdate`,`iplocked`,`persistent`,`destroyed`) VALUES ("XXtpTfT4dxFlz5qbxKNAKHVe3G8UZvJF6BHoIc_Z",NOW(),0,0,0)
* SELECT s.`id` AS `_id`, s.`userid` AS `_userid`, s.`checkstring` AS `_checkstring`, s.`startdate` AS `_startdate_str`, s.`expiredate` AS `_expiredate_str`, s.`lastaccess` AS `_lastaccess_str`, s.`ip` AS `_ip`, s.`iplocked` AS `_iplocked`, s.`persistent` AS `_persistent`, s.`browser` AS `_browser`, s.`hits` AS `_hits`, s.`destroyed` AS `_destroyed`, s.`data` AS `_data` FROM `sessions` AS s WHERE `id` = 80306 LIMIT 1
* SELECT t.`id` FROM `tree` AS t INNER JOIN `tree_nodenames` AS n ON (n.`nodeid` = t.`id` AND n.`lang` = "nl") WHERE t.`parentid` IS NULL AND (0=1 OR t.`siteid` = 1 OR t.`siteid` IS NULL) AND n.`name` = "tags"
* SELECT t.`id` AS `_id`, t.`siteid` AS `_siteid`, t.`parentid` AS `_parentid`, t.`targetid` AS `_targetid`, t.`depth` AS `_depth`, t.`type` AS `_type`, t.`order` AS `_order`, t.`inmenu` AS `_inmenu`, t.`modified` AS `_modified_str` FROM `tree` AS t WHERE `id` = 31 AND (t.`siteid` = 1 OR t.`siteid` IS NULL) LIMIT 1
* SELECT t.`nodeid` AS `_nodeid`, t.`lang` AS `_lang`, t.`name` AS `_name`, t.`link` AS `_link`, t.`url` AS `_url` FROM `tree_content` AS t WHERE `nodeid` = 31 AND `lang` = "nl" LIMIT 1
* SELECT t.`id` FROM `tree` AS t INNER JOIN `tree_nodenames` AS n ON (n.`nodeid` = t.`id` AND n.`lang` = "nl") WHERE t.`parentid` = 31 AND (0=1 OR t.`siteid` = 1 OR t.`siteid` IS NULL) AND n.`name` = "budget"
* SELECT t.`id` AS `_id`, t.`groupid` AS `_groupid`, t.`siteid` AS `_siteid`, t.`relevance` AS `_relevance`, t.`modified` AS `_modified_str` FROM `tags` AS t INNER JOIN `tag_content` AS c ON (t.`id` = c.`tagid` AND `lang` = "nl") WHERE t.`siteid` in (1) AND c.`slug` = "budget"
* SELECT t.`tagid` AS `_tagid`, t.`lang` AS `_lang`, t.`text` AS `_text`, t.`slug` AS `_slug`, t.`description` AS `_description`, t.`content_html` AS `_content_html`, t.`content_src` AS `_content_src` FROM `tag_content` AS t WHERE `tagid` = 59 AND `lang` = "nl" LIMIT 1
* SELECT projectid AS `id`, SUM(CASE WHEN `tagid` = 59 THEN LEAST(1000,`normalised`) ELSE 0 END) AS `match` FROM `project_x_tags` WHERE `tagid` IN (59) AND `projectid` IN (SELECT p.`id` FROM `projects` AS p INNER JOIN `project_content` AS c ON (p.`id` = c.`projectid` AND `lang` = "nl") WHERE p.`siteid` in (1) AND p.`pubdate` < "2025-12-11 15:08:41" AND (p.`expiredate` IS NULL OR p.`expiredate` > "2025-12-11 15:08:41") AND NOT p.`engineering_project` AND c.`title` <> "") GROUP BY `projectid` ORDER BY `match` DESC LIMIT 5
* ABBR: SELECT p.`id` AS `_id`, p.`siteid` AS `_siteid`, p.`imageid` AS `_imageid`, p.`fileid` AS `_fileid`, p.`highlighted` AS `_highlighted`, p.`class` AS `_class`, p.`client` AS `_client`, p.`design_from` AS `_design_from_str`, p.`design_until` AS `_design_until_str`, p.`built_from` AS `_built_from_str`, p.`built_until` AS `_built_until_str`, p.`date_dsp_depth` AS `_date_dsp_depth`, p.`area` AS `_area`, p.`area_new` AS `_area_new`, p.`area_renovated` AS `_area_renovated`, p.`address` AS `_address`, p.`city` AS `_city`, p.`countrytag` AS `_countrytag`, p.`autolatlong` AS `_autolatlong`, p.`latlong` AS `_latlong`, p.`lat` AS `_lat`, p.`long` AS `_long`, p.`facebook_url` AS `_facebook_url`, p.`website_url` AS `_website_url`, p.`vimeo_url` AS `_vimeo_url`, p.`panorama` AS `_panorama`, p.`pubdate` AS `_pubdate_str`, p.`expiredate` AS `_expiredate_str`, p.`modified` AS `_modifi...
* SELECT craftmanshipid AS `id`, SUM(CASE WHEN `tagid` = 59 THEN LEAST(1000,`normalised`) ELSE 0 END) AS `match` FROM `craftmanship_x_tags` WHERE `tagid` IN (59) AND `craftmanshipid` IN (SELECT c.`id` FROM `craftmanships` AS c INNER JOIN `craftmanship_content` AS ct ON (c.`id` = ct.`craftmanshipid` AND `lang` = "nl") WHERE ct.`title` <> "" AND c.`siteid` in (1)) GROUP BY `craftmanshipid` ORDER BY `match` DESC LIMIT 5
* SELECT newsitemid AS `id`, SUM(CASE WHEN `tagid` = 59 THEN LEAST(1000,`normalised`) ELSE 0 END) AS `match` FROM `newsitem_x_tags` WHERE `tagid` IN (59) AND `newsitemid` IN (SELECT n.`id` FROM `newsitems` AS n INNER JOIN `newsitem_content` AS c ON (n.`id` = c.`newsitemid` AND `lang` = "nl") WHERE c.`title` <> "" AND n.`pubdate` < "2025-12-11 15:08:41" AND n.`siteid` in (1)) GROUP BY `newsitemid` ORDER BY `match` DESC LIMIT 5
* SELECT n.`id` AS `_id`, n.`siteid` AS `_siteid`, n.`source` AS `_source`, n.`type` AS `_type`, n.`imageid` AS `_imageid`, n.`video` AS `_video`, n.`date` AS `_date_str`, n.`time` AS `_time_str`, n.`authorid` AS `_authorid`, n.`pubdate` AS `_pubdate_str`, n.`modified` AS `_modified_str` FROM `newsitems` AS n WHERE `id` IN (18,10)
* SELECT employeeid AS `id`, SUM(CASE WHEN `tagid` = 59 THEN LEAST(1000,`normalised`) ELSE 0 END) AS `match` FROM `employee_x_tags` WHERE `tagid` IN (59) AND `employeeid` IN (SELECT e.`id` FROM `employees` AS e INNER JOIN `employee_content` AS c ON (e.`id` = c.`employeeid` AND `lang` = "nl") WHERE e.`siteid` in (1) AND c.`title` <> "") GROUP BY `employeeid` ORDER BY `match` DESC LIMIT 5
* SELECT t.`id` AS `_id`, t.`siteid` AS `_siteid`, t.`parentid` AS `_parentid`, t.`targetid` AS `_targetid`, t.`depth` AS `_depth`, t.`type` AS `_type`, t.`order` AS `_order`, t.`inmenu` AS `_inmenu`, t.`modified` AS `_modified_str` FROM `tree` AS t WHERE `type` IN (36) AND (t.`siteid` = 1 OR t.`siteid` IS NULL)
* SELECT t.`nodeid` AS `_nodeid`, t.`lang` AS `_lang`, t.`name` AS `_name`, t.`link` AS `_link`, t.`url` AS `_url` FROM `tree_content` AS t WHERE `nodeid` = 13 AND `lang` = "nl" LIMIT 1
* SELECT t.`id` AS `_id`, t.`siteid` AS `_siteid`, t.`parentid` AS `_parentid`, t.`targetid` AS `_targetid`, t.`depth` AS `_depth`, t.`type` AS `_type`, t.`order` AS `_order`, t.`inmenu` AS `_inmenu`, t.`modified` AS `_modified_str` FROM `tree` AS t WHERE `type` IN (40) AND (t.`siteid` = 1 OR t.`siteid` IS NULL)
* SELECT d.`hostname` AS `_hostname`, d.`lang` AS `_lang`, d.`siteid` AS `_siteid`, d.`locale` AS `_locale`, d.`UAcode` AS `_UAcode`, d.`title` AS `_title`, d.`enabled` AS `_enabled`, d.`default` AS `_default`, d.`priority` AS `_priority`, d.`subroot` AS `_subroot` FROM `domains` AS d WHERE `siteid` = 1 AND (`default` = 1 OR `enabled` = 1) ORDER BY `priority`, `hostname` ASC
* SELECT p.`projectid` AS `_projectid`, p.`fileid` AS `_fileid`, p.`itl_facebook_url` AS `_itl_facebook_url`, p.`itl_website_url` AS `_itl_website_url`, p.`area_custom_label` AS `_area_custom_label`, p.`lang` AS `_lang`, p.`name` AS `_name`, p.`title` AS `_title`, p.`subtitle` AS `_subtitle`, p.`slug` AS `_slug`, p.`description` AS `_description`, p.`content_html` AS `_content_html`, p.`content_src` AS `_content_src` FROM `project_content` AS p WHERE `projectid` = 7 AND `lang` = "nl" LIMIT 1
* SELECT t.`id` AS `_id`, t.`siteid` AS `_siteid`, t.`parentid` AS `_parentid`, t.`targetid` AS `_targetid`, t.`depth` AS `_depth`, t.`type` AS `_type`, t.`order` AS `_order`, t.`inmenu` AS `_inmenu`, t.`modified` AS `_modified_str` FROM `tree` AS t WHERE `type` IN (38) AND (t.`siteid` = 1 OR t.`siteid` IS NULL)
* SELECT t.`nodeid` AS `_nodeid`, t.`lang` AS `_lang`, t.`name` AS `_name`, t.`link` AS `_link`, t.`url` AS `_url` FROM `tree_content` AS t WHERE `nodeid` = 20 AND `lang` = "nl" LIMIT 1
* SELECT i.`id` AS `_id`, i.`type` AS `_type`, i.`basename` AS `_basename`, i.`width` AS `_width`, i.`height` AS `_height`, i.`size` AS `_size`, i.`hash` AS `_hash`, i.`panorama` AS `_panorama`, i.`added` AS `_added_str`, i.`modified` AS `_modified_str`, i.`added_by` AS `_added_by`, i.`protected` AS `_protected`, i.`crop_side` AS `_crop_side` FROM `images` AS i WHERE `id` = 514 LIMIT 1
* SELECT t.`id` AS `_id`, t.`siteid` AS `_siteid`, t.`parentid` AS `_parentid`, t.`targetid` AS `_targetid`, t.`depth` AS `_depth`, t.`type` AS `_type`, t.`order` AS `_order`, t.`inmenu` AS `_inmenu`, t.`modified` AS `_modified_str` FROM `tree` AS t WHERE `type` IN (32) AND (t.`siteid` = 1 OR t.`siteid` IS NULL)
* SELECT t.`nodeid` AS `_nodeid`, t.`lang` AS `_lang`, t.`name` AS `_name`, t.`link` AS `_link`, t.`url` AS `_url` FROM `tree_content` AS t WHERE `nodeid` = 11 AND `lang` = "nl" LIMIT 1
* SELECT n.`newsitemid` AS `_newsitemid`, n.`lang` AS `_lang`, n.`title` AS `_title`, n.`slug` AS `_slug`, n.`description` AS `_description`, n.`content_html` AS `_content_html`, n.`content_src` AS `_content_src` FROM `newsitem_content` AS n WHERE `newsitemid` = 18 AND `lang` = "nl" LIMIT 1
* SELECT i.`id` AS `_id`, i.`type` AS `_type`, i.`basename` AS `_basename`, i.`width` AS `_width`, i.`height` AS `_height`, i.`size` AS `_size`, i.`hash` AS `_hash`, i.`panorama` AS `_panorama`, i.`added` AS `_added_str`, i.`modified` AS `_modified_str`, i.`added_by` AS `_added_by`, i.`protected` AS `_protected`, i.`crop_side` AS `_crop_side` FROM `images` AS i WHERE `id` = 83 LIMIT 1
* SELECT p.`projectid` AS `_projectid`, p.`fileid` AS `_fileid`, p.`itl_facebook_url` AS `_itl_facebook_url`, p.`itl_website_url` AS `_itl_website_url`, p.`area_custom_label` AS `_area_custom_label`, p.`lang` AS `_lang`, p.`name` AS `_name`, p.`title` AS `_title`, p.`subtitle` AS `_subtitle`, p.`slug` AS `_slug`, p.`description` AS `_description`, p.`content_html` AS `_content_html`, p.`content_src` AS `_content_src` FROM `project_content` AS p WHERE `projectid` = 28 AND `lang` = "nl" LIMIT 1
* SELECT i.`id` AS `_id`, i.`type` AS `_type`, i.`basename` AS `_basename`, i.`width` AS `_width`, i.`height` AS `_height`, i.`size` AS `_size`, i.`hash` AS `_hash`, i.`panorama` AS `_panorama`, i.`added` AS `_added_str`, i.`modified` AS `_modified_str`, i.`added_by` AS `_added_by`, i.`protected` AS `_protected`, i.`crop_side` AS `_crop_side` FROM `images` AS i WHERE `id` = 356 LIMIT 1
* SELECT p.`projectid` AS `_projectid`, p.`fileid` AS `_fileid`, p.`itl_facebook_url` AS `_itl_facebook_url`, p.`itl_website_url` AS `_itl_website_url`, p.`area_custom_label` AS `_area_custom_label`, p.`lang` AS `_lang`, p.`name` AS `_name`, p.`title` AS `_title`, p.`subtitle` AS `_subtitle`, p.`slug` AS `_slug`, p.`description` AS `_description`, p.`content_html` AS `_content_html`, p.`content_src` AS `_content_src` FROM `project_content` AS p WHERE `projectid` = 11 AND `lang` = "nl" LIMIT 1
* SELECT i.`id` AS `_id`, i.`type` AS `_type`, i.`basename` AS `_basename`, i.`width` AS `_width`, i.`height` AS `_height`, i.`size` AS `_size`, i.`hash` AS `_hash`, i.`panorama` AS `_panorama`, i.`added` AS `_added_str`, i.`modified` AS `_modified_str`, i.`added_by` AS `_added_by`, i.`protected` AS `_protected`, i.`crop_side` AS `_crop_side` FROM `images` AS i WHERE `id` = 258 LIMIT 1
* SELECT p.`projectid` AS `_projectid`, p.`fileid` AS `_fileid`, p.`itl_facebook_url` AS `_itl_facebook_url`, p.`itl_website_url` AS `_itl_website_url`, p.`area_custom_label` AS `_area_custom_label`, p.`lang` AS `_lang`, p.`name` AS `_name`, p.`title` AS `_title`, p.`subtitle` AS `_subtitle`, p.`slug` AS `_slug`, p.`description` AS `_description`, p.`content_html` AS `_content_html`, p.`content_src` AS `_content_src` FROM `project_content` AS p WHERE `projectid` = 27 AND `lang` = "nl" LIMIT 1
* SELECT i.`id` AS `_id`, i.`type` AS `_type`, i.`basename` AS `_basename`, i.`width` AS `_width`, i.`height` AS `_height`, i.`size` AS `_size`, i.`hash` AS `_hash`, i.`panorama` AS `_panorama`, i.`added` AS `_added_str`, i.`modified` AS `_modified_str`, i.`added_by` AS `_added_by`, i.`protected` AS `_protected`, i.`crop_side` AS `_crop_side` FROM `images` AS i WHERE `id` = 349 LIMIT 1
* SELECT n.`newsitemid` AS `_newsitemid`, n.`lang` AS `_lang`, n.`title` AS `_title`, n.`slug` AS `_slug`, n.`description` AS `_description`, n.`content_html` AS `_content_html`, n.`content_src` AS `_content_src` FROM `newsitem_content` AS n WHERE `newsitemid` = 10 AND `lang` = "nl" LIMIT 1
* SELECT i.`id` AS `_id`, i.`type` AS `_type`, i.`basename` AS `_basename`, i.`width` AS `_width`, i.`height` AS `_height`, i.`size` AS `_size`, i.`hash` AS `_hash`, i.`panorama` AS `_panorama`, i.`added` AS `_added_str`, i.`modified` AS `_modified_str`, i.`added_by` AS `_added_by`, i.`protected` AS `_protected`, i.`crop_side` AS `_crop_side` FROM `images` AS i WHERE `id` = 93 LIMIT 1
* SELECT p.`projectid` AS `_projectid`, p.`fileid` AS `_fileid`, p.`itl_facebook_url` AS `_itl_facebook_url`, p.`itl_website_url` AS `_itl_website_url`, p.`area_custom_label` AS `_area_custom_label`, p.`lang` AS `_lang`, p.`name` AS `_name`, p.`title` AS `_title`, p.`subtitle` AS `_subtitle`, p.`slug` AS `_slug`, p.`description` AS `_description`, p.`content_html` AS `_content_html`, p.`content_src` AS `_content_src` FROM `project_content` AS p WHERE `projectid` = 10 AND `lang` = "nl" LIMIT 1
* SELECT i.`id` AS `_id`, i.`type` AS `_type`, i.`basename` AS `_basename`, i.`width` AS `_width`, i.`height` AS `_height`, i.`size` AS `_size`, i.`hash` AS `_hash`, i.`panorama` AS `_panorama`, i.`added` AS `_added_str`, i.`modified` AS `_modified_str`, i.`added_by` AS `_added_by`, i.`protected` AS `_protected`, i.`crop_side` AS `_crop_side` FROM `images` AS i WHERE `id` = 88 LIMIT 1
* SELECT t.`id` AS `_id`, t.`siteid` AS `_siteid`, t.`parentid` AS `_parentid`, t.`targetid` AS `_targetid`, t.`depth` AS `_depth`, t.`type` AS `_type`, t.`order` AS `_order`, t.`inmenu` AS `_inmenu`, t.`modified` AS `_modified_str` FROM `tree` AS t LEFT JOIN `pages` AS p ON t.`id` = p.`id` INNER JOIN `tree_content` AS c ON (t.`id` = c.`nodeid` AND c.`lang` = "nl") WHERE `type` IN (1,32,33,35,38,39,44) AND (`siteid` IS NULL OR `siteid` in (1,1)) AND (p.`id` IS NULL OR ( p.`pubdate` < NOW() AND (p.`expiredate` IS NULL OR p.`expiredate` > NOW()) ) ) AND `depth` <= 2 AND `inmenu` AND c.name <> "" ORDER BY `depth` ASC,`order` ASC
* SELECT t.`nodeid` AS `_nodeid`, t.`lang` AS `_lang`, t.`name` AS `_name`, t.`link` AS `_link`, t.`url` AS `_url` FROM `tree_content` AS t WHERE 1=1 AND `lang` = "nl" AND `nodeid` IN (34,21,20,11,22,27,28,23,24,29,25,30,26,31)
* SELECT t.`id` AS `_id`, t.`siteid` AS `_siteid`, t.`parentid` AS `_parentid`, t.`targetid` AS `_targetid`, t.`depth` AS `_depth`, t.`type` AS `_type`, t.`order` AS `_order`, t.`inmenu` AS `_inmenu`, t.`modified` AS `_modified_str` FROM `tree` AS t WHERE `type` IN (34) AND (t.`siteid` = 1 OR t.`siteid` IS NULL)
* SELECT t.`id` AS `_id`, t.`siteid` AS `_siteid`, t.`parentid` AS `_parentid`, t.`targetid` AS `_targetid`, t.`depth` AS `_depth`, t.`type` AS `_type`, t.`order` AS `_order`, t.`inmenu` AS `_inmenu`, t.`modified` AS `_modified_str` FROM `tree` AS t WHERE `type` IN (38) AND (t.`siteid` = 1 OR t.`siteid` IS NULL)
* SELECT t.`nodeid` AS `_nodeid`, t.`lang` AS `_lang`, t.`name` AS `_name`, t.`link` AS `_link`, t.`url` AS `_url` FROM `tree_content` AS t WHERE `nodeid` = 31 AND `lang` = "en" LIMIT 1
* SELECT p.`id` AS `_id`, p.`imageid` AS `_imageid`, p.`pubdate` AS `_pubdate_str`, p.`highlighted` AS `_highlighted`, p.`class` AS `_class`, p.`template` AS `_template`, p.`expiredate` AS `_expiredate_str`, p.`modified` AS `_modified_str`, p.`modified_byid` AS `_modified_byid` FROM `pages` AS p INNER JOIN `page_content` AS c ON (c.`staticpageid` = p.`id` AND c.`lang` = "nl") INNER JOIN `tree` AS tr ON (tr.`id` = p.`id`) WHERE c.`title` <> "" AND p.`pubdate` < "2025-12-11 15:08:41" AND (p.`expiredate` IS NULL OR p.`expiredate` > "2025-12-11 15:08:41") AND p.`template` = "ctpage" AND tr.`siteid` IN (1)
* SELECT `data` FROM `settings_data` WHERE `siteid` = 1 AND `name` = "social"
* SELECT t.`id` AS `_id`, t.`siteid` AS `_siteid`, t.`parentid` AS `_parentid`, t.`targetid` AS `_targetid`, t.`depth` AS `_depth`, t.`type` AS `_type`, t.`order` AS `_order`, t.`inmenu` AS `_inmenu`, t.`modified` AS `_modified_str` FROM `tree` AS t WHERE `id` = 32 AND (t.`siteid` = 1 OR t.`siteid` IS NULL) LIMIT 1
* SELECT t.`nodeid` AS `_nodeid`, t.`lang` AS `_lang`, t.`name` AS `_name`, t.`link` AS `_link`, t.`url` AS `_url` FROM `tree_content` AS t WHERE `nodeid` = 32 AND `lang` = "nl" LIMIT 1
* SELECT t.`nodeid` AS `_nodeid`, t.`lang` AS `_lang`, t.`name` AS `_name`, t.`link` AS `_link`, t.`url` AS `_url` FROM `tree_content` AS t WHERE `nodeid` = 10 AND `lang` = "nl" LIMIT 1
#> INCLUDES: 350 files
#> REQUEST
Processing time : 0.024399995803833
Request method : GET
HTTP POST : 0 vars
HTTP GET : 0 vars
HTTP COOKIE :0 vars
