Symfony Profiler

SELECT
  tl_iso_product.*,
  'de' AS language,
  IF(
    tl_iso_product.pid > 0, parent.type,
    tl_iso_product.type
  ) AS type,
  tl_iso_product.images AS images_fallback,
  tl_iso_product.hauptbild AS hauptbild_fallback,
  tl_iso_product.bildergalerie AS bildergalerie_fallback,
  GROUP_CONCAT(c.page_id) AS product_categories
FROM
  tl_iso_product
  LEFT OUTER JOIN tl_iso_product parent ON tl_iso_product.pid = parent.id
  LEFT OUTER JOIN tl_iso_product_category c ON IFNULL(parent.id, tl_iso_product.id)= c.pid
WHERE
  tl_iso_product.language = ''
  AND tl_iso_product.id = ?

SELECT tl_iso_product.*, 'de' AS language, IF(tl_iso_product.pid>0, parent.type, tl_iso_product.type) AS type, tl_iso_product.images AS images_fallback, tl_iso_product.hauptbild AS hauptbild_fallback, tl_iso_product.bildergalerie AS bildergalerie_fallback, GROUP_CONCAT(c.page_id) AS product_categories FROM tl_iso_product LEFT OUTER JOIN tl_iso_product parent ON tl_iso_product.pid=parent.id LEFT OUTER JOIN tl_iso_product_category c ON IFNULL(parent.id, tl_iso_product.id)=c.pid WHERE tl_iso_product.language='' AND tl_iso_product.id='395';

SELECT
  attributeName,
  attributeCondition
FROM
  tl_iso_rule
WHERE
  enabled = '1'
  AND productRestrictions = 'attribute'
  AND attributeName != ''
GROUP BY
  attributeName,
  attributeCondition

SELECT attributeName, attributeCondition FROM tl_iso_rule WHERE enabled='1' AND productRestrictions='attribute' AND attributeName!='' GROUP BY attributeName, attributeCondition;

SELECT
  *
FROM
  tl_iso_rule r
WHERE
  type = 'product'
  AND enabled = '1'
  AND (
    startDate = ''
    OR startDate <= UNIX_TIMESTAMP('2026-05-02 23:31:32')
  )
  AND (
    endDate = ''
    OR endDate >= UNIX_TIMESTAMP('2026-05-02 23:31:32')
  )
  AND (
    startTime = ''
    OR startTime <= UNIX_TIMESTAMP('1970-01-01 23:31:32')
  )
  AND (
    endTime = ''
    OR endTime >= UNIX_TIMESTAMP('1970-01-01 23:31:32')
  )
  AND (
    limitPerConfig = 0
    OR limitPerConfig >(
      SELECT
        COUNT(*)
      FROM
        tl_iso_rule_usage
      WHERE
        pid = r.id
        AND config_id = 1
        AND order_id NOT IN (
          SELECT
            id
          FROM
            tl_iso_product_collection
          WHERE
            type = 'order'
            AND source_collection_id = 0
        )
    )
  )
  AND (
    configRestrictions = ''
    OR (
      configRestrictions = '1'
      AND configCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'configs'
          AND object_id = 1
      )> 0
    )
    OR (
      configRestrictions = '1'
      AND configCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'configs'
          AND object_id = 1
      )= 0
    )
  )
  AND (
    memberRestrictions = 'none'
    OR (
      memberRestrictions = 'guests'
      AND memberCondition = '1'
    )
  )
  AND (
    productRestrictions = 'none'
    OR (
      productRestrictions = 'producttypes'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'producttypes'
          AND object_id IN (0, 1)
      )> 0
    )
    OR (
      productRestrictions = 'producttypes'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'producttypes'
          AND object_id IN (0, 1)
      )= 0
    )
    OR (
      productRestrictions = 'products'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'products'
          AND object_id IN (0, 383)
      )> 0
    )
    OR (
      productRestrictions = 'products'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'products'
          AND object_id IN (0, 383)
      )= 0
    )
    OR (
      productRestrictions = 'variants'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'variants'
          AND object_id IN (0, 383)
      )> 0
    )
    OR (
      productRestrictions = 'variants'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'variants'
          AND object_id IN (0, 383)
      )= 0
    )
    OR (
      productRestrictions = 'pages'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'pages'
          AND object_id IN (
            SELECT
              page_id
            FROM
              tl_iso_product_category
            WHERE
              pid IN (0, 383)
          )
      )> 0
    )
    OR (
      productRestrictions = 'pages'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'pages'
          AND object_id IN (
            SELECT
              page_id
            FROM
              tl_iso_product_category
            WHERE
              pid IN (0, 383)
          )
      )= 0
    )
  )

SELECT * FROM tl_iso_rule r WHERE type='product' AND enabled='1' AND (startDate='' OR startDate <= UNIX_TIMESTAMP('2026-05-02 23:31:32')) AND (endDate='' OR endDate >= UNIX_TIMESTAMP('2026-05-02 23:31:32')) AND (startTime='' OR startTime <= UNIX_TIMESTAMP('1970-01-01 23:31:32')) AND (endTime='' OR endTime >= UNIX_TIMESTAMP('1970-01-01 23:31:32')) AND (limitPerConfig=0 OR limitPerConfig>(SELECT COUNT(*) FROM tl_iso_rule_usage WHERE pid=r.id AND config_id=1 AND order_id NOT IN (SELECT id FROM tl_iso_product_collection WHERE type='order' AND source_collection_id=0))) AND (configRestrictions=''
                            OR (configRestrictions='1' AND configCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='configs' AND object_id=1)>0)
                            OR (configRestrictions='1' AND configCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='configs' AND object_id=1)=0)) AND (memberRestrictions='none' OR (memberRestrictions='guests' AND memberCondition='1')) AND (productRestrictions='none' OR (productRestrictions='producttypes' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='producttypes' AND object_id IN (0,1))>0) OR (productRestrictions='producttypes' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='producttypes' AND object_id IN (0,1))=0) OR (productRestrictions='products' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='products' AND object_id IN (0,383))>0) OR (productRestrictions='products' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='products' AND object_id IN (0,383))=0) OR (productRestrictions='variants' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='variants' AND object_id IN (0,383))>0) OR (productRestrictions='variants' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='variants' AND object_id IN (0,383))=0) OR (productRestrictions='pages' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='pages' AND object_id IN (SELECT page_id FROM tl_iso_product_category WHERE pid IN (0,383)))>0) OR (productRestrictions='pages' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='pages' AND object_id IN (SELECT page_id FROM tl_iso_product_category WHERE pid IN (0,383)))=0));

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` = ?
LIMIT
  0, 1

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`='92' LIMIT 0,1;