SELECT c.* FROM cms_module_products c INNER JOIN cms_module_products_prodtohier ph ON ph.product_id = c.id LEFT JOIN cms_module_products_hierordering ordtbl ON (ordtbl.hier_id = 13 AND ordtbl.product_id = c.id) WHERE c.status = 'published' AND ph.hierarchy_id = 13 ORDER BY ordtbl.order_id ASC LIMIT 0, 1000
Got error 28 from storage engine