Got error 28 from storage engine
SELECT * FROM SC_products p left join SC_categories c on c.categoryID = p.categoryID WHERE p.slug='atlas-concorde-stay-skyline-brick' order by c.parent limit 1