last query = SELECT * FROM emplaw
LEFT OUTER JOIN emplawcontent ON emplawcontent.emplawID = emplaw.id AND emplawcontent.languageID = 'en'
JOIN pageID ON pageID.contentID = emplaw.id AND pageID.contentTable = 'emplaw'
JOIN pageIDcontent ON pageIDcontent.pageIDID = pageID.id AND pageIDcontent.languageID = 'en'
WHERE pageID.menulevelID = '37' ORDER BY emplawcontent.title
Private Client Law
Our lawyers have extensive experience in advising private individuals during different phases of life, for better and for worse. We help you plan for both the present and the future, to help you avoid conflicts and unpleasant surprises.