1. Professional Transparent Plastic LCD Screen Protector LCD Cover for Sony NEX5 NEX3[48272]

    Price:  $2.53

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

    The item is a 58mm lens cover. It is lightweight and portable, and it can well protect your camera lens and prolong your lens' useful life.

    Main features:
    * New and high quality
    * Compatible with all kinds of lens or filter with front thread
    * Special inner grip design with lens hood
    * Durable material
    * Protects your expensive lens/filter away from dirt and scratch


    Type: 58mm lens cap
    Weight: 13g

    Package included:
    1*58mm lens cover

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