1. Main
2. Vulnerability Database
3. Moment.js

SELECT B2S.ID, B2S.BULETIN_ID, B2S.TYPE, B2S.VENDOR_ID, B2S.SOFT_ID, B2S.VERSION_ID, B2S.VULN_ID, B2S.FIXED, B2S.PATCH, B2S.CVE ,S.NAME as SOFT_NAME, S.ALIAS as SOFT_ALIAS, S.CPE as SOFT_CPE ,V.NAME as VENDOR_NAME, V.ALIAS as VENDOR_ALIAS, V.CPE as VENDOR_CPE ,SV.VERSION as VERSION ,SV.PARENT_VERSION_ID, SV.BUILD, SV.SOURCE_VERSION, CONCAT(SV.VERSION,' ',SV.BUILD) as VERSION_BUILD ,B.CODE as BULETIN_CODE, B.TITLE AS BULETIN_TITLE, B.DATE_CREATE, B.SEVERITY ,SS.TYPE as SS_SOFT_TYPE, SS.CODE as SS_SOFT_CODE, SS.TITLE AS SS_SOFT_TITLE ,ST.TITLE AS ST_SOFT_TITLE FROM sh_db_buletin_2_soft B2S left join sh_db_soft S on S.ID = B2S.SOFT_ID left join sh_db_soft_version SV on SV.ID = B2S.VERSION_ID left join sh_db_vendor V on V.ID = S.VENDOR_ID left join sh_db_buletin B on B.ID = B2S.BULETIN_ID left join sh_db_soft_subtype SS on SS.CODE = S.TYPE left join sh_db_soft_type ST on ST.CODE = SS.TYPE WHERE (B2S.TYPE = 'B' OR B2S.TYPE = 'N') AND B2S.VENDOR_ID = '2076' group by B2S.BULETIN_ID ORDER BY B2S.BULETIN_ID DESC