Got error 28 from storage engine
SELECT a.p_id,b.title,s_lead, seo_url_default, offer_text, stock, serial,price1, price2, ( CASE WHEN price2 > 0 THEN price2 else price1 END ) as price FROM products_product as a JOIN products_product_lang as b ON a.p_id=b.p_id AND lang='HU' JOIN products_price as c ON a.p_id=c.p_id JOIN products_related_data as d ON a.p_id=d.rel_p_id AND d.p_id=4860 AND rel_type='C' WHERE a.status='Y' AND a.stock>0 ORDER BY price