Cannot complete query (getAll):
SELECT
`tp`.`product_id` AS `id`,
SUBSTRING(`tp`.`product`, 1, 20) AS `title`,
`tp`.`product_version` AS `version`,
`tp`.`box_image` AS `thumbnail`,
SUBSTRING(`tp`.`product_desc`, 1, 30) AS `snipet`,
`tp`.`licence_paid` AS `price`,
`tp`.`licence_paid`-`tp`.`licence_discount` AS `discountSave`,
100*(`tp`.`licence_paid`-`tp`.`licence_discount`)/`tp`.`licence_paid` AS `discountPercent`,
`tp`.`product_owner` AS `vendor`,
AVG(`tc`.`vote`) AS `vote`,
COUNT(DISTINCT `ts`.`id`) AS `downloads`,
`tpc`.`pathName` AS `category`
FROM `boon_dlzProducts` AS `tp`
LEFT JOIN `boon_dlzComments` AS `tc` ON `tp`.`product_id`=`tc`.`product_id`
LEFT JOIN `boon_dlzPpCategories` AS `tpc` ON `tp`.`product_category_id`=`tpc`.`id`
LEFT JOIN `boon_dlzStatistics` AS `ts` ON `tp`.`product_id`=`ts`.`product_id`
WHERE `tp`.`product_owner`='mytechlogic' AND `tp`.`product_category_id`<>'0' AND `tp`.`stopped`<>'1'
GROUP BY `tp`.`product_id`
ORDER BY `tp`.`product_date` DESC LIMIT 5
Got error 28 from storage engine