Go direct and contact this barrister through Clerksroom Direct today

  • Go direct to save on solicitors’ fees
  • We’ll find the right Barrister for you
  • 1000+ Barristers: all direct access specialists
  • Save up to 42% with fixed costss
SELECT	(`article`.`id`) AS `id`,
	(`article`.`name`) AS `name`,
	(`article`.`title`) AS `title`,
	(`article`.`summary`) AS `summary`,
	(`article`.`author`) AS `author`,
	(`article`.`content`) AS `content`,
	(`article`.`sidebar`) AS `sidebar`,
	(`article`.`image`) AS `image`,
	(`article`.`banner`) AS `banner`,
	(`article`.`dark_banner_text`) AS `dark_banner_text`,
	(`article`.`image_one`) AS `image_one`,
	(`article`.`image_two`) AS `image_two`,
	(`article`.`meta_title`) AS `meta_title`,
	(`article`.`meta_description`) AS `meta_description`,
	(`article`.`publish_date`) AS `publish_date`,
	(`article`.`guide`) AS `guide`,
	(`article`.`publish`) AS `publish`,
	(`article`.`discard`) AS `discard`,
	(`article`.`updated`) AS `updated`
FROM `article`
WHERE `article`.`id` = '3'
AND `article`.`discard` IS FALSE
AND `article`.`publish` IS TRUE
AND `article`.`publish_date` <= CURRENT_DATE
Command completed in 0.0010988712310791 seconds - 1 row(s) affected.
SELECT	(`article_tag`.`article_id`) AS `article_id`,
	(`article_tag`.`tag_id`) AS `tag_id`
FROM `article_tag`
WHERE `article_tag`.`article_id` IN ('3')
Command completed in 0.00093293190002441 seconds - 4 row(s) affected.
SELECT	(`tag`.`id`) AS `id`,
	(`tag`.`name`) AS `name`,
	(`tag`.`publish`) AS `publish`,
	(`tag`.`discard`) AS `discard`,
	(`tag`.`updated`) AS `updated`
FROM `tag`
WHERE `tag`.`discard` IS FALSE
AND `tag`.`publish` IS TRUE
AND `tag`.`id` IN ('7', '21', '23', '25')
ORDER BY `tag`.`name` ASC, `tag`.`id` ASC
Command completed in 0.0011048316955566 seconds - 4 row(s) affected.
SELECT	(`article`.`id`) AS `id`,
	(`article`.`name`) AS `name`,
	(`article`.`title`) AS `title`,
	(`article`.`summary`) AS `summary`,
	(`article`.`author`) AS `author`,
	(`article`.`content`) AS `content`,
	(`article`.`sidebar`) AS `sidebar`,
	(`article`.`image`) AS `image`,
	(`article`.`banner`) AS `banner`,
	(`article`.`dark_banner_text`) AS `dark_banner_text`,
	(`article`.`image_one`) AS `image_one`,
	(`article`.`image_two`) AS `image_two`,
	(`article`.`meta_title`) AS `meta_title`,
	(`article`.`meta_description`) AS `meta_description`,
	(`article`.`publish_date`) AS `publish_date`,
	(`article`.`guide`) AS `guide`,
	(`article`.`publish`) AS `publish`,
	(`article`.`discard`) AS `discard`,
	(`article`.`updated`) AS `updated`
FROM `article`
WHERE `article`.`discard` IS FALSE
AND `article`.`publish` IS TRUE
AND `article`.`publish_date` <= CURRENT_DATE
AND `article`.`guide` = 1
AND `article`.`id` IN (
	SELECT	`article_id`
	FROM `article_tag`
	WHERE `article_tag`.`tag_id` = '7')
ORDER BY `article`.`publish_date` DESC, `article`.`id` DESC
LIMIT 3
Command completed in 0.0019898414611816 seconds - 3 row(s) affected.
SELECT	(`article_tag`.`article_id`) AS `article_id`,
	(`article_tag`.`tag_id`) AS `tag_id`
