1. CN-LUX480 48 LED Video Light Lamp for Canon Nikon Camera DV Camcorder[38909]

    Price:  $26.00

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

    The product is a CN-LUX480 48 LED video light  lamp for canon nikon camera DV camcorder.

    * Features 48-LED lights for optimum illumination and diffuser.
    * A PMMA protector in the front of light housing, making LED bulbs safer.
    * Matched with a diffuser and two filters, it can adjust the color temperature of the light, suitable for different environments.
    * Matched with fixing screws, it can adjust illumination direction of LED lighting.
    * With shoe adapter, it can be used to connect the LED lighting and camera apparatus.
    * Rotate switch for on/off and brightness adjustment.
    * Built-up slot allows you to connect other lights together.
    * Compact design, high power, good durability, and low heat output.
    * Applicable for camera video camcorder DV of most brands.

    * LED quantity: 48 pieces
    * Total power: 2.9W
    * Voltage: 4.5-5V
    * Color temperature: 5600K/ 3200K
    * Battery: 3 * AA (not included)
    * Item weight: 172g/ 6.06oz
    * Item size: 9 * 8.5 * 4.2cm/ 3.54 * 3.35 * 1.65in
    * Package size: 12.2 * 9.5 * 5.5cm/ 4.80 * 3.74 * 2.17in

    Package include
    1 * LED video light
    2 * Filters
    1 * User manual

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