{SELECT
`Apply1`.`HISTORYID1` AS `HistoryID`,
`Apply1`.`C1`,
`Apply1`.`Version`,
`Apply1`.`LogDate`,
`Apply1`.`IsDeleted`,
`Apply1`.`Name`,
`Apply1`.`Information`,
`Apply1`.`ExpirationDate`,
`Apply1`.`TimesViewed`,
`Apply1`.`IsCompensated`,
`Apply1`.`Price`,
`Apply1`.`IsApproved`,
`Apply1`.`Weight`,
`Apply1`.`VideoURL`,
`Apply1`.`UserGuideURL`,
`Apply1`.`Author_ID`,
`Apply1`.`Dimension_Id`,
`Apply1`.`ProductCategory_Id`,
`Apply1`.`Supplier_ID`
FROM (SELECT
`Distinct1`.`HistoryID`,
(SELECT
`Project2`.`HistoryID`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `HISTORYID1`,
(SELECT
`Project2`.`Version`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `Version`,
(SELECT
`Project2`.`LogDate`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `LogDate`,
(SELECT
`Project2`.`IsDeleted`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `IsDeleted`,
(SELECT
`Project2`.`Author_ID`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `Author_ID`,
(SELECT
`Project2`.`Dimension_Id`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `Dimension_Id`,
(SELECT
`Project2`.`ProductCategory_Id`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `ProductCategory_Id`,
(SELECT
`Project2`.`Supplier_ID`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `Supplier_ID`,
(SELECT
`Project2`.`Name`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `Name`,
(SELECT
`Project2`.`Information`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `Information`,
(SELECT
`Project2`.`ExpirationDate`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `ExpirationDate`,
(SELECT
`Project2`.`TimesViewed`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `TimesViewed`,
(SELECT
`Project2`.`IsCompensated`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `IsCompensated`,
(SELECT
`Project2`.`Price`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `Price`,
(SELECT
`Project2`.`IsApproved`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `IsApproved`,
(SELECT
`Project2`.`Weight`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `Weight`,
(SELECT
`Project2`.`VideoURL`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `VideoURL`,
(SELECT
`Project2`.`UserGuideURL`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `UserGuideURL`,
(SELECT
`Project2`.`C1`
FROM (SELECT
`Extent2`.`HistoryID`,
`Extent2`.`Version`,
`Extent2`.`LogDate`,
`Extent2`.`IsDeleted`,
`Extent2`.`Author_ID`,
`Extent3`.`Dimension_Id`,
`Extent3`.`ProductCategory_Id`,
`Extent3`.`Supplier_ID`,
`Extent3`.`Name`,
`Extent3`.`Information`,
`Extent3`.`ExpirationDate`,
`Extent3`.`TimesViewed`,
`Extent3`.`IsCompensated`,
`Extent3`.`Price`,
`Extent3`.`IsApproved`,
`Extent3`.`Weight`,
`Extent3`.`VideoURL`,
`Extent3`.`UserGuideURL`,
@gp1 AS `C1`
FROM `Histories` AS `Extent2` INNER JOIN `Products` AS `Extent3` ON (`Extent2`.`HistoryID` = `Extent3`.`HistoryID`) AND (`Extent2`.`Version` = `Extent3`.`Version`)
 WHERE `Extent1`.`HistoryID` = `Extent2`.`HistoryID`) AS `Project2`
 ORDER BY
`Project2`.`Version` DESC LIMIT 1) AS `C1`
FROM (SELECT DISTINCT
`Extent1`.`HistoryID`
FROM `Products` AS `Extent1`) AS `Distinct1`) AS `Apply1`}