SELECT (`site`.`partner_id`) AS `partner_id`,
(`site`.`title`) AS `title`,
(`site`.`hostname`) AS `hostname`,
(`site`.`theme`) AS `theme`,
(`site`.`favicon`) AS `favicon`,
(`site`.`address`) AS `address`,
(`site`.`postcode`) AS `postcode`,
(`site`.`vat_number`) AS `vat_number`,
(`site`.`imap_server`) AS `imap_server`,
(`site`.`imap_username`) AS `imap_username`,
(`site`.`imap_password`) AS `imap_password`,
(`site`.`created`) AS `created`,
(`site`.`updated`) AS `updated`,
(`partner`.`id`) AS `id`,
(`partner`.`name`) AS `name`,
(`partner`.`email`) AS `email`,
(`partner`.`telephone`) AS `telephone`,
(`partner`.`dx`) AS `dx`,
(`partner`.`referrers`) AS `referrers`,
(`partner`.`vat_registered`) AS `vat_registered`,
(`partner`.`api_key`) AS `api_key`,
(`partner`.`content`) AS `content`,
(`partner`.`image`) AS `image`,
(`partner`.`agreement`) AS `agreement`,
(`partner`.`partner_rate`) AS `partner_rate`,
(`partner`.`admin_rate`) AS `admin_rate`,
(`partner`.`xero_id`) AS `xero_id`,
(`partner`.`internal`) AS `internal`,
(`partner`.`static`) AS `static`,
(`partner`.`publish`) AS `publish`,
(`partner`.`discard`) AS `discard`
FROM `site`
INNER JOIN `partner` ON `partner`.`id` = `site`.`partner_id`
Command completed in 0.0032408237457275 seconds - 2 row(s) affected.
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 '/' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.00080108642578125 seconds - 623 row(s) affected.
SELECT (`page`.`id`) AS `id`,
(`page`.`site_id`) AS `site_id`,
(`page`.`parent`) AS `parent`,
(`page`.`ordinal`) AS `ordinal`,
(`page`.`name`) AS `name`,
(`page`.`title`) AS `title`,
(`page`.`content`) AS `content`,
(`page`.`hero`) AS `hero`,
(`page`.`banner_id`) AS `banner_id`,
(`page`.`meta_title`) AS `meta_title`,
(`page`.`meta_description`) AS `meta_description`,
(`page`.`static`) AS `static`,
(`page`.`publish`) AS `publish`,
(`page`.`discard`) AS `discard`,
(`page`.`updated`) AS `updated`
FROM `page`
WHERE `page`.`discard` IS FALSE
AND `page`.`publish` IS TRUE
AND `page`.`site_id` = 1
ORDER BY `page`.`parent` ASC, `page`.`ordinal` ASC, `page`.`name` ASC, `page`.`id` ASC
Command completed in 0.0050551891326904 seconds - 42 row(s) affected.
