1. Big PVA Chamois Towel /Synthetic-chamois Clean Cham Car Wash Cloth-Color Random[55904]

    Price:  $6.77

    This product was added to our catalog on Saturday 01 November, 2014.

    This synthetic-chamois towel is ideal for car and household cleaning. Our PVA shamois towel can be used for swimming towel, sport towel, car towel, pets towel,features towel,hair drying towel,etc. They can dry water very quickly.

    * This synthetic-chamois towel is ideal for car and household cleaning.
    * Besides the softness and warmness, it has the useful property of bearing soap without damage.
    * Its most common use is in automobile washing where it may be known as a "shammy" cloth.
    * Its water absorbency makes it good for other uses. Being somehow spongy, it easily retains oil making it good for wiping fingerprints from polished metallic surface.
    * Size:66cm*43*0.2cm
    * Color Random

    * Super absorbent
    * Suitable for household wares, cars and pets cleaning
    * Compact size makes it great for travel
    * Green products made of PVA and flour.
    * Soft and smooth feeling.
    * Resistant to bacteria and be molded.

    Package include:
    * Clean cham x 1

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'good8com_stationall.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image, p.products_price, p.products_tax_class_id from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '1658' and opa.orders_id = opb.orders_id and opb.products_id != '1658' 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 3