FROM `article_tag`
WHERE `article_tag`.`article_id` IN ('57', '3', '51')
Command completed in 0.00090885162353516 seconds - 15 row(s) affected.
SELECT	(`tag`.`id`) AS `id`,
	(`tag`.`name`) AS `name`,
	(`tag`.`publish`) AS `publish`,
	(`tag`.`discard`) AS `discard`,
	(`tag`.`updated`) AS `updated`
FROM `tag`
WHERE `tag`.`discard` IS FALSE
AND `tag`.`publish` IS TRUE
AND `tag`.`id` IN ('7', '21', '23', '25', '7', '9', '11', '19', '21', '23', '25', '7', '9', '11', '25')
ORDER BY `tag`.`name` ASC, `tag`.`id` ASC
Command completed in 0.0010960102081299 seconds - 7 row(s) affected.
SELECT	(`article`.`id`) AS `id`,
	(`article`.`name`) AS `name`,
	(`article`.`title`) AS `title`,
	(`article`.`summary`) AS `summary`,
	(`article`.`author`) AS `author`,
	(`article`.`content`) AS `content`,
	(`article`.`sidebar`) AS `sidebar`,
	(`article`.`image`) AS `image`,
	(`article`.`banner`) AS `banner`,
	(`article`.`dark_banner_text`) AS `dark_banner_text`,
	(`article`.`image_one`) AS `image_one`,
	(`article`.`image_two`) AS `image_two`,
	(`article`.`meta_title`) AS `meta_title`,
	(`article`.`meta_description`) AS `meta_description`,
	(`article`.`publish_date`) AS `publish_date`,
	(`article`.`guide`) AS `guide`,
	(`article`.`publish`) AS `publish`,
	(`article`.`discard`) AS `discard`,
	(`article`.`updated`) AS `updated`
FROM `article`
WHERE `article`.`discard` IS FALSE
AND `article`.`publish` IS TRUE
AND `article`.`publish_date` <= CURRENT_DATE
AND `article`.`guide` = 1
AND `article`.`id` IN (
	SELECT	`article_id`
	FROM `article_tag`
	WHERE `article_tag`.`tag_id` = '23')
ORDER BY `article`.`publish_date` DESC, `article`.`id` DESC
LIMIT 3
Command completed in 0.0018100738525391 seconds - 3 row(s) affected.
SELECT	(`article_tag`.`article_id`) AS `article_id`,
	(`article_tag`.`tag_id`) AS `tag_id`
FROM `article_tag`
WHERE `article_tag`.`article_id` IN ('3', '51', '35')
Command completed in 0.00091385841369629 seconds - 18 row(s) affected.
SELECT	(`tag`.`id`) AS `id`,
	(`tag`.`name`) AS `name`,
	(`tag`.`publish`) AS `publish`,
	(`tag`.`discard`) AS `discard`,
	(`tag`.`updated`) AS `updated`
FROM `tag`
WHERE `tag`.`discard` IS FALSE
AND `tag`.`publish` IS TRUE
AND `tag`.`id` IN ('7', '21', '23', '25', '7', '9', '11', '19', '21', '23', '25', '7', '9', '11', '19', '21', '23', '25')
ORDER BY `tag`.`name` ASC, `tag`.`id` ASC
Command completed in 0.00093698501586914 seconds - 7 row(s) affected.
SELECT	(`article`.`id`) AS `id`,
	(`article`.`name`) AS `name`,
	(`article`.`title`) AS `title`,
	(`article`.`summary`) AS `summary`,
	(`article`.`author`) AS `author`,
	(`article`.`content`) AS `content`,
	(`article`.`sidebar`) AS `sidebar`,
	(`article`.`image`) AS `image`,
	(`article`.`banner`) AS `banner`,
	(`article`.`dark_banner_text`) AS `dark_banner_text`,
	(`article`.`image_one`) AS `image_one`,
	(`article`.`image_two`) AS `image_two`,
	(`article`.`meta_title`) AS `meta_title`,
	(`article`.`meta_description`) AS `meta_description`,
	(`article`.`publish_date`) AS `publish_date`,
	(`article`.`guide`) AS `guide`,
	(`article`.`publish`) AS `publish`,
	(`article`.`discard`) AS `discard`,
	(`article`.`updated`) AS `updated`
