Got error 28 from storage engine
SELECT * FROM SC_products p left join SC_categories c on c.categoryID = p.categoryID WHERE p.slug='architeza-diamante-d510-20' order by c.parent limit 1