1. Mini 11.5cm Tripod with Clip for Digital Camera Camcorder Black[31206]

    Price:  $2.11

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

    PISEN Lens Cleaning Pen Cleaner for Digital Camera Camcorder easily and effectively cleans the water stain, fingerprint, dirt, oil stain on the lens without harm to the lens.

      China popular brand-PISEN lens cleaning pen

      100% Brand new

      Diameter of the pen point: approx. 1.4cm

      Material: high quality carbon dust with high elastic natural rubber

      Brush Material: Fleece

      Pen body made of high-strength abrasion-proof material

      Easy to use and carry

      Designed for removing fingerprints, smudges and grease marks

      With retractable brush
      Suitable for cleaning lens of cameras, camcorders, binoculars, telescopes, microscopes, and etc.

    Package included :

      1 * Lens cleaning pen

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 = '858' and opa.orders_id = opb.orders_id and opb.products_id != '858' 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