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.00040292739868164 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.0059759616851807 seconds - 624 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.00031304359436035 seconds - 42 row(s) affected.