Symfony Profiler

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  (
    tl_page.type = 'root'
    AND (
      tl_page.dns = ?
      OR tl_page.dns = ''
    )
  )

SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns='getmybox.ch' OR tl_page.dns=''));

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias = ?
  OR tl_page.alias = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.alias='index' OR tl_page.alias='/';

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`id` = ?
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`='95' LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  (
    tl_page.type = 'root'
    AND (
      tl_page.dns = ?
      OR tl_page.dns = ''
    )
  )

SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns='getmybox.ch' OR tl_page.dns=''));

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias = ?
  OR tl_page.alias = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.alias='index' OR tl_page.alias='/';

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

SELECT
  tl_layout.*
FROM
  tl_layout
WHERE
  tl_layout.`id` = ?
LIMIT
  0, 1

SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`='11' LIMIT 0,1;

SELECT
  *
FROM
  tl_theme
WHERE
  tl_theme.`id` = ?
LIMIT
  0, 1

SELECT * FROM tl_theme WHERE tl_theme.`id`='1' LIMIT 0,1;

SELECT
  tl_module.*,
  j1.`id` AS boxmaker_jumpToCart__id,
  j1.`pid` AS boxmaker_jumpToCart__pid,
  j1.`sorting` AS boxmaker_jumpToCart__sorting,
  j1.`tstamp` AS boxmaker_jumpToCart__tstamp,
  j1.`title` AS boxmaker_jumpToCart__title,
  j1.`type` AS boxmaker_jumpToCart__type,
  j1.`alias` AS boxmaker_jumpToCart__alias,
  j1.`requireItem` AS boxmaker_jumpToCart__requireItem,
  j1.`routePriority` AS boxmaker_jumpToCart__routePriority,
  j1.`pageTitle` AS boxmaker_jumpToCart__pageTitle,
  j1.`language` AS boxmaker_jumpToCart__language,
  j1.`robots` AS boxmaker_jumpToCart__robots,
  j1.`description` AS boxmaker_jumpToCart__description,
  j1.`redirect` AS boxmaker_jumpToCart__redirect,
  j1.`jumpTo` AS boxmaker_jumpToCart__jumpTo,
  j1.`redirectBack` AS boxmaker_jumpToCart__redirectBack,
  j1.`url` AS boxmaker_jumpToCart__url,
  j1.`target` AS boxmaker_jumpToCart__target,
  j1.`dns` AS boxmaker_jumpToCart__dns,
  j1.`staticFiles` AS boxmaker_jumpToCart__staticFiles,
  j1.`staticPlugins` AS boxmaker_jumpToCart__staticPlugins,
  j1.`fallback` AS boxmaker_jumpToCart__fallback,
  j1.`disableLanguageRedirect` AS boxmaker_jumpToCart__disableLanguageRedirect,
  j1.`favicon` AS boxmaker_jumpToCart__favicon,
  j1.`robotsTxt` AS boxmaker_jumpToCart__robotsTxt,
  j1.`maintenanceMode` AS boxmaker_jumpToCart__maintenanceMode,
  j1.`mailerTransport` AS boxmaker_jumpToCart__mailerTransport,
  j1.`enableCanonical` AS boxmaker_jumpToCart__enableCanonical,
  j1.`canonicalLink` AS boxmaker_jumpToCart__canonicalLink,
  j1.`canonicalKeepParams` AS boxmaker_jumpToCart__canonicalKeepParams,
  j1.`adminEmail` AS boxmaker_jumpToCart__adminEmail,
  j1.`dateFormat` AS boxmaker_jumpToCart__dateFormat,
  j1.`timeFormat` AS boxmaker_jumpToCart__timeFormat,
  j1.`datimFormat` AS boxmaker_jumpToCart__datimFormat,
  j1.`validAliasCharacters` AS boxmaker_jumpToCart__validAliasCharacters,
  j1.`useFolderUrl` AS boxmaker_jumpToCart__useFolderUrl,
  j1.`urlPrefix` AS boxmaker_jumpToCart__urlPrefix,
  j1.`urlSuffix` AS boxmaker_jumpToCart__urlSuffix,
  j1.`useSSL` AS boxmaker_jumpToCart__useSSL,
  j1.`autoforward` AS boxmaker_jumpToCart__autoforward,
  j1.`protected` AS boxmaker_jumpToCart__protected,
  j1.`groups` AS boxmaker_jumpToCart__groups,
  j1.`includeLayout` AS boxmaker_jumpToCart__includeLayout,
  j1.`layout` AS boxmaker_jumpToCart__layout,
  j1.`subpageLayout` AS boxmaker_jumpToCart__subpageLayout,
  j1.`includeCache` AS boxmaker_jumpToCart__includeCache,
  j1.`cache` AS boxmaker_jumpToCart__cache,
  j1.`alwaysLoadFromCache` AS boxmaker_jumpToCart__alwaysLoadFromCache,
  j1.`clientCache` AS boxmaker_jumpToCart__clientCache,
  j1.`includeChmod` AS boxmaker_jumpToCart__includeChmod,
  j1.`cuser` AS boxmaker_jumpToCart__cuser,
  j1.`cgroup` AS boxmaker_jumpToCart__cgroup,
  j1.`chmod` AS boxmaker_jumpToCart__chmod,
  j1.`noSearch` AS boxmaker_jumpToCart__noSearch,
  j1.`cssClass` AS boxmaker_jumpToCart__cssClass,
  j1.`sitemap` AS boxmaker_jumpToCart__sitemap,
  j1.`hide` AS boxmaker_jumpToCart__hide,
  j1.`guests` AS boxmaker_jumpToCart__guests,
  j1.`tabindex` AS boxmaker_jumpToCart__tabindex,
  j1.`accesskey` AS boxmaker_jumpToCart__accesskey,
  j1.`published` AS boxmaker_jumpToCart__published,
  j1.`start` AS boxmaker_jumpToCart__start,
  j1.`stop` AS boxmaker_jumpToCart__stop,
  j1.`enforceTwoFactor` AS boxmaker_jumpToCart__enforceTwoFactor,
  j1.`twoFactorJumpTo` AS boxmaker_jumpToCart__twoFactorJumpTo,
  j1.`pageIcon` AS boxmaker_jumpToCart__pageIcon,
  j1.`navigationTeaser` AS boxmaker_jumpToCart__navigationTeaser,
  j1.`navigationHasIcons` AS boxmaker_jumpToCart__navigationHasIcons,
  j1.`navigationIcon` AS boxmaker_jumpToCart__navigationIcon,
  j1.`languageMain` AS boxmaker_jumpToCart__languageMain,
  j1.`languageRoot` AS boxmaker_jumpToCart__languageRoot,
  j1.`languageQuery` AS boxmaker_jumpToCart__languageQuery,
  j1.`cssStyleSelector` AS boxmaker_jumpToCart__cssStyleSelector,
  j2.`id` AS boxmaker_jumpToStart__id,
  j2.`pid` AS boxmaker_jumpToStart__pid,
  j2.`sorting` AS boxmaker_jumpToStart__sorting,
  j2.`tstamp` AS boxmaker_jumpToStart__tstamp,
  j2.`title` AS boxmaker_jumpToStart__title,
  j2.`type` AS boxmaker_jumpToStart__type,
  j2.`alias` AS boxmaker_jumpToStart__alias,
  j2.`requireItem` AS boxmaker_jumpToStart__requireItem,
  j2.`routePriority` AS boxmaker_jumpToStart__routePriority,
  j2.`pageTitle` AS boxmaker_jumpToStart__pageTitle,
  j2.`language` AS boxmaker_jumpToStart__language,
  j2.`robots` AS boxmaker_jumpToStart__robots,
  j2.`description` AS boxmaker_jumpToStart__description,
  j2.`redirect` AS boxmaker_jumpToStart__redirect,
  j2.`jumpTo` AS boxmaker_jumpToStart__jumpTo,
  j2.`redirectBack` AS boxmaker_jumpToStart__redirectBack,
  j2.`url` AS boxmaker_jumpToStart__url,
  j2.`target` AS boxmaker_jumpToStart__target,
  j2.`dns` AS boxmaker_jumpToStart__dns,
  j2.`staticFiles` AS boxmaker_jumpToStart__staticFiles,
  j2.`staticPlugins` AS boxmaker_jumpToStart__staticPlugins,
  j2.`fallback` AS boxmaker_jumpToStart__fallback,
  j2.`disableLanguageRedirect` AS boxmaker_jumpToStart__disableLanguageRedirect,
  j2.`favicon` AS boxmaker_jumpToStart__favicon,
  j2.`robotsTxt` AS boxmaker_jumpToStart__robotsTxt,
  j2.`maintenanceMode` AS boxmaker_jumpToStart__maintenanceMode,
  j2.`mailerTransport` AS boxmaker_jumpToStart__mailerTransport,
  j2.`enableCanonical` AS boxmaker_jumpToStart__enableCanonical,
  j2.`canonicalLink` AS boxmaker_jumpToStart__canonicalLink,
  j2.`canonicalKeepParams` AS boxmaker_jumpToStart__canonicalKeepParams,
  j2.`adminEmail` AS boxmaker_jumpToStart__adminEmail,
  j2.`dateFormat` AS boxmaker_jumpToStart__dateFormat,
  j2.`timeFormat` AS boxmaker_jumpToStart__timeFormat,
  j2.`datimFormat` AS boxmaker_jumpToStart__datimFormat,
  j2.`validAliasCharacters` AS boxmaker_jumpToStart__validAliasCharacters,
  j2.`useFolderUrl` AS boxmaker_jumpToStart__useFolderUrl,
  j2.`urlPrefix` AS boxmaker_jumpToStart__urlPrefix,
  j2.`urlSuffix` AS boxmaker_jumpToStart__urlSuffix,
  j2.`useSSL` AS boxmaker_jumpToStart__useSSL,
  j2.`autoforward` AS boxmaker_jumpToStart__autoforward,
  j2.`protected` AS boxmaker_jumpToStart__protected,
  j2.`groups` AS boxmaker_jumpToStart__groups,
  j2.`includeLayout` AS boxmaker_jumpToStart__includeLayout,
  j2.`layout` AS boxmaker_jumpToStart__layout,
  j2.`subpageLayout` AS boxmaker_jumpToStart__subpageLayout,
  j2.`includeCache` AS boxmaker_jumpToStart__includeCache,
  j2.`cache` AS boxmaker_jumpToStart__cache,
  j2.`alwaysLoadFromCache` AS boxmaker_jumpToStart__alwaysLoadFromCache,
  j2.`clientCache` AS boxmaker_jumpToStart__clientCache,
  j2.`includeChmod` AS boxmaker_jumpToStart__includeChmod,
  j2.`cuser` AS boxmaker_jumpToStart__cuser,
  j2.`cgroup` AS boxmaker_jumpToStart__cgroup,
  j2.`chmod` AS boxmaker_jumpToStart__chmod,
  j2.`noSearch` AS boxmaker_jumpToStart__noSearch,
  j2.`cssClass` AS boxmaker_jumpToStart__cssClass,
  j2.`sitemap` AS boxmaker_jumpToStart__sitemap,
  j2.`hide` AS boxmaker_jumpToStart__hide,
  j2.`guests` AS boxmaker_jumpToStart__guests,
  j2.`tabindex` AS boxmaker_jumpToStart__tabindex,
  j2.`accesskey` AS boxmaker_jumpToStart__accesskey,
  j2.`published` AS boxmaker_jumpToStart__published,
  j2.`start` AS boxmaker_jumpToStart__start,
  j2.`stop` AS boxmaker_jumpToStart__stop,
  j2.`enforceTwoFactor` AS boxmaker_jumpToStart__enforceTwoFactor,
  j2.`twoFactorJumpTo` AS boxmaker_jumpToStart__twoFactorJumpTo,
  j2.`pageIcon` AS boxmaker_jumpToStart__pageIcon,
  j2.`navigationTeaser` AS boxmaker_jumpToStart__navigationTeaser,
  j2.`navigationHasIcons` AS boxmaker_jumpToStart__navigationHasIcons,
  j2.`navigationIcon` AS boxmaker_jumpToStart__navigationIcon,
  j2.`languageMain` AS boxmaker_jumpToStart__languageMain,
  j2.`languageRoot` AS boxmaker_jumpToStart__languageRoot,
  j2.`languageQuery` AS boxmaker_jumpToStart__languageQuery,
  j2.`cssStyleSelector` AS boxmaker_jumpToStart__cssStyleSelector,
  j3.`id` AS boxmaker_jumpToConfirmation__id,
  j3.`pid` AS boxmaker_jumpToConfirmation__pid,
  j3.`sorting` AS boxmaker_jumpToConfirmation__sorting,
  j3.`tstamp` AS boxmaker_jumpToConfirmation__tstamp,
  j3.`title` AS boxmaker_jumpToConfirmation__title,
  j3.`type` AS boxmaker_jumpToConfirmation__type,
  j3.`alias` AS boxmaker_jumpToConfirmation__alias,
  j3.`requireItem` AS boxmaker_jumpToConfirmation__requireItem,
  j3.`routePriority` AS boxmaker_jumpToConfirmation__routePriority,
  j3.`pageTitle` AS boxmaker_jumpToConfirmation__pageTitle,
  j3.`language` AS boxmaker_jumpToConfirmation__language,
  j3.`robots` AS boxmaker_jumpToConfirmation__robots,
  j3.`description` AS boxmaker_jumpToConfirmation__description,
  j3.`redirect` AS boxmaker_jumpToConfirmation__redirect,
  j3.`jumpTo` AS boxmaker_jumpToConfirmation__jumpTo,
  j3.`redirectBack` AS boxmaker_jumpToConfirmation__redirectBack,
  j3.`url` AS boxmaker_jumpToConfirmation__url,
  j3.`target` AS boxmaker_jumpToConfirmation__target,
  j3.`dns` AS boxmaker_jumpToConfirmation__dns,
  j3.`staticFiles` AS boxmaker_jumpToConfirmation__staticFiles,
  j3.`staticPlugins` AS boxmaker_jumpToConfirmation__staticPlugins,
  j3.`fallback` AS boxmaker_jumpToConfirmation__fallback,
  j3.`disableLanguageRedirect` AS boxmaker_jumpToConfirmation__disableLanguageRedirect,
  j3.`favicon` AS boxmaker_jumpToConfirmation__favicon,
  j3.`robotsTxt` AS boxmaker_jumpToConfirmation__robotsTxt,
  j3.`maintenanceMode` AS boxmaker_jumpToConfirmation__maintenanceMode,
  j3.`mailerTransport` AS boxmaker_jumpToConfirmation__mailerTransport,
  j3.`enableCanonical` AS boxmaker_jumpToConfirmation__enableCanonical,
  j3.`canonicalLink` AS boxmaker_jumpToConfirmation__canonicalLink,
  j3.`canonicalKeepParams` AS boxmaker_jumpToConfirmation__canonicalKeepParams,
  j3.`adminEmail` AS boxmaker_jumpToConfirmation__adminEmail,
  j3.`dateFormat` AS boxmaker_jumpToConfirmation__dateFormat,
  j3.`timeFormat` AS boxmaker_jumpToConfirmation__timeFormat,
  j3.`datimFormat` AS boxmaker_jumpToConfirmation__datimFormat,
  j3.`validAliasCharacters` AS boxmaker_jumpToConfirmation__validAliasCharacters,
  j3.`useFolderUrl` AS boxmaker_jumpToConfirmation__useFolderUrl,
  j3.`urlPrefix` AS boxmaker_jumpToConfirmation__urlPrefix,
  j3.`urlSuffix` AS boxmaker_jumpToConfirmation__urlSuffix,
  j3.`useSSL` AS boxmaker_jumpToConfirmation__useSSL,
  j3.`autoforward` AS boxmaker_jumpToConfirmation__autoforward,
  j3.`protected` AS boxmaker_jumpToConfirmation__protected,
  j3.`groups` AS boxmaker_jumpToConfirmation__groups,
  j3.`includeLayout` AS boxmaker_jumpToConfirmation__includeLayout,
  j3.`layout` AS boxmaker_jumpToConfirmation__layout,
  j3.`subpageLayout` AS boxmaker_jumpToConfirmation__subpageLayout,
  j3.`includeCache` AS boxmaker_jumpToConfirmation__includeCache,
  j3.`cache` AS boxmaker_jumpToConfirmation__cache,
  j3.`alwaysLoadFromCache` AS boxmaker_jumpToConfirmation__alwaysLoadFromCache,
  j3.`clientCache` AS boxmaker_jumpToConfirmation__clientCache,
  j3.`includeChmod` AS boxmaker_jumpToConfirmation__includeChmod,
  j3.`cuser` AS boxmaker_jumpToConfirmation__cuser,
  j3.`cgroup` AS boxmaker_jumpToConfirmation__cgroup,
  j3.`chmod` AS boxmaker_jumpToConfirmation__chmod,
  j3.`noSearch` AS boxmaker_jumpToConfirmation__noSearch,
  j3.`cssClass` AS boxmaker_jumpToConfirmation__cssClass,
  j3.`sitemap` AS boxmaker_jumpToConfirmation__sitemap,
  j3.`hide` AS boxmaker_jumpToConfirmation__hide,
  j3.`guests` AS boxmaker_jumpToConfirmation__guests,
  j3.`tabindex` AS boxmaker_jumpToConfirmation__tabindex,
  j3.`accesskey` AS boxmaker_jumpToConfirmation__accesskey,
  j3.`published` AS boxmaker_jumpToConfirmation__published,
  j3.`start` AS boxmaker_jumpToConfirmation__start,
  j3.`stop` AS boxmaker_jumpToConfirmation__stop,
  j3.`enforceTwoFactor` AS boxmaker_jumpToConfirmation__enforceTwoFactor,
  j3.`twoFactorJumpTo` AS boxmaker_jumpToConfirmation__twoFactorJumpTo,
  j3.`pageIcon` AS boxmaker_jumpToConfirmation__pageIcon,
  j3.`navigationTeaser` AS boxmaker_jumpToConfirmation__navigationTeaser,
  j3.`navigationHasIcons` AS boxmaker_jumpToConfirmation__navigationHasIcons,
  j3.`navigationIcon` AS boxmaker_jumpToConfirmation__navigationIcon,
  j3.`languageMain` AS boxmaker_jumpToConfirmation__languageMain,
  j3.`languageRoot` AS boxmaker_jumpToConfirmation__languageRoot,
  j3.`languageQuery` AS boxmaker_jumpToConfirmation__languageQuery,
  j3.`cssStyleSelector` AS boxmaker_jumpToConfirmation__cssStyleSelector,
  j4.`id` AS boxmaker_jumpToOfferConfirmation__id,
  j4.`pid` AS boxmaker_jumpToOfferConfirmation__pid,
  j4.`sorting` AS boxmaker_jumpToOfferConfirmation__sorting,
  j4.`tstamp` AS boxmaker_jumpToOfferConfirmation__tstamp,
  j4.`title` AS boxmaker_jumpToOfferConfirmation__title,
  j4.`type` AS boxmaker_jumpToOfferConfirmation__type,
  j4.`alias` AS boxmaker_jumpToOfferConfirmation__alias,
  j4.`requireItem` AS boxmaker_jumpToOfferConfirmation__requireItem,
  j4.`routePriority` AS boxmaker_jumpToOfferConfirmation__routePriority,
  j4.`pageTitle` AS boxmaker_jumpToOfferConfirmation__pageTitle,
  j4.`language` AS boxmaker_jumpToOfferConfirmation__language,
  j4.`robots` AS boxmaker_jumpToOfferConfirmation__robots,
  j4.`description` AS boxmaker_jumpToOfferConfirmation__description,
  j4.`redirect` AS boxmaker_jumpToOfferConfirmation__redirect,
  j4.`jumpTo` AS boxmaker_jumpToOfferConfirmation__jumpTo,
  j4.`redirectBack` AS boxmaker_jumpToOfferConfirmation__redirectBack,
  j4.`url` AS boxmaker_jumpToOfferConfirmation__url,
  j4.`target` AS boxmaker_jumpToOfferConfirmation__target,
  j4.`dns` AS boxmaker_jumpToOfferConfirmation__dns,
  j4.`staticFiles` AS boxmaker_jumpToOfferConfirmation__staticFiles,
  j4.`staticPlugins` AS boxmaker_jumpToOfferConfirmation__staticPlugins,
  j4.`fallback` AS boxmaker_jumpToOfferConfirmation__fallback,
  j4.`disableLanguageRedirect` AS boxmaker_jumpToOfferConfirmation__disableLanguageRedirect,
  j4.`favicon` AS boxmaker_jumpToOfferConfirmation__favicon,
  j4.`robotsTxt` AS boxmaker_jumpToOfferConfirmation__robotsTxt,
  j4.`maintenanceMode` AS boxmaker_jumpToOfferConfirmation__maintenanceMode,
  j4.`mailerTransport` AS boxmaker_jumpToOfferConfirmation__mailerTransport,
  j4.`enableCanonical` AS boxmaker_jumpToOfferConfirmation__enableCanonical,
  j4.`canonicalLink` AS boxmaker_jumpToOfferConfirmation__canonicalLink,
  j4.`canonicalKeepParams` AS boxmaker_jumpToOfferConfirmation__canonicalKeepParams,
  j4.`adminEmail` AS boxmaker_jumpToOfferConfirmation__adminEmail,
  j4.`dateFormat` AS boxmaker_jumpToOfferConfirmation__dateFormat,
  j4.`timeFormat` AS boxmaker_jumpToOfferConfirmation__timeFormat,
  j4.`datimFormat` AS boxmaker_jumpToOfferConfirmation__datimFormat,
  j4.`validAliasCharacters` AS boxmaker_jumpToOfferConfirmation__validAliasCharacters,
  j4.`useFolderUrl` AS boxmaker_jumpToOfferConfirmation__useFolderUrl,
  j4.`urlPrefix` AS boxmaker_jumpToOfferConfirmation__urlPrefix,
  j4.`urlSuffix` AS boxmaker_jumpToOfferConfirmation__urlSuffix,
  j4.`useSSL` AS boxmaker_jumpToOfferConfirmation__useSSL,
  j4.`autoforward` AS boxmaker_jumpToOfferConfirmation__autoforward,
  j4.`protected` AS boxmaker_jumpToOfferConfirmation__protected,
  j4.`groups` AS boxmaker_jumpToOfferConfirmation__groups,
  j4.`includeLayout` AS boxmaker_jumpToOfferConfirmation__includeLayout,
  j4.`layout` AS boxmaker_jumpToOfferConfirmation__layout,
  j4.`subpageLayout` AS boxmaker_jumpToOfferConfirmation__subpageLayout,
  j4.`includeCache` AS boxmaker_jumpToOfferConfirmation__includeCache,
  j4.`cache` AS boxmaker_jumpToOfferConfirmation__cache,
  j4.`alwaysLoadFromCache` AS boxmaker_jumpToOfferConfirmation__alwaysLoadFromCache,
  j4.`clientCache` AS boxmaker_jumpToOfferConfirmation__clientCache,
  j4.`includeChmod` AS boxmaker_jumpToOfferConfirmation__includeChmod,
  j4.`cuser` AS boxmaker_jumpToOfferConfirmation__cuser,
  j4.`cgroup` AS boxmaker_jumpToOfferConfirmation__cgroup,
  j4.`chmod` AS boxmaker_jumpToOfferConfirmation__chmod,
  j4.`noSearch` AS boxmaker_jumpToOfferConfirmation__noSearch,
  j4.`cssClass` AS boxmaker_jumpToOfferConfirmation__cssClass,
  j4.`sitemap` AS boxmaker_jumpToOfferConfirmation__sitemap,
  j4.`hide` AS boxmaker_jumpToOfferConfirmation__hide,
  j4.`guests` AS boxmaker_jumpToOfferConfirmation__guests,
  j4.`tabindex` AS boxmaker_jumpToOfferConfirmation__tabindex,
  j4.`accesskey` AS boxmaker_jumpToOfferConfirmation__accesskey,
  j4.`published` AS boxmaker_jumpToOfferConfirmation__published,
  j4.`start` AS boxmaker_jumpToOfferConfirmation__start,
  j4.`stop` AS boxmaker_jumpToOfferConfirmation__stop,
  j4.`enforceTwoFactor` AS boxmaker_jumpToOfferConfirmation__enforceTwoFactor,
  j4.`twoFactorJumpTo` AS boxmaker_jumpToOfferConfirmation__twoFactorJumpTo,
  j4.`pageIcon` AS boxmaker_jumpToOfferConfirmation__pageIcon,
  j4.`navigationTeaser` AS boxmaker_jumpToOfferConfirmation__navigationTeaser,
  j4.`navigationHasIcons` AS boxmaker_jumpToOfferConfirmation__navigationHasIcons,
  j4.`navigationIcon` AS boxmaker_jumpToOfferConfirmation__navigationIcon,
  j4.`languageMain` AS boxmaker_jumpToOfferConfirmation__languageMain,
  j4.`languageRoot` AS boxmaker_jumpToOfferConfirmation__languageRoot,
  j4.`languageQuery` AS boxmaker_jumpToOfferConfirmation__languageQuery,
  j4.`cssStyleSelector` AS boxmaker_jumpToOfferConfirmation__cssStyleSelector
