Join us

Join us

Help us spread the word.
Become a partner for free!

Barristers

Get started now.
It's fast, easy and completely free of charge.

Create a free barrister profile

View and manage cases

Want more info? View our FAQs

Register
Marketing partners

Would you like to benefit and become
a marketing partner for free?

Signpost clients to us

View statistics in real time

No set up cost!

 
More info

By registering, you agree to our terms and conditions and privacy policy.

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.0011098384857178 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 '/57-join-us' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.010165929794312 seconds - 623 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.0008540153503418 seconds - 42 row(s) affected.