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.0005650520324707 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 '/barrister/family-law' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.0047061443328857 seconds - 623 row(s) affected.
SELECT	(`lander`.`id`) AS `id`,
	(`lander`.`name`) AS `name`,
	(`lander`.`slug`) AS `slug`,
	(`lander`.`title`) AS `title`,
	(`lander`.`template`) AS `template`,
	(`lander`.`area_of_law_id`) AS `area_of_law_id`,
	(`lander`.`content`) AS `content`,
	(`lander`.`intro`) AS `intro`,
	(`lander`.`content_1`) AS `content_1`,
	(`lander`.`links`) AS `links`,
	(`lander`.`content_2`) AS `content_2`,
	(`lander`.`content_2_image`) AS `content_2_image`,
	(`lander`.`content_3`) AS `content_3`,
	(`lander`.`content_3_image`) AS `content_3_image`,
	(`lander`.`banner_1`) AS `banner_1`,
	(`lander`.`banner_2`) AS `banner_2`,
	(`lander`.`partner_id`) AS `partner_id`,
	(`lander`.`meta_title`) AS `meta_title`,
	(`lander`.`meta_description`) AS `meta_description`,
	(`lander`.`publish`) AS `publish`,
	(`lander`.`discard`) AS `discard`,
	(`lander`.`updated`) AS `updated`
FROM `lander`
WHERE `lander`.`discard` IS FALSE
AND `lander`.`publish` IS TRUE
AND `lander`.`slug` = 'family-law'
ORDER BY `lander`.`name` ASC, `lander`.`id` ASC
LIMIT 1
Command completed in 0.0017819404602051 seconds - 1 row(s) affected.
SELECT	(`area_of_law`.`id`) AS `id`,
	(`area_of_law`.`parent`) AS `parent`,
	(`area_of_law`.`ordinal`) AS `ordinal`,
	(`area_of_law`.`online_id`) AS `online_id`,
	(`area_of_law`.`c365_id`) AS `c365_id`,
	(`area_of_law`.`name`) AS `name`,
	(`area_of_law`.`color`) AS `color`,
	(`area_of_law`.`admin_colour`) AS `admin_colour`,
	(`area_of_law`.`publish`) AS `publish`,
	(`area_of_law`.`discard`) AS `discard`,
	(`area_of_law`.`updated`) AS `updated`
FROM `area_of_law`
WHERE `area_of_law`.`discard` IS FALSE
AND `area_of_law`.`publish` IS TRUE
AND `area_of_law`.`id` IN (NULL)
ORDER BY `area_of_law`.`ordinal` ASC, `area_of_law`.`id` ASC
Command completed in 0.0003349781036377 seconds - 0 row(s) affected.
SELECT	(`user`.`id`) AS `id`,
	(`user`.`site_id`) AS `site_id`,
	(`user`.`admin`) AS `admin`,
	(`user`.`developer`) AS `developer`,
	(`user`.`staff`) AS `staff`,
	(`user`.`email`) AS `email`,
	(`user`.`first_name`) AS `first_name`,
	(`user`.`last_name`) AS `last_name`,
	(`user`.`password_secret`) AS `password_secret`,
	(`user`.`password_strategy`) AS `password_strategy`,
	(`user`.`facebook_id`) AS `facebook_id`,
	(`user`.`linkedin_id`) AS `linkedin_id`,
	(`user`.`barrister_id`) AS `barrister_id`,
	(`user`.`chambers_id`) AS `chambers_id`,
	(`user`.`client_id`) AS `client_id`,
	(`user`.`partner_id`) AS `partner_id`,
	(`user`.`photo`) AS `photo`,
	(`user`.`signature`) AS `signature`,
	(`user`.`position`) AS `position`,
	(`user`.`bio`) AS `bio`,
	(`user`.`help`) AS `help`,
	(`user`.`lock`) AS `lock`,
	(`user`.`discard`) AS `discard`
