SELECT '* ' + os + CHAR(10)
FROM [release] AS r
INNER JOIN [product] AS p ON r.product_id = p.product_id
INNER JOIN [version] AS v on r.version_id = v.version_id
INNER JOIN [status] AS s on r.status_id = s.status_id
INNER JOIN [releaseOs] AS ros on r.release_id = ros.release_id
INNER JOIN [os] AS os on os.os_id = ros.os_id
WHERE product = '1E Client Deployment Assistant'
AND version = '1.5'
--AND os_type = 'Server'
AND os_vendor_supported = 'Y'ORDER BY os.os_type DESC, os.release_date DESC

SELECT '* ' + framework + CHAR(10)
FROM [release] AS r
INNER JOIN [product] AS p ON r.product_id = p.product_id
INNER JOIN [version] AS v on r.version_id = v.version_id
INNER JOIN [status] AS s on r.status_id = s.status_id
INNER JOIN [releaseFramework] AS rf on r.release_id = rf.release_id
INNER JOIN [framework] AS f on f.framework_id = rf.framework_id
WHERE product = '1E Client Deployment Assistant'
AND version = '1.5'
--AND f.framework like '%6'
AND f.vendor_supported = 'Y'
ORDER BY framework DESC

SELECT '* ' + sccm + CHAR(10)
FROM [release] AS r
INNER JOIN [product] AS p ON r.product_id = p.product_id
INNER JOIN [version] AS v on r.version_id = v.version_id
INNER JOIN [status] AS s on r.status_id = s.status_id
INNER JOIN [releaseSccm] AS rsccm on r.release_id = rsccm.release_id
INNER JOIN [sccm] AS sccm on sccm.sccm_id = rsccm.sccm_id
WHERE product = '1E Client Deployment Assistant'
AND version = '1.5'
AND sccm.sccm not like '%TP%'
AND sccm.vendor_supported = 'Y'
ORDER BY sccm DESC