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 = '36' ORDER BY emplawcontent.title
Real Estate & Construction Law
We have a large team of lawyers who know the ins and outs of the real estate industry and its participants. We assist in the preparation and implementation of contracts, in negotiations and in disputes in connection with construction projects and contract work.