Got error 28 from storage engine
SELECT * FROM SC_products p left join SC_categories c on c.categoryID = p.categoryID WHERE p.slug='gaya-taco-plants-03-beige' order by c.parent limit 1