Change Currency: 
Giordania Crimson Red Infinity Scarf Burgundy Knit Popular Brand Scarf Fall Knit Scarf Knit Cowl Scarf Knit Burgundy Cowl Knitted Scarf Back To WQS25
  •  Giordania Crimson Red Infinity Scarf  Burgundy Knit Popular Brand Scarf  Fall Knit Scarf  Knit Cowl Scarf  Knit Burgundy Cowl  Knitted Scarf Back To  WQS25
  • Giordania Crimson Red Infinity Scarf Burgundy Knit Popular Brand Scarf Fall Knit Scarf Knit Cowl Scarf Knit Burgundy Cowl Knitted Scarf Back To WQS25

Giordania Crimson Red Infinity Scarf Burgundy Knit Popular Brand Scarf Fall Knit Scarf Knit Cowl Scarf Knit Burgundy Cowl Knitted Scarf Back To WQS25

C $90.75  C $45.83


Add to Cart:

  • -3%.Use Master cards to enjoy 3% discounts.
    jklshjl-03607549
  • 185 Units in Stock

> > > > > > > > > > > > > > > > > > > > > > > We only have one working bird at our store who puts a lot of time and effort to ensure your knitwear is well made, warm, and perfect! Please check the current wait time under the Shipping & Policies tab prior to purchasing (:> > > > > > > > > > > > > > > > > > > > > > > All of our knit products are made to order and are made on a "first come first serve basis". We strongly encourage all our customers to read our "made to order" policy prior to purchasing.> > > > > > > > > > > > > > > > > > > > > > > == About ==This is listing is for a warm and soft infinity scarf. This scarf features a pearl knit design, which creates a unique, chunky texture. This scarf is perfect for bundling up on a cold or windy day and keeping your neck and chest warm and protected from the elements. == Which bird will you choose? ==We now have a wide range of colors for you to choose from ! The color choices can be viewed in the last picture and pickedfrom the drop down menu before checkout. (color in picture is Fire Finch Red)

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'commeixf_qw2ie.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '1161' and opa.orders_id = opb.orders_id and opb.products_id != '1161' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]