theQuery571 => select * from ( select piddl_content.*, piddl_contentgroups.piddlcontentgroup_id, piddl_contentgroups.piddlcontentgroup_publication, piddl_contentgroups.piddlcontentgroup_name, piddl_contentgroups.piddlcontentgroup_maxcontentcount, doc_id, doc_headline, doc_byline, doc_location, doc_pool, doc_published, doc_modified, doc_expires, doc_url, doc_section, doc_sort, doc_summary_short, doc_summary_med, doc_summary_long, doc_address, doc_image, doc_text, section_id, section_publication, section_type, section_url, section_name, section_site, section_language, doc_editor_name, webinar_master.*, case when piddlcontent_type = 'document' and section_type in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show') then doc_modified when piddlcontent_type = 'document' and (section_type is null or section_type not in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show')) then doc_published when piddlcontent_type = 'webinar' then webinar_date_begin else piddlcontent_createDate end as piddlcontent_pubdate, sub_listpublications.listpub_list from informationweek.dbo.piddl_content piddl_content left join informationweek.dbo.piddl_contentgroups piddl_contentgroups on piddlcontent_contentgroupid = piddlcontentgroup_id left join informationweek.dbo.msg_messages msg_messages on piddlcontent_keyid = msg_id and piddlcontent_type = 'message' left join informationweek.dbo.msg_threads msg_threads on msg_thread = thread_id left join doc_documents with (nolock, index(IX_doc_documents_3)) on piddlcontent_keyid = doc_id and piddlcontent_type = 'document' left join doc_sections on doc_section = section_id left join lightreading.doc_editors doc_editors on doc_documents.doc_author = doc_editors.doc_editor left join informationweek.lightreading.webinar_master webinar_master on piddlcontent_keyid = webinar_id and piddlcontent_type = 'webinar' left join informationweek.lightreading.sub_listpublications sub_listpublications on piddlcontent_keyid = listpub_id and piddlcontent_type = 'mailinglist' where piddlcontent_publication in ('darkreading') and 1=1 and piddlcontent_isActive = 1 and (piddlcontent_type <> 'document' or (piddlcontent_type = 'document' and doc_id <> '' and doc_id is not null and section_id <> '' and section_id is not null and section_visible = 1 and doc_pool in ('Public') and doc_published is not null and doc_published <= getdate() and section_language is null )) and 1=1 and piddlcontent_type in ('document') and doc_section in (609) and year(case when piddlcontent_type = 'document' and section_type in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show') then doc_modified when piddlcontent_type = 'document' and (section_type is null or section_type not in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show')) then doc_published else piddlcontent_createDate end) = 2018 and month(case when piddlcontent_type = 'document' and section_type in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show') then doc_modified when piddlcontent_type = 'document' and (section_type is null or section_type not in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show')) then doc_published else piddlcontent_createDate end) = 12 ) as this_recordset order by piddlcontent_pubdate desc Slideshows-Security Now - Content posted in ...

Dark Reading is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Slideshows-Security Now

Content posted in December 2018
Top 10 Security Stories of 2018
Slideshows-Security Now  |  12/24/2018  | 
With 2018 drawing to a close, Security Now looks back at the last 12 months to find which stories made the biggest impression on our readers and why these topics remain important even after the stories have faded from the headlines.


COVID-19: Latest Security News & Commentary
Dark Reading Staff 7/1/2020
Ripple20 Threatens Increasingly Connected Medical Devices
Kelly Sheridan, Staff Editor, Dark Reading,  6/30/2020
DDoS Attacks Jump 542% from Q4 2019 to Q1 2020
Dark Reading Staff 6/30/2020
Register for Dark Reading Newsletters
White Papers
Video
Cartoon
Current Issue
The Threat from the Internet--and What Your Organization Can Do About It
This report describes some of the latest attacks and threats emanating from the Internet, as well as advice and tips on how your organization can mitigate those threats before they affect your business. Download it today!
Flash Poll
Twitter Feed
Dark Reading - Bug Report
Bug Report
Enterprise Vulnerabilities
From DHS/US-CERT's National Vulnerability Database
CVE-2020-15478
PUBLISHED: 2020-07-01
The Journal theme before 3.1.0 for OpenCart allows exposure of sensitive data via SQL errors.
CVE-2020-6261
PUBLISHED: 2020-07-01
SAP Solution Manager (Trace Analysis), version 7.20, allows an attacker to perform a log injection into the trace file, due to Incomplete XML Validation. The readability of the trace file is impaired.
CVE-2020-15471
PUBLISHED: 2020-07-01
In nDPI through 3.2, the packet parsing code is vulnerable to a heap-based buffer over-read in ndpi_parse_packet_line_info in lib/ndpi_main.c.
CVE-2020-15472
PUBLISHED: 2020-07-01
In nDPI through 3.2, the H.323 dissector is vulnerable to a heap-based buffer over-read in ndpi_search_h323 in lib/protocols/h323.c, as demonstrated by a payload packet length that is too short.
CVE-2020-15473
PUBLISHED: 2020-07-01
In nDPI through 3.2, the OpenVPN dissector is vulnerable to a heap-based buffer over-read in ndpi_search_openvpn in lib/protocols/openvpn.c.