Symfony Profiler

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'gncyonsi_tmpsympathiemagazin'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  COUNT(*) AS count
FROM
  tl_content
WHERE
  tl_content.pid = ?
  AND tl_content.ptable = ?
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= '1777761840'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1777761840'
  )
  AND tl_content.tstamp != 0

SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='103' AND tl_content.ptable='tl_news' AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1777761840') AND (tl_content.stop='' OR tl_content.stop>'1777761840') AND tl_content.tstamp!=0;

SELECT
  tl_content.*,
  j1.`id` AS ceJumpToPrimaryLink__id,
  j1.`pid` AS ceJumpToPrimaryLink__pid,
  j1.`sorting` AS ceJumpToPrimaryLink__sorting,
  j1.`tstamp` AS ceJumpToPrimaryLink__tstamp,
  j1.`title` AS ceJumpToPrimaryLink__title,
  j1.`type` AS ceJumpToPrimaryLink__type,
  j1.`alias` AS ceJumpToPrimaryLink__alias,
  j1.`requireItem` AS ceJumpToPrimaryLink__requireItem,
  j1.`routePriority` AS ceJumpToPrimaryLink__routePriority,
  j1.`pageTitle` AS ceJumpToPrimaryLink__pageTitle,
  j1.`language` AS ceJumpToPrimaryLink__language,
  j1.`robots` AS ceJumpToPrimaryLink__robots,
  j1.`description` AS ceJumpToPrimaryLink__description,
  j1.`redirect` AS ceJumpToPrimaryLink__redirect,
  j1.`jumpTo` AS ceJumpToPrimaryLink__jumpTo,
  j1.`redirectBack` AS ceJumpToPrimaryLink__redirectBack,
  j1.`url` AS ceJumpToPrimaryLink__url,
  j1.`target` AS ceJumpToPrimaryLink__target,
  j1.`dns` AS ceJumpToPrimaryLink__dns,
  j1.`staticFiles` AS ceJumpToPrimaryLink__staticFiles,
  j1.`staticPlugins` AS ceJumpToPrimaryLink__staticPlugins,
  j1.`fallback` AS ceJumpToPrimaryLink__fallback,
  j1.`disableLanguageRedirect` AS ceJumpToPrimaryLink__disableLanguageRedirect,
  j1.`favicon` AS ceJumpToPrimaryLink__favicon,
  j1.`robotsTxt` AS ceJumpToPrimaryLink__robotsTxt,
  j1.`maintenanceMode` AS ceJumpToPrimaryLink__maintenanceMode,
  j1.`mailerTransport` AS ceJumpToPrimaryLink__mailerTransport,
  j1.`enableCanonical` AS ceJumpToPrimaryLink__enableCanonical,
  j1.`canonicalLink` AS ceJumpToPrimaryLink__canonicalLink,
  j1.`canonicalKeepParams` AS ceJumpToPrimaryLink__canonicalKeepParams,
  j1.`adminEmail` AS ceJumpToPrimaryLink__adminEmail,
  j1.`dateFormat` AS ceJumpToPrimaryLink__dateFormat,
  j1.`timeFormat` AS ceJumpToPrimaryLink__timeFormat,
  j1.`datimFormat` AS ceJumpToPrimaryLink__datimFormat,
  j1.`validAliasCharacters` AS ceJumpToPrimaryLink__validAliasCharacters,
  j1.`useFolderUrl` AS ceJumpToPrimaryLink__useFolderUrl,
  j1.`urlPrefix` AS ceJumpToPrimaryLink__urlPrefix,
  j1.`urlSuffix` AS ceJumpToPrimaryLink__urlSuffix,
  j1.`useSSL` AS ceJumpToPrimaryLink__useSSL,
  j1.`autoforward` AS ceJumpToPrimaryLink__autoforward,
  j1.`protected` AS ceJumpToPrimaryLink__protected,
  j1.`groups` AS ceJumpToPrimaryLink__groups,
  j1.`includeLayout` AS ceJumpToPrimaryLink__includeLayout,
  j1.`layout` AS ceJumpToPrimaryLink__layout,
  j1.`subpageLayout` AS ceJumpToPrimaryLink__subpageLayout,
  j1.`includeCache` AS ceJumpToPrimaryLink__includeCache,
  j1.`cache` AS ceJumpToPrimaryLink__cache,
  j1.`alwaysLoadFromCache` AS ceJumpToPrimaryLink__alwaysLoadFromCache,
  j1.`clientCache` AS ceJumpToPrimaryLink__clientCache,
  j1.`includeChmod` AS ceJumpToPrimaryLink__includeChmod,
  j1.`cuser` AS ceJumpToPrimaryLink__cuser,
  j1.`cgroup` AS ceJumpToPrimaryLink__cgroup,
  j1.`chmod` AS ceJumpToPrimaryLink__chmod,
  j1.`noSearch` AS ceJumpToPrimaryLink__noSearch,
  j1.`cssClass` AS ceJumpToPrimaryLink__cssClass,
  j1.`sitemap` AS ceJumpToPrimaryLink__sitemap,
  j1.`hide` AS ceJumpToPrimaryLink__hide,
  j1.`guests` AS ceJumpToPrimaryLink__guests,
  j1.`tabindex` AS ceJumpToPrimaryLink__tabindex,
  j1.`accesskey` AS ceJumpToPrimaryLink__accesskey,
  j1.`published` AS ceJumpToPrimaryLink__published,
  j1.`start` AS ceJumpToPrimaryLink__start,
  j1.`stop` AS ceJumpToPrimaryLink__stop,
  j1.`enforceTwoFactor` AS ceJumpToPrimaryLink__enforceTwoFactor,
  j1.`twoFactorJumpTo` AS ceJumpToPrimaryLink__twoFactorJumpTo,
  j1.`iso_config` AS ceJumpToPrimaryLink__iso_config,
  j1.`iso_store_id` AS ceJumpToPrimaryLink__iso_store_id,
  j1.`iso_readerMode` AS ceJumpToPrimaryLink__iso_readerMode,
  j1.`iso_readerJumpTo` AS ceJumpToPrimaryLink__iso_readerJumpTo,
  j2.`id` AS ceJumpToSecondaryLink__id,
  j2.`pid` AS ceJumpToSecondaryLink__pid,
  j2.`sorting` AS ceJumpToSecondaryLink__sorting,
  j2.`tstamp` AS ceJumpToSecondaryLink__tstamp,
  j2.`title` AS ceJumpToSecondaryLink__title,
  j2.`type` AS ceJumpToSecondaryLink__type,
  j2.`alias` AS ceJumpToSecondaryLink__alias,
  j2.`requireItem` AS ceJumpToSecondaryLink__requireItem,
  j2.`routePriority` AS ceJumpToSecondaryLink__routePriority,
  j2.`pageTitle` AS ceJumpToSecondaryLink__pageTitle,
  j2.`language` AS ceJumpToSecondaryLink__language,
  j2.`robots` AS ceJumpToSecondaryLink__robots,
  j2.`description` AS ceJumpToSecondaryLink__description,
  j2.`redirect` AS ceJumpToSecondaryLink__redirect,
  j2.`jumpTo` AS ceJumpToSecondaryLink__jumpTo,
  j2.`redirectBack` AS ceJumpToSecondaryLink__redirectBack,
  j2.`url` AS ceJumpToSecondaryLink__url,
  j2.`target` AS ceJumpToSecondaryLink__target,
  j2.`dns` AS ceJumpToSecondaryLink__dns,
  j2.`staticFiles` AS ceJumpToSecondaryLink__staticFiles,
  j2.`staticPlugins` AS ceJumpToSecondaryLink__staticPlugins,
  j2.`fallback` AS ceJumpToSecondaryLink__fallback,
  j2.`disableLanguageRedirect` AS ceJumpToSecondaryLink__disableLanguageRedirect,
  j2.`favicon` AS ceJumpToSecondaryLink__favicon,
  j2.`robotsTxt` AS ceJumpToSecondaryLink__robotsTxt,
  j2.`maintenanceMode` AS ceJumpToSecondaryLink__maintenanceMode,
  j2.`mailerTransport` AS ceJumpToSecondaryLink__mailerTransport,
  j2.`enableCanonical` AS ceJumpToSecondaryLink__enableCanonical,
  j2.`canonicalLink` AS ceJumpToSecondaryLink__canonicalLink,
  j2.`canonicalKeepParams` AS ceJumpToSecondaryLink__canonicalKeepParams,
  j2.`adminEmail` AS ceJumpToSecondaryLink__adminEmail,
  j2.`dateFormat` AS ceJumpToSecondaryLink__dateFormat,
  j2.`timeFormat` AS ceJumpToSecondaryLink__timeFormat,
  j2.`datimFormat` AS ceJumpToSecondaryLink__datimFormat,
  j2.`validAliasCharacters` AS ceJumpToSecondaryLink__validAliasCharacters,
  j2.`useFolderUrl` AS ceJumpToSecondaryLink__useFolderUrl,
  j2.`urlPrefix` AS ceJumpToSecondaryLink__urlPrefix,
  j2.`urlSuffix` AS ceJumpToSecondaryLink__urlSuffix,
  j2.`useSSL` AS ceJumpToSecondaryLink__useSSL,
  j2.`autoforward` AS ceJumpToSecondaryLink__autoforward,
  j2.`protected` AS ceJumpToSecondaryLink__protected,
  j2.`groups` AS ceJumpToSecondaryLink__groups,
  j2.`includeLayout` AS ceJumpToSecondaryLink__includeLayout,
  j2.`layout` AS ceJumpToSecondaryLink__layout,
  j2.`subpageLayout` AS ceJumpToSecondaryLink__subpageLayout,
  j2.`includeCache` AS ceJumpToSecondaryLink__includeCache,
  j2.`cache` AS ceJumpToSecondaryLink__cache,
  j2.`alwaysLoadFromCache` AS ceJumpToSecondaryLink__alwaysLoadFromCache,
  j2.`clientCache` AS ceJumpToSecondaryLink__clientCache,
  j2.`includeChmod` AS ceJumpToSecondaryLink__includeChmod,
  j2.`cuser` AS ceJumpToSecondaryLink__cuser,
  j2.`cgroup` AS ceJumpToSecondaryLink__cgroup,
  j2.`chmod` AS ceJumpToSecondaryLink__chmod,
  j2.`noSearch` AS ceJumpToSecondaryLink__noSearch,
  j2.`cssClass` AS ceJumpToSecondaryLink__cssClass,
  j2.`sitemap` AS ceJumpToSecondaryLink__sitemap,
  j2.`hide` AS ceJumpToSecondaryLink__hide,
  j2.`guests` AS ceJumpToSecondaryLink__guests,
  j2.`tabindex` AS ceJumpToSecondaryLink__tabindex,
  j2.`accesskey` AS ceJumpToSecondaryLink__accesskey,
  j2.`published` AS ceJumpToSecondaryLink__published,
  j2.`start` AS ceJumpToSecondaryLink__start,
  j2.`stop` AS ceJumpToSecondaryLink__stop,
  j2.`enforceTwoFactor` AS ceJumpToSecondaryLink__enforceTwoFactor,
  j2.`twoFactorJumpTo` AS ceJumpToSecondaryLink__twoFactorJumpTo,
  j2.`iso_config` AS ceJumpToSecondaryLink__iso_config,
  j2.`iso_store_id` AS ceJumpToSecondaryLink__iso_store_id,
  j2.`iso_readerMode` AS ceJumpToSecondaryLink__iso_readerMode,
  j2.`iso_readerJumpTo` AS ceJumpToSecondaryLink__iso_readerJumpTo
