COMMERCIAL CONTRACTS

Filter By: Professional: Sue FriedbergDavid Gurwin Type: SELECT modResource.id as id FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_site_tmplvar_contentvalues` `TV1` ON TV1.contentid=modResource.id WHERE ( ( `modResource`.`published` = 1 AND `modResource`.`template` = 29 AND `modResource`.`parent` = 178 ) AND ( `TV1`.`value` LIKE '%e6e341fd-1e01-4545-b2a7-819552de8c20%' AND `TV1`.`tmplvarid` = '96' ) ) SELECT modResource.id as id FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_site_tmplvar_contentvalues` `TV1` ON TV1.contentid=modResource.id WHERE ( ( `modResource`.`published` = 1 AND `modResource`.`template` = 29 AND `modResource`.`parent` = 173 ) AND ( `TV1`.`value` LIKE '%e6e341fd-1e01-4545-b2a7-819552de8c20%' AND `TV1`.`tmplvarid` = '96' ) ) Articles & Advisories Date Range: