string(2714) "SELECT `modResource`.`id`, `modResource`.`type`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, `modResource`.`alias_visible`, IFNULL(`TVimage`.`value`, '') AS `tv.image`, IFNULL(`TVannotation`.`value`, '') AS `tv.annotation`, IFNULL(`TVdate_update`.`value`, '') AS `tv.date_update`, IFNULL(`TVlinkedin`.`value`, '') AS `tv.Linkedin`, IFNULL(`TVmain_position`.`value`, '') AS `tv.Main_Position`, IFNULL(`TVposition`.`value`, '') AS `tv.Position`, IFNULL(`TVimage2x`.`value`, '') AS `tv.Image2X` FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_site_tmplvar_contentvalues` `TVimage` ON `TVimage`.`contentid` = `modResource`.`id` AND `TVimage`.`tmplvarid` = 1 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVannotation` ON `TVannotation`.`contentid` = `modResource`.`id` AND `TVannotation`.`tmplvarid` = 4 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVdate_update` ON `TVdate_update`.`contentid` = `modResource`.`id` AND `TVdate_update`.`tmplvarid` = 16 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVlinkedin` ON `TVlinkedin`.`contentid` = `modResource`.`id` AND `TVlinkedin`.`tmplvarid` = 22 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVmain_position` ON `TVmain_position`.`contentid` = `modResource`.`id` AND `TVmain_position`.`tmplvarid` = 23 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVposition` ON `TVposition`.`contentid` = `modResource`.`id` AND `TVposition`.`tmplvarid` = 25 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVimage2x` ON `TVimage2x`.`contentid` = `modResource`.`id` AND `TVimage2x`.`tmplvarid` = 29 WHERE ( `modResource`.`parent` IN (293) AND `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 ) ORDER BY modResource.menuindex ASC LIMIT 100 "
Founder
Lawyer and Legal Consultant
Partner
Lawyer and Legal Consultant
Partner
Lawyer, Family Law Mediator
Legal assistant
Legal administrative assistant
Legal consultant
Trainee lawyer