FROM
  tl_content
  LEFT JOIN tl_page j1 ON tl_content.`ceJumpToPrimaryLink` = j1.id
  LEFT JOIN tl_page j2 ON tl_content.`ceJumpToSecondaryLink` = j2.id
WHERE
  tl_content.pid = ?
  AND (
    tl_content.ptable = ?
    OR tl_content.ptable = ''
  )
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= '1777761840'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1777761840'
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

SELECT tl_content.*, j1.`id` AS ceJumpToPrimaryLink__id, j1.`pid` AS ceJumpToPrimaryLink__pid, j1.`sorting` AS ceJumpToPrimaryLink__sorting, j1.`tstamp` AS ceJumpToPrimaryLink__tstamp, j1.`title` AS ceJumpToPrimaryLink__title, j1.`type` AS ceJumpToPrimaryLink__type, j1.`alias` AS ceJumpToPrimaryLink__alias, j1.`requireItem` AS ceJumpToPrimaryLink__requireItem, j1.`routePriority` AS ceJumpToPrimaryLink__routePriority, j1.`pageTitle` AS ceJumpToPrimaryLink__pageTitle, j1.`language` AS ceJumpToPrimaryLink__language, j1.`robots` AS ceJumpToPrimaryLink__robots, j1.`description` AS ceJumpToPrimaryLink__description, j1.`redirect` AS ceJumpToPrimaryLink__redirect, j1.`jumpTo` AS ceJumpToPrimaryLink__jumpTo, j1.`redirectBack` AS ceJumpToPrimaryLink__redirectBack, j1.`url` AS ceJumpToPrimaryLink__url, j1.`target` AS ceJumpToPrimaryLink__target, j1.`dns` AS ceJumpToPrimaryLink__dns, j1.`staticFiles` AS ceJumpToPrimaryLink__staticFiles, j1.`staticPlugins` AS ceJumpToPrimaryLink__staticPlugins, j1.`fallback` AS ceJumpToPrimaryLink__fallback, j1.`disableLanguageRedirect` AS ceJumpToPrimaryLink__disableLanguageRedirect, j1.`favicon` AS ceJumpToPrimaryLink__favicon, j1.`robotsTxt` AS ceJumpToPrimaryLink__robotsTxt, j1.`maintenanceMode` AS ceJumpToPrimaryLink__maintenanceMode, j1.`mailerTransport` AS ceJumpToPrimaryLink__mailerTransport, j1.`enableCanonical` AS ceJumpToPrimaryLink__enableCanonical, j1.`canonicalLink` AS ceJumpToPrimaryLink__canonicalLink, j1.`canonicalKeepParams` AS ceJumpToPrimaryLink__canonicalKeepParams, j1.`adminEmail` AS ceJumpToPrimaryLink__adminEmail, j1.`dateFormat` AS ceJumpToPrimaryLink__dateFormat, j1.`timeFormat` AS ceJumpToPrimaryLink__timeFormat, j1.`datimFormat` AS ceJumpToPrimaryLink__datimFormat, j1.`validAliasCharacters` AS ceJumpToPrimaryLink__validAliasCharacters, j1.`useFolderUrl` AS ceJumpToPrimaryLink__useFolderUrl, j1.`urlPrefix` AS ceJumpToPrimaryLink__urlPrefix, j1.`urlSuffix` AS ceJumpToPrimaryLink__urlSuffix, j1.`useSSL` AS ceJumpToPrimaryLink__useSSL, j1.`autoforward` AS ceJumpToPrimaryLink__autoforward, j1.`protected` AS ceJumpToPrimaryLink__protected, j1.`groups` AS ceJumpToPrimaryLink__groups, j1.`includeLayout` AS ceJumpToPrimaryLink__includeLayout, j1.`layout` AS ceJumpToPrimaryLink__layout, j1.`subpageLayout` AS ceJumpToPrimaryLink__subpageLayout, j1.`includeCache` AS ceJumpToPrimaryLink__includeCache, j1.`cache` AS ceJumpToPrimaryLink__cache, j1.`alwaysLoadFromCache` AS ceJumpToPrimaryLink__alwaysLoadFromCache, j1.`clientCache` AS ceJumpToPrimaryLink__clientCache, j1.`includeChmod` AS ceJumpToPrimaryLink__includeChmod, j1.`cuser` AS ceJumpToPrimaryLink__cuser, j1.`cgroup` AS ceJumpToPrimaryLink__cgroup, j1.`chmod` AS ceJumpToPrimaryLink__chmod, j1.`noSearch` AS ceJumpToPrimaryLink__noSearch, j1.`cssClass` AS ceJumpToPrimaryLink__cssClass, j1.`sitemap` AS ceJumpToPrimaryLink__sitemap, j1.`hide` AS ceJumpToPrimaryLink__hide, j1.`guests` AS ceJumpToPrimaryLink__guests, j1.`tabindex` AS ceJumpToPrimaryLink__tabindex, j1.`accesskey` AS ceJumpToPrimaryLink__accesskey, j1.`published` AS ceJumpToPrimaryLink__published, j1.`start` AS ceJumpToPrimaryLink__start, j1.`stop` AS ceJumpToPrimaryLink__stop, j1.`enforceTwoFactor` AS ceJumpToPrimaryLink__enforceTwoFactor, j1.`twoFactorJumpTo` AS ceJumpToPrimaryLink__twoFactorJumpTo, j1.`iso_config` AS ceJumpToPrimaryLink__iso_config, j1.`iso_store_id` AS ceJumpToPrimaryLink__iso_store_id, j1.`iso_readerMode` AS ceJumpToPrimaryLink__iso_readerMode, j1.`iso_readerJumpTo` AS ceJumpToPrimaryLink__iso_readerJumpTo, j2.`id` AS ceJumpToSecondaryLink__id, j2.`pid` AS ceJumpToSecondaryLink__pid, j2.`sorting` AS ceJumpToSecondaryLink__sorting, j2.`tstamp` AS ceJumpToSecondaryLink__tstamp, j2.`title` AS ceJumpToSecondaryLink__title, j2.`type` AS ceJumpToSecondaryLink__type, j2.`alias` AS ceJumpToSecondaryLink__alias, j2.`requireItem` AS ceJumpToSecondaryLink__requireItem, j2.`routePriority` AS ceJumpToSecondaryLink__routePriority, j2.`pageTitle` AS ceJumpToSecondaryLink__pageTitle, j2.`language` AS ceJumpToSecondaryLink__language, j2.`robots` AS ceJumpToSecondaryLink__robots, j2.`description` AS ceJumpToSecondaryLink__description, j2.`redirect` AS ceJumpToSecondaryLink__redirect, j2.`jumpTo` AS ceJumpToSecondaryLink__jumpTo, j2.`redirectBack` AS ceJumpToSecondaryLink__redirectBack, j2.`url` AS ceJumpToSecondaryLink__url, j2.`target` AS ceJumpToSecondaryLink__target, j2.`dns` AS ceJumpToSecondaryLink__dns, j2.`staticFiles` AS ceJumpToSecondaryLink__staticFiles, j2.`staticPlugins` AS ceJumpToSecondaryLink__staticPlugins, j2.`fallback` AS ceJumpToSecondaryLink__fallback, j2.`disableLanguageRedirect` AS ceJumpToSecondaryLink__disableLanguageRedirect, j2.`favicon` AS ceJumpToSecondaryLink__favicon, j2.`robotsTxt` AS ceJumpToSecondaryLink__robotsTxt, j2.`maintenanceMode` AS ceJumpToSecondaryLink__maintenanceMode, j2.`mailerTransport` AS ceJumpToSecondaryLink__mailerTransport, j2.`enableCanonical` AS ceJumpToSecondaryLink__enableCanonical, j2.`canonicalLink` AS ceJumpToSecondaryLink__canonicalLink, j2.`canonicalKeepParams` AS ceJumpToSecondaryLink__canonicalKeepParams, j2.`adminEmail` AS ceJumpToSecondaryLink__adminEmail, j2.`dateFormat` AS ceJumpToSecondaryLink__dateFormat, j2.`timeFormat` AS ceJumpToSecondaryLink__timeFormat, j2.`datimFormat` AS ceJumpToSecondaryLink__datimFormat, j2.`validAliasCharacters` AS ceJumpToSecondaryLink__validAliasCharacters, j2.`useFolderUrl` AS ceJumpToSecondaryLink__useFolderUrl, j2.`urlPrefix` AS ceJumpToSecondaryLink__urlPrefix, j2.`urlSuffix` AS ceJumpToSecondaryLink__urlSuffix, j2.`useSSL` AS ceJumpToSecondaryLink__useSSL, j2.`autoforward` AS ceJumpToSecondaryLink__autoforward, j2.`protected` AS ceJumpToSecondaryLink__protected, j2.`groups` AS ceJumpToSecondaryLink__groups, j2.`includeLayout` AS ceJumpToSecondaryLink__includeLayout, j2.`layout` AS ceJumpToSecondaryLink__layout, j2.`subpageLayout` AS ceJumpToSecondaryLink__subpageLayout, j2.`includeCache` AS ceJumpToSecondaryLink__includeCache, j2.`cache` AS ceJumpToSecondaryLink__cache, j2.`alwaysLoadFromCache` AS ceJumpToSecondaryLink__alwaysLoadFromCache, j2.`clientCache` AS ceJumpToSecondaryLink__clientCache, j2.`includeChmod` AS ceJumpToSecondaryLink__includeChmod, j2.`cuser` AS ceJumpToSecondaryLink__cuser, j2.`cgroup` AS ceJumpToSecondaryLink__cgroup, j2.`chmod` AS ceJumpToSecondaryLink__chmod, j2.`noSearch` AS ceJumpToSecondaryLink__noSearch, j2.`cssClass` AS ceJumpToSecondaryLink__cssClass, j2.`sitemap` AS ceJumpToSecondaryLink__sitemap, j2.`hide` AS ceJumpToSecondaryLink__hide, j2.`guests` AS ceJumpToSecondaryLink__guests, j2.`tabindex` AS ceJumpToSecondaryLink__tabindex, j2.`accesskey` AS ceJumpToSecondaryLink__accesskey, j2.`published` AS ceJumpToSecondaryLink__published, j2.`start` AS ceJumpToSecondaryLink__start, j2.`stop` AS ceJumpToSecondaryLink__stop, j2.`enforceTwoFactor` AS ceJumpToSecondaryLink__enforceTwoFactor, j2.`twoFactorJumpTo` AS ceJumpToSecondaryLink__twoFactorJumpTo, j2.`iso_config` AS ceJumpToSecondaryLink__iso_config, j2.`iso_store_id` AS ceJumpToSecondaryLink__iso_store_id, j2.`iso_readerMode` AS ceJumpToSecondaryLink__iso_readerMode, j2.`iso_readerJumpTo` AS ceJumpToSecondaryLink__iso_readerJumpTo FROM tl_content LEFT JOIN tl_page j1 ON tl_content.`ceJumpToPrimaryLink`=j1.id LEFT JOIN tl_page j2 ON tl_content.`ceJumpToSecondaryLink`=j2.id WHERE tl_content.pid='113' AND (tl_content.ptable='tl_article' OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1777761840') AND (tl_content.stop='' OR tl_content.stop>'1777761840') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid = UNHEX(?)
LIMIT
  0, 1

SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('2dae78c50e8411e9ad5dfcaa14c41d86') LIMIT 0,1;

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

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

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type NOT IN (
        'error_401', 'error_403', 'error_404',
        'error_503'
      )
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1777761840'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1777761840'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = ?
  AND p1.type != 'root'
  AND p1.type NOT IN (
    'error_401', 'error_403', 'error_404',
    'error_503'
  )
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1777761840'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1777761840'
  )
