Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
SELECT p.PRODUCT_ID, PUB_DATE_WN = ISNULL(upd.PUB_DATE, ''), STD_ABBV_CODE = ISNULL(upd.STD_ABBV_CODE, ''), TITLE = ISNULL(p.LONG_NAME, ''), PUB_YEAR_INV = ISNULL(f.USR_PUB_YEAR, ''), PUBLISHER_WN = ISNULL(upd.PUBLISHER, ''), TEXT = ISNULL(t.TEXT, ''), MEETING_LOCATION = ISNULL(mpl.LOCATION, ''), PRODUCT_URL = ISNULL(pwc.PRODUCT_URL, '') FROM dbo.WEB_PRODUCT_VW p LEFT OUTER JOIN dbo.PRODUCT_TEXT t ON t.PRODUCT_ID = p.PRODUCT_ID and t.TEXT_TYPE_CODE = 'WEB_LONG' LEFT OUTER JOIN dbo.USR_PRODUCT_FACTS f ON f.PRODUCT_ID = p.PRODUCT_ID LEFT OUTER JOIN dbo.INV_PRODUCT i ON i.PRODUCT_ID = p.PRODUCT_ID LEFT OUTER JOIN dbo.USR_PRODUCT_DETAIL upd ON upd.PRODUCT_ID = p.PRODUCT_ID LEFT OUTER JOIN dbo.MTG_PRODUCT_LOCATION mpl ON mpl.PRODUCT_ID = p.PRODUCT_ID LEFT OUTER JOIN dbo.PRODUCT_WEB_CONTROL pwc ON pwc.PRODUCT_ID = p.PRODUCT_ID WHERE (p.SUBSYSTEM = 'INV' OR p.SUBSYSTEM = 'ECD' OR p.SUBSYSTEM = 'MTG' OR p.SUBSYSTEM = 'MBR') AND ((p.PRODUCT_CODE = p.PARENT_PRODUCT) OR (p.PRODUCT_ID = '30' OR p.PRODUCT_ID = '82' OR p.PRODUCT_ID = '264')) AND p.AVAILABLE_TO_ORDERS_FLAG = 'Y' AND p.END_DATE >= CURRENT_TIMESTAMP
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!