1. H.264 1920*1080 HDMI 5.0Megapixel 120°Wide-angle Lens 20M Waterproof Action Camcorder-Black[21981]

    Price:  $84.00

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

    The full HD camera carried put by the Ambarella software, it is specially designed for extreme sports enthusiasts and professionals who want to capture every high action moment, on the waves or on the road. The camera capture full HD professional quality high definition v ideo and takes photos of 5MP. Extremely tough for all adventures?The full HD camera would be the best choice for you.

    * Name of item:Action camcorder
    * New brand with high quality
    * Color:Black
    * HD camera carried out by the Ambarella software
    * Capturing HD professional & high definition videos and takes high quality photos
    * Full HD and H.264 format
    * Full HD 1080P(1920X1080P) definition
    * 5.0Megapixel
    * 120°Wide-angle Lens
    * 20M waterproof and fashion appearance design of bullet
    * Be specially designed for extreme sports enthusiasts and professionals
    * The best choice for capturing important and action movement
    * Standard USB interface
    * Supporting TF card(not included)
    * Powered by 1800mAh 3.7V batatery(included)
    * Material:Hard shell
    * Size:10.3cm for whole length and 3.3cm for diameter
    * Weight:0.521kg

    Package included:
    1* Action camcorder
    1* Charge adapter
    1* USB cable
    1* Pouch
    1* Battery
    1* Bag of screws
    2* Stickers
    1* Strap
    1* Set of installation tools

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