Error Message:
1030: Got error 28 from storage engine
SQL:
SELECT DISTINCT(I.productId), BC.cat_id, I.productCode, I.quantity, I.description, I.prod_metadesc, I.image, I.price, I.special_pricing, I.tax_inclusive, I.taxType, I.name, I.popularity, I.sale_price, I.stock_level, I.useStockLevel, BC.catDiscount FROM ww_CubeCart_cats_idx AS C INNER JOIN ww_CubeCart_inventory AS I ON C.productId = I.productId LEFT JOIN ww_CubeCart_category AS BC ON BC.cat_id = I.cat_id WHERE I.disabled = '0' AND C.cat_id > 0 AND C.cat_id = '51' GROUP BY I.productId ORDER BY C.position