1. CY-20 90 Degree Rotation Electronic Flash Lamp for Camera and Camcorder - Black [13325]

    Price:  $14.02

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

    This item is a flash lamp for camera or camcorder to take photography. It is very convenient to use and can be used with various kinds of cameras. It will be a good partner for your camera.

    * Convenient and easy to use
    * Light weight and portable
    * Fits for various kinds of cameras
    * Can rotate for 90 degree
    * Low pressure trigger
    * Guide number: 20M (ISO 100, DIN 21)
    * Color temperature: 5600 K (daylight type)
    * Effective irradiation angle: horizontal 60 degree, vertical 40 degree
    * Flash duration: 1/1000 S
    * Power: 2 x 1.5V AA Batteries (Not included)
    * Recycle time: 7 S
    * Size: 10 x 6 x 4 cm
    * Color: Black

    Package included:
    1* Flash lamp

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