FROM
  tl_module
  LEFT JOIN tl_page j1 ON tl_module.`boxmaker_jumpToCart` = j1.id
  LEFT JOIN tl_page j2 ON tl_module.`boxmaker_jumpToStart` = j2.id
  LEFT JOIN tl_page j3 ON tl_module.`boxmaker_jumpToConfirmation` = j3.id
  LEFT JOIN tl_page j4 ON tl_module.`boxmaker_jumpToOfferConfirmation` = j4.id
WHERE
  tl_module.id IN(54, 55, 20, 0, 0, 0, 0, 7, 16)
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '54,55,20,0,0,0,0,7,16'
  )

SELECT tl_module.*, j1.`id` AS boxmaker_jumpToCart__id, j1.`pid` AS boxmaker_jumpToCart__pid, j1.`sorting` AS boxmaker_jumpToCart__sorting, j1.`tstamp` AS boxmaker_jumpToCart__tstamp, j1.`title` AS boxmaker_jumpToCart__title, j1.`type` AS boxmaker_jumpToCart__type, j1.`alias` AS boxmaker_jumpToCart__alias, j1.`requireItem` AS boxmaker_jumpToCart__requireItem, j1.`routePriority` AS boxmaker_jumpToCart__routePriority, j1.`pageTitle` AS boxmaker_jumpToCart__pageTitle, j1.`language` AS boxmaker_jumpToCart__language, j1.`robots` AS boxmaker_jumpToCart__robots, j1.`description` AS boxmaker_jumpToCart__description, j1.`redirect` AS boxmaker_jumpToCart__redirect, j1.`jumpTo` AS boxmaker_jumpToCart__jumpTo, j1.`redirectBack` AS boxmaker_jumpToCart__redirectBack, j1.`url` AS boxmaker_jumpToCart__url, j1.`target` AS boxmaker_jumpToCart__target, j1.`dns` AS boxmaker_jumpToCart__dns, j1.`staticFiles` AS boxmaker_jumpToCart__staticFiles, j1.`staticPlugins` AS boxmaker_jumpToCart__staticPlugins, j1.`fallback` AS boxmaker_jumpToCart__fallback, j1.`disableLanguageRedirect` AS boxmaker_jumpToCart__disableLanguageRedirect, j1.`favicon` AS boxmaker_jumpToCart__favicon, j1.`robotsTxt` AS boxmaker_jumpToCart__robotsTxt, j1.`maintenanceMode` AS boxmaker_jumpToCart__maintenanceMode, j1.`mailerTransport` AS boxmaker_jumpToCart__mailerTransport, j1.`enableCanonical` AS boxmaker_jumpToCart__enableCanonical, j1.`canonicalLink` AS boxmaker_jumpToCart__canonicalLink, j1.`canonicalKeepParams` AS boxmaker_jumpToCart__canonicalKeepParams, j1.`adminEmail` AS boxmaker_jumpToCart__adminEmail, j1.`dateFormat` AS boxmaker_jumpToCart__dateFormat, j1.`timeFormat` AS boxmaker_jumpToCart__timeFormat, j1.`datimFormat` AS boxmaker_jumpToCart__datimFormat, j1.`validAliasCharacters` AS boxmaker_jumpToCart__validAliasCharacters, j1.`useFolderUrl` AS boxmaker_jumpToCart__useFolderUrl, j1.`urlPrefix` AS boxmaker_jumpToCart__urlPrefix, j1.`urlSuffix` AS boxmaker_jumpToCart__urlSuffix, j1.`useSSL` AS boxmaker_jumpToCart__useSSL, j1.`autoforward` AS boxmaker_jumpToCart__autoforward, j1.`protected` AS boxmaker_jumpToCart__protected, j1.`groups` AS boxmaker_jumpToCart__groups, j1.`includeLayout` AS boxmaker_jumpToCart__includeLayout, j1.`layout` AS boxmaker_jumpToCart__layout, j1.`subpageLayout` AS boxmaker_jumpToCart__subpageLayout, j1.`includeCache` AS boxmaker_jumpToCart__includeCache, j1.`cache` AS boxmaker_jumpToCart__cache, j1.`alwaysLoadFromCache` AS boxmaker_jumpToCart__alwaysLoadFromCache, j1.`clientCache` AS boxmaker_jumpToCart__clientCache, j1.`includeChmod` AS boxmaker_jumpToCart__includeChmod, j1.`cuser` AS boxmaker_jumpToCart__cuser, j1.`cgroup` AS boxmaker_jumpToCart__cgroup, j1.`chmod` AS boxmaker_jumpToCart__chmod, j1.`noSearch` AS boxmaker_jumpToCart__noSearch, j1.`cssClass` AS boxmaker_jumpToCart__cssClass, j1.`sitemap` AS boxmaker_jumpToCart__sitemap, j1.`hide` AS boxmaker_jumpToCart__hide, j1.`guests` AS boxmaker_jumpToCart__guests, j1.`tabindex` AS boxmaker_jumpToCart__tabindex, j1.`accesskey` AS boxmaker_jumpToCart__accesskey, j1.`published` AS boxmaker_jumpToCart__published, j1.`start` AS boxmaker_jumpToCart__start, j1.`stop` AS boxmaker_jumpToCart__stop, j1.`enforceTwoFactor` AS boxmaker_jumpToCart__enforceTwoFactor, j1.`twoFactorJumpTo` AS boxmaker_jumpToCart__twoFactorJumpTo, j1.`pageIcon` AS boxmaker_jumpToCart__pageIcon, j1.`navigationTeaser` AS boxmaker_jumpToCart__navigationTeaser, j1.`navigationHasIcons` AS boxmaker_jumpToCart__navigationHasIcons, j1.`navigationIcon` AS boxmaker_jumpToCart__navigationIcon, j1.`languageMain` AS boxmaker_jumpToCart__languageMain, j1.`languageRoot` AS boxmaker_jumpToCart__languageRoot, j1.`languageQuery` AS boxmaker_jumpToCart__languageQuery, j1.`cssStyleSelector` AS boxmaker_jumpToCart__cssStyleSelector, j2.`id` AS boxmaker_jumpToStart__id, j2.`pid` AS boxmaker_jumpToStart__pid, j2.`sorting` AS boxmaker_jumpToStart__sorting, j2.`tstamp` AS boxmaker_jumpToStart__tstamp, j2.`title` AS boxmaker_jumpToStart__title, j2.`type` AS boxmaker_jumpToStart__type, j2.`alias` AS boxmaker_jumpToStart__alias, j2.`requireItem` AS boxmaker_jumpToStart__requireItem, j2.`routePriority` AS boxmaker_jumpToStart__routePriority, j2.`pageTitle` AS boxmaker_jumpToStart__pageTitle, j2.`language` AS boxmaker_jumpToStart__language, j2.`robots` AS boxmaker_jumpToStart__robots, j2.`description` AS boxmaker_jumpToStart__description, j2.`redirect` AS boxmaker_jumpToStart__redirect, j2.`jumpTo` AS boxmaker_jumpToStart__jumpTo, j2.`redirectBack` AS boxmaker_jumpToStart__redirectBack, j2.`url` AS boxmaker_jumpToStart__url, j2.`target` AS boxmaker_jumpToStart__target, j2.`dns` AS boxmaker_jumpToStart__dns, j2.`staticFiles` AS boxmaker_jumpToStart__staticFiles, j2.`staticPlugins` AS boxmaker_jumpToStart__staticPlugins, j2.`fallback` AS boxmaker_jumpToStart__fallback, j2.`disableLanguageRedirect` AS boxmaker_jumpToStart__disableLanguageRedirect, j2.`favicon` AS boxmaker_jumpToStart__favicon, j2.`robotsTxt` AS boxmaker_jumpToStart__robotsTxt, j2.`maintenanceMode` AS boxmaker_jumpToStart__maintenanceMode, j2.`mailerTransport` AS boxmaker_jumpToStart__mailerTransport, j2.`enableCanonical` AS boxmaker_jumpToStart__enableCanonical, j2.`canonicalLink` AS boxmaker_jumpToStart__canonicalLink, j2.`canonicalKeepParams` AS boxmaker_jumpToStart__canonicalKeepParams, j2.`adminEmail` AS boxmaker_jumpToStart__adminEmail, j2.`dateFormat` AS boxmaker_jumpToStart__dateFormat, j2.`timeFormat` AS boxmaker_jumpToStart__timeFormat, j2.`datimFormat` AS boxmaker_jumpToStart__datimFormat, j2.`validAliasCharacters` AS boxmaker_jumpToStart__validAliasCharacters, j2.`useFolderUrl` AS boxmaker_jumpToStart__useFolderUrl, j2.`urlPrefix` AS boxmaker_jumpToStart__urlPrefix, j2.`urlSuffix` AS boxmaker_jumpToStart__urlSuffix, j2.`useSSL` AS boxmaker_jumpToStart__useSSL, j2.`autoforward` AS boxmaker_jumpToStart__autoforward, j2.`protected` AS boxmaker_jumpToStart__protected, j2.`groups` AS boxmaker_jumpToStart__groups, j2.`includeLayout` AS boxmaker_jumpToStart__includeLayout, j2.`layout` AS boxmaker_jumpToStart__layout, j2.`subpageLayout` AS boxmaker_jumpToStart__subpageLayout, j2.`includeCache` AS boxmaker_jumpToStart__includeCache, j2.`cache` AS boxmaker_jumpToStart__cache, j2.`alwaysLoadFromCache` AS boxmaker_jumpToStart__alwaysLoadFromCache, j2.`clientCache` AS boxmaker_jumpToStart__clientCache, j2.`includeChmod` AS boxmaker_jumpToStart__includeChmod, j2.`cuser` AS boxmaker_jumpToStart__cuser, j2.`cgroup` AS boxmaker_jumpToStart__cgroup, j2.`chmod` AS boxmaker_jumpToStart__chmod, j2.`noSearch` AS boxmaker_jumpToStart__noSearch, j2.`cssClass` AS boxmaker_jumpToStart__cssClass, j2.`sitemap` AS boxmaker_jumpToStart__sitemap, j2.`hide` AS boxmaker_jumpToStart__hide, j2.`guests` AS boxmaker_jumpToStart__guests, j2.`tabindex` AS boxmaker_jumpToStart__tabindex, j2.`accesskey` AS boxmaker_jumpToStart__accesskey, j2.`published` AS boxmaker_jumpToStart__published, j2.`start` AS boxmaker_jumpToStart__start, j2.`stop` AS boxmaker_jumpToStart__stop, j2.`enforceTwoFactor` AS boxmaker_jumpToStart__enforceTwoFactor, j2.`twoFactorJumpTo` AS boxmaker_jumpToStart__twoFactorJumpTo, j2.`pageIcon` AS boxmaker_jumpToStart__pageIcon, j2.`navigationTeaser` AS boxmaker_jumpToStart__navigationTeaser, j2.`navigationHasIcons` AS boxmaker_jumpToStart__navigationHasIcons, j2.`navigationIcon` AS boxmaker_jumpToStart__navigationIcon, j2.`languageMain` AS boxmaker_jumpToStart__languageMain, j2.`languageRoot` AS boxmaker_jumpToStart__languageRoot, j2.`languageQuery` AS boxmaker_jumpToStart__languageQuery, j2.`cssStyleSelector` AS boxmaker_jumpToStart__cssStyleSelector, j3.`id` AS boxmaker_jumpToConfirmation__id, j3.`pid` AS boxmaker_jumpToConfirmation__pid, j3.`sorting` AS boxmaker_jumpToConfirmation__sorting, j3.`tstamp` AS boxmaker_jumpToConfirmation__tstamp, j3.`title` AS boxmaker_jumpToConfirmation__title, j3.`type` AS boxmaker_jumpToConfirmation__type, j3.`alias` AS boxmaker_jumpToConfirmation__alias, j3.`requireItem` AS boxmaker_jumpToConfirmation__requireItem, j3.`routePriority` AS boxmaker_jumpToConfirmation__routePriority, j3.`pageTitle` AS boxmaker_jumpToConfirmation__pageTitle, j3.`language` AS boxmaker_jumpToConfirmation__language, j3.`robots` AS boxmaker_jumpToConfirmation__robots, j3.`description` AS boxmaker_jumpToConfirmation__description, j3.`redirect` AS boxmaker_jumpToConfirmation__redirect, j3.`jumpTo` AS boxmaker_jumpToConfirmation__jumpTo, j3.`redirectBack` AS boxmaker_jumpToConfirmation__redirectBack, j3.`url` AS boxmaker_jumpToConfirmation__url, j3.`target` AS boxmaker_jumpToConfirmation__target, j3.`dns` AS boxmaker_jumpToConfirmation__dns, j3.`staticFiles` AS boxmaker_jumpToConfirmation__staticFiles, j3.`staticPlugins` AS boxmaker_jumpToConfirmation__staticPlugins, j3.`fallback` AS boxmaker_jumpToConfirmation__fallback, j3.`disableLanguageRedirect` AS boxmaker_jumpToConfirmation__disableLanguageRedirect, j3.`favicon` AS boxmaker_jumpToConfirmation__favicon, j3.`robotsTxt` AS boxmaker_jumpToConfirmation__robotsTxt, j3.`maintenanceMode` AS boxmaker_jumpToConfirmation__maintenanceMode, j3.`mailerTransport` AS boxmaker_jumpToConfirmation__mailerTransport, j3.`enableCanonical` AS boxmaker_jumpToConfirmation__enableCanonical, j3.`canonicalLink` AS boxmaker_jumpToConfirmation__canonicalLink, j3.`canonicalKeepParams` AS boxmaker_jumpToConfirmation__canonicalKeepParams, j3.`adminEmail` AS boxmaker_jumpToConfirmation__adminEmail, j3.`dateFormat` AS boxmaker_jumpToConfirmation__dateFormat, j3.`timeFormat` AS boxmaker_jumpToConfirmation__timeFormat, j3.`datimFormat` AS boxmaker_jumpToConfirmation__datimFormat, j3.`validAliasCharacters` AS boxmaker_jumpToConfirmation__validAliasCharacters, j3.`useFolderUrl` AS boxmaker_jumpToConfirmation__useFolderUrl, j3.`urlPrefix` AS boxmaker_jumpToConfirmation__urlPrefix, j3.`urlSuffix` AS boxmaker_jumpToConfirmation__urlSuffix, j3.`useSSL` AS boxmaker_jumpToConfirmation__useSSL, j3.`autoforward` AS boxmaker_jumpToConfirmation__autoforward, j3.`protected` AS boxmaker_jumpToConfirmation__protected, j3.`groups` AS boxmaker_jumpToConfirmation__groups, j3.`includeLayout` AS boxmaker_jumpToConfirmation__includeLayout, j3.`layout` AS boxmaker_jumpToConfirmation__layout, j3.`subpageLayout` AS boxmaker_jumpToConfirmation__subpageLayout, j3.`includeCache` AS boxmaker_jumpToConfirmation__includeCache, j3.`cache` AS boxmaker_jumpToConfirmation__cache, j3.`alwaysLoadFromCache` AS boxmaker_jumpToConfirmation__alwaysLoadFromCache, j3.`clientCache` AS boxmaker_jumpToConfirmation__clientCache, j3.`includeChmod` AS boxmaker_jumpToConfirmation__includeChmod, j3.`cuser` AS boxmaker_jumpToConfirmation__cuser, j3.`cgroup` AS boxmaker_jumpToConfirmation__cgroup, j3.`chmod` AS boxmaker_jumpToConfirmation__chmod, j3.`noSearch` AS boxmaker_jumpToConfirmation__noSearch, j3.`cssClass` AS boxmaker_jumpToConfirmation__cssClass, j3.`sitemap` AS boxmaker_jumpToConfirmation__sitemap, j3.`hide` AS boxmaker_jumpToConfirmation__hide, j3.`guests` AS boxmaker_jumpToConfirmation__guests, j3.`tabindex` AS boxmaker_jumpToConfirmation__tabindex, j3.`accesskey` AS boxmaker_jumpToConfirmation__accesskey, j3.`published` AS boxmaker_jumpToConfirmation__published, j3.`start` AS boxmaker_jumpToConfirmation__start, j3.`stop` AS boxmaker_jumpToConfirmation__stop, j3.`enforceTwoFactor` AS boxmaker_jumpToConfirmation__enforceTwoFactor, j3.`twoFactorJumpTo` AS boxmaker_jumpToConfirmation__twoFactorJumpTo, j3.`pageIcon` AS boxmaker_jumpToConfirmation__pageIcon, j3.`navigationTeaser` AS boxmaker_jumpToConfirmation__navigationTeaser, j3.`navigationHasIcons` AS boxmaker_jumpToConfirmation__navigationHasIcons, j3.`navigationIcon` AS boxmaker_jumpToConfirmation__navigationIcon, j3.`languageMain` AS boxmaker_jumpToConfirmation__languageMain, j3.`languageRoot` AS boxmaker_jumpToConfirmation__languageRoot, j3.`languageQuery` AS boxmaker_jumpToConfirmation__languageQuery, j3.`cssStyleSelector` AS boxmaker_jumpToConfirmation__cssStyleSelector, j4.`id` AS boxmaker_jumpToOfferConfirmation__id, j4.`pid` AS boxmaker_jumpToOfferConfirmation__pid, j4.`sorting` AS boxmaker_jumpToOfferConfirmation__sorting, j4.`tstamp` AS boxmaker_jumpToOfferConfirmation__tstamp, j4.`title` AS boxmaker_jumpToOfferConfirmation__title, j4.`type` AS boxmaker_jumpToOfferConfirmation__type, j4.`alias` AS boxmaker_jumpToOfferConfirmation__alias, j4.`requireItem` AS boxmaker_jumpToOfferConfirmation__requireItem, j4.`routePriority` AS boxmaker_jumpToOfferConfirmation__routePriority, j4.`pageTitle` AS boxmaker_jumpToOfferConfirmation__pageTitle, j4.`language` AS boxmaker_jumpToOfferConfirmation__language, j4.`robots` AS boxmaker_jumpToOfferConfirmation__robots, j4.`description` AS boxmaker_jumpToOfferConfirmation__description, j4.`redirect` AS boxmaker_jumpToOfferConfirmation__redirect, j4.`jumpTo` AS boxmaker_jumpToOfferConfirmation__jumpTo, j4.`redirectBack` AS boxmaker_jumpToOfferConfirmation__redirectBack, j4.`url` AS boxmaker_jumpToOfferConfirmation__url, j4.`target` AS boxmaker_jumpToOfferConfirmation__target, j4.`dns` AS boxmaker_jumpToOfferConfirmation__dns, j4.`staticFiles` AS boxmaker_jumpToOfferConfirmation__staticFiles, j4.`staticPlugins` AS boxmaker_jumpToOfferConfirmation__staticPlugins, j4.`fallback` AS boxmaker_jumpToOfferConfirmation__fallback, j4.`disableLanguageRedirect` AS boxmaker_jumpToOfferConfirmation__disableLanguageRedirect, j4.`favicon` AS boxmaker_jumpToOfferConfirmation__favicon, j4.`robotsTxt` AS boxmaker_jumpToOfferConfirmation__robotsTxt, j4.`maintenanceMode` AS boxmaker_jumpToOfferConfirmation__maintenanceMode, j4.`mailerTransport` AS boxmaker_jumpToOfferConfirmation__mailerTransport, j4.`enableCanonical` AS boxmaker_jumpToOfferConfirmation__enableCanonical, j4.`canonicalLink` AS boxmaker_jumpToOfferConfirmation__canonicalLink, j4.`canonicalKeepParams` AS boxmaker_jumpToOfferConfirmation__canonicalKeepParams, j4.`adminEmail` AS boxmaker_jumpToOfferConfirmation__adminEmail, j4.`dateFormat` AS boxmaker_jumpToOfferConfirmation__dateFormat, j4.`timeFormat` AS boxmaker_jumpToOfferConfirmation__timeFormat, j4.`datimFormat` AS boxmaker_jumpToOfferConfirmation__datimFormat, j4.`validAliasCharacters` AS boxmaker_jumpToOfferConfirmation__validAliasCharacters, j4.`useFolderUrl` AS boxmaker_jumpToOfferConfirmation__useFolderUrl, j4.`urlPrefix` AS boxmaker_jumpToOfferConfirmation__urlPrefix, j4.`urlSuffix` AS boxmaker_jumpToOfferConfirmation__urlSuffix, j4.`useSSL` AS boxmaker_jumpToOfferConfirmation__useSSL, j4.`autoforward` AS boxmaker_jumpToOfferConfirmation__autoforward, j4.`protected` AS boxmaker_jumpToOfferConfirmation__protected, j4.`groups` AS boxmaker_jumpToOfferConfirmation__groups, j4.`includeLayout` AS boxmaker_jumpToOfferConfirmation__includeLayout, j4.`layout` AS boxmaker_jumpToOfferConfirmation__layout, j4.`subpageLayout` AS boxmaker_jumpToOfferConfirmation__subpageLayout, j4.`includeCache` AS boxmaker_jumpToOfferConfirmation__includeCache, j4.`cache` AS boxmaker_jumpToOfferConfirmation__cache, j4.`alwaysLoadFromCache` AS boxmaker_jumpToOfferConfirmation__alwaysLoadFromCache, j4.`clientCache` AS boxmaker_jumpToOfferConfirmation__clientCache, j4.`includeChmod` AS boxmaker_jumpToOfferConfirmation__includeChmod, j4.`cuser` AS boxmaker_jumpToOfferConfirmation__cuser, j4.`cgroup` AS boxmaker_jumpToOfferConfirmation__cgroup, j4.`chmod` AS boxmaker_jumpToOfferConfirmation__chmod, j4.`noSearch` AS boxmaker_jumpToOfferConfirmation__noSearch, j4.`cssClass` AS boxmaker_jumpToOfferConfirmation__cssClass, j4.`sitemap` AS boxmaker_jumpToOfferConfirmation__sitemap, j4.`hide` AS boxmaker_jumpToOfferConfirmation__hide, j4.`guests` AS boxmaker_jumpToOfferConfirmation__guests, j4.`tabindex` AS boxmaker_jumpToOfferConfirmation__tabindex, j4.`accesskey` AS boxmaker_jumpToOfferConfirmation__accesskey, j4.`published` AS boxmaker_jumpToOfferConfirmation__published, j4.`start` AS boxmaker_jumpToOfferConfirmation__start, j4.`stop` AS boxmaker_jumpToOfferConfirmation__stop, j4.`enforceTwoFactor` AS boxmaker_jumpToOfferConfirmation__enforceTwoFactor, j4.`twoFactorJumpTo` AS boxmaker_jumpToOfferConfirmation__twoFactorJumpTo, j4.`pageIcon` AS boxmaker_jumpToOfferConfirmation__pageIcon, j4.`navigationTeaser` AS boxmaker_jumpToOfferConfirmation__navigationTeaser, j4.`navigationHasIcons` AS boxmaker_jumpToOfferConfirmation__navigationHasIcons, j4.`navigationIcon` AS boxmaker_jumpToOfferConfirmation__navigationIcon, j4.`languageMain` AS boxmaker_jumpToOfferConfirmation__languageMain, j4.`languageRoot` AS boxmaker_jumpToOfferConfirmation__languageRoot, j4.`languageQuery` AS boxmaker_jumpToOfferConfirmation__languageQuery, j4.`cssStyleSelector` AS boxmaker_jumpToOfferConfirmation__cssStyleSelector FROM tl_module LEFT JOIN tl_page j1 ON tl_module.`boxmaker_jumpToCart`=j1.id LEFT JOIN tl_page j2 ON tl_module.`boxmaker_jumpToStart`=j2.id LEFT JOIN tl_page j3 ON tl_module.`boxmaker_jumpToConfirmation`=j3.id LEFT JOIN tl_page j4 ON tl_module.`boxmaker_jumpToOfferConfirmation`=j4.id WHERE tl_module.id IN(54,55,20,0,0,0,0,7,16) ORDER BY FIND_IN_SET(`tl_module`.`id`, '54,55,20,0,0,0,0,7,16');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.pid = ?
  AND tl_page.type != 'root'
  AND tl_page.type NOT IN (
    'error_401', 'error_403', 'error_404',
    'error_503'
  )
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= 1713967380
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1713967380
  )
ORDER BY
  tl_page.sorting
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.pid='1' AND tl_page.type!='root' AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1713967380) AND (tl_page.stop='' OR tl_page.stop>1713967380) ORDER BY tl_page.sorting LIMIT 0,1;

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  tl_article.pid = ?
  AND tl_article.inColumn = ?
  AND tl_article.published = '1'
  AND (
    tl_article.start = ''
    OR tl_article.start <= 1713967380
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > 1713967380
  )
ORDER BY
  tl_article.sorting

SELECT tl_article.* FROM tl_article WHERE tl_article.pid='7' AND tl_article.inColumn='main' AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<=1713967380) AND (tl_article.stop='' OR tl_article.stop>1713967380) ORDER BY tl_article.sorting;

SELECT
  tl_content.*
FROM
  tl_content
WHERE
  tl_content.pid = ?
  AND (
    tl_content.ptable = ?
    OR tl_content.ptable = ''
  )
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= 1713967380
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > 1713967380
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

SELECT tl_content.* FROM tl_content WHERE tl_content.pid='5' AND (tl_content.ptable='tl_article' OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1713967380) AND (tl_content.stop='' OR tl_content.stop>1713967380) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;