Furniture: Advance Filtering
SELECT _id, style, name, style_category_desc, (REPLACE(style_category_desc,'Tribeca Options','Design Your Own')) FROM `stir_style` WHERE active = 'Y'
AND `style_category_desc` != ''
AND `style_category_desc` != 'Quick Ship'
AND `style_category_desc` != 'Correlating Ottomans'
AND `style_category_desc` != 'Outdoor Correlating Ottomans'
AND `style_category_desc` != 'Loveseats'
AND `style_category_desc` != 'Outdoor Loveseats'
AND `style_category_desc` != 'Tribeca Options'
AND `style_category_desc` != 'Sectionals'
AND `style_category_desc` != 'Outdoor Sectionals'
GROUP BY style_category_desc
ORDER BY style_category_desc ASC