/* 
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
/**
 * Author:  gal
 */

RENAME TABLE physical_address TO full_address;

 ALTER TABLE concepts_indexes DROP PRIMARY KEY, ADD PRIMARY KEY(id, concept);

INSERT INTO `concepts_indexes` (concept) VALUES('tourism_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `tourism_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='tourism_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('social_unrest_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `social_unrest_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='social_unrest_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('transportation_traffic_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `transportation_traffic_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='transportation_traffic_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('weather_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `weather_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='weather_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('social_issues_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `social_issues_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='social_issues_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('social_unrest_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `social_unrest_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='social_unrest_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('sport_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `sport_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='sport_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('technology_it_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `technology_it_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='technology_it_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('terrorism_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `terrorism_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='terrorism_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('physical_science_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `physical_science_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='physical_science_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('politics_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `politics_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='politics_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('public_safety_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `public_safety_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='public_safety_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('radical_islam_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `radical_islam_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='radical_islam_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('religion_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `religion_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='religion_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('islam_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `islam_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='islam_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('legal_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `legal_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='legal_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('mathematics_logic_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mathematics_logic_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='mathematics_logic_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('medical_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `medical_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='medical_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('military_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `military_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='military_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('entertainment_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `entertainment_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='entertainment_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('environment_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `environment_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='environment_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('explosive_ied_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `explosive_ied_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='explosive_ied_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('food_culinary_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `food_culinary_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='food_culinary_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('intelligence_security_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `intelligence_security_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='intelligence_security_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('banking_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `banking_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='banking_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('crime_police_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `crime_police_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='crime_police_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('cyber_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `cyber_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='cyber_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('economy_finance_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `economy_finance_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='economy_finance_topic')));

INSERT INTO `concepts_indexes` (concept) VALUES('energy_topic');
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `energy_topic` AS (
SELECT  `all_concepts_table`.`id` AS `id`,  `all_concepts_table`.`docId` AS `docId`,  `all_concepts_table`.`name_version` AS `name_version`,  `all_concepts_table`.`names_agg` AS `names_agg`,  `all_concepts_table`.`clean_name` AS `clean_name`,  `all_concepts_table`.`ontName` AS `ontName`,  `all_concepts_table`.`ontUrl` AS `ontUrl`,  `all_concepts_table`.`docKey` AS `docKey`,  `all_concepts_table`.`date` AS `date`,  `all_concepts_table`.`modifier` AS `modifier`,  `all_concepts_table`.`country` AS `country`,  `all_concepts_table`.`province` AS `province`,  `all_concepts_table`.`city` AS `city`,  `all_concepts_table`.`anti` AS `anti`,  `all_concepts_table`.`pro` AS `pro`,  `all_concepts_table`.`username` AS `username`,  `all_concepts_table`.`occurrences` AS `occurrences`,  `all_concepts_table`.`positive` AS `positive`,  `all_concepts_table`.`negative` AS `negative`,  `all_concepts_table`.`orgText_version` AS `orgText_version`,  `all_concepts_table`.`type` AS `type`,  `all_concepts_table`.`concept_type` AS `concept_type`,  `all_concepts_table`.`concept_type_source` AS `concept_type_source`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`,  COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE 
concept='energy_topic')));