'SELECT DISTINCT s.post_id, s.author_id, s.image_guid, s.image_id, s.artist_guid, s.artist_id, s.artist_slug, s.artist, s.post_title, s.pub_date, s.image_type_id as image_color_type_id, s.language_id, s.keywords, s.country, s.allowed_sites, s.file_name, s.format FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) ) OR ( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) )) ORDER BY s.pub_date DESC, s.image_id DESC LIMIT 20;'
'SELECT DISTINCT s.post_id, s.author_id, s.image_guid, s.image_id, s.artist_guid, s.artist_id, s.artist_slug, s.artist, s.post_title, s.pub_date, s.image_type_id as image_color_type_id, s.language_id, s.keywords, s.country, s.allowed_sites, s.file_name, s.format FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) ) OR ( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) )) ORDER BY s.pub_date DESC, s.image_id DESC LIMIT 20;'
'SELECT DISTINCT s.post_id, s.author_id, s.image_guid, s.image_id, s.artist_guid, s.artist_id, s.artist_slug, s.artist, s.post_title, s.pub_date, s.image_type_id as image_color_type_id, s.language_id, s.keywords, s.country, s.allowed_sites, s.file_name, s.format FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) ) OR ( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) )) ORDER BY s.pub_date DESC, s.image_id DESC LIMIT 20;'
'SELECT DISTINCT s.post_id, s.author_id, s.image_guid, s.image_id, s.artist_guid, s.artist_id, s.artist_slug, s.artist, s.post_title, s.pub_date, s.image_type_id as image_color_type_id, s.language_id, s.keywords, s.country, s.allowed_sites, s.file_name, s.format FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) ) OR ( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) )) ORDER BY s.pub_date DESC, s.image_id DESC LIMIT 20;'
'SELECT DISTINCT COUNT(*) As Records FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) ) OR ( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) ))'
'SELECT DISTINCT s.post_id, s.author_id, s.image_guid, s.image_id, s.artist_guid, s.artist_id, s.artist_slug, s.artist, s.post_title, s.pub_date, s.image_type_id as image_color_type_id, s.language_id, s.keywords, s.country, s.allowed_sites, s.file_name, s.format FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}newsroom{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) ) OR ( (s.post_title LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) OR (s.keywords LIKE \'{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\\"newsroom\\"{7c20f30be80d464fea37e6235654c52a1a96a480524fbcfb3000bb0cf1421e76}\' ) )) ORDER BY s.pub_date DESC, s.image_id DESC LIMIT 20;'
Capital Gazette, gazette, news, journalists, victims, killed, editors, newsroom, gun, shot, murdered, mass shooting, media, print, reporters
CAPITAL GAZETTE
capital gazette,annapolis maryland,journalists,newspaper,maryland newspaper, Rob Hiaasen,gerald fischman,john mcnamara,wendi winters,rebecca smith,newsroom,shootin,mass murder
CAPITAL GAZETTE
Capital Gazette, mass shooting, journalism, guns, journalists, reporters, newsroom, 2nd Amendment,
NEWSPAPER KILLER
black widow, Alden Global Capital, hedge fund, Denver Post, Boulder, Riverside, Orange County, Digital First Media, newspapers, revenue, reporters, print, newsrooms, vultures, jackals, wall street, media
