
--
-- Table structure for table `table001`
--

--
-- Table structure for table `table011`
--

CREATE TABLE `table011` (
  `column91` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column218` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column188` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`column91`,`column218`),
  KEY `column218` (`column218`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `table011`
--


CREATE TABLE `table001` (
  `column221` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column93` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `column98` datetime DEFAULT NULL,
  `column102` varchar(256) NOT NULL DEFAULT 'publish',
  `column122` varchar(256) NOT NULL DEFAULT '',
  `column97` varchar(50) DEFAULT NULL,
  `column92` varchar(10) DEFAULT NULL,
  `column128` varchar(10) DEFAULT NULL,
  `column99` varchar(50) DEFAULT NULL,
  `column100` decimal(10,2) DEFAULT NULL,
  `column51` decimal(10,2) DEFAULT NULL,
  `column50` decimal(10,2) DEFAULT NULL,
  `column42` decimal(10,2) DEFAULT NULL,
  `column32` varchar(10) DEFAULT NULL,
  `column17` decimal(10,2) DEFAULT NULL,
  `column94` decimal(10,2) DEFAULT NULL,
  `column105` decimal(10,2) DEFAULT NULL,
  `column111` varchar(50) DEFAULT NULL,
  `column112` varchar(50) DEFAULT NULL,
  `column30` varchar(50) DEFAULT NULL,
  `column12` varchar(50) DEFAULT NULL,
  `column13` varchar(50) DEFAULT NULL,
  `column9` varchar(50) DEFAULT NULL,
  `column5` varchar(100) DEFAULT NULL,
  `column6` varchar(100) DEFAULT NULL,
  `column8` varchar(100) DEFAULT NULL,
  `column16` varchar(100) DEFAULT NULL,
  `column15` varchar(50) DEFAULT NULL,
  `column10` varchar(50) DEFAULT NULL,
  `column11` varchar(50) DEFAULT NULL,
  `column14` varchar(256) DEFAULT NULL,
  `column156` varchar(50) DEFAULT NULL,
  `column157` varchar(50) DEFAULT NULL,
  `column154` varchar(50) DEFAULT NULL,
  `column150` varchar(100) DEFAULT NULL,
  `column151` varchar(100) DEFAULT NULL,
  `column153` varchar(100) DEFAULT NULL,
  `column161` varchar(100) DEFAULT NULL,
  `column160` varchar(50) DEFAULT NULL,
  `column155` varchar(50) DEFAULT NULL,
  `column158` varchar(50) DEFAULT NULL,
  `column159` varchar(50) DEFAULT NULL,
  `column46` varchar(10) DEFAULT NULL,
  `column45` varchar(10) DEFAULT NULL,
  `column104` decimal(10,2) DEFAULT NULL,
  `column101` decimal(10,2) DEFAULT NULL,
  `column141` varchar(10) DEFAULT NULL,
  `column29` varchar(256) DEFAULT NULL,
  `column18` decimal(10,2) DEFAULT NULL,
  `column106` varchar(10) DEFAULT NULL,
  `column7` varchar(256) DEFAULT NULL,
  `column152` varchar(256) DEFAULT NULL,
  `column48` varchar(50) DEFAULT NULL,
  `column34` varchar(50) DEFAULT NULL,
  `column36` varchar(50) DEFAULT NULL,
  `column109` datetime DEFAULT NULL,
  `column24` datetime DEFAULT NULL,
  `column140` varchar(10) DEFAULT NULL,
  `column103` varchar(10) DEFAULT NULL,
  `column31` varchar(50) DEFAULT NULL,
  `column33` varchar(150) DEFAULT NULL,
  `column19` varchar(150) DEFAULT NULL,
  `column59` varchar(10) DEFAULT NULL,
  `column230` varchar(100) NOT NULL,
  `column96` varchar(50) NOT NULL DEFAULT '',
  `column229` int(20) unsigned NOT NULL,
  `column132` int(10) DEFAULT NULL,
  `column194` int(10) DEFAULT NULL,
  `column138` decimal(10,2) DEFAULT NULL,
  `column182` varchar(30) DEFAULT NULL,
  `column65` decimal(10,2) DEFAULT NULL,
  `column66` decimal(10,2) DEFAULT NULL,
  `column69` decimal(10,2) DEFAULT NULL,
  `column67` decimal(10,2) DEFAULT NULL,
  `column68` longtext DEFAULT NULL,
  `column84` varchar(30) DEFAULT NULL,
  `column56` varchar(256) DEFAULT NULL,
  `column27` decimal(10,2) DEFAULT NULL,
  `column191` decimal(10,2) DEFAULT NULL,
  `column184` decimal(10,2) DEFAULT NULL,
  `column0` varchar(256) DEFAULT NULL,
  `column139` varchar(256) DEFAULT NULL,
  `column60` varchar(256) DEFAULT NULL,
  `column25` varchar(256) DEFAULT NULL,
  `column181` decimal(10,2) DEFAULT NULL,
  `column162` decimal(10,2) DEFAULT NULL,
  `column41` decimal(10,2) DEFAULT NULL,
  `column131` datetime DEFAULT NULL,
  `column133` varchar(256) DEFAULT NULL,
  `column135` varchar(30) DEFAULT NULL,
  `column137` varchar(30) DEFAULT NULL,
  `column130` varchar(50) DEFAULT NULL,
  `column134` varchar(50) DEFAULT NULL,
  `column107` varchar(256) DEFAULT NULL,
  `column108` varchar(256) DEFAULT NULL,
  `column164` varchar(256) DEFAULT NULL,
  `column190` decimal(10,2) DEFAULT NULL,
  `column183` varchar(10) DEFAULT NULL,
  `column75` varchar(10) DEFAULT NULL,
  `column3` varchar(10) DEFAULT NULL,
  `column166` varchar(10) DEFAULT NULL,
  `column47` varchar(10) DEFAULT NULL,
  `column44` int(10) DEFAULT NULL,
  `column43` int(10) DEFAULT NULL,
  `column167` decimal(10,2) DEFAULT NULL,
  `column168` varchar(10) DEFAULT NULL,
  `column195` decimal(10,2) DEFAULT NULL,
  `column210` int(10) DEFAULT NULL,
  `column136` varchar(10) DEFAULT NULL,
  `column127` decimal(10,2) DEFAULT NULL,
  `column213` varchar(10) DEFAULT NULL,
  `column64` decimal(10,2) DEFAULT NULL,
  `column212` decimal(10,2) DEFAULT NULL,
  `column54` decimal(10,2) DEFAULT NULL,
  `column143` decimal(10,2) DEFAULT NULL,
  `column144` decimal(10,2) DEFAULT NULL,
  `column199` decimal(10,2) DEFAULT NULL,
  `column200` decimal(10,2) DEFAULT NULL,
  `column57` varchar(256) DEFAULT NULL,
  `column38` decimal(10,2) DEFAULT NULL,
  `column40` decimal(10,2) DEFAULT NULL,
  `column39` decimal(10,2) DEFAULT NULL,
  `column37` decimal(10,2) DEFAULT NULL,
  `column211` decimal(10,2) DEFAULT NULL,
  `column87` decimal(10,2) DEFAULT NULL,
  `column78` decimal(10,2) DEFAULT NULL,
  `column88` decimal(10,2) DEFAULT NULL,
  `column79` decimal(10,2) DEFAULT NULL,
  `column89` decimal(10,2) DEFAULT NULL,
  `column80` decimal(10,2) DEFAULT NULL,
  `column85` decimal(10,2) DEFAULT NULL,
  `column76` decimal(10,2) DEFAULT NULL,
  `column86` decimal(10,2) DEFAULT NULL,
  `column77` decimal(10,2) DEFAULT NULL,
  `column175` decimal(10,2) DEFAULT NULL,
  `column173` decimal(10,2) DEFAULT NULL,
  `column174` decimal(10,2) DEFAULT NULL,
  `column176` decimal(10,2) DEFAULT NULL,
  `column178` decimal(10,2) DEFAULT NULL,
  `column177` decimal(10,2) DEFAULT NULL,
  `column169` decimal(10,2) DEFAULT NULL,
  `column170` decimal(10,2) DEFAULT NULL,
  `column197` decimal(10,2) DEFAULT NULL,
  `column196` decimal(10,2) DEFAULT NULL,
  `column202` decimal(10,2) DEFAULT NULL,
  `column201` decimal(10,2) DEFAULT NULL,
  `column198` decimal(10,2) DEFAULT NULL,
  `column171` decimal(10,2) DEFAULT NULL,
  `column205` varchar(256) DEFAULT NULL,
  `column209` varchar(256) DEFAULT NULL,
  `column204` decimal(10,2) DEFAULT NULL,
  `column207` varchar(256) DEFAULT NULL,
  `column208` varchar(256) DEFAULT NULL,
  `column206` varchar(256) DEFAULT NULL,
  `column172` varchar(256) DEFAULT NULL,
  `column145` varchar(256) DEFAULT NULL,
  `column146` varchar(256) DEFAULT NULL,
  UNIQUE KEY `idx_table001_order_id_order_item_id` (`column221`,`column229`),
  KEY `idx_table001_order_modified_date` (`column98`),
  KEY `idx_table001_order_date_order_status` (`column93`,`column102`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `table001`
--

--
-- Temporary table structure for view `view001`
--

/*!50001 DROP VIEW IF EXISTS `view001`*/;
/*!50001 CREATE VIEW `view001` AS SELECT
 1 AS `column221`,
  1 AS `column93`,
  1 AS `column98`,
  1 AS `column102`,
  1 AS `column122`,
  1 AS `column97`,
  1 AS `column92`,
  1 AS `column128`,
  1 AS `column99`,
  1 AS `column100`,
  1 AS `column51`,
  1 AS `column50`,
  1 AS `column42`,
  1 AS `column32`,
  1 AS `column17`,
  1 AS `column94`,
  1 AS `column105`,
  1 AS `column111`,
  1 AS `column112`,
  1 AS `column30`,
  1 AS `column12`,
  1 AS `column13`,
  1 AS `column9`,
  1 AS `column5`,
  1 AS `column6`,
  1 AS `column8`,
  1 AS `column16`,
  1 AS `column15`,
  1 AS `column10`,
  1 AS `column11`,
  1 AS `column14`,
  1 AS `column156`,
  1 AS `column157`,
  1 AS `column154`,
  1 AS `column150`,
  1 AS `column151`,
  1 AS `column153`,
  1 AS `column161`,
  1 AS `column160`,
  1 AS `column155`,
  1 AS `column158`,
  1 AS `column159`,
  1 AS `column46`,
  1 AS `column45`,
  1 AS `column104`,
  1 AS `column101`,
  1 AS `column141`,
  1 AS `column29`,
  1 AS `column18`,
  1 AS `column106`,
  1 AS `column7`,
  1 AS `column152`,
  1 AS `column48`,
  1 AS `column34`,
  1 AS `column36`,
  1 AS `column109`,
  1 AS `column24`,
  1 AS `column140`,
  1 AS `column103`,
  1 AS `column31`,
  1 AS `column33`,
  1 AS `column19`,
  1 AS `column59`,
  1 AS `column230`,
  1 AS `column96`,
  1 AS `column229`,
  1 AS `column132`,
  1 AS `column194`,
  1 AS `column138`,
  1 AS `column182`,
  1 AS `column65`,
  1 AS `column66`,
  1 AS `column69`,
  1 AS `column67`,
  1 AS `column68`,
  1 AS `column84`,
  1 AS `column56`,
  1 AS `column27`,
  1 AS `column191`,
  1 AS `column184`,
  1 AS `column0`,
  1 AS `column139`,
  1 AS `column60`,
  1 AS `column25`,
  1 AS `column181`,
  1 AS `column162`,
  1 AS `column41`,
  1 AS `column199`,
  1 AS `column200`,
  1 AS `column57`,
  1 AS `column38`,
  1 AS `column39`,
  1 AS `column37`,
  1 AS `column40`,
  1 AS `column131`,
  1 AS `column133`,
  1 AS `column135`,
  1 AS `column137`,
  1 AS `column130`,
  1 AS `column134`,
  1 AS `column107`,
  1 AS `column108`,
  1 AS `column164`,
  1 AS `column190`,
  1 AS `column183`,
  1 AS `column75`,
  1 AS `column3`,
  1 AS `column166`,
  1 AS `afield22`,
  1 AS `column47`,
  1 AS `column44`,
  1 AS `column43`,
  1 AS `column167`,
  1 AS `column168`,
  1 AS `column195`,
  1 AS `column210`,
  1 AS `column136`,
  1 AS `column127`,
  1 AS `column213`,
  1 AS `column64`,
  1 AS `column212`,
  1 AS `column54`,
  1 AS `afield11`,
  1 AS `afield18`,
  1 AS `afield10`,
  1 AS `column143`,
  1 AS `column144`,
  1 AS `afield0`,
  1 AS `afield13`,
  1 AS `column211`,
  1 AS `column87`,
  1 AS `column78`,
  1 AS `column88`,
  1 AS `column79`,
  1 AS `column89`,
  1 AS `column80`,
  1 AS `column85`,
  1 AS `column76`,
  1 AS `column86`,
  1 AS `column77`,
  1 AS `column175`,
  1 AS `column173`,
  1 AS `column174`,
  1 AS `column176`,
  1 AS `column178`,
  1 AS `column177`,
  1 AS `column169`,
  1 AS `column170`,
  1 AS `column197`,
  1 AS `column196`,
  1 AS `column202`,
  1 AS `column201`,
  1 AS `column198`,
  1 AS `column171`,
  1 AS `column205`,
  1 AS `column209`,
  1 AS `column204`,
  1 AS `column207`,
  1 AS `column208`,
  1 AS `column206`,
  1 AS `column172`,
  1 AS `column145`,
  1 AS `column146` */;

--
-- Table structure for table `table002`
--

CREATE TABLE `table002` (
  `column73` varchar(20) DEFAULT NULL,
  `column72` varchar(20) DEFAULT NULL,
  `column74` varchar(150) DEFAULT NULL,
  UNIQUE KEY `idx_table002` (`column73`,`column72`,`column74`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Temporary table structure for view `view002`
--

/*!50001 DROP VIEW IF EXISTS `view002`*/;
/*!50001 CREATE VIEW `view002` AS SELECT
 1 AS `column221`,
  1 AS `column93`,
  1 AS `column102`,
  1 AS `column122`,
  1 AS `column97`,
  1 AS `column92`,
  1 AS `column128`,
  1 AS `column99`,
  1 AS `column100`,
  1 AS `column51`,
  1 AS `column50`,
  1 AS `column42`,
  1 AS `column32`,
  1 AS `column17`,
  1 AS `column94`,
  1 AS `column105`,
  1 AS `column111`,
  1 AS `column112`,
  1 AS `column30`,
  1 AS `column12`,
  1 AS `column13`,
  1 AS `column9`,
  1 AS `column5`,
  1 AS `column6`,
  1 AS `column8`,
  1 AS `column16`,
  1 AS `column15`,
  1 AS `column10`,
  1 AS `column11`,
  1 AS `column14`,
  1 AS `column156`,
  1 AS `column157`,
  1 AS `column154`,
  1 AS `column150`,
  1 AS `column151`,
  1 AS `column153`,
  1 AS `column161`,
  1 AS `column160`,
  1 AS `column155`,
  1 AS `column158`,
  1 AS `column159`,
  1 AS `column46`,
  1 AS `column45`,
  1 AS `column104`,
  1 AS `column101`,
  1 AS `column141`,
  1 AS `column29`,
  1 AS `column18`,
  1 AS `column106`,
  1 AS `column7`,
  1 AS `column152`,
  1 AS `column48`,
  1 AS `column34`,
  1 AS `column36`,
  1 AS `column109`,
  1 AS `column24`,
  1 AS `column140`,
  1 AS `column103`,
  1 AS `column31`,
  1 AS `column33`,
  1 AS `column19`,
  1 AS `column59` */;

--
-- Temporary table structure for view `view003`
--

/*!50001 DROP VIEW IF EXISTS `view003`*/;
/*!50001 CREATE VIEW `view003` AS SELECT
 1 AS `column230`,
  1 AS `column96`,
  1 AS `column221`,
  1 AS `column229`,
  1 AS `column132`,
  1 AS `column194`,
  1 AS `column138`,
  1 AS `column182`,
  1 AS `column65`,
  1 AS `column66`,
  1 AS `column69`,
  1 AS `column67`,
  1 AS `column68`,
  1 AS `column84`,
  1 AS `column56`,
  1 AS `column27`,
  1 AS `column191`,
  1 AS `column184`,
  1 AS `column0`,
  1 AS `column139`,
  1 AS `column60`,
  1 AS `column25`,
  1 AS `column181`,
  1 AS `column162`,
  1 AS `column41`,
  1 AS `column199`,
  1 AS `column200`,
  1 AS `column57`,
  1 AS `column38`,
  1 AS `column39`,
  1 AS `column37`,
  1 AS `column40` */;

--
-- Table structure for table `table003`
--

CREATE TABLE `table003` (
  `column221` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column93` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `column102` varchar(20) NOT NULL DEFAULT 'publish',
  `column122` varchar(200) NOT NULL DEFAULT '',
  `column98` datetime DEFAULT NULL,
  `column97` varchar(50) DEFAULT NULL,
  `column92` varchar(10) DEFAULT NULL,
  `column128` varchar(10) DEFAULT NULL,
  `column99` varchar(50) DEFAULT NULL,
  `column100` decimal(10,2) DEFAULT NULL,
  `column51` decimal(10,2) DEFAULT NULL,
  `column50` decimal(10,2) DEFAULT NULL,
  `column42` decimal(10,2) DEFAULT NULL,
  `column32` varchar(10) DEFAULT NULL,
  `column17` decimal(10,2) DEFAULT NULL,
  `column94` decimal(10,2) DEFAULT NULL,
  `column105` decimal(10,2) DEFAULT NULL,
  `column111` varchar(50) DEFAULT NULL,
  `column112` varchar(50) DEFAULT NULL,
  `column30` varchar(50) DEFAULT NULL,
  `column12` varchar(50) DEFAULT NULL,
  `column13` varchar(50) DEFAULT NULL,
  `column9` varchar(50) DEFAULT NULL,
  `column5` varchar(100) DEFAULT NULL,
  `column6` varchar(100) DEFAULT NULL,
  `column8` varchar(100) DEFAULT NULL,
  `column16` varchar(100) DEFAULT NULL,
  `column15` varchar(50) DEFAULT NULL,
  `column10` varchar(50) DEFAULT NULL,
  `column11` varchar(50) DEFAULT NULL,
  `column14` varchar(20) DEFAULT NULL,
  `column156` varchar(50) DEFAULT NULL,
  `column157` varchar(50) DEFAULT NULL,
  `column154` varchar(50) DEFAULT NULL,
  `column150` varchar(100) DEFAULT NULL,
  `column151` varchar(100) DEFAULT NULL,
  `column153` varchar(100) DEFAULT NULL,
  `column161` varchar(100) DEFAULT NULL,
  `column160` varchar(50) DEFAULT NULL,
  `column155` varchar(50) DEFAULT NULL,
  `column158` varchar(50) DEFAULT NULL,
  `column159` varchar(50) DEFAULT NULL,
  `column46` varchar(10) DEFAULT NULL,
  `column45` varchar(10) DEFAULT NULL,
  `column104` decimal(10,2) DEFAULT NULL,
  `column101` decimal(10,2) DEFAULT NULL,
  `column141` varchar(10) DEFAULT NULL,
  `column29` varchar(20) DEFAULT NULL,
  `column18` decimal(10,2) DEFAULT NULL,
  `column106` varchar(10) DEFAULT NULL,
  `column7` varchar(200) DEFAULT NULL,
  `column152` varchar(200) DEFAULT NULL,
  `column48` varchar(50) DEFAULT NULL,
  `column34` varchar(50) DEFAULT NULL,
  `column36` varchar(50) DEFAULT NULL,
  `column109` datetime DEFAULT NULL,
  `column24` datetime DEFAULT NULL,
  `column140` varchar(10) DEFAULT NULL,
  `column103` varchar(10) DEFAULT NULL,
  `column31` varchar(50) DEFAULT NULL,
  `column33` varchar(150) DEFAULT NULL,
  `column19` varchar(150) DEFAULT NULL,
  `column59` varchar(10) DEFAULT NULL,
  `column203` decimal(10,2) DEFAULT NULL,
  `column58` varchar(20) DEFAULT NULL,
  UNIQUE KEY `idx_table003_order_id` (`column221`),
  KEY `idx_table003_order_date` (`column93`),
  KEY `idx_table003_order_status` (`column102`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `table003`
--


--
-- Temporary table structure for view `view004`
--

/*!50001 DROP VIEW IF EXISTS `view004`*/;
/*!50001 CREATE VIEW `view004` AS SELECT
 1 AS `column221`,
  1 AS `column93`,
  1 AS `column102`,
  1 AS `column122`,
  1 AS `column98`,
  1 AS `column97`,
  1 AS `column92`,
  1 AS `column128`,
  1 AS `column99`,
  1 AS `column100`,
  1 AS `column51`,
  1 AS `column50`,
  1 AS `column42`,
  1 AS `column32`,
  1 AS `column17`,
  1 AS `column94`,
  1 AS `column105`,
  1 AS `column111`,
  1 AS `column112`,
  1 AS `column30`,
  1 AS `column12`,
  1 AS `column13`,
  1 AS `column9`,
  1 AS `column5`,
  1 AS `column6`,
  1 AS `column8`,
  1 AS `column16`,
  1 AS `column15`,
  1 AS `column10`,
  1 AS `column11`,
  1 AS `column14`,
  1 AS `column156`,
  1 AS `column157`,
  1 AS `column154`,
  1 AS `column150`,
  1 AS `column151`,
  1 AS `column153`,
  1 AS `column161`,
  1 AS `column160`,
  1 AS `column155`,
  1 AS `column158`,
  1 AS `column159`,
  1 AS `column46`,
  1 AS `column45`,
  1 AS `column104`,
  1 AS `column101`,
  1 AS `column141`,
  1 AS `column29`,
  1 AS `column18`,
  1 AS `column106`,
  1 AS `column7`,
  1 AS `column152`,
  1 AS `column48`,
  1 AS `column34`,
  1 AS `column36`,
  1 AS `column109`,
  1 AS `column24`,
  1 AS `column140`,
  1 AS `column103`,
  1 AS `column31`,
  1 AS `column33`,
  1 AS `column19`,
  1 AS `column59`,
  1 AS `column203`,
  1 AS `column58` */;

--
-- Temporary table structure for view `view005`
--

/*!50001 DROP VIEW IF EXISTS `view005`*/;
/*!50001 CREATE VIEW `view005` AS SELECT
 1 AS `afield9` */;

--
-- Temporary table structure for view `view006`
--

/*!50001 DROP VIEW IF EXISTS `view006`*/;
/*!50001 CREATE VIEW `view006` AS SELECT
 1 AS `column132`,
  1 AS `column131`,
  1 AS `column133`,
  1 AS `afield12`,
  1 AS `field30`,
  1 AS `column190`,
  1 AS `field45`,
  1 AS `field44`,
  1 AS `field10`,
  1 AS `field0`,
  1 AS `field31`,
  1 AS `field47`,
  1 AS `field5`,
  1 AS `field4`,
  1 AS `field3`,
  1 AS `field32`,
  1 AS `field33`,
  1 AS `field48`,
  1 AS `field60`,
  1 AS `field25`,
  1 AS `field21`,
  1 AS `field64`,
  1 AS `field63`,
  1 AS `field9`,
  1 AS `field62`,
  1 AS `field8`,
  1 AS `field23`,
  1 AS `field46`,
  1 AS `field22`,
  1 AS `field26`,
  1 AS `field27`,
  1 AS `field6`,
  1 AS `field7`,
  1 AS `field2`,
  1 AS `field24`,
  1 AS `field1` */;

--
-- Temporary table structure for view `view007`
--

/*!50001 DROP VIEW IF EXISTS `view007`*/;
/*!50001 CREATE VIEW `view007` AS SELECT
 1 AS `column132`,
  1 AS `column131`,
  1 AS `column133`,
  1 AS `afield12`,
  1 AS `column135`,
  1 AS `column137`,
  1 AS `column130`,
  1 AS `column134`,
  1 AS `column107`,
  1 AS `column108` */;

--
-- Temporary table structure for view `view008`
--

/*!50001 DROP VIEW IF EXISTS `view008`*/;
/*!50001 CREATE VIEW `view008` AS SELECT
 1 AS `column132`,
  1 AS `column131`,
  1 AS `column133`,
  1 AS `afield12`,
  1 AS `column218`,
  1 AS `column185`,
  1 AS `afield8`,
  1 AS `column217`,
  1 AS `afield16`,
  1 AS `column216`,
  1 AS `column186`,
  1 AS `column188` */;

--
-- Temporary table structure for view `view009`
--

/*!50001 DROP VIEW IF EXISTS `view009`*/;
/*!50001 CREATE VIEW `view009` AS SELECT
 1 AS `column132`,
  1 AS `column131`,
  1 AS `column133`,
  1 AS `afield12`,
  1 AS `column135`,
  1 AS `column137`,
  1 AS `column130`,
  1 AS `column134`,
  1 AS `column107`,
  1 AS `column108`,
  1 AS `field30`,
  1 AS `column190`,
  1 AS `field45`,
  1 AS `field44`,
  1 AS `field10`,
  1 AS `field0`,
  1 AS `field31`,
  1 AS `field47`,
  1 AS `field5`,
  1 AS `field4`,
  1 AS `field3`,
  1 AS `field32`,
  1 AS `field33`,
  1 AS `field48`,
  1 AS `field60`,
  1 AS `field25`,
  1 AS `field21`,
  1 AS `field64`,
  1 AS `field63`,
  1 AS `field9`,
  1 AS `field62`,
  1 AS `field8`,
  1 AS `field23`,
  1 AS `field46`,
  1 AS `field22`,
  1 AS `field26`,
  1 AS `field27`,
  1 AS `field6`,
  1 AS `field7`,
  1 AS `field2`,
  1 AS `field24`,
  1 AS `field1`,
  1 AS `field61`,
  1 AS `field18`,
  1 AS `field13`,
  1 AS `field19`,
  1 AS `field14`,
  1 AS `field20`,
  1 AS `field15`,
  1 AS `field16`,
  1 AS `field11`,
  1 AS `field17`,
  1 AS `field12`,
  1 AS `field40`,
  1 AS `field38`,
  1 AS `field39`,
  1 AS `field41`,
  1 AS `field43`,
  1 AS `field42`,
  1 AS `field34`,
  1 AS `field35`,
  1 AS `field50`,
  1 AS `field49`,
  1 AS `field53`,
  1 AS `field52`,
  1 AS `field51`,
  1 AS `field36`,
  1 AS `field55`,
  1 AS `field59`,
  1 AS `field54`,
  1 AS `field57`,
  1 AS `field58`,
  1 AS `field56`,
  1 AS `field37`,
  1 AS `field28`,
  1 AS `field29` */;

--
-- Table structure for table `table004`
--

CREATE TABLE `table004` (
  `column215` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column223` varchar(191) NOT NULL,
  `column238` varchar(20) NOT NULL,
  `column148` datetime DEFAULT '0000-00-00 00:00:00',
  `column149` datetime DEFAULT '0000-00-00 00:00:00',
  `column1` varchar(191) DEFAULT NULL,
  `column147` longtext DEFAULT NULL,
  `column220` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column2` int(11) NOT NULL DEFAULT 0,
  `column62` datetime DEFAULT '0000-00-00 00:00:00',
  `column63` datetime DEFAULT '0000-00-00 00:00:00',
  `column219` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column49` varchar(8000) DEFAULT NULL,
  `column129` tinyint(3) unsigned NOT NULL DEFAULT 10,
  PRIMARY KEY (`column215`),
  KEY `column223` (`column223`),
  KEY `column238` (`column238`),
  KEY `column148` (`column148`),
  KEY `column1` (`column1`),
  KEY `column220` (`column220`),
  KEY `column62` (`column62`),
  KEY `column219` (`column219`),
  KEY `afield1` (`column219`,`column238`,`column148`)
) ENGINE=InnoDB AUTO_INCREMENT=660593 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `table004`
--


--
-- Table structure for table `table005`
--

CREATE TABLE `table005` (
  `column219` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column35` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`column219`),
  KEY `column35` (`column35`)
) ENGINE=InnoDB AUTO_INCREMENT=2049182 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `table005`
--


--
-- Table structure for table `table014`
--

CREATE TABLE `table014` (
  `column220` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column216` varchar(255) NOT NULL,
  PRIMARY KEY (`column220`),
  KEY `column216` (`column216`(191))
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `table014`
--


--
-- Table structure for table `table015`
--

CREATE TABLE `table015` (
  `column225` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column215` bigint(20) unsigned NOT NULL,
  `column226` text NOT NULL,
  `column70` datetime DEFAULT '0000-00-00 00:00:00',
  `column71` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`column225`),
  KEY `column215` (`column215`),
  KEY `column70` (`column70`)
) ENGINE=InnoDB AUTO_INCREMENT=1063239 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `table015`
--


--
-- Table structure for table `table016`
--

CREATE TABLE `table016` (
  `column224` mediumint(9) NOT NULL AUTO_INCREMENT,
  `column26` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `column237` varchar(256) NOT NULL,
  `column242` varchar(256) NOT NULL,
  `column240` varchar(256) NOT NULL,
  `column241` varchar(256) NOT NULL,
  `column243` varchar(256) NOT NULL,
  `column236` int(128) NOT NULL,
  `column228` int(128) NOT NULL,
  UNIQUE KEY `column224` (`column224`),
  UNIQUE KEY `column228` (`column228`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `table016`
--


--
-- Table structure for table `table017`
--

CREATE TABLE `table017` (
  `column227` bigint(20) NOT NULL AUTO_INCREMENT,
  `column4` bigint(20) NOT NULL DEFAULT 0,
  `column82` varchar(255) DEFAULT NULL,
  `column83` longtext DEFAULT NULL,
  PRIMARY KEY (`column227`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `table017`
--


--
-- Table structure for table `afield17`
--

CREATE TABLE `afield17` (
  `column227` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column22` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column82` varchar(255) DEFAULT NULL,
  `column83` longtext DEFAULT NULL,
  PRIMARY KEY (`column227`),
  KEY `column22` (`column22`),
  KEY `column82` (`column82`(191))
) ENGINE=InnoDB AUTO_INCREMENT=528 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `afield17`
--


--
-- Table structure for table `table018`
--
--
-- Table structure for table `table007`
--

CREATE TABLE `table007` (
  `column227` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column117` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column82` varchar(255) DEFAULT NULL,
  `column83` longtext DEFAULT NULL,
  PRIMARY KEY (`column227`),
  KEY `column117` (`column117`),
  KEY `column82` (`column82`(191))
) ENGINE=InnoDB AUTO_INCREMENT=1303445 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `table007`
--


--
-- Table structure for table `table008`
--

CREATE TABLE `table008` (
  `column214` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column114` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column115` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `column116` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `column232` longtext NOT NULL,
  `column235` text NOT NULL,
  `column234` text NOT NULL,
  `column125` varchar(20) NOT NULL DEFAULT 'publish',
  `column23` varchar(20) NOT NULL DEFAULT 'open',
  `column113` varchar(20) NOT NULL DEFAULT 'open',
  `column124` varchar(255) NOT NULL DEFAULT '',
  `column121` varchar(200) NOT NULL DEFAULT '',
  `column239` text NOT NULL,
  `column231` text NOT NULL,
  `column119` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `column120` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `column233` longtext NOT NULL,
  `column123` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column53` varchar(255) NOT NULL DEFAULT '',
  `column81` int(11) NOT NULL DEFAULT 0,
  `column126` varchar(20) NOT NULL DEFAULT 'post',
  `column118` varchar(100) NOT NULL DEFAULT '',
  `column21` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`column214`),
  KEY `afield21` (`column126`,`column125`,`column115`,`column214`),
  KEY `column123` (`column123`),
  KEY `column114` (`column114`),
  KEY `column121` (`column121`(191))
) ENGINE=InnoDB AUTO_INCREMENT=347868 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `table008`
--


--
-- Table structure for table `table010`
--

CREATE TABLE `table010` (
  `column218` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column217` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column185` varchar(32) NOT NULL DEFAULT '',
  `column222` longtext NOT NULL,
  `column110` bigint(20) unsigned NOT NULL DEFAULT 0,
  `column28` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`column218`),
  UNIQUE KEY `afield15` (`column217`,`column185`),
  KEY `column185` (`column185`)
) ENGINE=InnoDB AUTO_INCREMENT=1469 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `table010`
--

--
-- Table structure for table `table009`
--

CREATE TABLE `table009` (
  `column217` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column90` varchar(200) NOT NULL DEFAULT '',
  `column216` varchar(200) NOT NULL DEFAULT '',
  `column186` bigint(10) NOT NULL DEFAULT 0,
  `column188` int(4) DEFAULT 0,
  PRIMARY KEY (`column217`),
  KEY `column216` (`column216`(191)),
  KEY `column90` (`column90`(191))
) ENGINE=InnoDB AUTO_INCREMENT=1469 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `table009`
--


--
-- Table structure for table `table006`
--

CREATE TABLE `table006` (
  `column227` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column229` bigint(20) unsigned NOT NULL,
  `column82` varchar(255) DEFAULT NULL,
  `column83` longtext DEFAULT NULL,
  PRIMARY KEY (`column227`),
  KEY `column229` (`column229`),
  KEY `column82` (`column82`(32))
) ENGINE=InnoDB AUTO_INCREMENT=1782762 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `table006`
--


--
-- Table structure for table `table012`
--

CREATE TABLE `table012` (
  `column229` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column230` text NOT NULL,
  `column96` varchar(200) NOT NULL DEFAULT '',
  `column221` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`column229`),
  KEY `column221` (`column221`)
) ENGINE=InnoDB AUTO_INCREMENT=198545 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `table012`
--


--
-- Table structure for table `table013`
--

CREATE TABLE `table013` (
  `column224` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `column193` varchar(255) DEFAULT NULL,
  `column117` bigint(20) unsigned DEFAULT NULL,
  `column180` bigint(20) unsigned DEFAULT NULL,
  `column192` varchar(8) DEFAULT NULL,
  `column55` int(11) unsigned DEFAULT NULL,
  `column179` int(11) unsigned DEFAULT NULL,
  `column54` int(11) unsigned DEFAULT NULL,
  `column212` int(11) unsigned DEFAULT NULL,
  `column163` int(11) unsigned DEFAULT NULL,
  `column61` varchar(32) DEFAULT NULL,
  `column142` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`column224`),
  KEY `afield6` (`column117`,`column192`),
  KEY `afield4` (`column55`,`column192`)
) ENGINE=InnoDB AUTO_INCREMENT=168362 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `table013`
--


--
-- Final view structure for view `view001`
--

/*!50001 DROP VIEW IF EXISTS `view001`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view001` AS select `afield23`.`column221` AS `column221`,`afield23`.`column93` AS `column93`,`afield23`.`column98` AS `column98`,`afield23`.`column102` AS `column102`,`afield23`.`column122` AS `column122`,`afield23`.`column97` AS `column97`,`afield23`.`column92` AS `column92`,`afield23`.`column128` AS `column128`,`afield23`.`column99` AS `column99`,`afield23`.`column100` AS `column100`,`afield23`.`column51` AS `column51`,`afield23`.`column50` AS `column50`,`afield23`.`column42` AS `column42`,`afield23`.`column32` AS `column32`,`afield23`.`column17` AS `column17`,`afield23`.`column94` AS `column94`,`afield23`.`column105` AS `column105`,`afield23`.`column111` AS `column111`,`afield23`.`column112` AS `column112`,`afield23`.`column30` AS `column30`,`afield23`.`column12` AS `column12`,`afield23`.`column13` AS `column13`,`afield23`.`column9` AS `column9`,`afield23`.`column5` AS `column5`,`afield23`.`column6` AS `column6`,`afield23`.`column8` AS `column8`,`afield23`.`column16` AS `column16`,`afield23`.`column15` AS `column15`,`afield23`.`column10` AS `column10`,`afield23`.`column11` AS `column11`,`afield23`.`column14` AS `column14`,`afield23`.`column156` AS `column156`,`afield23`.`column157` AS `column157`,`afield23`.`column154` AS `column154`,`afield23`.`column150` AS `column150`,`afield23`.`column151` AS `column151`,`afield23`.`column153` AS `column153`,`afield23`.`column161` AS `column161`,`afield23`.`column160` AS `column160`,`afield23`.`column155` AS `column155`,`afield23`.`column158` AS `column158`,`afield23`.`column159` AS `column159`,`afield23`.`column46` AS `column46`,`afield23`.`column45` AS `column45`,`afield23`.`column104` AS `column104`,`afield23`.`column101` AS `column101`,`afield23`.`column141` AS `column141`,`afield23`.`column29` AS `column29`,`afield23`.`column18` AS `column18`,`afield23`.`column106` AS `column106`,`afield23`.`column7` AS `column7`,`afield23`.`column152` AS `column152`,`afield23`.`column48` AS `column48`,`afield23`.`column34` AS `column34`,`afield23`.`column36` AS `column36`,`afield23`.`column109` AS `column109`,`afield23`.`column24` AS `column24`,`afield23`.`column140` AS `column140`,`afield23`.`column103` AS `column103`,`afield23`.`column31` AS `column31`,`afield23`.`column33` AS `column33`,`afield23`.`column19` AS `column19`,`afield23`.`column59` AS `column59`,`afield24`.`column230` AS `column230`,`afield24`.`column96` AS `column96`,`afield24`.`column229` AS `column229`,`afield24`.`column132` AS `column132`,`afield24`.`column194` AS `column194`,`afield24`.`column138` AS `column138`,`afield24`.`column182` AS `column182`,`afield24`.`column65` AS `column65`,`afield24`.`column66` AS `column66`,`afield24`.`column69` AS `column69`,`afield24`.`column67` AS `column67`,`afield24`.`column68` AS `column68`,`afield24`.`column84` AS `column84`,`afield24`.`column56` AS `column56`,`afield24`.`column27` AS `column27`,`afield24`.`column191` AS `column191`,`afield24`.`column184` AS `column184`,`afield24`.`column0` AS `column0`,`afield24`.`column139` AS `column139`,`afield24`.`column60` AS `column60`,`afield24`.`column25` AS `column25`,`afield24`.`column181` AS `column181`,`afield24`.`column162` AS `column162`,`afield24`.`column41` AS `column41`,`afield24`.`column199` AS `column199`,`afield24`.`column200` AS `column200`,`afield24`.`column57` AS `column57`,`afield24`.`column38` AS `column38`,`afield24`.`column39` AS `column39`,`afield24`.`column37` AS `column37`,`afield24`.`column40` AS `column40`,`afield2`.`column131` AS `column131`,`afield2`.`column133` AS `column133`,`afield2`.`column135` AS `column135`,`afield2`.`column137` AS `column137`,`afield2`.`column130` AS `column130`,`afield2`.`column134` AS `column134`,`afield2`.`column107` AS `column107`,`afield2`.`column108` AS `column108`,`afield2`.`field30` AS `column164`,`afield2`.`column190` AS `column190`,`afield2`.`field45` AS `column183`,`afield2`.`field10` AS `column75`,`afield2`.`field0` AS `column3`,`afield2`.`field31` AS `column166`,`afield2`.`field47` AS `afield22`,`afield2`.`field5` AS `column47`,`afield2`.`field4` AS `column44`,`afield2`.`field3` AS `column43`,`afield2`.`field32` AS `column167`,`afield2`.`field33` AS `column168`,`afield2`.`field48` AS `column195`,`afield2`.`field60` AS `column210`,`afield2`.`field25` AS `column136`,`afield2`.`field21` AS `column127`,`afield2`.`field64` AS `column213`,`afield2`.`field9` AS `column64`,`afield2`.`field62` AS `column212`,`afield2`.`field8` AS `column54`,`afield2`.`field23` AS `afield11`,`afield2`.`field46` AS `afield18`,`afield2`.`field22` AS `afield10`,`afield2`.`field26` AS `column143`,`afield2`.`field27` AS `column144`,`afield2`.`field2` AS `afield0`,`afield2`.`field24` AS `afield13`,`afield2`.`field61` AS `column211`,`afield2`.`field18` AS `column87`,`afield2`.`field13` AS `column78`,`afield2`.`field19` AS `column88`,`afield2`.`field14` AS `column79`,`afield2`.`field20` AS `column89`,`afield2`.`field15` AS `column80`,`afield2`.`field16` AS `column85`,`afield2`.`field11` AS `column76`,`afield2`.`field17` AS `column86`,`afield2`.`field12` AS `column77`,`afield2`.`field40` AS `column175`,`afield2`.`field38` AS `column173`,`afield2`.`field39` AS `column174`,`afield2`.`field41` AS `column176`,`afield2`.`field43` AS `column178`,`afield2`.`field42` AS `column177`,`afield2`.`field34` AS `column169`,`afield2`.`field35` AS `column170`,`afield2`.`field50` AS `column197`,`afield2`.`field49` AS `column196`,`afield2`.`field53` AS `column202`,`afield2`.`field52` AS `column201`,`afield2`.`field51` AS `column198`,`afield2`.`field36` AS `column171`,`afield2`.`field55` AS `column205`,`afield2`.`field59` AS `column209`,`afield2`.`field54` AS `column204`,`afield2`.`field57` AS `column207`,`afield2`.`field58` AS `column208`,`afield2`.`field56` AS `column206`,`afield2`.`field37` AS `column172`,`afield2`.`field28` AS `column145`,`afield2`.`field29` AS `column146` from ((`view003` `afield24` join `view004` `afield23`) join `view009` `afield2`) where `afield24`.`column221` = `afield23`.`column221` and `afield24`.`column132` = `afield2`.`column132` and `afield24`.`column96` = 'line_item' */;

--
-- Final view structure for view `view002`
--

/*!50001 DROP VIEW IF EXISTS `view002`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view002` AS select `afield3`.`column221` AS `column221`,`afield3`.`column93` AS `column93`,`afield3`.`column102` AS `column102`,`afield3`.`column122` AS `column122`,`afield3`.`column97` AS `column97`,`afield3`.`column92` AS `column92`,`afield3`.`column128` AS `column128`,`afield3`.`column99` AS `column99`,`afield3`.`column100` AS `column100`,`afield3`.`column51` AS `column51`,`afield3`.`column50` AS `column50`,`afield3`.`column42` AS `column42`,`afield3`.`column32` AS `column32`,`afield3`.`column17` AS `column17`,`afield3`.`column94` AS `column94`,`afield3`.`column105` AS `column105`,`afield3`.`column111` AS `column111`,`afield3`.`column112` AS `column112`,`afield3`.`column30` AS `column30`,`afield3`.`column12` AS `column12`,`afield3`.`column13` AS `column13`,`afield3`.`column9` AS `column9`,`afield3`.`column5` AS `column5`,`afield3`.`column6` AS `column6`,`afield3`.`column8` AS `column8`,`afield3`.`column16` AS `column16`,`afield3`.`column15` AS `column15`,`afield3`.`column10` AS `column10`,`afield3`.`column11` AS `column11`,`afield3`.`column14` AS `column14`,`afield3`.`column156` AS `column156`,`afield3`.`column157` AS `column157`,`afield3`.`column154` AS `column154`,`afield3`.`column150` AS `column150`,`afield3`.`column151` AS `column151`,`afield3`.`column153` AS `column153`,`afield3`.`column161` AS `column161`,`afield3`.`column160` AS `column160`,`afield3`.`column155` AS `column155`,`afield3`.`column158` AS `column158`,`afield3`.`column159` AS `column159`,`afield3`.`column46` AS `column46`,`afield3`.`column45` AS `column45`,`afield3`.`column104` AS `column104`,`afield3`.`column101` AS `column101`,`afield3`.`column141` AS `column141`,`afield3`.`column29` AS `column29`,`afield3`.`column18` AS `column18`,`afield3`.`column106` AS `column106`,`afield3`.`column7` AS `column7`,`afield3`.`column152` AS `column152`,`afield3`.`column48` AS `column48`,`afield3`.`column34` AS `column34`,`afield3`.`column36` AS `column36`,`afield3`.`column109` AS `column109`,`afield3`.`column24` AS `column24`,`afield3`.`column140` AS `column140`,`afield3`.`column103` AS `column103`,`afield3`.`column31` AS `column31`,`afield3`.`column33` AS `column33`,`afield3`.`column19` AS `column19`,`afield3`.`column59` AS `column59` from `table003` `afield3` */;

--
-- Final view structure for view `view003`
--

/*!50001 DROP VIEW IF EXISTS `view003`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view003` AS select `afield24`.`column230` AS `column230`,`afield24`.`column96` AS `column96`,`afield24`.`column221` AS `column221`,`afield25`.`column229` AS `column229`,max(case when `afield25`.`column82` = 'value75' then `afield25`.`column83` else NULL end) AS `column132`,max(case when `afield25`.`column82` = 'value116' then `afield25`.`column83` else NULL end) AS `column194`,max(case when `afield25`.`column82` = 'value79' then `afield25`.`column83` else NULL end) AS `column138`,max(case when `afield25`.`column82` = 'value113' then `afield25`.`column83` else NULL end) AS `column182`,max(case when `afield25`.`column82` = 'value43' then `afield25`.`column83` else NULL end) AS `column65`,max(case when `afield25`.`column82` = 'value44' then `afield25`.`column83` else NULL end) AS `column66`,max(case when `afield25`.`column82` = 'value47' then `afield25`.`column83` else NULL end) AS `column69`,max(case when `afield25`.`column82` = 'value45' then `afield25`.`column83` else NULL end) AS `column67`,max(case when `afield25`.`column82` = 'value46' then `afield25`.`column83` else NULL end) AS `column68`,max(case when `afield25`.`column82` = 'method_id' then `afield25`.`column83` else NULL end) AS `column84`,max(case when `afield25`.`column82` = 'instance_id' then `afield25`.`column83` else NULL end) AS `column56`,max(case when `afield25`.`column82` = 'cost' then `afield25`.`column83` else NULL end) AS `column27`,max(case when `afield25`.`column82` = 'total_tax' then `afield25`.`column83` else NULL end) AS `column191`,max(case when `afield25`.`column82` = 'taxes' then `afield25`.`column83` else NULL end) AS `column184`,max(case when `afield25`.`column82` = 'Items' then `afield25`.`column83` else NULL end) AS `column0`,max(case when `afield25`.`column82` = 'rate_id' then `afield25`.`column83` else NULL end) AS `column139`,max(case when `afield25`.`column82` = 'label' then `afield25`.`column83` else NULL end) AS `column60`,max(case when `afield25`.`column82` = 'compound' then `afield25`.`column83` else NULL end) AS `column25`,max(case when `afield25`.`column82` = 'tax_amount' then `afield25`.`column83` else NULL end) AS `column181`,max(case when `afield25`.`column82` = 'shipping_tax_amount' then `afield25`.`column83` else NULL end) AS `column162`,max(case when `afield25`.`column82` = 'discount_amount' then `afield25`.`column83` else NULL end) AS `column41`,max(case when `afield25`.`column82` = 'value122' then `afield25`.`column83` else NULL end) AS `column199`,max(case when `afield25`.`column82` = 'value123' then `afield25`.`column83` else NULL end) AS `column200`,max(case when `afield25`.`column82` = 'value41' then `afield25`.`column83` else NULL end) AS `column57`,max(case when `afield25`.`column82` = 'value27' then `afield25`.`column83` else NULL end) AS `column38`,max(case when `afield25`.`column82` = 'value28' then `afield25`.`column83` else NULL end) AS `column39`,max(case when `afield25`.`column82` = 'value26' then `afield25`.`column83` else NULL end) AS `column37`,max(case when `afield25`.`column82` = 'value83' then `afield25`.`column83` else NULL end) AS `column40` from (`table006` `afield25` join `table012` `afield24`) where `afield25`.`column229` = `afield24`.`column229` group by `afield24`.`column230`,`afield24`.`column96`,`afield24`.`column221`,`afield25`.`column229` */;

--
-- Final view structure for view `view004`
--

/*!50001 DROP VIEW IF EXISTS `view004`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view004` AS select `afield26`.`column214` AS `column221`,`afield26`.`column115` AS `column93`,`afield26`.`column125` AS `column102`,`afield26`.`column121` AS `column122`,`afield26`.`column119` AS `column98`,max(case when `afield27`.`column82` = 'value61' then `afield27`.`column83` else NULL end) AS `column97`,max(case when `afield27`.`column82` = 'value59' then `afield27`.`column83` else NULL end) AS `column92`,max(case when `afield27`.`column82` = 'value73' then `afield27`.`column83` else NULL end) AS `column128`,max(case when `afield27`.`column82` = 'value62' then `afield27`.`column83` else NULL end) AS `column99`,max(case when `afield27`.`column82` = 'value63' then `afield27`.`column83` else NULL end) AS `column100`,max(case when `afield27`.`column82` = 'value39' then `afield27`.`column83` else NULL end) AS `column51`,max(case when `afield27`.`column82` = 'value38' then `afield27`.`column83` else NULL end) AS `column50`,max(case when `afield27`.`column82` = 'value29' then `afield27`.`column83` else NULL end) AS `column42`,max(case when `afield27`.`column82` = 'value22' then `afield27`.`column83` else NULL end) AS `column32`,max(case when `afield27`.`column82` = 'value14' then `afield27`.`column83` else NULL end) AS `column17`,max(case when `afield27`.`column82` = 'value60' then `afield27`.`column83` else NULL end) AS `column94`,max(case when `afield27`.`column82` = 'value67' then `afield27`.`column83` else NULL end) AS `column105`,max(case when `afield27`.`column82` = 'value70' then `afield27`.`column83` else NULL end) AS `column111`,max(case when `afield27`.`column82` = 'value71' then `afield27`.`column83` else NULL end) AS `column112`,max(case when `afield27`.`column82` = 'value20' then `afield27`.`column83` else NULL end) AS `column30`,max(case when `afield27`.`column82` = 'value8' then `afield27`.`column83` else NULL end) AS `column12`,max(case when `afield27`.`column82` = 'value9' then `afield27`.`column83` else NULL end) AS `column13`,max(case when `afield27`.`column82` = 'value5' then `afield27`.`column83` else NULL end) AS `column9`,max(case when `afield27`.`column82` = 'value1' then `afield27`.`column83` else NULL end) AS `column5`,max(case when `afield27`.`column82` = 'value2' then `afield27`.`column83` else NULL end) AS `column6`,max(case when `afield27`.`column82` = 'value4' then `afield27`.`column83` else NULL end) AS `column8`,max(case when `afield27`.`column82` = 'value12' then `afield27`.`column83` else NULL end) AS `column16`,max(case when `afield27`.`column82` = 'value11' then `afield27`.`column83` else NULL end) AS `column15`,max(case when `afield27`.`column82` = 'value6' then `afield27`.`column83` else NULL end) AS `column10`,max(case when `afield27`.`column82` = 'value7' then `afield27`.`column83` else NULL end) AS `column11`,max(case when `afield27`.`column82` = 'value10' then `afield27`.`column83` else NULL end) AS `column14`,max(case when `afield27`.`column82` = 'value93' then `afield27`.`column83` else NULL end) AS `column156`,max(case when `afield27`.`column82` = 'value94' then `afield27`.`column83` else NULL end) AS `column157`,max(case when `afield27`.`column82` = 'value91' then `afield27`.`column83` else NULL end) AS `column154`,max(case when `afield27`.`column82` = 'value87' then `afield27`.`column83` else NULL end) AS `column150`,max(case when `afield27`.`column82` = 'value88' then `afield27`.`column83` else NULL end) AS `column151`,max(case when `afield27`.`column82` = 'value90' then `afield27`.`column83` else NULL end) AS `column153`,max(case when `afield27`.`column82` = 'value98' then `afield27`.`column83` else NULL end) AS `column161`,max(case when `afield27`.`column82` = 'value97' then `afield27`.`column83` else NULL end) AS `column160`,max(case when `afield27`.`column82` = 'value92' then `afield27`.`column83` else NULL end) AS `column155`,max(case when `afield27`.`column82` = 'value95' then `afield27`.`column83` else NULL end) AS `column158`,max(case when `afield27`.`column82` = 'value96' then `afield27`.`column83` else NULL end) AS `column159`,max(case when `afield27`.`column82` = 'value33' then `afield27`.`column83` else NULL end) AS `column46`,max(case when `afield27`.`column82` = 'value32' then `afield27`.`column83` else NULL end) AS `column45`,max(case when `afield27`.`column82` = 'value66' then `afield27`.`column83` else NULL end) AS `column104`,max(case when `afield27`.`column82` = 'value64' then `afield27`.`column83` else NULL end) AS `column101`,max(case when `afield27`.`column82` = 'value81' then `afield27`.`column83` else NULL end) AS `column141`,max(case when `afield27`.`column82` = 'value19' then `afield27`.`column83` else NULL end) AS `column29`,max(case when `afield27`.`column82` = 'value15' then `afield27`.`column83` else NULL end) AS `column18`,max(case when `afield27`.`column82` = 'value68' then `afield27`.`column83` else NULL end) AS `column106`,max(case when `afield27`.`column82` = 'value3' then `afield27`.`column83` else NULL end) AS `column7`,max(case when `afield27`.`column82` = 'value89' then `afield27`.`column83` else NULL end) AS `column152`,max(case when `afield27`.`column82` = 'value36' then `afield27`.`column83` else NULL end) AS `column48`,max(case when `afield27`.`column82` = 'value24' then `afield27`.`column83` else NULL end) AS `column34`,max(case when `afield27`.`column82` = 'value25' then `afield27`.`column83` else NULL end) AS `column36`,max(case when `afield27`.`column82` = 'value69' then `afield27`.`column83` else NULL end) AS `column109`,max(case when `afield27`.`column82` = 'value18' then `afield27`.`column83` else NULL end) AS `column24`,max(case when `afield27`.`column82` = 'value80' then `afield27`.`column83` else NULL end) AS `column140`,max(case when `afield27`.`column82` = 'value65' then `afield27`.`column83` else NULL end) AS `column103`,max(case when `afield27`.`column82` = 'value21' then `afield27`.`column83` else NULL end) AS `column31`,max(case when `afield27`.`column82` = 'value23' then `afield27`.`column83` else NULL end) AS `column33`,max(case when `afield27`.`column82` = 'value16' then `afield27`.`column83` else NULL end) AS `column19`,max(case when `afield27`.`column82` = 'is_vat_exempt' then `afield27`.`column83` else NULL end) AS `column59`,max(case when `afield27`.`column82` = 'value126' then `afield27`.`column83` else NULL end) AS `column203`,(select 'Yes' from (`table012` `afield24` join `table006` `afield25`) where `afield24`.`column221` = `afield26`.`column214` and `afield24`.`column96` = 'line_item' and `afield24`.`column229` = `afield25`.`column229` and `afield25`.`column82` = 'value41' and `afield25`.`column83` = 'yes' limit 1) AS `column58` from (`table007` `afield27` join `table008` `afield26`) where `afield26`.`column214` = `afield27`.`column117` and `afield26`.`column126` = 'shop_order' group by `afield26`.`column214`,`afield26`.`column115`,`afield26`.`column125`,`afield26`.`column121`,`afield26`.`column119` */;

--
-- Final view structure for view `view005`
--

/*!50001 DROP VIEW IF EXISTS `view005`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view005` AS select 'test_' AS `afield9` */;

--
-- Final view structure for view `view006`
--

/*!50001 DROP VIEW IF EXISTS `view006`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view006` AS select `afield26`.`column214` AS `column132`,`afield26`.`column115` AS `column131`,`afield26`.`column125` AS `column133`,`afield26`.`column121` AS `afield12`,max(case when `afield27`.`column82` = 'value99' then `afield27`.`column83` else NULL end) AS `field30`,max(case when `afield27`.`column82` = 'total_sales' then `afield27`.`column83` else NULL end) AS `column190`,max(case when `afield27`.`column82` = 'value114' then `afield27`.`column83` else NULL end) AS `field45`,max(case when `afield27`.`column82` = 'value113' then `afield27`.`column83` else NULL end) AS `field44`,max(case when `afield27`.`column82` = 'value48' then `afield27`.`column83` else NULL end) AS `field10`,max(case when `afield27`.`column82` = 'value0' then `afield27`.`column83` else NULL end) AS `field0`,max(case when `afield27`.`column82` = 'value100' then `afield27`.`column83` else NULL end) AS `field31`,max(case when `afield27`.`column82` = 'value117' then `afield27`.`column83` else NULL end) AS `field47`,max(case when `afield27`.`column82` = 'value34' then `afield27`.`column83` else NULL end) AS `field5`,max(case when `afield27`.`column82` = 'value31' then `afield27`.`column83` else NULL end) AS `field4`,max(case when `afield27`.`column82` = 'value30' then `afield27`.`column83` else NULL end) AS `field3`,max(case when `afield27`.`column82` = 'value101' then `afield27`.`column83` else NULL end) AS `field32`,max(case when `afield27`.`column82` = 'value102' then `afield27`.`column83` else NULL end) AS `field33`,max(case when `afield27`.`column82` = 'value118' then `afield27`.`column83` else NULL end) AS `field48`,max(case when `afield27`.`column82` = 'value133' then `afield27`.`column83` else NULL end) AS `field60`,max(case when `afield27`.`column82` = 'value78' then `afield27`.`column83` else NULL end) AS `field25`,max(case when `afield27`.`column82` = 'value72' then `afield27`.`column83` else NULL end) AS `field21`,max(case when `afield27`.`column82` = 'value137' then `afield27`.`column83` else NULL end) AS `field64`,max(case when `afield27`.`column82` = 'value136' then `afield27`.`column83` else NULL end) AS `field63`,max(case when `afield27`.`column82` = 'value42' then `afield27`.`column83` else NULL end) AS `field9`,max(case when `afield27`.`column82` = 'value135' then `afield27`.`column83` else NULL end) AS `field62`,max(case when `afield27`.`column82` = 'value40' then `afield27`.`column83` else NULL end) AS `field8`,max(case when `afield27`.`column82` = 'value76' then `afield27`.`column83` else NULL end) AS `field23`,max(case when `afield27`.`column82` = 'value115' then `afield27`.`column83` else NULL end) AS `field46`,max(case when `afield27`.`column82` = 'value74' then `afield27`.`column83` else NULL end) AS `field22`,max(case when `afield27`.`column82` = 'value82' then `afield27`.`column83` else NULL end) AS `field26`,max(case when `afield27`.`column82` = 'value84' then `afield27`.`column83` else NULL end) AS `field27`,max(case when `afield27`.`column82` = 'value35' then `afield27`.`column83` else NULL end) AS `field6`,max(case when `afield27`.`column82` = 'value37' then `afield27`.`column83` else NULL end) AS `field7`,max(case when `afield27`.`column82` = 'value17' then `afield27`.`column83` else NULL end) AS `field2`,max(case when `afield27`.`column82` = 'value77' then `afield27`.`column83` else NULL end) AS `field24`,max(case when `afield27`.`column82` = 'value13' then `afield27`.`column83` else NULL end) AS `field1` from (`table007` `afield27` join `table008` `afield26`) where `afield26`.`column214` = `afield27`.`column117` and `afield26`.`column126` in ('product','product_variation') group by `afield26`.`column214`,`afield26`.`column115`,`afield26`.`column125`,`afield26`.`column121` */;

--
-- Final view structure for view `view007`
--

/*!50001 DROP VIEW IF EXISTS `view007`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view007` AS select `afield5`.`column214` AS `column132`,`afield5`.`column115` AS `column131`,`afield5`.`column125` AS `column133`,`afield5`.`column121` AS `afield12`,max(case when `afield20`.`column185` = 'product_type' then `afield28`.`column90` else NULL end) AS `column135`,max(case when `afield20`.`column185` = 'product_visibility' then `afield28`.`column90` else NULL end) AS `column137`,max(case when `afield20`.`column185` = 'product_cat' then `afield28`.`column90` else NULL end) AS `column130`,max(case when `afield20`.`column185` = 'product_tag' then `afield28`.`column90` else NULL end) AS `column134`,max(case when `afield20`.`column185` = 'pa_color' then `afield28`.`column90` else NULL end) AS `column107`,max(case when `afield20`.`column185` = 'pa_size' then `afield28`.`column90` else NULL end) AS `column108` from (((`table008` `afield5` join `table011` `afield19`) join `table010` `afield20`) join `table009` `afield28`) where `afield5`.`column126` in ('product','product_variation') and `afield5`.`column214` = `afield19`.`column91` and `afield19`.`column218` = `afield20`.`column218` and `afield20`.`column217` = `afield28`.`column217` group by `afield5`.`column214`,`afield5`.`column115`,`afield5`.`column125`,`afield5`.`column121` */;

--
-- Final view structure for view `view008`
--

/*!50001 DROP VIEW IF EXISTS `view008`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view008` AS select `afield5`.`column214` AS `column132`,`afield5`.`column115` AS `column131`,`afield5`.`column125` AS `column133`,`afield5`.`column121` AS `afield12`,`afield20`.`column218` AS `column218`,`afield20`.`column185` AS `column185`,`afield20`.`column110` AS `afield8`,`afield28`.`column217` AS `column217`,`afield28`.`column90` AS `afield16`,`afield28`.`column216` AS `column216`,`afield28`.`column186` AS `column186`,`afield19`.`column188` AS `column188` from (((`table008` `afield5` join `table011` `afield19`) join `table010` `afield20`) join `table009` `afield28`) where `afield5`.`column126` in ('product','product_variation') and `afield5`.`column214` = `afield19`.`column91` and `afield19`.`column218` = `afield20`.`column218` and `afield20`.`column217` = `afield28`.`column217` */;

--
-- Final view structure for view `view009`
--

/*!50001 DROP VIEW IF EXISTS `view009`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view009` AS select `afield5`.`column214` AS `column132`,`afield5`.`column115` AS `column131`,`afield5`.`column125` AS `column133`,`afield5`.`column121` AS `afield12`,max(case when `afield20`.`column185` = 'product_type' then `afield28`.`column90` else NULL end) AS `column135`,max(case when `afield20`.`column185` = 'product_visibility' then `afield28`.`column90` else NULL end) AS `column137`,max(case when `afield20`.`column185` = 'product_cat' then `afield28`.`column90` else NULL end) AS `column130`,max(case when `afield20`.`column185` = 'product_tag' then `afield28`.`column90` else NULL end) AS `column134`,max(case when `afield20`.`column185` = 'pa_color' then `afield28`.`column90` else NULL end) AS `column107`,max(case when `afield20`.`column185` = 'pa_size' then `afield28`.`column90` else NULL end) AS `column108`,max(case when `afield27`.`column82` = 'value99' then `afield27`.`column83` else NULL end) AS `field30`,max(case when `afield27`.`column82` = 'total_sales' then `afield27`.`column83` else NULL end) AS `column190`,max(case when `afield27`.`column82` = 'value114' then `afield27`.`column83` else NULL end) AS `field45`,max(case when `afield27`.`column82` = 'value113' then `afield27`.`column83` else NULL end) AS `field44`,max(case when `afield27`.`column82` = 'value48' then `afield27`.`column83` else NULL end) AS `field10`,max(case when `afield27`.`column82` = 'value0' then `afield27`.`column83` else NULL end) AS `field0`,max(case when `afield27`.`column82` = 'value100' then `afield27`.`column83` else NULL end) AS `field31`,max(case when `afield27`.`column82` = 'value117' then `afield27`.`column83` else NULL end) AS `field47`,max(case when `afield27`.`column82` = 'value34' then `afield27`.`column83` else NULL end) AS `field5`,max(case when `afield27`.`column82` = 'value31' then `afield27`.`column83` else NULL end) AS `field4`,max(case when `afield27`.`column82` = 'value30' then `afield27`.`column83` else NULL end) AS `field3`,max(case when `afield27`.`column82` = 'value101' then `afield27`.`column83` else NULL end) AS `field32`,max(case when `afield27`.`column82` = 'value102' then `afield27`.`column83` else NULL end) AS `field33`,max(case when `afield27`.`column82` = 'value118' then `afield27`.`column83` else NULL end) AS `field48`,max(case when `afield27`.`column82` = 'value133' then `afield27`.`column83` else NULL end) AS `field60`,max(case when `afield27`.`column82` = 'value78' then `afield27`.`column83` else NULL end) AS `field25`,max(case when `afield27`.`column82` = 'value72' then `afield27`.`column83` else NULL end) AS `field21`,max(case when `afield27`.`column82` = 'value137' then `afield27`.`column83` else NULL end) AS `field64`,max(case when `afield27`.`column82` = 'value136' then `afield27`.`column83` else NULL end) AS `field63`,max(case when `afield27`.`column82` = 'value42' then `afield27`.`column83` else NULL end) AS `field9`,max(case when `afield27`.`column82` = 'value135' then `afield27`.`column83` else NULL end) AS `field62`,max(case when `afield27`.`column82` = 'value40' then `afield27`.`column83` else NULL end) AS `field8`,max(case when `afield27`.`column82` = 'value76' then `afield27`.`column83` else NULL end) AS `field23`,max(case when `afield27`.`column82` = 'value115' then `afield27`.`column83` else NULL end) AS `field46`,max(case when `afield27`.`column82` = 'value74' then `afield27`.`column83` else NULL end) AS `field22`,max(case when `afield27`.`column82` = 'value82' then `afield27`.`column83` else NULL end) AS `field26`,max(case when `afield27`.`column82` = 'value84' then `afield27`.`column83` else NULL end) AS `field27`,max(case when `afield27`.`column82` = 'value35' then `afield27`.`column83` else NULL end) AS `field6`,max(case when `afield27`.`column82` = 'value37' then `afield27`.`column83` else NULL end) AS `field7`,max(case when `afield27`.`column82` = 'value17' then `afield27`.`column83` else NULL end) AS `field2`,max(case when `afield27`.`column82` = 'value77' then `afield27`.`column83` else NULL end) AS `field24`,max(case when `afield27`.`column82` = 'value13' then `afield27`.`column83` else NULL end) AS `field1`,max(case when `afield27`.`column82` = 'value134' then `afield27`.`column83` else NULL end) AS `field61`,max(case when `afield27`.`column82` = 'value56' then `afield27`.`column83` else NULL end) AS `field18`,max(case when `afield27`.`column82` = 'value51' then `afield27`.`column83` else NULL end) AS `field13`,max(case when `afield27`.`column82` = 'value57' then `afield27`.`column83` else NULL end) AS `field19`,max(case when `afield27`.`column82` = 'value52' then `afield27`.`column83` else NULL end) AS `field14`,max(case when `afield27`.`column82` = 'value58' then `afield27`.`column83` else NULL end) AS `field20`,max(case when `afield27`.`column82` = 'value53' then `afield27`.`column83` else NULL end) AS `field15`,max(case when `afield27`.`column82` = 'value54' then `afield27`.`column83` else NULL end) AS `field16`,max(case when `afield27`.`column82` = 'value49' then `afield27`.`column83` else NULL end) AS `field11`,max(case when `afield27`.`column82` = 'value55' then `afield27`.`column83` else NULL end) AS `field17`,max(case when `afield27`.`column82` = 'value50' then `afield27`.`column83` else NULL end) AS `field12`,max(case when `afield27`.`column82` = 'value109' then `afield27`.`column83` else NULL end) AS `field40`,max(case when `afield27`.`column82` = 'value107' then `afield27`.`column83` else NULL end) AS `field38`,max(case when `afield27`.`column82` = 'value108' then `afield27`.`column83` else NULL end) AS `field39`,max(case when `afield27`.`column82` = 'value110' then `afield27`.`column83` else NULL end) AS `field41`,max(case when `afield27`.`column82` = 'value112' then `afield27`.`column83` else NULL end) AS `field43`,max(case when `afield27`.`column82` = 'value111' then `afield27`.`column83` else NULL end) AS `field42`,max(case when `afield27`.`column82` = 'value103' then `afield27`.`column83` else NULL end) AS `field34`,max(case when `afield27`.`column82` = 'value104' then `afield27`.`column83` else NULL end) AS `field35`,max(case when `afield27`.`column82` = 'value120' then `afield27`.`column83` else NULL end) AS `field50`,max(case when `afield27`.`column82` = 'value119' then `afield27`.`column83` else NULL end) AS `field49`,max(case when `afield27`.`column82` = 'value125' then `afield27`.`column83` else NULL end) AS `field53`,max(case when `afield27`.`column82` = 'value124' then `afield27`.`column83` else NULL end) AS `field52`,max(case when `afield27`.`column82` = 'value121' then `afield27`.`column83` else NULL end) AS `field51`,max(case when `afield27`.`column82` = 'value105' then `afield27`.`column83` else NULL end) AS `field36`,max(case when `afield27`.`column82` = 'value128' then `afield27`.`column83` else NULL end) AS `field55`,max(case when `afield27`.`column82` = 'value132' then `afield27`.`column83` else NULL end) AS `field59`,max(case when `afield27`.`column82` = 'value127' then `afield27`.`column83` else NULL end) AS `field54`,max(case when `afield27`.`column82` = 'value130' then `afield27`.`column83` else NULL end) AS `field57`,max(case when `afield27`.`column82` = 'value131' then `afield27`.`column83` else NULL end) AS `field58`,max(case when `afield27`.`column82` = 'value129' then `afield27`.`column83` else NULL end) AS `field56`,max(case when `afield27`.`column82` = 'value106' then `afield27`.`column83` else NULL end) AS `field37`,max(case when `afield27`.`column82` = 'value85' then `afield27`.`column83` else NULL end) AS `field28`,max(case when `afield27`.`column82` = 'value86' then `afield27`.`column83` else NULL end) AS `field29` from ((((`table008` `afield5` join `table011` `afield19`) join `table010` `afield20`) join `table009` `afield28`) join `table007` `afield27`) where `afield5`.`column126` in ('product','product_variation') and `afield5`.`column214` = `afield19`.`column91` and `afield5`.`column214` = `afield27`.`column117` and `afield19`.`column218` = `afield20`.`column218` and `afield20`.`column217` = `afield28`.`column217` group by `afield5`.`column214`,`afield5`.`column115`,`afield5`.`column125`,`afield5`.`column121` */;


