1. JYC PRO1-D Super Slim Wide Band Protector 52mm Filter for Digital Camera[48052]

    Price:  $5.74

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

    Digital multi-coated with UV filters, specialized use with wide-angle lens to avoid the corners, with suitable digital successive diagonal, can absorb a large number of UV, the elimination of mist to increase the imaging resolution.

    - Quality filters and super high resolution.
    - Photographic, digital camera filters.
    - Manufactured from the finest solid optical glass.
    - Ground and polished to the most practical thinness.
    - Heat-treated to avoid any distortion or focal shift and each filter is subject to strict tests in order to ensure a perfect surface which is essential to a good filter.
    - Ultra-violet: Absorbs ultra-violet rays without increase of exposure, thereby preventing hazing and foggy effects in distant landscape. Constant use of this filter is recommended for clearer pictures as well as a lens protector.
    - CIP polarizing: Removes or reduces reflections from non-metallic surfaces, darkens, blue sky while increasing color saturation penetrates haze. Simply rotates the filter in its mount until the optimum effect is obtained.

    Package included:
    1* MC-UV Filter

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