1. Professional Soft Microfiber Cleaning Cloth for DSLR Lens Cellphone LCD LED Screen[48357]

    Price:  $1.73

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

    This little portable universal external flash diffuser will prevent  the flash from causing harsh reflections or glare spots or from creating deep shadows. Simply put the item over the camera's flashlight, point and shoot. The light will be softened and your photoes will be well shoot without the harsh glare.

    Main features:
    * Provides soft even flash illumination.
    * Enlarge and diffuse the light with the flash in the direct flash position.
    * Soften shadows and eliminate unpleasant "red eye".
    * Not block either exposure sensors or auto focus assist beams on most flashes.
    * Universal/One-size-fits-all.
    * Folds down flat for easy storage and portability

    Compatible with:
    Nikon SB-800 SB-600 SB-80DX SB28 SB26 SB25 SB24
    Canon 580EX 550EX 540EZ 430EX 420EX 380EX 430EZ
    Metz 40MZ2 54MZ3
    MINOLTA 5600hs 5400xi/hx 5200i 3600
    OLYMPUS FL-40 FL-50 G40
    SONY HVL-F1000 HVL-F32X
    Sigma EF-500DG Super, ST
    Nissin 360TW 360TXP PZ400-C-N-M
    Sunpak 2000DZ 266D MZ440AF
    Tumax 988
    Vivitar 2500 273 3500 850AF

    Color: black + gray
    Dimensions: 10cm * 13cm
    Weight: 43g(with packing)

    Package included:
    1*multifunction flash diffuser

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