Profile description
(Due to the local restrictions required in the Isle of Man, Richard will need to send an additional client care agreement to reflect the variations in rules when working from the Isle of Man)
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` FROM `barrister` WHERE `barrister`.`id` = '47' AND `barrister`.`discard` IS FALSE AND `barrister`.`publish` IS TRUE
Command completed in 0.00095701217651367 seconds - 1 row(s) affected.
SELECT (`chambers`.`id`) AS `id`, (`chambers`.`name`) AS `name`, (`chambers`.`email`) AS `email`, (`chambers`.`line_1`) AS `line_1`, (`chambers`.`line_2`) AS `line_2`, (`chambers`.`line_3`) AS `line_3`, (`chambers`.`city`) AS `city`, (`chambers`.`postcode`) AS `postcode`, (`chambers`.`telephone`) AS `telephone`, (`chambers`.`fax`) AS `fax`, (`chambers`.`dx`) AS `dx`, (`chambers`.`discard`) AS `discard`, (`chambers`.`created`) AS `created`, (`chambers`.`updated`) AS `updated` FROM `chambers` WHERE `chambers`.`discard` IS FALSE AND `chambers`.`id` IN (121) ORDER BY `chambers`.`name` ASC, `chambers`.`id` ASC
Command completed in 0.00040102005004883 seconds - 1 row(s) affected.
SELECT (`barrister_region`.`barrister_id`) AS `barrister_id`, (`barrister_region`.`region_id`) AS `region_id` FROM `barrister_region` WHERE `barrister_region`.`barrister_id` IN (47)
Command completed in 0.00032806396484375 seconds - 2 row(s) affected.
SELECT (`region`.`id`) AS `id`, (`region`.`ordinal`) AS `ordinal`, (`region`.`name`) AS `name`, (`region`.`discard`) AS `discard`, (`region`.`updated`) AS `updated` FROM `region` WHERE `region`.`discard` IS FALSE AND `region`.`id` IN (1, 12) ORDER BY `region`.`ordinal` ASC, `region`.`name` ASC, `region`.`id` ASC
Command completed in 0.00031805038452148 seconds - 1 row(s) affected.
SELECT (`area_of_law`.`id`) AS `id`, (`area_of_law`.`parent`) AS `parent`, (`barrister_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` INNER JOIN `barrister_area_of_law` ON `barrister_area_of_law`.`area_of_law_id` = `area_of_law`.`id` AND `barrister_area_of_law`.`barrister_id` = 47 WHERE `area_of_law`.`discard` IS FALSE AND `area_of_law`.`publish` IS TRUE AND `area_of_law`.`id` IN ( SELECT `area_of_law_id` FROM `barrister_area_of_law` WHERE `barrister_area_of_law`.`barrister_id` = 47) ORDER BY `barrister_area_of_law`.`ordinal`, `area_of_law`.`ordinal` ASC, `area_of_law`.`id` ASC
Command completed in 0.0005490779876709 seconds - 7 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` FROM `testimonial` WHERE `testimonial`.`discard` IS FALSE AND `testimonial`.`publish` IS TRUE AND (`barrister_id` = 47 OR `barrister_id` IS NULL) ORDER BY `testimonial`.`barrister_id` DESC, RAND() LIMIT 10
Command completed in 0.00079703330993652 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.00041007995605469 seconds - 42 row(s) affected.