SEARCH

SELECT * FROM stir_style WHERE ( `style` LIKE '%ottoman%' AND active = 'Y' AND `name` != 'Design Your Own' AND `style_category_desc` != '' AND `name` != 'Design Your Own' AND `style_category_desc` != 'Quick Ship' AND `style_category_desc` != 'Correlating Ottomans' AND `style_category_desc` != 'Outdoor Correlating Ottomans' AND `style_category_desc` != 'Outdoor Loveseats' AND `style_category_desc` != 'Tribeca Options') OR ( `name` LIKE '%ottoman%' AND active = 'Y' AND `style_category_desc` != '' AND `name` != 'Design Your Own' AND `style_category_desc` != 'Quick Ship' AND `style_category_desc` != 'Correlating Ottomans' AND `style_category_desc` != 'Outdoor Correlating Ottomans' AND `style_category_desc` != 'Outdoor Loveseats' AND `style_category_desc` != 'Tribeca Options') OR ( `description` LIKE '%ottoman%' AND active = 'Y' AND `style_category_desc` != '' AND `name` != 'Design Your Own' AND `style_category_desc` != 'Quick Ship' AND `style_category_desc` != 'Correlating Ottomans' AND `style_category_desc` != 'Outdoor Correlating Ottomans' AND `style_category_desc` != 'Outdoor Loveseats' AND `style_category_desc` != 'Tribeca Options') OR ( `collection_code` LIKE '%ottoman%' AND active = 'Y' AND `style_category_desc` != '' AND `name` != 'Design Your Own' AND `style_category_desc` != 'Quick Ship' AND `style_category_desc` != 'Correlating Ottomans' AND `style_category_desc` != 'Outdoor Correlating Ottomans' AND `style_category_desc` != 'Outdoor Loveseats' AND `style_category_desc` != 'Tribeca Options') ORDER BY `style` ASC, `name` ASC


SELECT * FROM stir_fabric WHERE (`pattern` LIKE '%ottoman%' OR `color` LIKE '%ottoman%') AND fabric_collection_code1 NOT IN ( 'Dana Gibson Collection', 'Miles Talbott Boutique Collection', 'Washable Wonders Quick Ship' ) AND fabric_collection_code2 NOT IN ( 'Direct Buy Collection', 'Miles Talbott Boutique Collection' ) AND fabric_collection_code3 NOT IN ( 'Direct Buy Collection', 'Miles Talbott Boutique Collection' ) ORDER BY `pattern` ASC, `color` ASC