ORDER BY
  p1.sorting

SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1777761840') AND (p2.stop='' OR p2.stop>'1777761840')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='66' AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1777761840') AND (p1.stop='' OR p1.stop>'1777761840') ORDER BY p1.sorting;

SELECT
  tl_module.*,
  j1.`id` AS modTopBarJumpToNewsletter__id,
  j1.`pid` AS modTopBarJumpToNewsletter__pid,
  j1.`sorting` AS modTopBarJumpToNewsletter__sorting,
  j1.`tstamp` AS modTopBarJumpToNewsletter__tstamp,
  j1.`title` AS modTopBarJumpToNewsletter__title,
  j1.`type` AS modTopBarJumpToNewsletter__type,
  j1.`alias` AS modTopBarJumpToNewsletter__alias,
  j1.`requireItem` AS modTopBarJumpToNewsletter__requireItem,
  j1.`routePriority` AS modTopBarJumpToNewsletter__routePriority,
  j1.`pageTitle` AS modTopBarJumpToNewsletter__pageTitle,
  j1.`language` AS modTopBarJumpToNewsletter__language,
  j1.`robots` AS modTopBarJumpToNewsletter__robots,
  j1.`description` AS modTopBarJumpToNewsletter__description,
  j1.`redirect` AS modTopBarJumpToNewsletter__redirect,
  j1.`jumpTo` AS modTopBarJumpToNewsletter__jumpTo,
  j1.`redirectBack` AS modTopBarJumpToNewsletter__redirectBack,
  j1.`url` AS modTopBarJumpToNewsletter__url,
  j1.`target` AS modTopBarJumpToNewsletter__target,
  j1.`dns` AS modTopBarJumpToNewsletter__dns,
  j1.`staticFiles` AS modTopBarJumpToNewsletter__staticFiles,
  j1.`staticPlugins` AS modTopBarJumpToNewsletter__staticPlugins,
  j1.`fallback` AS modTopBarJumpToNewsletter__fallback,
  j1.`disableLanguageRedirect` AS modTopBarJumpToNewsletter__disableLanguageRedirect,
  j1.`favicon` AS modTopBarJumpToNewsletter__favicon,
  j1.`robotsTxt` AS modTopBarJumpToNewsletter__robotsTxt,
  j1.`maintenanceMode` AS modTopBarJumpToNewsletter__maintenanceMode,
  j1.`mailerTransport` AS modTopBarJumpToNewsletter__mailerTransport,
  j1.`enableCanonical` AS modTopBarJumpToNewsletter__enableCanonical,
  j1.`canonicalLink` AS modTopBarJumpToNewsletter__canonicalLink,
  j1.`canonicalKeepParams` AS modTopBarJumpToNewsletter__canonicalKeepParams,
  j1.`adminEmail` AS modTopBarJumpToNewsletter__adminEmail,
  j1.`dateFormat` AS modTopBarJumpToNewsletter__dateFormat,
  j1.`timeFormat` AS modTopBarJumpToNewsletter__timeFormat,
  j1.`datimFormat` AS modTopBarJumpToNewsletter__datimFormat,
  j1.`validAliasCharacters` AS modTopBarJumpToNewsletter__validAliasCharacters,
  j1.`useFolderUrl` AS modTopBarJumpToNewsletter__useFolderUrl,
  j1.`urlPrefix` AS modTopBarJumpToNewsletter__urlPrefix,
  j1.`urlSuffix` AS modTopBarJumpToNewsletter__urlSuffix,
  j1.`useSSL` AS modTopBarJumpToNewsletter__useSSL,
  j1.`autoforward` AS modTopBarJumpToNewsletter__autoforward,
  j1.`protected` AS modTopBarJumpToNewsletter__protected,
  j1.`groups` AS modTopBarJumpToNewsletter__groups,
  j1.`includeLayout` AS modTopBarJumpToNewsletter__includeLayout,
  j1.`layout` AS modTopBarJumpToNewsletter__layout,
  j1.`subpageLayout` AS modTopBarJumpToNewsletter__subpageLayout,
  j1.`includeCache` AS modTopBarJumpToNewsletter__includeCache,
  j1.`cache` AS modTopBarJumpToNewsletter__cache,
  j1.`alwaysLoadFromCache` AS modTopBarJumpToNewsletter__alwaysLoadFromCache,
  j1.`clientCache` AS modTopBarJumpToNewsletter__clientCache,
  j1.`includeChmod` AS modTopBarJumpToNewsletter__includeChmod,
  j1.`cuser` AS modTopBarJumpToNewsletter__cuser,
  j1.`cgroup` AS modTopBarJumpToNewsletter__cgroup,
  j1.`chmod` AS modTopBarJumpToNewsletter__chmod,
  j1.`noSearch` AS modTopBarJumpToNewsletter__noSearch,
  j1.`cssClass` AS modTopBarJumpToNewsletter__cssClass,
  j1.`sitemap` AS modTopBarJumpToNewsletter__sitemap,
  j1.`hide` AS modTopBarJumpToNewsletter__hide,
  j1.`guests` AS modTopBarJumpToNewsletter__guests,
  j1.`tabindex` AS modTopBarJumpToNewsletter__tabindex,
  j1.`accesskey` AS modTopBarJumpToNewsletter__accesskey,
  j1.`published` AS modTopBarJumpToNewsletter__published,
  j1.`start` AS modTopBarJumpToNewsletter__start,
  j1.`stop` AS modTopBarJumpToNewsletter__stop,
  j1.`enforceTwoFactor` AS modTopBarJumpToNewsletter__enforceTwoFactor,
  j1.`twoFactorJumpTo` AS modTopBarJumpToNewsletter__twoFactorJumpTo,
  j1.`iso_config` AS modTopBarJumpToNewsletter__iso_config,
  j1.`iso_store_id` AS modTopBarJumpToNewsletter__iso_store_id,
  j1.`iso_readerMode` AS modTopBarJumpToNewsletter__iso_readerMode,
  j1.`iso_readerJumpTo` AS modTopBarJumpToNewsletter__iso_readerJumpTo,
  j2.`id` AS modTopBarJumpToCart__id,
  j2.`pid` AS modTopBarJumpToCart__pid,
  j2.`sorting` AS modTopBarJumpToCart__sorting,
  j2.`tstamp` AS modTopBarJumpToCart__tstamp,
  j2.`title` AS modTopBarJumpToCart__title,
  j2.`type` AS modTopBarJumpToCart__type,
  j2.`alias` AS modTopBarJumpToCart__alias,
  j2.`requireItem` AS modTopBarJumpToCart__requireItem,
  j2.`routePriority` AS modTopBarJumpToCart__routePriority,
  j2.`pageTitle` AS modTopBarJumpToCart__pageTitle,
  j2.`language` AS modTopBarJumpToCart__language,
  j2.`robots` AS modTopBarJumpToCart__robots,
  j2.`description` AS modTopBarJumpToCart__description,
  j2.`redirect` AS modTopBarJumpToCart__redirect,
  j2.`jumpTo` AS modTopBarJumpToCart__jumpTo,
  j2.`redirectBack` AS modTopBarJumpToCart__redirectBack,
  j2.`url` AS modTopBarJumpToCart__url,
  j2.`target` AS modTopBarJumpToCart__target,
  j2.`dns` AS modTopBarJumpToCart__dns,
  j2.`staticFiles` AS modTopBarJumpToCart__staticFiles,
  j2.`staticPlugins` AS modTopBarJumpToCart__staticPlugins,
  j2.`fallback` AS modTopBarJumpToCart__fallback,
  j2.`disableLanguageRedirect` AS modTopBarJumpToCart__disableLanguageRedirect,
  j2.`favicon` AS modTopBarJumpToCart__favicon,
  j2.`robotsTxt` AS modTopBarJumpToCart__robotsTxt,
  j2.`maintenanceMode` AS modTopBarJumpToCart__maintenanceMode,
  j2.`mailerTransport` AS modTopBarJumpToCart__mailerTransport,
  j2.`enableCanonical` AS modTopBarJumpToCart__enableCanonical,
  j2.`canonicalLink` AS modTopBarJumpToCart__canonicalLink,
  j2.`canonicalKeepParams` AS modTopBarJumpToCart__canonicalKeepParams,
  j2.`adminEmail` AS modTopBarJumpToCart__adminEmail,
  j2.`dateFormat` AS modTopBarJumpToCart__dateFormat,
  j2.`timeFormat` AS modTopBarJumpToCart__timeFormat,
  j2.`datimFormat` AS modTopBarJumpToCart__datimFormat,
  j2.`validAliasCharacters` AS modTopBarJumpToCart__validAliasCharacters,
  j2.`useFolderUrl` AS modTopBarJumpToCart__useFolderUrl,
  j2.`urlPrefix` AS modTopBarJumpToCart__urlPrefix,
  j2.`urlSuffix` AS modTopBarJumpToCart__urlSuffix,
  j2.`useSSL` AS modTopBarJumpToCart__useSSL,
  j2.`autoforward` AS modTopBarJumpToCart__autoforward,
  j2.`protected` AS modTopBarJumpToCart__protected,
  j2.`groups` AS modTopBarJumpToCart__groups,
  j2.`includeLayout` AS modTopBarJumpToCart__includeLayout,
  j2.`layout` AS modTopBarJumpToCart__layout,
  j2.`subpageLayout` AS modTopBarJumpToCart__subpageLayout,
  j2.`includeCache` AS modTopBarJumpToCart__includeCache,
  j2.`cache` AS modTopBarJumpToCart__cache,
  j2.`alwaysLoadFromCache` AS modTopBarJumpToCart__alwaysLoadFromCache,
  j2.`clientCache` AS modTopBarJumpToCart__clientCache,
  j2.`includeChmod` AS modTopBarJumpToCart__includeChmod,
  j2.`cuser` AS modTopBarJumpToCart__cuser,
  j2.`cgroup` AS modTopBarJumpToCart__cgroup,
  j2.`chmod` AS modTopBarJumpToCart__chmod,
  j2.`noSearch` AS modTopBarJumpToCart__noSearch,
  j2.`cssClass` AS modTopBarJumpToCart__cssClass,
  j2.`sitemap` AS modTopBarJumpToCart__sitemap,
  j2.`hide` AS modTopBarJumpToCart__hide,
  j2.`guests` AS modTopBarJumpToCart__guests,
  j2.`tabindex` AS modTopBarJumpToCart__tabindex,
  j2.`accesskey` AS modTopBarJumpToCart__accesskey,
  j2.`published` AS modTopBarJumpToCart__published,
  j2.`start` AS modTopBarJumpToCart__start,
  j2.`stop` AS modTopBarJumpToCart__stop,
  j2.`enforceTwoFactor` AS modTopBarJumpToCart__enforceTwoFactor,
  j2.`twoFactorJumpTo` AS modTopBarJumpToCart__twoFactorJumpTo,
  j2.`iso_config` AS modTopBarJumpToCart__iso_config,
  j2.`iso_store_id` AS modTopBarJumpToCart__iso_store_id,
  j2.`iso_readerMode` AS modTopBarJumpToCart__iso_readerMode,
  j2.`iso_readerJumpTo` AS modTopBarJumpToCart__iso_readerJumpTo,
  j3.`id` AS modTopBarJumpToLogin__id,
  j3.`pid` AS modTopBarJumpToLogin__pid,
  j3.`sorting` AS modTopBarJumpToLogin__sorting,
  j3.`tstamp` AS modTopBarJumpToLogin__tstamp,
  j3.`title` AS modTopBarJumpToLogin__title,
  j3.`type` AS modTopBarJumpToLogin__type,
  j3.`alias` AS modTopBarJumpToLogin__alias,
  j3.`requireItem` AS modTopBarJumpToLogin__requireItem,
  j3.`routePriority` AS modTopBarJumpToLogin__routePriority,
  j3.`pageTitle` AS modTopBarJumpToLogin__pageTitle,
  j3.`language` AS modTopBarJumpToLogin__language,
  j3.`robots` AS modTopBarJumpToLogin__robots,
  j3.`description` AS modTopBarJumpToLogin__description,
  j3.`redirect` AS modTopBarJumpToLogin__redirect,
  j3.`jumpTo` AS modTopBarJumpToLogin__jumpTo,
  j3.`redirectBack` AS modTopBarJumpToLogin__redirectBack,
  j3.`url` AS modTopBarJumpToLogin__url,
  j3.`target` AS modTopBarJumpToLogin__target,
  j3.`dns` AS modTopBarJumpToLogin__dns,
  j3.`staticFiles` AS modTopBarJumpToLogin__staticFiles,
  j3.`staticPlugins` AS modTopBarJumpToLogin__staticPlugins,
  j3.`fallback` AS modTopBarJumpToLogin__fallback,
  j3.`disableLanguageRedirect` AS modTopBarJumpToLogin__disableLanguageRedirect,
  j3.`favicon` AS modTopBarJumpToLogin__favicon,
  j3.`robotsTxt` AS modTopBarJumpToLogin__robotsTxt,
  j3.`maintenanceMode` AS modTopBarJumpToLogin__maintenanceMode,
  j3.`mailerTransport` AS modTopBarJumpToLogin__mailerTransport,
  j3.`enableCanonical` AS modTopBarJumpToLogin__enableCanonical,
  j3.`canonicalLink` AS modTopBarJumpToLogin__canonicalLink,
  j3.`canonicalKeepParams` AS modTopBarJumpToLogin__canonicalKeepParams,
  j3.`adminEmail` AS modTopBarJumpToLogin__adminEmail,
  j3.`dateFormat` AS modTopBarJumpToLogin__dateFormat,
  j3.`timeFormat` AS modTopBarJumpToLogin__timeFormat,
  j3.`datimFormat` AS modTopBarJumpToLogin__datimFormat,
  j3.`validAliasCharacters` AS modTopBarJumpToLogin__validAliasCharacters,
  j3.`useFolderUrl` AS modTopBarJumpToLogin__useFolderUrl,
  j3.`urlPrefix` AS modTopBarJumpToLogin__urlPrefix,
  j3.`urlSuffix` AS modTopBarJumpToLogin__urlSuffix,
  j3.`useSSL` AS modTopBarJumpToLogin__useSSL,
  j3.`autoforward` AS modTopBarJumpToLogin__autoforward,
  j3.`protected` AS modTopBarJumpToLogin__protected,
  j3.`groups` AS modTopBarJumpToLogin__groups,
  j3.`includeLayout` AS modTopBarJumpToLogin__includeLayout,
  j3.`layout` AS modTopBarJumpToLogin__layout,
  j3.`subpageLayout` AS modTopBarJumpToLogin__subpageLayout,
  j3.`includeCache` AS modTopBarJumpToLogin__includeCache,
  j3.`cache` AS modTopBarJumpToLogin__cache,
  j3.`alwaysLoadFromCache` AS modTopBarJumpToLogin__alwaysLoadFromCache,
  j3.`clientCache` AS modTopBarJumpToLogin__clientCache,
  j3.`includeChmod` AS modTopBarJumpToLogin__includeChmod,
  j3.`cuser` AS modTopBarJumpToLogin__cuser,
  j3.`cgroup` AS modTopBarJumpToLogin__cgroup,
  j3.`chmod` AS modTopBarJumpToLogin__chmod,
  j3.`noSearch` AS modTopBarJumpToLogin__noSearch,
  j3.`cssClass` AS modTopBarJumpToLogin__cssClass,
  j3.`sitemap` AS modTopBarJumpToLogin__sitemap,
  j3.`hide` AS modTopBarJumpToLogin__hide,
  j3.`guests` AS modTopBarJumpToLogin__guests,
  j3.`tabindex` AS modTopBarJumpToLogin__tabindex,
  j3.`accesskey` AS modTopBarJumpToLogin__accesskey,
  j3.`published` AS modTopBarJumpToLogin__published,
  j3.`start` AS modTopBarJumpToLogin__start,
  j3.`stop` AS modTopBarJumpToLogin__stop,
  j3.`enforceTwoFactor` AS modTopBarJumpToLogin__enforceTwoFactor,
  j3.`twoFactorJumpTo` AS modTopBarJumpToLogin__twoFactorJumpTo,
  j3.`iso_config` AS modTopBarJumpToLogin__iso_config,
  j3.`iso_store_id` AS modTopBarJumpToLogin__iso_store_id,
  j3.`iso_readerMode` AS modTopBarJumpToLogin__iso_readerMode,
  j3.`iso_readerJumpTo` AS modTopBarJumpToLogin__iso_readerJumpTo,
  j4.`id` AS modTopBarJumpToLogout__id,
  j4.`pid` AS modTopBarJumpToLogout__pid,
  j4.`sorting` AS modTopBarJumpToLogout__sorting,
  j4.`tstamp` AS modTopBarJumpToLogout__tstamp,
  j4.`title` AS modTopBarJumpToLogout__title,
  j4.`type` AS modTopBarJumpToLogout__type,
  j4.`alias` AS modTopBarJumpToLogout__alias,
  j4.`requireItem` AS modTopBarJumpToLogout__requireItem,
  j4.`routePriority` AS modTopBarJumpToLogout__routePriority,
  j4.`pageTitle` AS modTopBarJumpToLogout__pageTitle,
  j4.`language` AS modTopBarJumpToLogout__language,
  j4.`robots` AS modTopBarJumpToLogout__robots,
  j4.`description` AS modTopBarJumpToLogout__description,
  j4.`redirect` AS modTopBarJumpToLogout__redirect,
  j4.`jumpTo` AS modTopBarJumpToLogout__jumpTo,
  j4.`redirectBack` AS modTopBarJumpToLogout__redirectBack,
  j4.`url` AS modTopBarJumpToLogout__url,
  j4.`target` AS modTopBarJumpToLogout__target,
  j4.`dns` AS modTopBarJumpToLogout__dns,
  j4.`staticFiles` AS modTopBarJumpToLogout__staticFiles,
  j4.`staticPlugins` AS modTopBarJumpToLogout__staticPlugins,
  j4.`fallback` AS modTopBarJumpToLogout__fallback,
  j4.`disableLanguageRedirect` AS modTopBarJumpToLogout__disableLanguageRedirect,
  j4.`favicon` AS modTopBarJumpToLogout__favicon,
  j4.`robotsTxt` AS modTopBarJumpToLogout__robotsTxt,
  j4.`maintenanceMode` AS modTopBarJumpToLogout__maintenanceMode,
  j4.`mailerTransport` AS modTopBarJumpToLogout__mailerTransport,
  j4.`enableCanonical` AS modTopBarJumpToLogout__enableCanonical,
  j4.`canonicalLink` AS modTopBarJumpToLogout__canonicalLink,
  j4.`canonicalKeepParams` AS modTopBarJumpToLogout__canonicalKeepParams,
  j4.`adminEmail` AS modTopBarJumpToLogout__adminEmail,
  j4.`dateFormat` AS modTopBarJumpToLogout__dateFormat,
  j4.`timeFormat` AS modTopBarJumpToLogout__timeFormat,
  j4.`datimFormat` AS modTopBarJumpToLogout__datimFormat,
  j4.`validAliasCharacters` AS modTopBarJumpToLogout__validAliasCharacters,
  j4.`useFolderUrl` AS modTopBarJumpToLogout__useFolderUrl,
  j4.`urlPrefix` AS modTopBarJumpToLogout__urlPrefix,
  j4.`urlSuffix` AS modTopBarJumpToLogout__urlSuffix,
  j4.`useSSL` AS modTopBarJumpToLogout__useSSL,
  j4.`autoforward` AS modTopBarJumpToLogout__autoforward,
  j4.`protected` AS modTopBarJumpToLogout__protected,
  j4.`groups` AS modTopBarJumpToLogout__groups,
  j4.`includeLayout` AS modTopBarJumpToLogout__includeLayout,
  j4.`layout` AS modTopBarJumpToLogout__layout,
  j4.`subpageLayout` AS modTopBarJumpToLogout__subpageLayout,
  j4.`includeCache` AS modTopBarJumpToLogout__includeCache,
  j4.`cache` AS modTopBarJumpToLogout__cache,
  j4.`alwaysLoadFromCache` AS modTopBarJumpToLogout__alwaysLoadFromCache,
  j4.`clientCache` AS modTopBarJumpToLogout__clientCache,
  j4.`includeChmod` AS modTopBarJumpToLogout__includeChmod,
  j4.`cuser` AS modTopBarJumpToLogout__cuser,
  j4.`cgroup` AS modTopBarJumpToLogout__cgroup,
  j4.`chmod` AS modTopBarJumpToLogout__chmod,
  j4.`noSearch` AS modTopBarJumpToLogout__noSearch,
  j4.`cssClass` AS modTopBarJumpToLogout__cssClass,
  j4.`sitemap` AS modTopBarJumpToLogout__sitemap,
  j4.`hide` AS modTopBarJumpToLogout__hide,
  j4.`guests` AS modTopBarJumpToLogout__guests,
  j4.`tabindex` AS modTopBarJumpToLogout__tabindex,
  j4.`accesskey` AS modTopBarJumpToLogout__accesskey,
  j4.`published` AS modTopBarJumpToLogout__published,
  j4.`start` AS modTopBarJumpToLogout__start,
  j4.`stop` AS modTopBarJumpToLogout__stop,
  j4.`enforceTwoFactor` AS modTopBarJumpToLogout__enforceTwoFactor,
  j4.`twoFactorJumpTo` AS modTopBarJumpToLogout__twoFactorJumpTo,
  j4.`iso_config` AS modTopBarJumpToLogout__iso_config,
  j4.`iso_store_id` AS modTopBarJumpToLogout__iso_store_id,
  j4.`iso_readerMode` AS modTopBarJumpToLogout__iso_readerMode,
  j4.`iso_readerJumpTo` AS modTopBarJumpToLogout__iso_readerJumpTo,
  j5.`id` AS modJumpToLogin__id,
  j5.`pid` AS modJumpToLogin__pid,
  j5.`sorting` AS modJumpToLogin__sorting,
  j5.`tstamp` AS modJumpToLogin__tstamp,
  j5.`title` AS modJumpToLogin__title,
  j5.`type` AS modJumpToLogin__type,
  j5.`alias` AS modJumpToLogin__alias,
  j5.`requireItem` AS modJumpToLogin__requireItem,
  j5.`routePriority` AS modJumpToLogin__routePriority,
  j5.`pageTitle` AS modJumpToLogin__pageTitle,
  j5.`language` AS modJumpToLogin__language,
  j5.`robots` AS modJumpToLogin__robots,
  j5.`description` AS modJumpToLogin__description,
  j5.`redirect` AS modJumpToLogin__redirect,
  j5.`jumpTo` AS modJumpToLogin__jumpTo,
  j5.`redirectBack` AS modJumpToLogin__redirectBack,
  j5.`url` AS modJumpToLogin__url,
  j5.`target` AS modJumpToLogin__target,
  j5.`dns` AS modJumpToLogin__dns,
  j5.`staticFiles` AS modJumpToLogin__staticFiles,
  j5.`staticPlugins` AS modJumpToLogin__staticPlugins,
  j5.`fallback` AS modJumpToLogin__fallback,
  j5.`disableLanguageRedirect` AS modJumpToLogin__disableLanguageRedirect,
  j5.`favicon` AS modJumpToLogin__favicon,
  j5.`robotsTxt` AS modJumpToLogin__robotsTxt,
  j5.`maintenanceMode` AS modJumpToLogin__maintenanceMode,
  j5.`mailerTransport` AS modJumpToLogin__mailerTransport,
  j5.`enableCanonical` AS modJumpToLogin__enableCanonical,
  j5.`canonicalLink` AS modJumpToLogin__canonicalLink,
  j5.`canonicalKeepParams` AS modJumpToLogin__canonicalKeepParams,
  j5.`adminEmail` AS modJumpToLogin__adminEmail,
  j5.`dateFormat` AS modJumpToLogin__dateFormat,
  j5.`timeFormat` AS modJumpToLogin__timeFormat,
  j5.`datimFormat` AS modJumpToLogin__datimFormat,
  j5.`validAliasCharacters` AS modJumpToLogin__validAliasCharacters,
  j5.`useFolderUrl` AS modJumpToLogin__useFolderUrl,
  j5.`urlPrefix` AS modJumpToLogin__urlPrefix,
  j5.`urlSuffix` AS modJumpToLogin__urlSuffix,
  j5.`useSSL` AS modJumpToLogin__useSSL,
  j5.`autoforward` AS modJumpToLogin__autoforward,
  j5.`protected` AS modJumpToLogin__protected,
  j5.`groups` AS modJumpToLogin__groups,
  j5.`includeLayout` AS modJumpToLogin__includeLayout,
  j5.`layout` AS modJumpToLogin__layout,
  j5.`subpageLayout` AS modJumpToLogin__subpageLayout,
  j5.`includeCache` AS modJumpToLogin__includeCache,
  j5.`cache` AS modJumpToLogin__cache,
  j5.`alwaysLoadFromCache` AS modJumpToLogin__alwaysLoadFromCache,
  j5.`clientCache` AS modJumpToLogin__clientCache,
  j5.`includeChmod` AS modJumpToLogin__includeChmod,
  j5.`cuser` AS modJumpToLogin__cuser,
  j5.`cgroup` AS modJumpToLogin__cgroup,
  j5.`chmod` AS modJumpToLogin__chmod,
  j5.`noSearch` AS modJumpToLogin__noSearch,
  j5.`cssClass` AS modJumpToLogin__cssClass,
  j5.`sitemap` AS modJumpToLogin__sitemap,
  j5.`hide` AS modJumpToLogin__hide,
  j5.`guests` AS modJumpToLogin__guests,
  j5.`tabindex` AS modJumpToLogin__tabindex,
  j5.`accesskey` AS modJumpToLogin__accesskey,
  j5.`published` AS modJumpToLogin__published,
  j5.`start` AS modJumpToLogin__start,
  j5.`stop` AS modJumpToLogin__stop,
  j5.`enforceTwoFactor` AS modJumpToLogin__enforceTwoFactor,
  j5.`twoFactorJumpTo` AS modJumpToLogin__twoFactorJumpTo,
  j5.`iso_config` AS modJumpToLogin__iso_config,
  j5.`iso_store_id` AS modJumpToLogin__iso_store_id,
  j5.`iso_readerMode` AS modJumpToLogin__iso_readerMode,
  j5.`iso_readerJumpTo` AS modJumpToLogin__iso_readerJumpTo,
  j6.`id` AS modPhotoCompetitionJumpToUpload__id,
  j6.`pid` AS modPhotoCompetitionJumpToUpload__pid,
  j6.`sorting` AS modPhotoCompetitionJumpToUpload__sorting,
  j6.`tstamp` AS modPhotoCompetitionJumpToUpload__tstamp,
  j6.`title` AS modPhotoCompetitionJumpToUpload__title,
  j6.`type` AS modPhotoCompetitionJumpToUpload__type,
  j6.`alias` AS modPhotoCompetitionJumpToUpload__alias,
  j6.`requireItem` AS modPhotoCompetitionJumpToUpload__requireItem,
  j6.`routePriority` AS modPhotoCompetitionJumpToUpload__routePriority,
  j6.`pageTitle` AS modPhotoCompetitionJumpToUpload__pageTitle,
  j6.`language` AS modPhotoCompetitionJumpToUpload__language,
  j6.`robots` AS modPhotoCompetitionJumpToUpload__robots,
  j6.`description` AS modPhotoCompetitionJumpToUpload__description,
  j6.`redirect` AS modPhotoCompetitionJumpToUpload__redirect,
  j6.`jumpTo` AS modPhotoCompetitionJumpToUpload__jumpTo,
  j6.`redirectBack` AS modPhotoCompetitionJumpToUpload__redirectBack,
  j6.`url` AS modPhotoCompetitionJumpToUpload__url,
  j6.`target` AS modPhotoCompetitionJumpToUpload__target,
  j6.`dns` AS modPhotoCompetitionJumpToUpload__dns,
  j6.`staticFiles` AS modPhotoCompetitionJumpToUpload__staticFiles,
  j6.`staticPlugins` AS modPhotoCompetitionJumpToUpload__staticPlugins,
  j6.`fallback` AS modPhotoCompetitionJumpToUpload__fallback,
  j6.`disableLanguageRedirect` AS modPhotoCompetitionJumpToUpload__disableLanguageRedirect,
  j6.`favicon` AS modPhotoCompetitionJumpToUpload__favicon,
  j6.`robotsTxt` AS modPhotoCompetitionJumpToUpload__robotsTxt,
  j6.`maintenanceMode` AS modPhotoCompetitionJumpToUpload__maintenanceMode,
  j6.`mailerTransport` AS modPhotoCompetitionJumpToUpload__mailerTransport,
  j6.`enableCanonical` AS modPhotoCompetitionJumpToUpload__enableCanonical,
  j6.`canonicalLink` AS modPhotoCompetitionJumpToUpload__canonicalLink,
  j6.`canonicalKeepParams` AS modPhotoCompetitionJumpToUpload__canonicalKeepParams,
  j6.`adminEmail` AS modPhotoCompetitionJumpToUpload__adminEmail,
  j6.`dateFormat` AS modPhotoCompetitionJumpToUpload__dateFormat,
  j6.`timeFormat` AS modPhotoCompetitionJumpToUpload__timeFormat,
  j6.`datimFormat` AS modPhotoCompetitionJumpToUpload__datimFormat,
  j6.`validAliasCharacters` AS modPhotoCompetitionJumpToUpload__validAliasCharacters,
  j6.`useFolderUrl` AS modPhotoCompetitionJumpToUpload__useFolderUrl,
  j6.`urlPrefix` AS modPhotoCompetitionJumpToUpload__urlPrefix,
  j6.`urlSuffix` AS modPhotoCompetitionJumpToUpload__urlSuffix,
  j6.`useSSL` AS modPhotoCompetitionJumpToUpload__useSSL,
  j6.`autoforward` AS modPhotoCompetitionJumpToUpload__autoforward,
  j6.`protected` AS modPhotoCompetitionJumpToUpload__protected,
  j6.`groups` AS modPhotoCompetitionJumpToUpload__groups,
  j6.`includeLayout` AS modPhotoCompetitionJumpToUpload__includeLayout,
  j6.`layout` AS modPhotoCompetitionJumpToUpload__layout,
  j6.`subpageLayout` AS modPhotoCompetitionJumpToUpload__subpageLayout,
  j6.`includeCache` AS modPhotoCompetitionJumpToUpload__includeCache,
  j6.`cache` AS modPhotoCompetitionJumpToUpload__cache,
  j6.`alwaysLoadFromCache` AS modPhotoCompetitionJumpToUpload__alwaysLoadFromCache,
  j6.`clientCache` AS modPhotoCompetitionJumpToUpload__clientCache,
  j6.`includeChmod` AS modPhotoCompetitionJumpToUpload__includeChmod,
  j6.`cuser` AS modPhotoCompetitionJumpToUpload__cuser,
  j6.`cgroup` AS modPhotoCompetitionJumpToUpload__cgroup,
  j6.`chmod` AS modPhotoCompetitionJumpToUpload__chmod,
  j6.`noSearch` AS modPhotoCompetitionJumpToUpload__noSearch,
  j6.`cssClass` AS modPhotoCompetitionJumpToUpload__cssClass,
  j6.`sitemap` AS modPhotoCompetitionJumpToUpload__sitemap,
  j6.`hide` AS modPhotoCompetitionJumpToUpload__hide,
  j6.`guests` AS modPhotoCompetitionJumpToUpload__guests,
  j6.`tabindex` AS modPhotoCompetitionJumpToUpload__tabindex,
  j6.`accesskey` AS modPhotoCompetitionJumpToUpload__accesskey,
  j6.`published` AS modPhotoCompetitionJumpToUpload__published,
  j6.`start` AS modPhotoCompetitionJumpToUpload__start,
  j6.`stop` AS modPhotoCompetitionJumpToUpload__stop,
  j6.`enforceTwoFactor` AS modPhotoCompetitionJumpToUpload__enforceTwoFactor,
  j6.`twoFactorJumpTo` AS modPhotoCompetitionJumpToUpload__twoFactorJumpTo,
  j6.`iso_config` AS modPhotoCompetitionJumpToUpload__iso_config,
  j6.`iso_store_id` AS modPhotoCompetitionJumpToUpload__iso_store_id,
  j6.`iso_readerMode` AS modPhotoCompetitionJumpToUpload__iso_readerMode,
  j6.`iso_readerJumpTo` AS modPhotoCompetitionJumpToUpload__iso_readerJumpTo
FROM
  tl_module
  LEFT JOIN tl_page j1 ON tl_module.`modTopBarJumpToNewsletter` = j1.id
  LEFT JOIN tl_page j2 ON tl_module.`modTopBarJumpToCart` = j2.id
  LEFT JOIN tl_page j3 ON tl_module.`modTopBarJumpToLogin` = j3.id
  LEFT JOIN tl_page j4 ON tl_module.`modTopBarJumpToLogout` = j4.id
  LEFT JOIN tl_page j5 ON tl_module.`modJumpToLogin` = j5.id
  LEFT JOIN tl_page j6 ON tl_module.`modPhotoCompetitionJumpToUpload` = j6.id
WHERE
  tl_module.id IN(66, 75, 76, 67, 0, 64, 57, 58)
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '66,75,76,67,0,64,57,58'
  )