FROM `article`
WHERE `article`.`discard` IS FALSE
AND `article`.`publish` IS TRUE
AND `article`.`publish_date` <= CURRENT_DATE
AND `article`.`guide` = 1
AND `article`.`id` IN (
	SELECT	`article_id`
	FROM `article_tag`
	WHERE `article_tag`.`tag_id` = '25')
ORDER BY `article`.`publish_date` DESC, `article`.`id` DESC
LIMIT 3
Command completed in 0.0017738342285156 seconds - 3 row(s) affected.
SELECT	(`article_tag`.`article_id`) AS `article_id`,
	(`article_tag`.`tag_id`) AS `tag_id`
FROM `article_tag`
WHERE `article_tag`.`article_id` IN ('57', '3', '51')
Command completed in 0.00067400932312012 seconds - 15 row(s) affected.
SELECT	(`tag`.`id`) AS `id`,
	(`tag`.`name`) AS `name`,
	(`tag`.`publish`) AS `publish`,
	(`tag`.`discard`) AS `discard`,
	(`tag`.`updated`) AS `updated`
FROM `tag`
WHERE `tag`.`discard` IS FALSE
AND `tag`.`publish` IS TRUE
AND `tag`.`id` IN ('7', '21', '23', '25', '7', '9', '11', '19', '21', '23', '25', '7', '9', '11', '25')
ORDER BY `tag`.`name` ASC, `tag`.`id` ASC
Command completed in 0.00065493583679199 seconds - 7 row(s) affected.
SELECT	(`article`.`id`) AS `id`,
	(`article`.`name`) AS `name`,
	(`article`.`title`) AS `title`,
	(`article`.`summary`) AS `summary`,
	(`article`.`author`) AS `author`,
	(`article`.`content`) AS `content`,
	(`article`.`sidebar`) AS `sidebar`,
	(`article`.`image`) AS `image`,
	(`article`.`banner`) AS `banner`,
	(`article`.`dark_banner_text`) AS `dark_banner_text`,
	(`article`.`image_one`) AS `image_one`,
	(`article`.`image_two`) AS `image_two`,
	(`article`.`meta_title`) AS `meta_title`,
	(`article`.`meta_description`) AS `meta_description`,
	(`article`.`publish_date`) AS `publish_date`,
	(`article`.`guide`) AS `guide`,
	(`article`.`publish`) AS `publish`,
	(`article`.`discard`) AS `discard`,
	(`article`.`updated`) AS `updated`
FROM `article`
WHERE `article`.`discard` IS FALSE
AND `article`.`publish` IS TRUE
AND `article`.`publish_date` <= CURRENT_DATE
AND `article`.`guide` = 1
AND `article`.`id` IN (
	SELECT	`article_id`
	FROM `article_tag`
	WHERE `article_tag`.`tag_id` = '21')
ORDER BY `article`.`publish_date` DESC, `article`.`id` DESC
LIMIT 3
Command completed in 0.0017440319061279 seconds - 3 row(s) affected.
SELECT	(`article_tag`.`article_id`) AS `article_id`,
	(`article_tag`.`tag_id`) AS `tag_id`
FROM `article_tag`
WHERE `article_tag`.`article_id` IN ('3', '51', '35')
Command completed in 0.00058102607727051 seconds - 18 row(s) affected.
SELECT	(`tag`.`id`) AS `id`,
	(`tag`.`name`) AS `name`,
	(`tag`.`publish`) AS `publish`,
	(`tag`.`discard`) AS `discard`,
	(`tag`.`updated`) AS `updated`