FROM `user`
WHERE `user`.`discard` IS FALSE
AND `user`.`site_id` IN (0, 1)
AND `user`.`staff` = 1
ORDER BY `user`.`last_name` ASC, `user`.`first_name` ASC
Command completed in 0.0003361701965332 seconds - 1 row(s) affected.
SELECT	(`barrister`.`id`) AS `id`,
	(`barrister`.`chambers_id`) AS `chambers_id`,
	(`barrister`.`online_id`) AS `online_id`,
	(`barrister`.`c365_id`) AS `c365_id`,
	(`barrister`.`first_name`) AS `first_name`,
	(`barrister`.`last_name`) AS `last_name`,
	(`barrister`.`summary`) AS `summary`,
	(`barrister`.`content`) AS `content`,
	(`barrister`.`email`) AS `email`,
	(`barrister`.`telephone`) AS `telephone`,
	(`barrister`.`admitted`) AS `admitted`,
	(`barrister`.`called_to_bar`) AS `called_to_bar`,
	(`barrister`.`took_silk`) AS `took_silk`,
	(`barrister`.`cc_name`) AS `cc_name`,
	(`barrister`.`cc_email`) AS `cc_email`,
	(`barrister`.`image`) AS `image`,
	(`barrister`.`vat_registered`) AS `vat_registered`,
	(`barrister`.`vat_number`) AS `vat_number`,
	(`barrister`.`handles_complaints`) AS `handles_complaints`,
	(`barrister`.`conducts_litigation`) AS `conducts_litigation`,
	(`barrister`.`xero_id`) AS `xero_id`,
	(`barrister`.`confirm`) AS `confirm`,
	(`barrister`.`indexable`) AS `indexable`,
	(`barrister`.`publish`) AS `publish`,
	(`barrister`.`discard`) AS `discard`,
	(`barrister`.`created`) AS `created`,
	(`barrister`.`updated`) AS `updated`,
	(`lander_barrister`.`ordinal`) AS `ordinal`
FROM `barrister`
INNER JOIN `lander_barrister` ON `lander_barrister`.`barrister_id` = `barrister`.`id` AND `lander_barrister`.`lander_id` = 1
WHERE `barrister`.`discard` IS FALSE
AND `barrister`.`publish` IS TRUE
AND `barrister`.`confirm` IS TRUE
AND `barrister`.`id` IN (
	SELECT	`barrister_id`
	FROM `lander_barrister`
	WHERE `lander_barrister`.`lander_id` = 1)
ORDER BY RAND()
LIMIT 9
Command completed in 0.001183032989502 seconds - 0 row(s) affected.
SELECT	(`faq`.`id`) AS `id`,
	(`faq`.`name`) AS `name`,
	(`faq`.`title`) AS `title`,
	(`faq`.`content`) AS `content`,
	(`faq`.`publish`) AS `publish`,
	(`faq`.`discard`) AS `discard`,
	(`faq`.`updated`) AS `updated`,
	(`lander_faq`.`ordinal`) AS `ordinal`
FROM `faq`
INNER JOIN `lander_faq` ON `lander_faq`.`faq_id` = `faq`.`id` AND `lander_faq`.`lander_id` = 1
WHERE `faq`.`discard` IS FALSE
AND `faq`.`publish` IS TRUE
AND `faq`.`id` IN (
	SELECT	`faq_id`
	FROM `lander_faq`
	WHERE `lander_faq`.`lander_id` = 1)
ORDER BY `lander_faq`.`ordinal`, `faq`.`id` ASC
Command completed in 0.00094985961914062 seconds - 10 row(s) affected.
SELECT	(`testimonial`.`id`) AS `id`,
	(`testimonial`.`barrister_id`) AS `barrister_id`,
	(`testimonial`.`name`) AS `name`,
	(`testimonial`.`title`) AS `title`,
	(`testimonial`.`rating`) AS `rating`,
	(`testimonial`.`content`) AS `content`,
	(`testimonial`.`publish`) AS `publish`,
	(`testimonial`.`discard`) AS `discard`,
	(`testimonial`.`updated`) AS `updated`,
	(`lander_testimonial`.`ordinal`) AS `ordinal`
FROM `testimonial`
INNER JOIN `lander_testimonial` ON `lander_testimonial`.`testimonial_id` = `testimonial`.`id` AND `lander_testimonial`.`lander_id` = 1
WHERE `testimonial`.`discard` IS FALSE
AND `testimonial`.`publish` IS TRUE
AND `testimonial`.`id` IN (
	SELECT	`testimonial_id`
	FROM `lander_testimonial`
	WHERE `lander_testimonial`.`lander_id` = 1)
ORDER BY `lander_testimonial`.`ordinal`, `testimonial`.`id` ASC
Command completed in 0.0006258487701416 seconds - 3 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.00052404403686523 seconds - 42 row(s) affected.