SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_products_lng_en.product, xcart_products_lng_en.descr, xcart_products_lng_en.fulldescr, IFNULL(xcart_variants.avail, xcart_products.avail) as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode FROM xcart_products INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_products.forsale = 'Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.avail = 'Y' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid WHERE xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_products_categories.categoryid='12' GROUP BY xcart_products.productid ORDER BY xcart_products_categories.orderby ASC, xcart_products_lng_en.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC
SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_products_lng_en.product, xcart_products_lng_en.descr, xcart_products_lng_en.fulldescr, IFNULL(xcart_variants.avail, xcart_products.avail) as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode FROM xcart_products INNER JOIN xcart_featured_products ON xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='12' INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_products.forsale = 'Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.avail = 'Y' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid WHERE xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL GROUP BY xcart_products.productid ORDER BY xcart_featured_products.product_order, xcart_products_lng_en.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC
Western Silk Bandanas/Wild Rags by Wyoming Traders
Sanpete Spur & Silver Western Store > Western Silk Bandanas/Wild Rags by Wyoming Traders

Western Silk Bandanas/Wild Rags by Wyoming Traders

Western Silk Bandanas/Wild Rags by Wyoming Traders

Select any combination of Western Silk Bandanas/Wild Rags to total $50 or more and receive a 10% discount. We combine shipping and give you FREE SHIPPING on any order of $ 75 or more.
On a Western Wild Rag order, no matter the quantity, even if we ship your order to Alaska, your shipping charges will never be over $7.00.

How to tie a bandana click here

Jacquard Ltd Edition Prints Silk Western Bandannas by Wyoming Traders

Jacquard Ltd Edition Prints Silk Western Bandannas by Wyoming Traders

Western Bandannas, Wild Rags, Limited Edition Prints by Wyoming Traders, Made For Cowboys...

Jacquard Paisley Silk Bandanas, Wild Rags by Wyoming Traders

Jacquard Paisley Silk Bandanas, Wild Rags by Wyoming Traders

Western Paisley Silk Bandanas, Silk Scarves, Cowboy Bandannas, or Wild Rags by Wyoming Traders....

Calico Silk Bandanas by Wyoming Traders

Calico Silk Bandanas by Wyoming Traders

Calico Silk Bandanas by Wyoming Traders Made For Cowboys &amp; Cowgirls with that western...

Solid Color Silk Bandanas Wild Rags by Wyoming Traders

Solid Color Silk Bandanas Wild Rags by Wyoming Traders

Cowboy Bandanas, Silk Scarves, Western Bandannas, or Wild Rags by Wyoming Traders . Solid Colors...

Prints Silk Bandanas by Wyoming Traders

Prints Silk Bandanas by Wyoming Traders

Wear these Beautifully patterned Silk Bandanas by Wyoming Traders &nbsp;to look good or or...

Polka Dot Silk Western Bandanas by Wyoming Traders

Polka Dot Silk Western Bandanas by Wyoming Traders

Western Bandanas,Wild Rags, Polka Dots by Wyoming Traders, Made For Western Men &amp; Women...

Brands Silk Cowboy Bandanas by Wyoming Traders

Brands Silk Cowboy Bandanas by Wyoming Traders

Brands Silk Cowboy Bandanas by Wyoming Traders Made For Cowboys &amp; Cowgirls to look right...

Large Silk Oversize  Bandanas  42-1/2 inches by Wyoming Traders

Large Silk Oversize Bandanas 42-1/2 inches by Wyoming Traders

Large Silk Oversize Bandanas, Silk Scarves, Western Bandannas, or Wild Rags by Wyoming Traders....

Jacquard Silk Bandanas/Wild Rags by Wyoming Traders

Jacquard Silk Bandanas/Wild Rags by Wyoming Traders

Jacquard Silk Bandanas/Wild Rags by Wyoming Traders&nbsp;Made For Cowboys & Cowgirls 12...