FROM `tag`
WHERE `tag`.`discard` IS FALSE
AND `tag`.`publish` IS TRUE
AND `tag`.`id` IN ('7', '21', '23', '25', '7', '9', '11', '19', '21', '23', '25', '7', '9', '11', '19', '21', '23', '25')
ORDER BY `tag`.`name` ASC, `tag`.`id` ASC
Command completed in 0.00069189071655273 seconds - 7 row(s) affected.
SELECT	(`article`.`id`) AS `id`,
	(`article`.`name`) AS `name`,
	(`article`.`title`) AS `title`,
	(`article`.`summary`) AS `summary`,
	(`article`.`author`) AS `author`,
	(`article`.`content`) AS `content`,
	(`article`.`sidebar`) AS `sidebar`,
	(`article`.`image`) AS `image`,
	(`article`.`banner`) AS `banner`,
	(`article`.`dark_banner_text`) AS `dark_banner_text`,
	(`article`.`image_one`) AS `image_one`,
	(`article`.`image_two`) AS `image_two`,
	(`article`.`meta_title`) AS `meta_title`,
	(`article`.`meta_description`) AS `meta_description`,
	(`article`.`publish_date`) AS `publish_date`,
	(`article`.`guide`) AS `guide`,
	(`article`.`publish`) AS `publish`,
	(`article`.`discard`) AS `discard`,
	(`article`.`updated`) AS `updated`
FROM `article`
WHERE `article`.`discard` IS FALSE
AND `article`.`publish` IS TRUE
AND `article`.`publish_date` <= CURRENT_DATE
AND `article`.`guide` = 1
AND `article`.`id` IN (
	SELECT	`target`
	FROM `article_article`
	WHERE `article_article`.`source` = '3')
ORDER BY `article`.`publish_date` DESC, `article`.`id` DESC
Command completed in 0.0018289089202881 seconds - 3 row(s) affected.
SELECT	(`article_tag`.`article_id`) AS `article_id`,
	(`article_tag`.`tag_id`) AS `tag_id`
FROM `article_tag`
WHERE `article_tag`.`article_id` IN ('57', '51', '1')
Command completed in 0.00075697898864746 seconds - 12 row(s) affected.
SELECT	(`tag`.`id`) AS `id`,
	(`tag`.`name`) AS `name`,
	(`tag`.`publish`) AS `publish`,
	(`tag`.`discard`) AS `discard`,
	(`tag`.`updated`) AS `updated`
FROM `tag`
WHERE `tag`.`discard` IS FALSE
AND `tag`.`publish` IS TRUE
AND `tag`.`id` IN ('5', '7', '9', '11', '19', '21', '23', '25', '7', '9', '11', '25')
ORDER BY `tag`.`name` ASC, `tag`.`id` ASC
Command completed in 0.00091218948364258 seconds - 7 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 '/guide/3-small-claims-court-overview' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.0041310787200928 seconds - 292 row(s) affected.
SELECT	(`page`.`id`) AS `id`,
	(`page`.`parent`) AS `parent`,
	(`page`.`ordinal`) AS `ordinal`,
	(`page`.`name`) AS `name`,
	(`page`.`title`) AS `title`,
	(`page`.`summary`) AS `summary`,
	(`page`.`content`) AS `content`,
	(`page`.`banner`) AS `banner`,
	(`page`.`dark_banner_text`) AS `dark_banner_text`,
	(`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`.`parent` IS NOT NULL
ORDER BY `page`.`parent` ASC, `page`.`ordinal` ASC, `page`.`name` ASC, `page`.`id` ASC
Command completed in 0.0017049312591553 seconds - 23 row(s) affected.
SELECT	(`page`.`id`) AS `id`,
	(`page`.`parent`) AS `parent`,
	(`page`.`ordinal`) AS `ordinal`,
	(`page`.`name`) AS `name`,
	(`page`.`title`) AS `title`,
	(`page`.`summary`) AS `summary`,
	(`page`.`content`) AS `content`,
	(`page`.`banner`) AS `banner`,
	(`page`.`dark_banner_text`) AS `dark_banner_text`,
	(`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
ORDER BY `page`.`parent` ASC, `page`.`ordinal` ASC, `page`.`name` ASC, `page`.`id` ASC
Command completed in 0.0014281272888184 seconds - 23 row(s) affected.