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.00059008598327637 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.0041549205780029 seconds - 607 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.00076389312744141 seconds - 42 row(s) affected.