1. JY620 50mm Photography On-camera Flash Speed-light with 1.7inch LCD Screen-Black[57242]

    Price:  $51.72

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

    This item is JY620 50mm Photography On-camera Flash Speed-light with 1.7inch LCD Screen. Do not use the flash in the presence of flammable or explosive gas. If the flash is operated in areas where there is a flammable gas, including propane, gasoline and dust, it could cause an explosion or fire.



    * Name of item: Photography flash speed-light
    * New brand with high quality
    * Color: Black
    * Model:JY620
    * Type: On-camera
    * Compatible cameras: Standard hot shoe cameras
    * Guide number: 40 (at 50mm focal length, ISO 100 in meters)
    * Flash coverage: 50mm
    * Exposure control type: Stroboscopic flash, manual flash
    * Effective flash range: 0.7-29m(with EF 50mm f/1.4, ISO 100)
    * Flash exposure compensation: Manual, =/- 0.3stops in 1/3- or 1/2-stop increments
    * Flash exposure confirmation: Flash exposure confirmation lamp lights
    * Recycling time: Normal flash 3.0 sec.(with size-AA alkaline batteries)
    * Flash-ready indicator: Red pilot lamp lights
    * Transmission method: Optical pulse
    * Slave flash modes: S1, S2
    * External power: Compact battery pack CP-E4
    * Transmission range: Appro. reception angle:+/- 40°horizontal, +/-30°vertical
    * Dimensions: 72x122x101mm

    Package included:
    1* Speed-light
    1* Carrying pouch
    1* Flash stand
    1* User manual(In Chinese and English)

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