SELECT (`label`.`id`) AS `id`,
(`label`.`name`) AS `name`,
(`label`.`path`) AS `path`,
(`label`.`source`) AS `source`,
(`label`.`content`) AS `content`,
(`label`.`block`) AS `block`,
(`label`.`discard`) AS `discard`
FROM `label`
WHERE `label`.`discard` IS FALSE
AND (`label`.`path` = ''
OR '/167-advice-and-guidance' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.0022280216217041 seconds - 292 row(s) affected.
SELECT (`page`.`id`) AS `id`,
(`page`.`parent`) AS `parent`,
(`page`.`ordinal`) AS `ordinal`,
(`page`.`name`) AS `name`,
(`page`.`title`) AS `title`,
(`page`.`summary`) AS `summary`,
(`page`.`content`) AS `content`,
(`page`.`theme`) AS `theme`,
(`page`.`meta_title`) AS `meta_title`,
(`page`.`meta_description`) AS `meta_description`,
(`page`.`slug`) AS `slug`,
(`page`.`password`) AS `password`,
(`page`.`donation_text`) AS `donation_text`,
(`page`.`donation_amounts`) AS `donation_amounts`,
(`page`.`grid`) AS `grid`,
(`page`.`grid_title`) AS `grid_title`,
(`page`.`static`) AS `static`,
(`page`.`donate`) AS `donate`,
(`page`.`publish`) AS `publish`,
(`page`.`discard`) AS `discard`,
(`page`.`updated`) AS `updated`,
(
SELECT `image`
FROM `page_image`
WHERE `page_image`.`discard` IS FALSE
AND `page_image`.`publish` IS TRUE
AND `page_image`.`page_id` = `page`.`id`
ORDER BY `page_image`.`ordinal` ASC
LIMIT 1) AS `image`
FROM `page`
WHERE `page`.`discard` IS FALSE
AND `page`.`publish` IS TRUE
ORDER BY `page`.`parent` ASC, `page`.`ordinal` ASC, `page`.`name` ASC, `page`.`id` ASC
Command completed in 0.0035829544067383 seconds - 63 row(s) affected.
SELECT (`page_image`.`id`) AS `id`,
(`page_image`.`page_id`) AS `page_id`,
(`page_image`.`ordinal`) AS `ordinal`,
(`page_image`.`name`) AS `name`,
(`page_image`.`title`) AS `title`,
(`page_image`.`summary`) AS `summary`,
(`page_image`.`url`) AS `url`,
(`page_image`.`image`) AS `image`,
(`page_image`.`image_mobile`) AS `image_mobile`,
(`page_image`.`image_alt`) AS `image_alt`,
(`page_image`.`publish`) AS `publish`,
(`page_image`.`discard`) AS `discard`,
(`page_image`.`updated`) AS `updated`
FROM `page_image`
WHERE `page_image`.`discard` IS FALSE
AND `page_image`.`publish` IS TRUE
ORDER BY `page_image`.`ordinal` ASC, `page_image`.`name` ASC, `page_image`.`id` ASC
Command completed in 0.0015959739685059 seconds - 62 row(s) affected.
SELECT (`page`.`id`) AS `id`,
(`page`.`parent`) AS `parent`,
(`page`.`ordinal`) AS `ordinal`,
(`page`.`name`) AS `name`,
(`page`.`title`) AS `title`,
(`page`.`summary`) AS `summary`,
(`page`.`content`) AS `content`,
(`page`.`theme`) AS `theme`,
(`page`.`meta_title`) AS `meta_title`,
(`page`.`meta_description`) AS `meta_description`,
(`page`.`slug`) AS `slug`,
(`page`.`password`) AS `password`,
(`page`.`donation_text`) AS `donation_text`,
(`page`.`donation_amounts`) AS `donation_amounts`,
(`page`.`grid`) AS `grid`,
(`page`.`grid_title`) AS `grid_title`,
(`page`.`static`) AS `static`,
(`page`.`donate`) AS `donate`,
(`page`.`publish`) AS `publish`,
(`page`.`discard`) AS `discard`,
(`page`.`updated`) AS `updated`,
(
SELECT `image`
FROM `page_image`
WHERE `page_image`.`discard` IS FALSE
AND `page_image`.`publish` IS TRUE
AND `page_image`.`page_id` = `page`.`id`
ORDER BY `page_image`.`ordinal` ASC
LIMIT 1) AS `image`
FROM `page`
WHERE `page`.`discard` IS FALSE
AND `page`.`publish` IS TRUE
ORDER BY `page`.`parent` ASC, `page`.`ordinal` ASC, `page`.`name` ASC, `page`.`id` ASC
Command completed in 0.0039329528808594 seconds - 63 row(s) affected.
SELECT (`page_image`.`id`) AS `id`,
(`page_image`.`page_id`) AS `page_id`,
(`page_image`.`ordinal`) AS `ordinal`,
(`page_image`.`name`) AS `name`,
(`page_image`.`title`) AS `title`,
(`page_image`.`summary`) AS `summary`,
(`page_image`.`url`) AS `url`,
(`page_image`.`image`) AS `image`,
(`page_image`.`image_mobile`) AS `image_mobile`,
(`page_image`.`image_alt`) AS `image_alt`,
(`page_image`.`publish`) AS `publish`,
(`page_image`.`discard`) AS `discard`,
(`page_image`.`updated`) AS `updated`
FROM `page_image`
WHERE `page_image`.`discard` IS FALSE
AND `page_image`.`publish` IS TRUE
ORDER BY `page_image`.`ordinal` ASC, `page_image`.`name` ASC, `page_image`.`id` ASC
Command completed in 0.0010249614715576 seconds - 62 row(s) affected.
SELECT (`page_section`.`id`) AS `id`,
(`page_section`.`page_id`) AS `page_id`,
(`page_section`.`ordinal`) AS `ordinal`,
(`page_section`.`type`) AS `type`,
(`page_section`.`content`) AS `content`,
(`page_section`.`publish`) AS `publish`,
(`page_section`.`discard`) AS `discard`,
(`page_section`.`updated`) AS `updated`,
(`page`.`name`) AS `page_name`
FROM `page_section`
INNER JOIN `page` ON `page`.`id` = `page_section`.`page_id` AND `page`.`discard` IS FALSE AND `page`.`publish` IS TRUE
WHERE `page_section`.`discard` IS FALSE
AND `page_section`.`publish` IS TRUE
AND `page_section`.`page_id` = 167
ORDER BY `page_section`.`ordinal` ASC, `page_section`.`id` ASC
Command completed in 0.0014379024505615 seconds - 1 row(s) affected.
SELECT (`page_section_slide`.`id`) AS `id`,
(`page_section_slide`.`page_section_id`) AS `page_section_id`,
(`page_section_slide`.`ordinal`) AS `ordinal`,
(`page_section_slide`.`name`) AS `name`,
(`page_section_slide`.`title`) AS `title`,
(`page_section_slide`.`content`) AS `content`,
(`page_section_slide`.`image`) AS `image`,
(`page_section_slide`.`image_alt`) AS `image_alt`,
(`page_section_slide`.`video`) AS `video`,
(`page_section_slide`.`publish`) AS `publish`,
(`page_section_slide`.`discard`) AS `discard`,
(`page_section_slide`.`updated`) AS `updated`
FROM `page_section_slide`
WHERE `page_section_slide`.`discard` IS FALSE
AND `page_section_slide`.`publish` IS TRUE
AND `page_section_slide`.`page_section_id` IN (91)
ORDER BY `page_section_slide`.`ordinal` ASC, `page_section_slide`.`name` ASC, `page_section_slide`.`id` ASC
Command completed in 0.0010018348693848 seconds - 0 row(s) affected.
SELECT (`faq`.`id`) AS `id`,
(`faq`.`parent`) AS `parent`,
(`faq`.`ordinal`) AS `ordinal`,
(`faq`.`name`) AS `name`,
(`faq`.`content`) AS `content`,
(`faq`.`publish`) AS `publish`,
(`faq`.`discard`) AS `discard`,
(`faq`.`updated`) AS `updated`
FROM `faq`
WHERE `faq`.`discard` IS FALSE
AND `faq`.`publish` IS TRUE
AND `faq`.`parent` IS NOT NULL
ORDER BY `faq`.`parent` ASC, `faq`.`ordinal` ASC, `faq`.`name` ASC, `faq`.`id` ASC
Command completed in 0.0025210380554199 seconds - 124 row(s) affected.
SELECT (`page_section_faq`.`page_section_id`) AS `page_section_id`,
(`page_section_faq`.`faq_id`) AS `faq_id`
FROM `page_section_faq`
WHERE `page_section_faq`.`page_section_id` = 91
Command completed in 0.0010089874267578 seconds - 1 row(s) affected.
SELECT (`notice`.`id`) AS `id`,
(`notice`.`ordinal`) AS `ordinal`,
(`notice`.`name`) AS `name`,
(`notice`.`title`) AS `title`,
(`notice`.`content`) AS `content`,
(`notice`.`image`) AS `image`,
(`notice`.`button_text`) AS `button_text`,
(`notice`.`button_link`) AS `button_link`,
(`notice`.`position`) AS `position`,
(`notice`.`icon`) AS `icon`,
(`notice`.`publish_date`) AS `publish_date`,
(`notice`.`publish_until`) AS `publish_until`,
(`notice`.`publish`) AS `publish`,
(`notice`.`discard`) AS `discard`,
(`notice`.`updated`) AS `updated`
FROM `notice`
WHERE `notice`.`discard` IS FALSE
AND `notice`.`publish` IS TRUE
AND `notice`.`publish_until` >= CURRENT_DATE
ORDER BY `notice`.`publish_date` DESC, `notice`.`id` DESC
LIMIT 1
Command completed in 0.00087094306945801 seconds - 0 row(s) affected.
SELECT (`page_section`.`id`) AS `id`,
(`page_section`.`page_id`) AS `page_id`,
(`page_section`.`ordinal`) AS `ordinal`,
(`page_section`.`type`) AS `type`,
(`page_section`.`content`) AS `content`,
(`page_section`.`publish`) AS `publish`,
(`page_section`.`discard`) AS `discard`,
(`page_section`.`updated`) AS `updated`,
(`page`.`name`) AS `page_name`
FROM `page_section`
INNER JOIN `page` ON `page`.`id` = `page_section`.`page_id` AND `page`.`discard` IS FALSE AND `page`.`publish` IS TRUE
WHERE `page_section`.`discard` IS FALSE
AND `page_section`.`publish` IS TRUE
AND `page_section`.`page_id` = 167
ORDER BY `page_section`.`ordinal` ASC, `page_section`.`id` ASC
Command completed in 0.000640869140625 seconds - 1 row(s) affected.
SELECT (`page_section_slide`.`id`) AS `id`,
(`page_section_slide`.`page_section_id`) AS `page_section_id`,
(`page_section_slide`.`ordinal`) AS `ordinal`,
(`page_section_slide`.`name`) AS `name`,
(`page_section_slide`.`title`) AS `title`,
(`page_section_slide`.`content`) AS `content`,
(`page_section_slide`.`image`) AS `image`,
(`page_section_slide`.`image_alt`) AS `image_alt`,
(`page_section_slide`.`video`) AS `video`,
(`page_section_slide`.`publish`) AS `publish`,
(`page_section_slide`.`discard`) AS `discard`,
(`page_section_slide`.`updated`) AS `updated`
FROM `page_section_slide`
WHERE `page_section_slide`.`discard` IS FALSE
AND `page_section_slide`.`publish` IS TRUE
AND `page_section_slide`.`page_section_id` IN (91)
ORDER BY `page_section_slide`.`ordinal` ASC, `page_section_slide`.`name` ASC, `page_section_slide`.`id` ASC
Command completed in 0.00069093704223633 seconds - 0 row(s) affected.
SELECT (`faq`.`id`) AS `id`,
(`faq`.`parent`) AS `parent`,
(`faq`.`ordinal`) AS `ordinal`,
(`faq`.`name`) AS `name`,
(`faq`.`content`) AS `content`,
(`faq`.`publish`) AS `publish`,
(`faq`.`discard`) AS `discard`,
(`faq`.`updated`) AS `updated`
FROM `faq`
WHERE `faq`.`discard` IS FALSE
AND `faq`.`publish` IS TRUE
AND `faq`.`parent` IS NOT NULL
ORDER BY `faq`.`parent` ASC, `faq`.`ordinal` ASC, `faq`.`name` ASC, `faq`.`id` ASC
Command completed in 0.001215934753418 seconds - 124 row(s) affected.
SELECT (`page_section_faq`.`page_section_id`) AS `page_section_id`,
(`page_section_faq`.`faq_id`) AS `faq_id`
FROM `page_section_faq`
WHERE `page_section_faq`.`page_section_id` = 91
Command completed in 0.00057291984558105 seconds - 1 row(s) affected.
SELECT (`banner`.`id`) AS `id`,
(`banner`.`name`) AS `name`,
(`banner`.`url`) AS `url`,
(`banner`.`image`) AS `image`,
(`banner`.`image_alt`) AS `image_alt`,
(`banner`.`publish`) AS `publish`,
(`banner`.`discard`) AS `discard`,
(`banner`.`updated`) AS `updated`,
(`page_banner`.`ordinal`) AS `ordinal`
FROM `banner`
INNER JOIN `page_banner` ON `page_banner`.`banner_id` = `banner`.`id` AND `page_banner`.`page_id` = 167
WHERE `banner`.`discard` IS FALSE
AND `banner`.`publish` IS TRUE
AND `banner`.`id` IN (
SELECT `banner_id`
FROM `page_banner`
WHERE `page_banner`.`page_id` = 167)
ORDER BY `page_banner`.`ordinal` ASC, `banner`.`name` ASC
Command completed in 0.00075697898864746 seconds - 0 row(s) affected.
.jpg)