Symfony Profiler

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias IN (
    'profile/amfm-tech-educational-broadcasting-incorporated',
    'profile'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('profile/amfm-tech-educational-broadcasting-incorporated','profile');

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

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

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

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

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

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

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias IN (
    'profile/amfm-tech-educational-broadcasting-incorporated',
    'profile'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('profile/amfm-tech-educational-broadcasting-incorporated','profile');

SELECT
  templates
FROM
  tl_theme

SELECT templates FROM tl_theme;

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

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

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

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

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(59, 49, 0, 0, 0, 56, 50)
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '59,49,0,0,0,56,50'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(59,49,0,0,0,56,50) ORDER BY FIND_IN_SET(`tl_module`.`id`, '59,49,0,0,0,56,50');

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

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

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

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

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

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

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

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

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.`id` = '46'
LIMIT
  0, 1

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

SELECT
  tl_artshub_profile_item.*
FROM
  tl_artshub_profile_item
WHERE
  tl_artshub_profile_item.published = '1'
  AND (
    tl_artshub_profile_item.id = 0
    OR tl_artshub_profile_item.alias = 'amfm-tech-educational-broadcasting-incorporated'
  )
LIMIT
  0, 1

SELECT tl_artshub_profile_item.* FROM tl_artshub_profile_item WHERE tl_artshub_profile_item.published='1' AND (tl_artshub_profile_item.id=0 OR tl_artshub_profile_item.alias='amfm-tech-educational-broadcasting-incorporated') LIMIT 0,1;

SELECT
  *
FROM
  tl_artshub_profile_type
WHERE
  tl_artshub_profile_type.`id` = '29'
LIMIT
  0, 1

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

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

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

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.`path` = 'files/assets/img/placeholders/profile-placeholder.jpg'
LIMIT
  0, 1

SELECT * FROM tl_files WHERE tl_files.`path`='files/assets/img/placeholders/profile-placeholder.jpg' LIMIT 0,1;

SELECT
  tl_image_size.*
FROM
  tl_image_size
WHERE
  tl_image_size.`id` = '3'
LIMIT
  0, 1

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

SELECT
  tl_image_size_item.*
FROM
  tl_image_size_item
WHERE
  tl_image_size_item.pid = 3
  AND tl_image_size_item.invisible = ''
ORDER BY
  sorting ASC

SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=3 AND tl_image_size_item.invisible='' ORDER BY sorting ASC;

SELECT
  *
FROM
  tl_artshub_profile_discipline
WHERE
  tl_artshub_profile_discipline.`id` IN('760')
ORDER BY
  FIND_IN_SET(
    tl_artshub_profile_discipline.`id`,
    '760'
  )

SELECT * FROM tl_artshub_profile_discipline WHERE tl_artshub_profile_discipline.`id` IN('760') ORDER BY FIND_IN_SET(tl_artshub_profile_discipline.`id`, '760');

SELECT
  *
FROM
  tl_artshub_profile_activity
WHERE
  tl_artshub_profile_activity.`id` IN('')
ORDER BY
  FIND_IN_SET(
    tl_artshub_profile_activity.`id`,
    ''
  )

SELECT * FROM tl_artshub_profile_activity WHERE tl_artshub_profile_activity.`id` IN('') ORDER BY FIND_IN_SET(tl_artshub_profile_activity.`id`, '');

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      'b0f63bb7fa1611eb890ef23c9128ddb0'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    'b0f63bb7fa1611eb890ef23c9128ddb0'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('b0f63bb7fa1611eb890ef23c9128ddb0')) ORDER BY tl_files.uuid!=UNHEX('b0f63bb7fa1611eb890ef23c9128ddb0');

SELECT
  tl_node.*
FROM
  tl_node
WHERE
  id = 15
  AND type = 'content'
LIMIT
  0, 1

SELECT tl_node.* FROM tl_node WHERE id=15 AND type='content' LIMIT 0,1;

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

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

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.`id` = '58'
LIMIT
  0, 1

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

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1746050640'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1746050640'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '160'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1746050640'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1746050640'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1746050640') AND (p2.stop='' OR p2.stop>'1746050640')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='160' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1746050640') AND (p1.stop='' OR p1.stop>'1746050640') ORDER BY p1.sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(161, 162, 163, 165, 166, 167, 168)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '161,162,164,163,165,166,167,168'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(161,162,163,165,166,167,168) ORDER BY FIND_IN_SET(`tl_page`.`id`, '161,162,164,163,165,166,167,168');

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1746050640'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1746050640'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '161'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1746050640'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1746050640'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1746050640') AND (p2.stop='' OR p2.stop>'1746050640')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='161' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1746050640') AND (p1.stop='' OR p1.stop>'1746050640') ORDER BY p1.sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(180, 172, 173, 181)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '180,172,173,181'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(180,172,173,181) ORDER BY FIND_IN_SET(`tl_page`.`id`, '180,172,173,181');

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1746050640'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1746050640'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '164'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1746050640'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1746050640'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1746050640') AND (p2.stop='' OR p2.stop>'1746050640')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='164' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1746050640') AND (p1.stop='' OR p1.stop>'1746050640') ORDER BY p1.sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(193, 194)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '169,193,194')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(193,194) ORDER BY FIND_IN_SET(`tl_page`.`id`, '169,193,194');

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1746050640'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1746050640'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '165'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1746050640'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1746050640'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1746050640') AND (p2.stop='' OR p2.stop>'1746050640')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='165' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1746050640') AND (p1.stop='' OR p1.stop>'1746050640') ORDER BY p1.sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(170, 178)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '170,178')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(170,178) ORDER BY FIND_IN_SET(`tl_page`.`id`, '170,178');

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1746050640'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1746050640'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '168'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1746050640'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1746050640'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1746050640') AND (p2.stop='' OR p2.stop>'1746050640')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='168' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1746050640') AND (p1.stop='' OR p1.stop>'1746050640') ORDER BY p1.sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(191, 190)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '191,190')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(191,190) ORDER BY FIND_IN_SET(`tl_page`.`id`, '191,190');

SELECT
  tl_node.*
FROM
  tl_node
WHERE
  id = 2
  AND type = 'content'
LIMIT
  0, 1

SELECT tl_node.* FROM tl_node WHERE id=2 AND type='content' LIMIT 0,1;

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

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

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = '150'
LIMIT
  0, 1

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

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.`id` = '51'
LIMIT
  0, 1

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

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1746050640'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1746050640'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '160'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1746050640'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1746050640'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1746050640') AND (p2.stop='' OR p2.stop>'1746050640')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='160' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1746050640') AND (p1.stop='' OR p1.stop>'1746050640') 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 != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1746050640'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1746050640'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '161'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1746050640'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1746050640'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1746050640') AND (p2.stop='' OR p2.stop>'1746050640')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='161' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1746050640') AND (p1.stop='' OR p1.stop>'1746050640') 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 != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1746050640'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1746050640'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '164'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1746050640'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1746050640'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1746050640') AND (p2.stop='' OR p2.stop>'1746050640')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='164' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1746050640') AND (p1.stop='' OR p1.stop>'1746050640') 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 != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1746050640'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1746050640'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '165'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1746050640'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1746050640'
  )
ORDER BY
  p1.sorting