Joy Okoye

Joy Okoye

  • Divorce
  • Family & Children
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` = '1275'
AND `barrister`.`discard` IS FALSE
AND `barrister`.`publish` IS TRUE
Command completed in 0.00065708160400391 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 (5)
ORDER BY `chambers`.`name` ASC, `chambers`.`id` ASC
Command completed in 0.00021696090698242 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 (1275)
Command completed in 0.00020194053649902 seconds - 0 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` = 1275
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` = 1275)
ORDER BY `barrister_area_of_law`.`ordinal`, `area_of_law`.`ordinal` ASC, `area_of_law`.`id` ASC
Command completed in 0.00041818618774414 seconds - 2 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` = 1275 OR `barrister_id` IS NULL)
ORDER BY `testimonial`.`barrister_id` DESC, RAND()
LIMIT 10
Command completed in 0.00058197975158691 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.00044989585876465 seconds - 42 row(s) affected.