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.00047016143798828 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.0063450336456299 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.0003819465637207 seconds - 42 row(s) affected.