SELECT * FROM `stir_fabric` WHERE
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'
)
AND performance IN('Crypton')
ORDER BY pattern, color ASC LIMIT 0, 60
