Brooklyn

SELECT * FROM `furniture_db` WHERE `slug_name` LIKE '%brooklyn%' AND (collection LIKE 'tables-ottomans' OR collection2 LIKE 'tables-ottomans' ) AND (`hide` = '0') ORDER BY CASE WHEN model_sku LIKE '%Bench%' THEN 1 WHEN model_sku LIKE '%Seagate%' THEN 2 WHEN model_sku LIKE '718T-%' AND model_sku NOT LIKE '%Table Top%' THEN 3 WHEN model_sku REGEXP '^718-[0-9]+' THEN 4 WHEN model_sku LIKE '%718B%' THEN 5 WHEN model_sku LIKE '%Table Top%' THEN 6 ELSE 99 END, CAST(REGEXP_SUBSTR(model_sku, '[0-9]+') AS UNSIGNED), model_sku