| 1 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`user_id`, `Setting`.`tab`, `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`is_default`, `Image`.`name`, `Image`.`size`, `Image`.`group`, `Image`.`ext`, `Image`.`type`, `Image`.`width`, `Image`.`height`, `Image`.`sortorder`, `Image`.`created`, `Image`.`modified` FROM `golf_live`.`settings` AS `Setting` LEFT JOIN `golf_live`.`files` AS `Image` ON (`Image`.`foreign_key` = `Setting`.`id` AND `Image`.`is_default` = '1' AND `Image`.`model` = 'Setting') WHERE `Setting`.`user_id` = 0 | | 209 | 209 | 0 |
| 2 | SELECT `T9n`.`locale`, `T9n`.`token`, `T9n`.`value` FROM `golf_live`.`t9n` AS `T9n` WHERE `T9n`.`area` = 'Frontend' AND `T9n`.`module` = 'Settings' AND `T9n`.`type` = 'setting' ORDER BY `T9n`.`area` ASC, `T9n`.`module` ASC, `T9n`.`type` ASC, `T9n`.`token` ASC | | 6 | 6 | 0 |
| 3 | SELECT `Club`.`id`, `I18n__Club__title__nl`.`content` FROM `golf_live`.`clubs` AS `Club` LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__title__nl` ON (`Club`.`id` = `I18n__Club__title__nl`.`foreign_key` AND `I18n__Club__title__nl`.`model` = 'Club' AND `I18n__Club__title__nl`.`field` = 'title' AND `I18n__Club__title__nl`.`locale` = 'nl') WHERE 1 = 1 | | 89 | 89 | 0 |
| 4 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = Club' | | 0 | 0 | 0 |
| 5 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'file_upload' | | 0 | 0 | 0 |
| 6 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'settings' | | 0 | 0 | 0 |
| 7 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 't9n' | | 0 | 0 | 0 |
| 8 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'user_management' | | 0 | 0 | 0 |
| 9 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'plugin_management' | | 0 | 0 | 0 |
| 10 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'menu_management' | | 0 | 0 | 0 |
| 11 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'help' | | 0 | 0 | 0 |
| 12 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'db_mail' | | 0 | 0 | 0 |
| 13 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'static_page' | | 10 | 10 | 0 |
| 14 | SELECT `StaticPage`.`id`, `StaticPage`.`parent_id`, `I18n__StaticPage__url__nl`.`content`, `I18n__StaticPage__url__fr`.`content` FROM `golf_live`.`static_pages` AS `StaticPage` LEFT JOIN `golf_live`.`i18n` AS `I18n__StaticPage__url__nl` ON (`StaticPage`.`id` = `I18n__StaticPage__url__nl`.`foreign_key` AND `I18n__StaticPage__url__nl`.`model` = 'StaticPage' AND `I18n__StaticPage__url__nl`.`field` = 'url' AND `I18n__StaticPage__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__StaticPage__url__fr` ON (`StaticPage`.`id` = `I18n__StaticPage__url__fr`.`foreign_key` AND `I18n__StaticPage__url__fr`.`model` = 'StaticPage' AND `I18n__StaticPage__url__fr`.`field` = 'url' AND `I18n__StaticPage__url__fr`.`locale` = 'fr') WHERE 1 = 1 ORDER BY `StaticPage`.`lft` ASC | | 26 | 26 | 0 |
| 15 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'media_library' | | 0 | 0 | 0 |
| 16 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'excel' | | 0 | 0 | 0 |
| 17 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'tags' | | 0 | 0 | 0 |
| 18 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'seo' | | 0 | 0 | 0 |
| 19 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'search' | | 0 | 0 | 0 |
| 20 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'activity_log' | | 0 | 0 | 0 |
| 21 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'blog' | | 850 | 850 | 0 |
| 22 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'faq' | | 0 | 0 | 0 |
| 23 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'feedback' | | 12 | 12 | 0 |
| 24 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'store' | | 0 | 0 | 0 |
| 25 | SELECT `Term`.`id`, `I18n__Term__url__nl`.`content` FROM `golf_live`.`terms` AS `Term` LEFT JOIN `golf_live`.`i18n` AS `I18n__Term__url__nl` ON (`Term`.`id` = `I18n__Term__url__nl`.`foreign_key` AND `I18n__Term__url__nl`.`model` = 'Term' AND `I18n__Term__url__nl`.`field` = 'url' AND `I18n__Term__url__nl`.`locale` = 'nl') WHERE 1 = 1 | | 1 | 1 | 0 |
| 26 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'banner' | | 0 | 0 | 0 |
| 27 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'agenda' | | 38 | 38 | 0 |
| 28 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'subscription' | | 0 | 0 | 0 |
| 29 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'social_media' | | 0 | 0 | 0 |
| 30 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'entities' | | 0 | 0 | 0 |
| 31 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'data' | | 0 | 0 | 0 |
| 32 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'clubs' | | 0 | 0 | 0 |
| 33 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'benefits' | | 0 | 0 | 0 |
| 34 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'api' | | 0 | 0 | 0 |
| 35 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'job' | | 12 | 12 | 0 |
| 36 | SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id`, `OldUrl`.`created`, `OldUrl`.`modified` FROM `golf_live`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'news' | | 0 | 0 | 0 |
| 37 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `golf_live`.`aros` AS `Aro` WHERE `model` = 'User' AND `foreign_key` IS NULL LIMIT 1 | | 0 | 0 | 0 |
| 38 | SELECT `Group`.`id` FROM `golf_live`.`groups` AS `Group` WHERE `name` = 'FRONTEND' LIMIT 1 | | 1 | 1 | 0 |
| 39 | SELECT `BlogPost`.*, `BlogPostImage`.*, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`twitter`, `User`.`linkedin`, `User`.`profile`, `User`.`avatar`, `I18n__BlogPost__title__nl`.`content`, `I18n__BlogPost__url__nl`.`content`, `I18n__BlogPost__body__nl`.`content`, `I18n__BlogPost__summary__nl`.`content`, `I18n__BlogPost__metatitle__nl`.`content`, `I18n__BlogPost__metadescription__nl`.`content`, `I18n__BlogPost__pagetitle__nl`.`content`, `I18n__BlogPost__taggedcontenttitle__nl`.`content`, (SELECT COUNT(id) FROM blog_post_comments WHERE post_id = `BlogPost`.`id` AND published IS NOT NULL) AS `BlogPost__comments`, `BlogPost`.`id` FROM `golf_live`.`blog_posts` AS `BlogPost` LEFT JOIN `golf_live`.`users` AS `User` ON (`BlogPost`.`created_by` = `User`.`id`) LEFT JOIN `golf_live`.`files` AS `BlogPostImage` ON (`BlogPostImage`.`foreign_key` = `BlogPost`.`id` AND `BlogPostImage`.`is_default` = '1' AND `BlogPostImage`.`model` = 'BlogPost') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__title__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__title__nl`.`foreign_key` AND `I18n__BlogPost__title__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__title__nl`.`field` = 'title' AND `I18n__BlogPost__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__url__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__url__nl`.`foreign_key` AND `I18n__BlogPost__url__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__url__nl`.`field` = 'url' AND `I18n__BlogPost__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__body__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__body__nl`.`foreign_key` AND `I18n__BlogPost__body__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__body__nl`.`field` = 'body' AND `I18n__BlogPost__body__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__summary__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__summary__nl`.`foreign_key` AND `I18n__BlogPost__summary__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__summary__nl`.`field` = 'summary' AND `I18n__BlogPost__summary__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__metatitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metatitle__nl`.`foreign_key` AND `I18n__BlogPost__metatitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogPost__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__metadescription__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metadescription__nl`.`foreign_key` AND `I18n__BlogPost__metadescription__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogPost__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__pagetitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__pagetitle__nl`.`foreign_key` AND `I18n__BlogPost__pagetitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogPost__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__taggedcontenttitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogPost__taggedcontenttitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogPost__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `I18n__BlogPost__url__nl`.`content` = 'trump-international-golf-links-scotland-promoot-zich-als-beste-36-holes-ter-wereld' AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:53' AND `BlogPost`.`published_until` >= '2026-03-13 11:23:53') OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:53' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-03-13 11:23:53')) ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`published_from` DESC, `BlogPost`.`created` DESC | | 1 | 1 | 452 |
| 40 | SELECT `BlogPostComment`.`id`, `BlogPostComment`.`post_id`, `BlogPostComment`.`user_id`, `BlogPostComment`.`username`, `BlogPostComment`.`user_email`, `BlogPostComment`.`text`, `BlogPostComment`.`published`, `BlogPostComment`.`created`, `BlogPostComment`.`modified` FROM `golf_live`.`blog_post_comments` AS `BlogPostComment` WHERE `BlogPostComment`.`post_id` = (22874) | | 0 | 0 | 0 |
| 41 | SELECT `ImagesList`.`id`, `ImagesList`.`model`, `ImagesList`.`foreign_key`, `ImagesList`.`is_default`, `ImagesList`.`name`, `ImagesList`.`size`, `ImagesList`.`group`, `ImagesList`.`ext`, `ImagesList`.`type`, `ImagesList`.`width`, `ImagesList`.`height`, `ImagesList`.`sortorder`, `ImagesList`.`created`, `ImagesList`.`modified` FROM `golf_live`.`files` AS `ImagesList` WHERE `model` = 'BlogPost' AND `ImagesList`.`foreign_key` = (22874) ORDER BY `ImagesList`.`sortorder` ASC | | 1 | 1 | 0 |
| 42 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogPost' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (22874) | | 0 | 0 | 0 |
| 43 | SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`blog_post_count`, `BlogCategory`.`under_blog_post_count`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`default`, `BlogCategory`.`is_enabled`, `BlogCategory`.`sitemap`, `BlogPostsToCategory`.`id`, `BlogPostsToCategory`.`category_id`, `BlogPostsToCategory`.`post_id`, `BlogPostsToCategory`.`order`, `BlogPostsToCategory`.`created` FROM `golf_live`.`blog_categories` AS `BlogCategory` JOIN `golf_live`.`blog_posts_to_categories` AS `BlogPostsToCategory` ON (`BlogPostsToCategory`.`post_id` = 22874 AND `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`) | | 1 | 1 | 0 |
| 44 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogPost' | | 0 | 0 | 0 |
| 45 | SELECT `BlogCategory`.*, `I18n__BlogCategory__title__nl`.`content`, `I18n__BlogCategory__description__nl`.`content`, `I18n__BlogCategory__url__nl`.`content`, `I18n__BlogCategory__metatitle__nl`.`content`, `I18n__BlogCategory__metadescription__nl`.`content`, `I18n__BlogCategory__pagetitle__nl`.`content`, `I18n__BlogCategory__rss_channel_title__nl`.`content`, `I18n__BlogCategory__rss_channel_description__nl`.`content`, `I18n__BlogCategory__taggedcontenttitle__nl`.`content`, `BlogCategory`.`id` FROM `golf_live`.`blog_categories` AS `BlogCategory` LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__title__nl`.`foreign_key` AND `I18n__BlogCategory__title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__title__nl`.`field` = 'title' AND `I18n__BlogCategory__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__description__nl`.`foreign_key` AND `I18n__BlogCategory__description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__description__nl`.`field` = 'description' AND `I18n__BlogCategory__description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__url__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__url__nl`.`foreign_key` AND `I18n__BlogCategory__url__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__url__nl`.`field` = 'url' AND `I18n__BlogCategory__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metatitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metatitle__nl`.`foreign_key` AND `I18n__BlogCategory__metatitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogCategory__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metadescription__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metadescription__nl`.`foreign_key` AND `I18n__BlogCategory__metadescription__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogCategory__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__pagetitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__pagetitle__nl`.`foreign_key` AND `I18n__BlogCategory__pagetitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogCategory__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_title__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_title__nl`.`field` = 'rss_channel_title' AND `I18n__BlogCategory__rss_channel_title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_description__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_description__nl`.`field` = 'rss_channel_description' AND `I18n__BlogCategory__rss_channel_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__taggedcontenttitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogCategory__taggedcontenttitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `BlogCategory`.`id` = 4 LIMIT 1 | | 1 | 1 | 0 |
| 46 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogCategory' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (4) | | 0 | 0 | 0 |
| 47 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogCategory' | | 0 | 0 | 0 |
| 48 | BEGIN | | 0 | 0 | 0 |
| 49 | SELECT COUNT(*) AS `count` FROM `golf_live`.`blog_posts` AS `BlogPost` WHERE `BlogPost`.`id` = 22874 | | 1 | 1 | 0 |
| 50 | SELECT COUNT(*) AS `count` FROM `golf_live`.`blog_posts` AS `BlogPost` WHERE `BlogPost`.`id` = 22874 | | 1 | 1 | 0 |
| 51 | SELECT `BlogPostsToCategory`.`category_id` FROM `golf_live`.`blog_posts_to_categories` AS `BlogPostsToCategory` WHERE `post_id` = 22874 | | 2 | 2 | 0 |
| 52 | SELECT COUNT(*) AS `count` FROM `golf_live`.`blog_posts` AS `BlogPost` WHERE `BlogPost`.`id` = 22874 | | 1 | 1 | 0 |
| 53 | UPDATE `golf_live`.`blog_posts` SET `id` = 22874, `counter` = 313, `modified` = '2026-03-13 11:23:53' WHERE `golf_live`.`blog_posts`.`id` = '22874' | | 1 | 1 | 1 |
| 54 | UPDATE blog_categories AS `BlogCategory` LEFT JOIN (SELECT BlogCategory.id, COUNT(DISTINCT post_id) AS under_count FROM blog_categories AS `BlogCategory` LEFT JOIN `golf_live`.`blog_categories` AS `BlogCategory2` ON (`BlogCategory`.`lft` <= `BlogCategory2`.`lft` AND `BlogCategory`.`rght` >= `BlogCategory2`.`rght`) INNER JOIN `golf_live`.`blog_posts_to_categories` AS `BlogPostsToCategory` ON (`BlogCategory2`.`id` = `BlogPostsToCategory`.`category_id`) INNER JOIN `golf_live`.`blog_posts` AS `BlogPost` ON (`BlogPostsToCategory`.`post_id`=`BlogPost`.`id`) WHERE `BlogPost`.`published` = 1 GROUP BY `BlogCategory`.`id`) AS `x` ON (`BlogCategory`.`id` = `x`.`id`) SET blog_post_count = (SELECT COUNT(*) FROM blog_posts_to_categories AS `BlogPostsToCategory` INNER JOIN `golf_live`.`blog_posts` AS `BlogPost` ON (`BlogPostsToCategory`.`post_id`=`BlogPost`.`id` AND `BlogPost`.`published` = 1) WHERE `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`), under_blog_post_count = IFNULL(x.under_count, 0) | | 0 | 0 | 19 |
| 55 | COMMIT | | 0 | 0 | 0 |
| 56 | SELECT `FileStorage`.`id`, `FileStorage`.`name`, `FileStorage`.`size`, `FileStorage`.`is_default`, `FileStorage`.`group`, `FileStorage`.`height`, `FileStorage`.`width`, `FileStorage`.`sortorder` FROM `golf_live`.`files` AS `FileStorage` WHERE `FileStorage`.`model` = 'BlogPost' AND `FileStorage`.`foreign_key` = 22874 ORDER BY `FileStorage`.`sortorder` ASC | | 1 | 1 | 0 |
| 57 | SELECT `BlogPostComment`.`id`, `BlogPostComment`.`post_id`, `BlogPostComment`.`user_id`, `BlogPostComment`.`username`, `BlogPostComment`.`user_email`, `BlogPostComment`.`text`, `BlogPostComment`.`published`, `BlogPostComment`.`created`, `BlogPostComment`.`modified`, `BlogPost`.`id`, `BlogPost`.`created_by`, `BlogPost`.`ext_link`, `BlogPost`.`published`, `BlogPost`.`published_from`, `BlogPost`.`published_until`, `BlogPost`.`sticky`, `BlogPost`.`in_rss`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`ext_url`, `BlogPost`.`sitemap`, `BlogPost`.`counter`, (SELECT COUNT(id) FROM blog_post_comments WHERE post_id = `BlogPost`.`id` AND published IS NOT NULL) AS `BlogPost__comments`, `User`.`gender`, `User`.`golfbe_membership`, `User`.`welcome_pack`, `User`.`play_golf`, `User`.`membership_card`, `User`.`remarks`, `User`.`payment_method`, `User`.`amount`, `User`.`membership_expiration`, `User`.`member_since`, `User`.`date_of_birth`, `User`.`age`, `User`.`homeclub`, `User`.`hcp2`, `User`.`hcp1`, `User`.`member_number`, `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`password`, `User`.`language`, `User`.`company`, `User`.`company_type`, `User`.`vat_number`, `User`.`is_subscribed`, `User`.`sms_shipping`, `User`.`twitter`, `User`.`linkedin`, `User`.`profile`, `User`.`avatar`, `User`.`birthdate`, `User`.`active`, `User`.`status`, `User`.`confirmation`, `User`.`lastlogin`, `User`.`user_agent_info`, `User`.`editable`, `User`.`b2b`, `User`.`created`, `User`.`modified`, `User`.`handschoen`, `User`.`kaart`, `User`.`lijst`, `User`.`street`, `User`.`zip`, `User`.`city`, `User`.`country`, (CONCAT(first_name, " ", last_name)) AS `User__full_name`, (CONCAT(first_name, " ", last_name)) AS `User__displayname` FROM `golf_live`.`blog_post_comments` AS `BlogPostComment` LEFT JOIN `golf_live`.`blog_posts` AS `BlogPost` ON (`BlogPostComment`.`post_id` = `BlogPost`.`id`) LEFT JOIN `golf_live`.`users` AS `User` ON (`BlogPostComment`.`user_id` = `User`.`id`) WHERE `BlogPostComment`.`post_id` = 22874 ORDER BY `BlogPostComment`.`created` ASC | | 0 | 0 | 0 |
| 58 | SELECT YEAR(`BlogPost`.`published_from`) AS `year`, DATE_FORMAT(BlogPost.published_from, '%m') AS `month`, DATE_FORMAT(BlogPost.published_from, "%b") AS `monthname`, `BlogPost`.`published_from` AS `timestamp`, COUNT(*) AS `count`, `BlogPost`.`id` FROM `golf_live`.`blog_posts` AS `BlogPost` LEFT JOIN `golf_live`.`files` AS `BlogPostImage` ON (`BlogPostImage`.`foreign_key` = `BlogPost`.`id` AND `BlogPostImage`.`is_default` = '1' AND `BlogPostImage`.`model` = 'BlogPost') WHERE `BlogPost`.`published` = '1' AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:53' AND `BlogPost`.`published_until` >= '2026-03-13 11:23:53') OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:53' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-03-13 11:23:53')) AND `BlogPost`.`id` NOT IN (-1) GROUP BY DATE_FORMAT(`BlogPost`.`published_from`, '%Y%m') ORDER BY `BlogPost`.`published_from` DESC | | 21 | 21 | 45 |
| 59 | SELECT `BlogPostComment`.`id`, `BlogPostComment`.`post_id`, `BlogPostComment`.`user_id`, `BlogPostComment`.`username`, `BlogPostComment`.`user_email`, `BlogPostComment`.`text`, `BlogPostComment`.`published`, `BlogPostComment`.`created`, `BlogPostComment`.`modified` FROM `golf_live`.`blog_post_comments` AS `BlogPostComment` WHERE `BlogPostComment`.`post_id` IN (22876, 22650, 22452, 22231, 21994, 21789, 21549, 21282, 21019, 20796, 20534, 20282, 20026, 19773, 19614, 19407, 19202, 18921, 18765, 18770, 18851) | | 0 | 0 | 0 |
| 60 | SELECT `ImagesList`.`id`, `ImagesList`.`model`, `ImagesList`.`foreign_key`, `ImagesList`.`is_default`, `ImagesList`.`name`, `ImagesList`.`size`, `ImagesList`.`group`, `ImagesList`.`ext`, `ImagesList`.`type`, `ImagesList`.`width`, `ImagesList`.`height`, `ImagesList`.`sortorder`, `ImagesList`.`created`, `ImagesList`.`modified` FROM `golf_live`.`files` AS `ImagesList` WHERE `model` = 'BlogPost' AND `ImagesList`.`foreign_key` IN (22876, 22650, 22452, 22231, 21994, 21789, 21549, 21282, 21019, 20796, 20534, 20282, 20026, 19773, 19614, 19407, 19202, 18921, 18765, 18770, 18851) ORDER BY `ImagesList`.`sortorder` ASC | | 21 | 21 | 0 |
| 61 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogPost' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` IN (22876, 22650, 22452, 22231, 21994, 21789, 21549, 21282, 21019, 20796, 20534, 20282, 20026, 19773, 19614, 19407, 19202, 18921, 18765, 18770, 18851) | | 0 | 0 | 0 |
| 62 | SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`blog_post_count`, `BlogCategory`.`under_blog_post_count`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`default`, `BlogCategory`.`is_enabled`, `BlogCategory`.`sitemap`, `BlogPostsToCategory`.`id`, `BlogPostsToCategory`.`category_id`, `BlogPostsToCategory`.`post_id`, `BlogPostsToCategory`.`order`, `BlogPostsToCategory`.`created` FROM `golf_live`.`blog_categories` AS `BlogCategory` JOIN `golf_live`.`blog_posts_to_categories` AS `BlogPostsToCategory` ON (`BlogPostsToCategory`.`post_id` IN (22876, 22650, 22452, 22231, 21994, 21789, 21549, 21282, 21019, 20796, 20534, 20282, 20026, 19773, 19614, 19407, 19202, 18921, 18765, 18770, 18851) AND `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`) | | 25 | 25 | 0 |
| 63 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogPost' | | 0 | 0 | 0 |
| 64 | SELECT `BlogPost`.*, `BlogPostImage`.*, `I18n__BlogPost__title__nl`.`content`, `I18n__BlogPost__url__nl`.`content`, `I18n__BlogPost__body__nl`.`content`, `I18n__BlogPost__summary__nl`.`content`, `I18n__BlogPost__metatitle__nl`.`content`, `I18n__BlogPost__metadescription__nl`.`content`, `I18n__BlogPost__pagetitle__nl`.`content`, `I18n__BlogPost__taggedcontenttitle__nl`.`content`, (SELECT COUNT(id) FROM blog_post_comments WHERE post_id = `BlogPost`.`id` AND published IS NOT NULL) AS `BlogPost__comments`, `BlogPost`.`id` FROM `golf_live`.`blog_posts` AS `BlogPost` LEFT JOIN `golf_live`.`files` AS `BlogPostImage` ON (`BlogPostImage`.`foreign_key` = `BlogPost`.`id` AND `BlogPostImage`.`is_default` = '1' AND `BlogPostImage`.`model` = 'BlogPost') INNER JOIN `golf_live`.`blog_posts_to_categories` AS `BlogPostsToCategory` ON (`BlogPost`.`id` = `BlogPostsToCategory`.`post_id`) LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__title__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__title__nl`.`foreign_key` AND `I18n__BlogPost__title__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__title__nl`.`field` = 'title' AND `I18n__BlogPost__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__url__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__url__nl`.`foreign_key` AND `I18n__BlogPost__url__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__url__nl`.`field` = 'url' AND `I18n__BlogPost__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__body__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__body__nl`.`foreign_key` AND `I18n__BlogPost__body__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__body__nl`.`field` = 'body' AND `I18n__BlogPost__body__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__summary__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__summary__nl`.`foreign_key` AND `I18n__BlogPost__summary__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__summary__nl`.`field` = 'summary' AND `I18n__BlogPost__summary__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__metatitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metatitle__nl`.`foreign_key` AND `I18n__BlogPost__metatitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogPost__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__metadescription__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metadescription__nl`.`foreign_key` AND `I18n__BlogPost__metadescription__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogPost__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__pagetitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__pagetitle__nl`.`foreign_key` AND `I18n__BlogPost__pagetitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogPost__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__taggedcontenttitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogPost__taggedcontenttitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogPost__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `I18n__BlogPost__url__nl`.`content` = 'internationaal/trump-international-golf-links-scotland-promoot-zich-als-beste-36-holes-ter-wereld' AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:53' AND `BlogPost`.`published_until` >= '2026-03-13 11:23:53') OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:53' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-03-13 11:23:53')) AND `BlogPost`.`id` NOT IN (-1) ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`published_from` DESC, `BlogPost`.`created` DESC LIMIT 1 | | 0 | 0 | 442 |
| 65 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogPost' | | 0 | 0 | 0 |
| 66 | SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`under_blog_post_count`, `I18n__BlogCategory__title__nl`.`content`, `I18n__BlogCategory__url__nl`.`content` FROM `golf_live`.`blog_categories` AS `BlogCategory` LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__title__nl`.`foreign_key` AND `I18n__BlogCategory__title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__title__nl`.`field` = 'title' AND `I18n__BlogCategory__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__url__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__url__nl`.`foreign_key` AND `I18n__BlogCategory__url__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__url__nl`.`field` = 'url' AND `I18n__BlogCategory__url__nl`.`locale` = 'nl') WHERE `BlogCategory`.`is_enabled` = '1' GROUP BY `BlogCategory`.`id` | | 5 | 5 | 0 |
| 67 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogCategory' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` IN (2, 3, 4, 5, 6) | | 0 | 0 | 0 |
| 68 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogCategory' | | 0 | 0 | 0 |
| 69 | SELECT `BlogCategory`.*, `I18n__BlogCategory__title__nl`.`content`, `I18n__BlogCategory__description__nl`.`content`, `I18n__BlogCategory__url__nl`.`content`, `I18n__BlogCategory__metatitle__nl`.`content`, `I18n__BlogCategory__metadescription__nl`.`content`, `I18n__BlogCategory__pagetitle__nl`.`content`, `I18n__BlogCategory__rss_channel_title__nl`.`content`, `I18n__BlogCategory__rss_channel_description__nl`.`content`, `I18n__BlogCategory__taggedcontenttitle__nl`.`content`, `BlogCategory`.`id` FROM `golf_live`.`blog_categories` AS `BlogCategory` LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__title__nl`.`foreign_key` AND `I18n__BlogCategory__title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__title__nl`.`field` = 'title' AND `I18n__BlogCategory__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__description__nl`.`foreign_key` AND `I18n__BlogCategory__description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__description__nl`.`field` = 'description' AND `I18n__BlogCategory__description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__url__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__url__nl`.`foreign_key` AND `I18n__BlogCategory__url__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__url__nl`.`field` = 'url' AND `I18n__BlogCategory__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metatitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metatitle__nl`.`foreign_key` AND `I18n__BlogCategory__metatitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogCategory__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metadescription__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metadescription__nl`.`foreign_key` AND `I18n__BlogCategory__metadescription__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogCategory__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__pagetitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__pagetitle__nl`.`foreign_key` AND `I18n__BlogCategory__pagetitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogCategory__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_title__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_title__nl`.`field` = 'rss_channel_title' AND `I18n__BlogCategory__rss_channel_title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_description__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_description__nl`.`field` = 'rss_channel_description' AND `I18n__BlogCategory__rss_channel_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__taggedcontenttitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogCategory__taggedcontenttitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `BlogCategory`.`id` = 4 LIMIT 1 | | 1 | 1 | 0 |
| 70 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogCategory' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (4) | | 0 | 0 | 0 |
| 71 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogCategory' | | 0 | 0 | 0 |
| 72 | SELECT `BlogCategory`.*, `I18n__BlogCategory__title__nl`.`content`, `I18n__BlogCategory__description__nl`.`content`, `I18n__BlogCategory__url__nl`.`content`, `I18n__BlogCategory__metatitle__nl`.`content`, `I18n__BlogCategory__metadescription__nl`.`content`, `I18n__BlogCategory__pagetitle__nl`.`content`, `I18n__BlogCategory__rss_channel_title__nl`.`content`, `I18n__BlogCategory__rss_channel_description__nl`.`content`, `I18n__BlogCategory__taggedcontenttitle__nl`.`content`, `BlogCategory`.`id` FROM `golf_live`.`blog_categories` AS `BlogCategory` LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__title__nl`.`foreign_key` AND `I18n__BlogCategory__title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__title__nl`.`field` = 'title' AND `I18n__BlogCategory__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__description__nl`.`foreign_key` AND `I18n__BlogCategory__description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__description__nl`.`field` = 'description' AND `I18n__BlogCategory__description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__url__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__url__nl`.`foreign_key` AND `I18n__BlogCategory__url__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__url__nl`.`field` = 'url' AND `I18n__BlogCategory__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metatitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metatitle__nl`.`foreign_key` AND `I18n__BlogCategory__metatitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogCategory__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metadescription__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metadescription__nl`.`foreign_key` AND `I18n__BlogCategory__metadescription__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogCategory__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__pagetitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__pagetitle__nl`.`foreign_key` AND `I18n__BlogCategory__pagetitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogCategory__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_title__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_title__nl`.`field` = 'rss_channel_title' AND `I18n__BlogCategory__rss_channel_title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_description__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_description__nl`.`field` = 'rss_channel_description' AND `I18n__BlogCategory__rss_channel_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__taggedcontenttitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogCategory__taggedcontenttitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `BlogCategory`.`id` = 4 LIMIT 1 | | 1 | 1 | 0 |
| 73 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogCategory' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (4) | | 0 | 0 | 0 |
| 74 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogCategory' | | 0 | 0 | 0 |
| 75 | SELECT `BlogCategory`.*, `I18n__BlogCategory__title__nl`.`content`, `I18n__BlogCategory__description__nl`.`content`, `I18n__BlogCategory__url__nl`.`content`, `I18n__BlogCategory__metatitle__nl`.`content`, `I18n__BlogCategory__metadescription__nl`.`content`, `I18n__BlogCategory__pagetitle__nl`.`content`, `I18n__BlogCategory__rss_channel_title__nl`.`content`, `I18n__BlogCategory__rss_channel_description__nl`.`content`, `I18n__BlogCategory__taggedcontenttitle__nl`.`content`, `BlogCategory`.`id` FROM `golf_live`.`blog_categories` AS `BlogCategory` LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__title__nl`.`foreign_key` AND `I18n__BlogCategory__title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__title__nl`.`field` = 'title' AND `I18n__BlogCategory__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__description__nl`.`foreign_key` AND `I18n__BlogCategory__description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__description__nl`.`field` = 'description' AND `I18n__BlogCategory__description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__url__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__url__nl`.`foreign_key` AND `I18n__BlogCategory__url__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__url__nl`.`field` = 'url' AND `I18n__BlogCategory__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metatitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metatitle__nl`.`foreign_key` AND `I18n__BlogCategory__metatitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogCategory__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metadescription__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metadescription__nl`.`foreign_key` AND `I18n__BlogCategory__metadescription__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogCategory__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__pagetitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__pagetitle__nl`.`foreign_key` AND `I18n__BlogCategory__pagetitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogCategory__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_title__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_title__nl`.`field` = 'rss_channel_title' AND `I18n__BlogCategory__rss_channel_title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_description__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_description__nl`.`field` = 'rss_channel_description' AND `I18n__BlogCategory__rss_channel_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__taggedcontenttitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogCategory__taggedcontenttitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `BlogCategory`.`id` = (4) | | 1 | 1 | 0 |
| 76 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogCategory' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (4) | | 0 | 0 | 0 |
| 77 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogCategory' | | 0 | 0 | 0 |
| 78 | SELECT `BlogPost`.*, `BlogPostImage`.*, `I18n__BlogPost__title__nl`.`content`, `I18n__BlogPost__url__nl`.`content`, `I18n__BlogPost__body__nl`.`content`, `I18n__BlogPost__summary__nl`.`content`, `I18n__BlogPost__metatitle__nl`.`content`, `I18n__BlogPost__metadescription__nl`.`content`, `I18n__BlogPost__pagetitle__nl`.`content`, `I18n__BlogPost__taggedcontenttitle__nl`.`content`, (SELECT COUNT(id) FROM blog_post_comments WHERE post_id = `BlogPost`.`id` AND published IS NOT NULL) AS `BlogPost__comments`, `BlogPost`.`id` FROM `golf_live`.`blog_posts` AS `BlogPost` LEFT JOIN `golf_live`.`files` AS `BlogPostImage` ON (`BlogPostImage`.`foreign_key` = `BlogPost`.`id` AND `BlogPostImage`.`is_default` = '1' AND `BlogPostImage`.`model` = 'BlogPost') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__title__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__title__nl`.`foreign_key` AND `I18n__BlogPost__title__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__title__nl`.`field` = 'title' AND `I18n__BlogPost__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__url__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__url__nl`.`foreign_key` AND `I18n__BlogPost__url__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__url__nl`.`field` = 'url' AND `I18n__BlogPost__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__body__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__body__nl`.`foreign_key` AND `I18n__BlogPost__body__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__body__nl`.`field` = 'body' AND `I18n__BlogPost__body__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__summary__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__summary__nl`.`foreign_key` AND `I18n__BlogPost__summary__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__summary__nl`.`field` = 'summary' AND `I18n__BlogPost__summary__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__metatitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metatitle__nl`.`foreign_key` AND `I18n__BlogPost__metatitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogPost__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__metadescription__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metadescription__nl`.`foreign_key` AND `I18n__BlogPost__metadescription__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogPost__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__pagetitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__pagetitle__nl`.`foreign_key` AND `I18n__BlogPost__pagetitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogPost__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__taggedcontenttitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogPost__taggedcontenttitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogPost__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `BlogPost`.`published_from` < '2026-02-28 10:59:18' AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:54' AND `BlogPost`.`published_until` >= '2026-03-13 11:23:54') OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:54' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-03-13 11:23:54')) AND `BlogPost`.`id` NOT IN (-1) ORDER BY `BlogPost`.`published_from` DESC LIMIT 1 | | 1 | 1 | 3 |
| 79 | SELECT `BlogPostComment`.`id`, `BlogPostComment`.`post_id`, `BlogPostComment`.`user_id`, `BlogPostComment`.`username`, `BlogPostComment`.`user_email`, `BlogPostComment`.`text`, `BlogPostComment`.`published`, `BlogPostComment`.`created`, `BlogPostComment`.`modified` FROM `golf_live`.`blog_post_comments` AS `BlogPostComment` WHERE `BlogPostComment`.`post_id` = (22878) | | 0 | 0 | 0 |
| 80 | SELECT `ImagesList`.`id`, `ImagesList`.`model`, `ImagesList`.`foreign_key`, `ImagesList`.`is_default`, `ImagesList`.`name`, `ImagesList`.`size`, `ImagesList`.`group`, `ImagesList`.`ext`, `ImagesList`.`type`, `ImagesList`.`width`, `ImagesList`.`height`, `ImagesList`.`sortorder`, `ImagesList`.`created`, `ImagesList`.`modified` FROM `golf_live`.`files` AS `ImagesList` WHERE `model` = 'BlogPost' AND `ImagesList`.`foreign_key` = (22878) ORDER BY `ImagesList`.`sortorder` ASC | | 1 | 1 | 0 |
| 81 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogPost' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (22878) | | 0 | 0 | 0 |
| 82 | SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`blog_post_count`, `BlogCategory`.`under_blog_post_count`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`default`, `BlogCategory`.`is_enabled`, `BlogCategory`.`sitemap`, `BlogPostsToCategory`.`id`, `BlogPostsToCategory`.`category_id`, `BlogPostsToCategory`.`post_id`, `BlogPostsToCategory`.`order`, `BlogPostsToCategory`.`created` FROM `golf_live`.`blog_categories` AS `BlogCategory` JOIN `golf_live`.`blog_posts_to_categories` AS `BlogPostsToCategory` ON (`BlogPostsToCategory`.`post_id` = 22878 AND `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`) | | 1 | 1 | 0 |
| 83 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogPost' | | 0 | 0 | 0 |
| 84 | SELECT `BlogPost`.*, `BlogPostImage`.*, `I18n__BlogPost__title__nl`.`content`, `I18n__BlogPost__url__nl`.`content`, `I18n__BlogPost__body__nl`.`content`, `I18n__BlogPost__summary__nl`.`content`, `I18n__BlogPost__metatitle__nl`.`content`, `I18n__BlogPost__metadescription__nl`.`content`, `I18n__BlogPost__pagetitle__nl`.`content`, `I18n__BlogPost__taggedcontenttitle__nl`.`content`, (SELECT COUNT(id) FROM blog_post_comments WHERE post_id = `BlogPost`.`id` AND published IS NOT NULL) AS `BlogPost__comments`, `BlogPost`.`id` FROM `golf_live`.`blog_posts` AS `BlogPost` LEFT JOIN `golf_live`.`files` AS `BlogPostImage` ON (`BlogPostImage`.`foreign_key` = `BlogPost`.`id` AND `BlogPostImage`.`is_default` = '1' AND `BlogPostImage`.`model` = 'BlogPost') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__title__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__title__nl`.`foreign_key` AND `I18n__BlogPost__title__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__title__nl`.`field` = 'title' AND `I18n__BlogPost__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__url__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__url__nl`.`foreign_key` AND `I18n__BlogPost__url__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__url__nl`.`field` = 'url' AND `I18n__BlogPost__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__body__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__body__nl`.`foreign_key` AND `I18n__BlogPost__body__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__body__nl`.`field` = 'body' AND `I18n__BlogPost__body__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__summary__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__summary__nl`.`foreign_key` AND `I18n__BlogPost__summary__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__summary__nl`.`field` = 'summary' AND `I18n__BlogPost__summary__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__metatitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metatitle__nl`.`foreign_key` AND `I18n__BlogPost__metatitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogPost__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__metadescription__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metadescription__nl`.`foreign_key` AND `I18n__BlogPost__metadescription__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogPost__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__pagetitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__pagetitle__nl`.`foreign_key` AND `I18n__BlogPost__pagetitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogPost__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__taggedcontenttitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogPost__taggedcontenttitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogPost__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:54' AND `BlogPost`.`published_until` >= '2026-03-13 11:23:54') OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:54' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-03-13 11:23:54')) AND `BlogPost`.`id` NOT IN (-1) AND `BlogPost`.`published_from` >= '2026-02-28 09:47:12' AND `BlogPost`.`published_from` != '2026-02-28 10:59:18' AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:54' AND `BlogPost`.`published_until` >= '2026-03-13 11:23:54') OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:54' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-03-13 11:23:54')) AND `BlogPost`.`id` NOT IN (-1) ORDER BY `BlogPost`.`published_from` ASC LIMIT 2 | | 2 | 2 | 2 |
| 85 | SELECT `BlogPostComment`.`id`, `BlogPostComment`.`post_id`, `BlogPostComment`.`user_id`, `BlogPostComment`.`username`, `BlogPostComment`.`user_email`, `BlogPostComment`.`text`, `BlogPostComment`.`published`, `BlogPostComment`.`created`, `BlogPostComment`.`modified` FROM `golf_live`.`blog_post_comments` AS `BlogPostComment` WHERE `BlogPostComment`.`post_id` IN (22878, 22876) | | 0 | 0 | 0 |
| 86 | SELECT `ImagesList`.`id`, `ImagesList`.`model`, `ImagesList`.`foreign_key`, `ImagesList`.`is_default`, `ImagesList`.`name`, `ImagesList`.`size`, `ImagesList`.`group`, `ImagesList`.`ext`, `ImagesList`.`type`, `ImagesList`.`width`, `ImagesList`.`height`, `ImagesList`.`sortorder`, `ImagesList`.`created`, `ImagesList`.`modified` FROM `golf_live`.`files` AS `ImagesList` WHERE `model` = 'BlogPost' AND `ImagesList`.`foreign_key` IN (22878, 22876) ORDER BY `ImagesList`.`sortorder` ASC | | 2 | 2 | 0 |
| 87 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogPost' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` IN (22878, 22876) | | 0 | 0 | 0 |
| 88 | SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`blog_post_count`, `BlogCategory`.`under_blog_post_count`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`default`, `BlogCategory`.`is_enabled`, `BlogCategory`.`sitemap`, `BlogPostsToCategory`.`id`, `BlogPostsToCategory`.`category_id`, `BlogPostsToCategory`.`post_id`, `BlogPostsToCategory`.`order`, `BlogPostsToCategory`.`created` FROM `golf_live`.`blog_categories` AS `BlogCategory` JOIN `golf_live`.`blog_posts_to_categories` AS `BlogPostsToCategory` ON (`BlogPostsToCategory`.`post_id` IN (22878, 22876) AND `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`) | | 2 | 2 | 0 |
| 89 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogPost' | | 0 | 0 | 0 |
| 90 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_leaderboard_banner' LIMIT 1 | | 1 | 1 | 0 |
| 91 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (4) ORDER BY `BannerImages`.`sort_order` ASC | | 1 | 1 | 0 |
| 92 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 4 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 0 | 0 | 0 |
| 93 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'banner_hoofdsponsors_01' LIMIT 1 | | 1 | 1 | 0 |
| 94 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (5) ORDER BY `BannerImages`.`sort_order` ASC | | 4 | 4 | 0 |
| 95 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 5 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 1 | 1 | 0 |
| 96 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'banner_hoofdsponsors_01' LIMIT 1 | | 1 | 1 | 0 |
| 97 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (5) ORDER BY `BannerImages`.`sort_order` ASC | | 4 | 4 | 0 |
| 98 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 5 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 1 | 1 | 0 |
| 99 | SELECT `BlogCategory`.*, `I18n__BlogCategory__title__nl`.`content`, `I18n__BlogCategory__description__nl`.`content`, `I18n__BlogCategory__url__nl`.`content`, `I18n__BlogCategory__metatitle__nl`.`content`, `I18n__BlogCategory__metadescription__nl`.`content`, `I18n__BlogCategory__pagetitle__nl`.`content`, `I18n__BlogCategory__rss_channel_title__nl`.`content`, `I18n__BlogCategory__rss_channel_description__nl`.`content`, `I18n__BlogCategory__taggedcontenttitle__nl`.`content`, `BlogCategory`.`id` FROM `golf_live`.`blog_categories` AS `BlogCategory` LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__title__nl`.`foreign_key` AND `I18n__BlogCategory__title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__title__nl`.`field` = 'title' AND `I18n__BlogCategory__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__description__nl`.`foreign_key` AND `I18n__BlogCategory__description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__description__nl`.`field` = 'description' AND `I18n__BlogCategory__description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__url__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__url__nl`.`foreign_key` AND `I18n__BlogCategory__url__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__url__nl`.`field` = 'url' AND `I18n__BlogCategory__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metatitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metatitle__nl`.`foreign_key` AND `I18n__BlogCategory__metatitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogCategory__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metadescription__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metadescription__nl`.`foreign_key` AND `I18n__BlogCategory__metadescription__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogCategory__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__pagetitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__pagetitle__nl`.`foreign_key` AND `I18n__BlogCategory__pagetitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogCategory__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_title__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_title__nl`.`field` = 'rss_channel_title' AND `I18n__BlogCategory__rss_channel_title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_description__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_description__nl`.`field` = 'rss_channel_description' AND `I18n__BlogCategory__rss_channel_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__taggedcontenttitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogCategory__taggedcontenttitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `BlogCategory`.`id` = 1 AND `BlogCategory`.`is_enabled` = '1' LIMIT 1 | | 0 | 0 | 0 |
| 100 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogCategory' | | 0 | 0 | 0 |
| 101 | SELECT `Club`.*, `ClubImage`.*, `I18n__Club__title__nl`.`content`, `I18n__Club__url__nl`.`content`, `I18n__Club__description__nl`.`content`, `I18n__Club__play_description__nl`.`content`, `I18n__Club__visit_description__nl`.`content`, `I18n__Club__greenfee__nl`.`content`, `I18n__Club__metatitle__nl`.`content`, `I18n__Club__metadescription__nl`.`content`, `I18n__Club__taggedcontenttitle__nl`.`content`, `Club`.`id` FROM `golf_live`.`clubs` AS `Club` LEFT JOIN `golf_live`.`files` AS `ClubImage` ON (`ClubImage`.`foreign_key` = `Club`.`id` AND `ClubImage`.`is_default` = '1' AND `ClubImage`.`model` = 'Club') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__title__nl` ON (`Club`.`id` = `I18n__Club__title__nl`.`foreign_key` AND `I18n__Club__title__nl`.`model` = 'Club' AND `I18n__Club__title__nl`.`field` = 'title' AND `I18n__Club__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__url__nl` ON (`Club`.`id` = `I18n__Club__url__nl`.`foreign_key` AND `I18n__Club__url__nl`.`model` = 'Club' AND `I18n__Club__url__nl`.`field` = 'url' AND `I18n__Club__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__description__nl` ON (`Club`.`id` = `I18n__Club__description__nl`.`foreign_key` AND `I18n__Club__description__nl`.`model` = 'Club' AND `I18n__Club__description__nl`.`field` = 'description' AND `I18n__Club__description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__play_description__nl` ON (`Club`.`id` = `I18n__Club__play_description__nl`.`foreign_key` AND `I18n__Club__play_description__nl`.`model` = 'Club' AND `I18n__Club__play_description__nl`.`field` = 'play_description' AND `I18n__Club__play_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__visit_description__nl` ON (`Club`.`id` = `I18n__Club__visit_description__nl`.`foreign_key` AND `I18n__Club__visit_description__nl`.`model` = 'Club' AND `I18n__Club__visit_description__nl`.`field` = 'visit_description' AND `I18n__Club__visit_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__greenfee__nl` ON (`Club`.`id` = `I18n__Club__greenfee__nl`.`foreign_key` AND `I18n__Club__greenfee__nl`.`model` = 'Club' AND `I18n__Club__greenfee__nl`.`field` = 'greenfee' AND `I18n__Club__greenfee__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__metatitle__nl` ON (`Club`.`id` = `I18n__Club__metatitle__nl`.`foreign_key` AND `I18n__Club__metatitle__nl`.`model` = 'Club' AND `I18n__Club__metatitle__nl`.`field` = 'metatitle' AND `I18n__Club__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__metadescription__nl` ON (`Club`.`id` = `I18n__Club__metadescription__nl`.`foreign_key` AND `I18n__Club__metadescription__nl`.`model` = 'Club' AND `I18n__Club__metadescription__nl`.`field` = 'metadescription' AND `I18n__Club__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__taggedcontenttitle__nl` ON (`Club`.`id` = `I18n__Club__taggedcontenttitle__nl`.`foreign_key` AND `I18n__Club__taggedcontenttitle__nl`.`model` = 'Club' AND `I18n__Club__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__Club__taggedcontenttitle__nl`.`locale` = 'nl') WHERE 1 = 1 LIMIT 1 | | 1 | 1 | 0 |
| 102 | SELECT `ClubImages`.`id`, `ClubImages`.`model`, `ClubImages`.`foreign_key`, `ClubImages`.`is_default`, `ClubImages`.`name`, `ClubImages`.`size`, `ClubImages`.`group`, `ClubImages`.`ext`, `ClubImages`.`type`, `ClubImages`.`width`, `ClubImages`.`height`, `ClubImages`.`sortorder`, `ClubImages`.`created`, `ClubImages`.`modified` FROM `golf_live`.`files` AS `ClubImages` WHERE `ClubImages`.`is_default` = '0' AND `ClubImages`.`model` = 'Club' AND `ClubImages`.`foreign_key` = (1) ORDER BY `ClubImages`.`sortorder` ASC | | 2 | 2 | 0 |
| 103 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'clubs' AND `Tagged`.`model` = 'Club' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (1) | | 0 | 0 | 0 |
| 104 | SELECT `ClubOption`.`id`, `ClubOption`.`css_class`, `ClubOption`.`created`, `ClubOptionsToClub`.`id`, `ClubOptionsToClub`.`club_id`, `ClubOptionsToClub`.`club_option_id`, `ClubOptionsToClub`.`order`, `ClubOptionsToClub`.`created` FROM `golf_live`.`club_options` AS `ClubOption` JOIN `golf_live`.`club_options_to_clubs` AS `ClubOptionsToClub` ON (`ClubOptionsToClub`.`club_id` = 1 AND `ClubOptionsToClub`.`club_option_id` = `ClubOption`.`id`) | | 14 | 14 | 0 |
| 105 | SELECT `Entity`.`id`, `Entity`.`street`, `Entity`.`street_nr`, `Entity`.`zip`, `Entity`.`city`, `Entity`.`country`, `Entity`.`lat`, `Entity`.`lng`, `Entity`.`state`, `Entity`.`email`, `Entity`.`phone`, `Entity`.`fax`, `Entity`.`website`, `Entity`.`entity_type_id`, `Entity`.`is_enable`, `Entity`.`sitemap`, `EntityToClub`.`id`, `EntityToClub`.`club_id`, `EntityToClub`.`entity_id`, `EntityToClub`.`distance`, `EntityToClub`.`duration`, `EntityToClub`.`order`, `EntityToClub`.`created` FROM `golf_live`.`entities` AS `Entity` JOIN `golf_live`.`entity_to_clubs` AS `EntityToClub` ON (`EntityToClub`.`club_id` = 1 AND `EntityToClub`.`entity_id` = `Entity`.`id`) ORDER BY `EntityToClub`.`distance` ASC | | 0 | 0 | 0 |
| 106 | SELECT `AgendaEvent`.`id`, `AgendaEvent`.`start_list`, `AgendaEvent`.`bijlage_15`, `AgendaEvent`.`bijlage_14`, `AgendaEvent`.`bijlage_13`, `AgendaEvent`.`bijlage_12`, `AgendaEvent`.`bijlage_11`, `AgendaEvent`.`bijlage_10`, `AgendaEvent`.`bijlage_9`, `AgendaEvent`.`bijlage_8`, `AgendaEvent`.`bijlage_7`, `AgendaEvent`.`bijlage_6`, `AgendaEvent`.`bijlage_5`, `AgendaEvent`.`bijlage_4`, `AgendaEvent`.`bijlage_3`, `AgendaEvent`.`bijlage_2`, `AgendaEvent`.`bijlage_1`, `AgendaEvent`.`color`, `AgendaEvent`.`price`, `AgendaEvent`.`price_member`, `AgendaEvent`.`public`, `AgendaEvent`.`subscription_enabled`, `AgendaEvent`.`attendees`, `AgendaEvent`.`feedback_id`, `AgendaEvent`.`form_template`, `AgendaEvent`.`images_count`, `AgendaEvent`.`created`, `AgendaEvent`.`modified`, `EventsToClub`.`id`, `EventsToClub`.`club_id`, `EventsToClub`.`event_id`, `EventsToClub`.`order`, `EventsToClub`.`created` FROM `golf_live`.`agenda_events` AS `AgendaEvent` JOIN `golf_live`.`events_to_clubs` AS `EventsToClub` ON (`EventsToClub`.`club_id` = 1 AND `EventsToClub`.`event_id` = `AgendaEvent`.`id`) | | 21 | 21 | 0 |
| 107 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = Club' | | 0 | 0 | 0 |
| 108 | SELECT `AgendaEventsDate`.*, `AgendaEvent`.*, `I18n__AgendaEvent__title__nl`.`content`, `I18n__AgendaEvent__url__nl`.`content`, `I18n__AgendaEvent__description__nl`.`content`, `I18n__AgendaEvent__metatitle__nl`.`content`, `I18n__AgendaEvent__metadescription__nl`.`content`, `I18n__AgendaEvent__taggedcontenttitle__nl`.`content` FROM `golf_live`.`agenda_events_dates` AS `AgendaEventsDate` LEFT JOIN `golf_live`.`agenda_events` AS `AgendaEvent` ON (`AgendaEventsDate`.`event_id` = `AgendaEvent`.`id`) LEFT JOIN `golf_live`.`i18n` AS `I18n__AgendaEvent__title__nl` ON (`AgendaEventsDate`.`event_id` = `I18n__AgendaEvent__title__nl`.`foreign_key` AND `I18n__AgendaEvent__title__nl`.`model` = 'AgendaEvent' AND `I18n__AgendaEvent__title__nl`.`field` = 'title' AND `I18n__AgendaEvent__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__AgendaEvent__url__nl` ON (`AgendaEventsDate`.`event_id` = `I18n__AgendaEvent__url__nl`.`foreign_key` AND `I18n__AgendaEvent__url__nl`.`model` = 'AgendaEvent' AND `I18n__AgendaEvent__url__nl`.`field` = 'url' AND `I18n__AgendaEvent__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__AgendaEvent__description__nl` ON (`AgendaEventsDate`.`event_id` = `I18n__AgendaEvent__description__nl`.`foreign_key` AND `I18n__AgendaEvent__description__nl`.`model` = 'AgendaEvent' AND `I18n__AgendaEvent__description__nl`.`field` = 'description' AND `I18n__AgendaEvent__description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__AgendaEvent__metatitle__nl` ON (`AgendaEventsDate`.`event_id` = `I18n__AgendaEvent__metatitle__nl`.`foreign_key` AND `I18n__AgendaEvent__metatitle__nl`.`model` = 'AgendaEvent' AND `I18n__AgendaEvent__metatitle__nl`.`field` = 'metatitle' AND `I18n__AgendaEvent__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__AgendaEvent__metadescription__nl` ON (`AgendaEventsDate`.`event_id` = `I18n__AgendaEvent__metadescription__nl`.`foreign_key` AND `I18n__AgendaEvent__metadescription__nl`.`model` = 'AgendaEvent' AND `I18n__AgendaEvent__metadescription__nl`.`field` = 'metadescription' AND `I18n__AgendaEvent__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__AgendaEvent__taggedcontenttitle__nl` ON (`AgendaEventsDate`.`event_id` = `I18n__AgendaEvent__taggedcontenttitle__nl`.`foreign_key` AND `I18n__AgendaEvent__taggedcontenttitle__nl`.`model` = 'AgendaEvent' AND `I18n__AgendaEvent__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__AgendaEvent__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `AgendaEventsDate`.`end` >= NOW() ORDER BY `AgendaEventsDate`.`start` ASC, `AgendaEventsDate`.`end` ASC LIMIT 3 | | 3 | 3 | 2 |
| 109 | SELECT `AgendaEventsDate`.`id`, `AgendaEventsDate`.`event_id`, `AgendaEventsDate`.`start`, `AgendaEventsDate`.`end`, `AgendaEventsDate`.`allDay` FROM `golf_live`.`agenda_events_dates` AS `AgendaEventsDate` WHERE `AgendaEventsDate`.`event_id` = (868) ORDER BY `AgendaEventsDate`.`start` DESC, `AgendaEventsDate`.`event_id` DESC | | 1 | 1 | 0 |
| 110 | SELECT `EventImage`.`id`, `EventImage`.`model`, `EventImage`.`foreign_key`, `EventImage`.`is_default`, `EventImage`.`name`, `EventImage`.`size`, `EventImage`.`group`, `EventImage`.`ext`, `EventImage`.`type`, `EventImage`.`width`, `EventImage`.`height`, `EventImage`.`sortorder`, `EventImage`.`created`, `EventImage`.`modified` FROM `golf_live`.`files` AS `EventImage` WHERE `EventImage`.`model` = 'AgendaEvent' AND `EventImage`.`foreign_key` = (868) ORDER BY `EventImage`.`is_default` DESC | | 1 | 1 | 0 |
| 111 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'agenda' AND `Tagged`.`model` = 'AgendaEvent' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (868) | | 0 | 0 | 0 |
| 112 | SELECT `Club`.`club_ppholes`, `Club`.`club_holes`, `Club`.`greenfee_weekend`, `Club`.`greenfee_weekdagen`, `Club`.`id`, `Club`.`holes`, `Club`.`street`, `Club`.`street_nr`, `Club`.`zip`, `Club`.`city`, `Club`.`country`, `Club`.`lat`, `Club`.`lng`, `Club`.`state`, `Club`.`email`, `Club`.`phone`, `Club`.`fax`, `Club`.`website`, `Club`.`teetime_url`, `Club`.`sitemap`, `Club`.`leadingcourse_id`, `Club`.`rating`, `Club`.`club_images`, `Club`.`modified`, `Club`.`created`, `Club`.`2020_course_rating`, `Club`.`2020_accomodation_rating`, `Club`.`2020_hospitality_rating`, `Club`.`2020_horeca_rating`, `Club`.`2020_publications_rating`, `Club`.`2020_total_rating`, `Club`.`2021_course_rating`, `Club`.`2021_accomodation_rating`, `Club`.`2021_hospitality_rating`, `Club`.`2021_horeca_rating`, `Club`.`2021_publications_rating`, `Club`.`2021_total_rating`, `Club`.`2022_course_rating`, `Club`.`2022_accomodation_rating`, `Club`.`2022_hospitality_rating`, `Club`.`2022_horeca_rating`, `Club`.`2022_publications_rating`, `Club`.`2022_total_rating`, `Club`.`2023_course_rating`, `Club`.`2023_accomodation_rating`, `Club`.`2023_hospitality_rating`, `Club`.`2023_horeca_rating`, `Club`.`2023_publications_rating`, `Club`.`2023_total_rating`, `EventsToClub`.`id`, `EventsToClub`.`club_id`, `EventsToClub`.`event_id`, `EventsToClub`.`order`, `EventsToClub`.`created` FROM `golf_live`.`clubs` AS `Club` JOIN `golf_live`.`events_to_clubs` AS `EventsToClub` ON (`EventsToClub`.`event_id` = 868 AND `EventsToClub`.`club_id` = `Club`.`id`) | | 1 | 1 | 0 |
| 113 | SELECT `AgendaEventsDate`.`id`, `AgendaEventsDate`.`event_id`, `AgendaEventsDate`.`start`, `AgendaEventsDate`.`end`, `AgendaEventsDate`.`allDay` FROM `golf_live`.`agenda_events_dates` AS `AgendaEventsDate` WHERE `AgendaEventsDate`.`event_id` = (879) ORDER BY `AgendaEventsDate`.`start` DESC, `AgendaEventsDate`.`event_id` DESC | | 1 | 1 | 0 |
| 114 | SELECT `EventImage`.`id`, `EventImage`.`model`, `EventImage`.`foreign_key`, `EventImage`.`is_default`, `EventImage`.`name`, `EventImage`.`size`, `EventImage`.`group`, `EventImage`.`ext`, `EventImage`.`type`, `EventImage`.`width`, `EventImage`.`height`, `EventImage`.`sortorder`, `EventImage`.`created`, `EventImage`.`modified` FROM `golf_live`.`files` AS `EventImage` WHERE `EventImage`.`model` = 'AgendaEvent' AND `EventImage`.`foreign_key` = (879) ORDER BY `EventImage`.`is_default` DESC | | 0 | 0 | 0 |
| 115 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'agenda' AND `Tagged`.`model` = 'AgendaEvent' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (879) | | 0 | 0 | 0 |
| 116 | SELECT `Club`.`club_ppholes`, `Club`.`club_holes`, `Club`.`greenfee_weekend`, `Club`.`greenfee_weekdagen`, `Club`.`id`, `Club`.`holes`, `Club`.`street`, `Club`.`street_nr`, `Club`.`zip`, `Club`.`city`, `Club`.`country`, `Club`.`lat`, `Club`.`lng`, `Club`.`state`, `Club`.`email`, `Club`.`phone`, `Club`.`fax`, `Club`.`website`, `Club`.`teetime_url`, `Club`.`sitemap`, `Club`.`leadingcourse_id`, `Club`.`rating`, `Club`.`club_images`, `Club`.`modified`, `Club`.`created`, `Club`.`2020_course_rating`, `Club`.`2020_accomodation_rating`, `Club`.`2020_hospitality_rating`, `Club`.`2020_horeca_rating`, `Club`.`2020_publications_rating`, `Club`.`2020_total_rating`, `Club`.`2021_course_rating`, `Club`.`2021_accomodation_rating`, `Club`.`2021_hospitality_rating`, `Club`.`2021_horeca_rating`, `Club`.`2021_publications_rating`, `Club`.`2021_total_rating`, `Club`.`2022_course_rating`, `Club`.`2022_accomodation_rating`, `Club`.`2022_hospitality_rating`, `Club`.`2022_horeca_rating`, `Club`.`2022_publications_rating`, `Club`.`2022_total_rating`, `Club`.`2023_course_rating`, `Club`.`2023_accomodation_rating`, `Club`.`2023_hospitality_rating`, `Club`.`2023_horeca_rating`, `Club`.`2023_publications_rating`, `Club`.`2023_total_rating`, `EventsToClub`.`id`, `EventsToClub`.`club_id`, `EventsToClub`.`event_id`, `EventsToClub`.`order`, `EventsToClub`.`created` FROM `golf_live`.`clubs` AS `Club` JOIN `golf_live`.`events_to_clubs` AS `EventsToClub` ON (`EventsToClub`.`event_id` = 879 AND `EventsToClub`.`club_id` = `Club`.`id`) | | 1 | 1 | 0 |
| 117 | SELECT `AgendaEventsDate`.`id`, `AgendaEventsDate`.`event_id`, `AgendaEventsDate`.`start`, `AgendaEventsDate`.`end`, `AgendaEventsDate`.`allDay` FROM `golf_live`.`agenda_events_dates` AS `AgendaEventsDate` WHERE `AgendaEventsDate`.`event_id` = (899) ORDER BY `AgendaEventsDate`.`start` DESC, `AgendaEventsDate`.`event_id` DESC | | 1 | 1 | 0 |
| 118 | SELECT `EventImage`.`id`, `EventImage`.`model`, `EventImage`.`foreign_key`, `EventImage`.`is_default`, `EventImage`.`name`, `EventImage`.`size`, `EventImage`.`group`, `EventImage`.`ext`, `EventImage`.`type`, `EventImage`.`width`, `EventImage`.`height`, `EventImage`.`sortorder`, `EventImage`.`created`, `EventImage`.`modified` FROM `golf_live`.`files` AS `EventImage` WHERE `EventImage`.`model` = 'AgendaEvent' AND `EventImage`.`foreign_key` = (899) ORDER BY `EventImage`.`is_default` DESC | | 0 | 0 | 0 |
| 119 | SELECT `Tagged`.*, `Tagged`.`value` FROM `golf_live`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'agenda' AND `Tagged`.`model` = 'AgendaEvent' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (899) | | 0 | 0 | 0 |
| 120 | SELECT `Club`.`club_ppholes`, `Club`.`club_holes`, `Club`.`greenfee_weekend`, `Club`.`greenfee_weekdagen`, `Club`.`id`, `Club`.`holes`, `Club`.`street`, `Club`.`street_nr`, `Club`.`zip`, `Club`.`city`, `Club`.`country`, `Club`.`lat`, `Club`.`lng`, `Club`.`state`, `Club`.`email`, `Club`.`phone`, `Club`.`fax`, `Club`.`website`, `Club`.`teetime_url`, `Club`.`sitemap`, `Club`.`leadingcourse_id`, `Club`.`rating`, `Club`.`club_images`, `Club`.`modified`, `Club`.`created`, `Club`.`2020_course_rating`, `Club`.`2020_accomodation_rating`, `Club`.`2020_hospitality_rating`, `Club`.`2020_horeca_rating`, `Club`.`2020_publications_rating`, `Club`.`2020_total_rating`, `Club`.`2021_course_rating`, `Club`.`2021_accomodation_rating`, `Club`.`2021_hospitality_rating`, `Club`.`2021_horeca_rating`, `Club`.`2021_publications_rating`, `Club`.`2021_total_rating`, `Club`.`2022_course_rating`, `Club`.`2022_accomodation_rating`, `Club`.`2022_hospitality_rating`, `Club`.`2022_horeca_rating`, `Club`.`2022_publications_rating`, `Club`.`2022_total_rating`, `Club`.`2023_course_rating`, `Club`.`2023_accomodation_rating`, `Club`.`2023_hospitality_rating`, `Club`.`2023_horeca_rating`, `Club`.`2023_publications_rating`, `Club`.`2023_total_rating`, `EventsToClub`.`id`, `EventsToClub`.`club_id`, `EventsToClub`.`event_id`, `EventsToClub`.`order`, `EventsToClub`.`created` FROM `golf_live`.`clubs` AS `Club` JOIN `golf_live`.`events_to_clubs` AS `EventsToClub` ON (`EventsToClub`.`event_id` = 899 AND `EventsToClub`.`club_id` = `Club`.`id`) | | 1 | 1 | 0 |
| 121 | SELECT `AgendaEventsSubscription`.`event_id` FROM `golf_live`.`agenda_events_subscriptions` AS `AgendaEventsSubscription` WHERE `user_id` IS NULL | | 0 | 0 | 0 |
| 122 | SELECT `Club`.*, `I18n__Club__title__nl`.`content`, `I18n__Club__url__nl`.`content`, `I18n__Club__description__nl`.`content`, `I18n__Club__play_description__nl`.`content`, `I18n__Club__visit_description__nl`.`content`, `I18n__Club__greenfee__nl`.`content`, `I18n__Club__metatitle__nl`.`content`, `I18n__Club__metadescription__nl`.`content`, `I18n__Club__taggedcontenttitle__nl`.`content` FROM `golf_live`.`clubs` AS `Club` LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__title__nl` ON (`Club`.`id` = `I18n__Club__title__nl`.`foreign_key` AND `I18n__Club__title__nl`.`model` = 'Club' AND `I18n__Club__title__nl`.`field` = 'title' AND `I18n__Club__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__url__nl` ON (`Club`.`id` = `I18n__Club__url__nl`.`foreign_key` AND `I18n__Club__url__nl`.`model` = 'Club' AND `I18n__Club__url__nl`.`field` = 'url' AND `I18n__Club__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__description__nl` ON (`Club`.`id` = `I18n__Club__description__nl`.`foreign_key` AND `I18n__Club__description__nl`.`model` = 'Club' AND `I18n__Club__description__nl`.`field` = 'description' AND `I18n__Club__description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__play_description__nl` ON (`Club`.`id` = `I18n__Club__play_description__nl`.`foreign_key` AND `I18n__Club__play_description__nl`.`model` = 'Club' AND `I18n__Club__play_description__nl`.`field` = 'play_description' AND `I18n__Club__play_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__visit_description__nl` ON (`Club`.`id` = `I18n__Club__visit_description__nl`.`foreign_key` AND `I18n__Club__visit_description__nl`.`model` = 'Club' AND `I18n__Club__visit_description__nl`.`field` = 'visit_description' AND `I18n__Club__visit_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__greenfee__nl` ON (`Club`.`id` = `I18n__Club__greenfee__nl`.`foreign_key` AND `I18n__Club__greenfee__nl`.`model` = 'Club' AND `I18n__Club__greenfee__nl`.`field` = 'greenfee' AND `I18n__Club__greenfee__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__metatitle__nl` ON (`Club`.`id` = `I18n__Club__metatitle__nl`.`foreign_key` AND `I18n__Club__metatitle__nl`.`model` = 'Club' AND `I18n__Club__metatitle__nl`.`field` = 'metatitle' AND `I18n__Club__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__metadescription__nl` ON (`Club`.`id` = `I18n__Club__metadescription__nl`.`foreign_key` AND `I18n__Club__metadescription__nl`.`model` = 'Club' AND `I18n__Club__metadescription__nl`.`field` = 'metadescription' AND `I18n__Club__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__taggedcontenttitle__nl` ON (`Club`.`id` = `I18n__Club__taggedcontenttitle__nl`.`foreign_key` AND `I18n__Club__taggedcontenttitle__nl`.`model` = 'Club' AND `I18n__Club__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__Club__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `Club`.`id` = 17 | | 1 | 1 | 0 |
| 123 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = Club' | | 0 | 0 | 0 |
| 124 | SELECT `AgendaEventsSubscription`.`event_id` FROM `golf_live`.`agenda_events_subscriptions` AS `AgendaEventsSubscription` WHERE `user_id` IS NULL | | 0 | 0 | 0 |
| 125 | SELECT `Club`.*, `I18n__Club__title__nl`.`content`, `I18n__Club__url__nl`.`content`, `I18n__Club__description__nl`.`content`, `I18n__Club__play_description__nl`.`content`, `I18n__Club__visit_description__nl`.`content`, `I18n__Club__greenfee__nl`.`content`, `I18n__Club__metatitle__nl`.`content`, `I18n__Club__metadescription__nl`.`content`, `I18n__Club__taggedcontenttitle__nl`.`content` FROM `golf_live`.`clubs` AS `Club` LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__title__nl` ON (`Club`.`id` = `I18n__Club__title__nl`.`foreign_key` AND `I18n__Club__title__nl`.`model` = 'Club' AND `I18n__Club__title__nl`.`field` = 'title' AND `I18n__Club__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__url__nl` ON (`Club`.`id` = `I18n__Club__url__nl`.`foreign_key` AND `I18n__Club__url__nl`.`model` = 'Club' AND `I18n__Club__url__nl`.`field` = 'url' AND `I18n__Club__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__description__nl` ON (`Club`.`id` = `I18n__Club__description__nl`.`foreign_key` AND `I18n__Club__description__nl`.`model` = 'Club' AND `I18n__Club__description__nl`.`field` = 'description' AND `I18n__Club__description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__play_description__nl` ON (`Club`.`id` = `I18n__Club__play_description__nl`.`foreign_key` AND `I18n__Club__play_description__nl`.`model` = 'Club' AND `I18n__Club__play_description__nl`.`field` = 'play_description' AND `I18n__Club__play_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__visit_description__nl` ON (`Club`.`id` = `I18n__Club__visit_description__nl`.`foreign_key` AND `I18n__Club__visit_description__nl`.`model` = 'Club' AND `I18n__Club__visit_description__nl`.`field` = 'visit_description' AND `I18n__Club__visit_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__greenfee__nl` ON (`Club`.`id` = `I18n__Club__greenfee__nl`.`foreign_key` AND `I18n__Club__greenfee__nl`.`model` = 'Club' AND `I18n__Club__greenfee__nl`.`field` = 'greenfee' AND `I18n__Club__greenfee__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__metatitle__nl` ON (`Club`.`id` = `I18n__Club__metatitle__nl`.`foreign_key` AND `I18n__Club__metatitle__nl`.`model` = 'Club' AND `I18n__Club__metatitle__nl`.`field` = 'metatitle' AND `I18n__Club__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__metadescription__nl` ON (`Club`.`id` = `I18n__Club__metadescription__nl`.`foreign_key` AND `I18n__Club__metadescription__nl`.`model` = 'Club' AND `I18n__Club__metadescription__nl`.`field` = 'metadescription' AND `I18n__Club__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__taggedcontenttitle__nl` ON (`Club`.`id` = `I18n__Club__taggedcontenttitle__nl`.`foreign_key` AND `I18n__Club__taggedcontenttitle__nl`.`model` = 'Club' AND `I18n__Club__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__Club__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `Club`.`id` = 38 | | 1 | 1 | 0 |
| 126 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = Club' | | 0 | 0 | 0 |
| 127 | SELECT `AgendaEventsSubscription`.`event_id` FROM `golf_live`.`agenda_events_subscriptions` AS `AgendaEventsSubscription` WHERE `user_id` IS NULL | | 0 | 0 | 0 |
| 128 | SELECT `Club`.*, `I18n__Club__title__nl`.`content`, `I18n__Club__url__nl`.`content`, `I18n__Club__description__nl`.`content`, `I18n__Club__play_description__nl`.`content`, `I18n__Club__visit_description__nl`.`content`, `I18n__Club__greenfee__nl`.`content`, `I18n__Club__metatitle__nl`.`content`, `I18n__Club__metadescription__nl`.`content`, `I18n__Club__taggedcontenttitle__nl`.`content` FROM `golf_live`.`clubs` AS `Club` LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__title__nl` ON (`Club`.`id` = `I18n__Club__title__nl`.`foreign_key` AND `I18n__Club__title__nl`.`model` = 'Club' AND `I18n__Club__title__nl`.`field` = 'title' AND `I18n__Club__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__url__nl` ON (`Club`.`id` = `I18n__Club__url__nl`.`foreign_key` AND `I18n__Club__url__nl`.`model` = 'Club' AND `I18n__Club__url__nl`.`field` = 'url' AND `I18n__Club__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__description__nl` ON (`Club`.`id` = `I18n__Club__description__nl`.`foreign_key` AND `I18n__Club__description__nl`.`model` = 'Club' AND `I18n__Club__description__nl`.`field` = 'description' AND `I18n__Club__description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__play_description__nl` ON (`Club`.`id` = `I18n__Club__play_description__nl`.`foreign_key` AND `I18n__Club__play_description__nl`.`model` = 'Club' AND `I18n__Club__play_description__nl`.`field` = 'play_description' AND `I18n__Club__play_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__visit_description__nl` ON (`Club`.`id` = `I18n__Club__visit_description__nl`.`foreign_key` AND `I18n__Club__visit_description__nl`.`model` = 'Club' AND `I18n__Club__visit_description__nl`.`field` = 'visit_description' AND `I18n__Club__visit_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__greenfee__nl` ON (`Club`.`id` = `I18n__Club__greenfee__nl`.`foreign_key` AND `I18n__Club__greenfee__nl`.`model` = 'Club' AND `I18n__Club__greenfee__nl`.`field` = 'greenfee' AND `I18n__Club__greenfee__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__metatitle__nl` ON (`Club`.`id` = `I18n__Club__metatitle__nl`.`foreign_key` AND `I18n__Club__metatitle__nl`.`model` = 'Club' AND `I18n__Club__metatitle__nl`.`field` = 'metatitle' AND `I18n__Club__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__metadescription__nl` ON (`Club`.`id` = `I18n__Club__metadescription__nl`.`foreign_key` AND `I18n__Club__metadescription__nl`.`model` = 'Club' AND `I18n__Club__metadescription__nl`.`field` = 'metadescription' AND `I18n__Club__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__Club__taggedcontenttitle__nl` ON (`Club`.`id` = `I18n__Club__taggedcontenttitle__nl`.`foreign_key` AND `I18n__Club__taggedcontenttitle__nl`.`model` = 'Club' AND `I18n__Club__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__Club__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `Club`.`id` = 77 | | 1 | 1 | 0 |
| 129 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = Club' | | 0 | 0 | 0 |
| 130 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner' LIMIT 1 | | 1 | 1 | 0 |
| 131 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (2) ORDER BY `BannerImages`.`sort_order` ASC | | 0 | 0 | 0 |
| 132 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 2 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 0 | 0 | 0 |
| 133 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner_02' LIMIT 1 | | 1 | 1 | 0 |
| 134 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (9) ORDER BY `BannerImages`.`sort_order` ASC | | 0 | 0 | 0 |
| 135 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 9 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 0 | 0 | 0 |
| 136 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner_03' LIMIT 1 | | 1 | 1 | 0 |
| 137 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (10) ORDER BY `BannerImages`.`sort_order` ASC | | 2 | 2 | 0 |
| 138 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 10 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 1 | 1 | 0 |
| 139 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner_03' LIMIT 1 | | 1 | 1 | 0 |
| 140 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (10) ORDER BY `BannerImages`.`sort_order` ASC | | 2 | 2 | 0 |
| 141 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 10 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 1 | 1 | 0 |
| 142 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner_04' LIMIT 1 | | 1 | 1 | 0 |
| 143 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (11) ORDER BY `BannerImages`.`sort_order` ASC | | 0 | 0 | 0 |
| 144 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 11 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 0 | 0 | 0 |
| 145 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner_05' LIMIT 1 | | 1 | 1 | 0 |
| 146 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (12) ORDER BY `BannerImages`.`sort_order` ASC | | 0 | 0 | 0 |
| 147 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 12 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 0 | 0 | 0 |
| 148 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner_06' LIMIT 1 | | 1 | 1 | 0 |
| 149 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (13) ORDER BY `BannerImages`.`sort_order` ASC | | 2 | 2 | 0 |
| 150 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 13 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 1 | 1 | 0 |
| 151 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner_06' LIMIT 1 | | 1 | 1 | 0 |
| 152 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (13) ORDER BY `BannerImages`.`sort_order` ASC | | 2 | 2 | 0 |
| 153 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 13 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 1 | 1 | 0 |
| 154 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner_07' LIMIT 1 | | 1 | 1 | 0 |
| 155 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (14) ORDER BY `BannerImages`.`sort_order` ASC | | 0 | 0 | 0 |
| 156 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 14 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 0 | 0 | 0 |
| 157 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner_08' LIMIT 1 | | 1 | 1 | 0 |
| 158 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (15) ORDER BY `BannerImages`.`sort_order` ASC | | 0 | 0 | 0 |
| 159 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 15 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 0 | 0 | 0 |
| 160 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner_09' LIMIT 1 | | 1 | 1 | 0 |
| 161 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (16) ORDER BY `BannerImages`.`sort_order` ASC | | 0 | 0 | 0 |
| 162 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 16 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 0 | 0 | 0 |
| 163 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'ads_sidebar_banner_10' LIMIT 1 | | 1 | 1 | 0 |
| 164 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (17) ORDER BY `BannerImages`.`sort_order` ASC | | 0 | 0 | 0 |
| 165 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 17 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 0 | 0 | 0 |
| 166 | SELECT `BlogPost`.`id`, `I18n__BlogPost__url__nl`.`content` FROM `golf_live`.`blog_posts` AS `BlogPost` LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__url__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__url__nl`.`foreign_key` AND `I18n__BlogPost__url__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__url__nl`.`field` = 'url' AND `I18n__BlogPost__url__nl`.`locale` = 'nl') WHERE `I18n__BlogPost__url__nl`.`content` = 'trump-international-golf-links-scotland-promoot-zich-als-beste-36-holes-ter-wereld' AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:54' AND `BlogPost`.`published_until` >= '2026-03-13 11:23:54') OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:54' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-03-13 11:23:54')) AND `BlogPost`.`id` NOT IN (-1) ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`published_from` DESC, `BlogPost`.`created` DESC LIMIT 1 | | 1 | 1 | 2 |
| 167 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogPost' | | 0 | 0 | 0 |
| 168 | SELECT `BlogPost`.`id`, `I18n__BlogPost__url__nl`.`content`, `I18n__BlogPost__url__fr`.`content` FROM `golf_live`.`blog_posts` AS `BlogPost` LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__url__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__url__nl`.`foreign_key` AND `I18n__BlogPost__url__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__url__nl`.`field` = 'url' AND `I18n__BlogPost__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogPost__url__fr` ON (`BlogPost`.`id` = `I18n__BlogPost__url__fr`.`foreign_key` AND `I18n__BlogPost__url__fr`.`model` = 'BlogPost' AND `I18n__BlogPost__url__fr`.`field` = 'url' AND `I18n__BlogPost__url__fr`.`locale` = 'fr') WHERE `BlogPost`.`id` = 22874 AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:54' AND `BlogPost`.`published_until` >= '2026-03-13 11:23:54') OR (`BlogPost`.`published_from` <= '2026-03-13 11:23:54' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-03-13 11:23:54')) AND `BlogPost`.`id` NOT IN (-1) ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`published_from` DESC, `BlogPost`.`created` DESC LIMIT 1 | | 1 | 1 | 1 |
| 169 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogPost' | | 0 | 0 | 0 |
| 170 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'partners_banner' LIMIT 1 | | 1 | 1 | 0 |
| 171 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (1) ORDER BY `BannerImages`.`sort_order` ASC | | 8 | 8 | 0 |
| 172 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 1 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 6 | 6 | 0 |
| 173 | SELECT `Banner`.*, `Banner`.`id` FROM `golf_live`.`banners` AS `Banner` WHERE `Banner`.`title` = 'partners_banner' LIMIT 1 | | 1 | 1 | 0 |
| 174 | SELECT `BannerImages`.`id`, `BannerImages`.`banner_id`, `BannerImages`.`start`, `BannerImages`.`end`, `BannerImages`.`active`, `BannerImages`.`lng`, `BannerImages`.`url`, `BannerImages`.`sort_order`, `BannerImages`.`_blank`, `BannerImages`.`nb_clicks` FROM `golf_live`.`banner_images` AS `BannerImages` WHERE `BannerImages`.`banner_id` = (1) ORDER BY `BannerImages`.`sort_order` ASC | | 8 | 8 | 0 |
| 175 | SELECT `BannerImage`.*, `ItemImage`.*, `I18n__BannerImage__text__nl`.`content`, `I18n__BannerImage__link__nl`.`content` FROM `golf_live`.`banner_images` AS `BannerImage` LEFT JOIN `golf_live`.`files` AS `ItemImage` ON (`ItemImage`.`foreign_key` = `BannerImage`.`id` AND `ItemImage`.`model` = 'BannerImage') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__text__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__text__nl`.`foreign_key` AND `I18n__BannerImage__text__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__text__nl`.`field` = 'text' AND `I18n__BannerImage__text__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BannerImage__link__nl` ON (`BannerImage`.`id` = `I18n__BannerImage__link__nl`.`foreign_key` AND `I18n__BannerImage__link__nl`.`model` = 'BannerImage' AND `I18n__BannerImage__link__nl`.`field` = 'link' AND `I18n__BannerImage__link__nl`.`locale` = 'nl') WHERE `BannerImage`.`banner_id` = 1 AND `BannerImage`.`active` != 'disabled' AND `BannerImage`.`lng` IN ('all', 'nl') ORDER BY `BannerImage`.`sort_order` asc | | 6 | 6 | 0 |
| 176 | SELECT `BlogCategory`.*, `I18n__BlogCategory__title__nl`.`content`, `I18n__BlogCategory__description__nl`.`content`, `I18n__BlogCategory__url__nl`.`content`, `I18n__BlogCategory__metatitle__nl`.`content`, `I18n__BlogCategory__metadescription__nl`.`content`, `I18n__BlogCategory__pagetitle__nl`.`content`, `I18n__BlogCategory__rss_channel_title__nl`.`content`, `I18n__BlogCategory__rss_channel_description__nl`.`content`, `I18n__BlogCategory__taggedcontenttitle__nl`.`content`, `BlogCategory`.`id` FROM `golf_live`.`blog_categories` AS `BlogCategory` LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__title__nl`.`foreign_key` AND `I18n__BlogCategory__title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__title__nl`.`field` = 'title' AND `I18n__BlogCategory__title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__description__nl`.`foreign_key` AND `I18n__BlogCategory__description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__description__nl`.`field` = 'description' AND `I18n__BlogCategory__description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__url__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__url__nl`.`foreign_key` AND `I18n__BlogCategory__url__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__url__nl`.`field` = 'url' AND `I18n__BlogCategory__url__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metatitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metatitle__nl`.`foreign_key` AND `I18n__BlogCategory__metatitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogCategory__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__metadescription__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__metadescription__nl`.`foreign_key` AND `I18n__BlogCategory__metadescription__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogCategory__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__pagetitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__pagetitle__nl`.`foreign_key` AND `I18n__BlogCategory__pagetitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogCategory__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_title__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_title__nl`.`field` = 'rss_channel_title' AND `I18n__BlogCategory__rss_channel_title__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__rss_channel_description__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__rss_channel_description__nl`.`foreign_key` AND `I18n__BlogCategory__rss_channel_description__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__rss_channel_description__nl`.`field` = 'rss_channel_description' AND `I18n__BlogCategory__rss_channel_description__nl`.`locale` = 'nl') LEFT JOIN `golf_live`.`i18n` AS `I18n__BlogCategory__taggedcontenttitle__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogCategory__taggedcontenttitle__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogCategory__taggedcontenttitle__nl`.`locale` = 'nl') WHERE `BlogCategory`.`id` = 1 AND `BlogCategory`.`is_enabled` = '1' LIMIT 1 | | 0 | 0 | 0 |
| 177 | SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golf_live`.`tags` AS `Tag` LEFT JOIN `golf_live`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE `Tag`.`id` = 'SELECT tag_id FROM `tagged` WHERE `model` = BlogCategory' | | 0 | 0 | 0 |