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.00074410438537598 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.0003509521484375 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.00027585029602051 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.00031185150146484 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.00049090385437012 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.00068998336791992 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.00030708312988281 seconds - 42 row(s) affected.