Cannot execute SQL query, Got error 28 from storage engine (1030)
Query: SELECT 
distinct page_products.product_id, products.product_code, products.stock_availab
le, products.price, products.rrp, products.weight, products.discount_scheme, pro
ducts.name, products.image, products.on_sale, products.sale_price, UNIX_TIMESTAM
P(products.sale_start), UNIX_TIMESTAMP(products.sale_end), products.description,
 products.unit_of_measure FROM page_products LEFT JOIN products ON page_products
.product_code = products.product_code WHERE page_products.node_id = '827' AND pr
oducts.product_code IS NOT NULL AND products.product_code != '' ORDER BY page_pr
oducts.product_code ASC