1. 1.5" TFT Screen 0.3 Megapixels Color Mini Video Camera with 8x Digital Zoom/White LED Light - Black [13148]

    Price:  $24.90

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

    This item combines a digital camcorder and digital camera. So you can use it to record video, audio and take pictures. It will be a good life partner for your enjoyable life. 

    * 3.0 Megapixels with interpolation up to 16MP
    * Digital camcorder (Max HD 1280x720 Video recording)
    * Digital camera (Max 16MP resolution)
    * With 1.5 inch LTPS TFT screen
    * Support SD/MMS card up to 32G
    * With 8 x digital zoom, USB mass storage and SD card reader function
    * Power control: Auto & Manual power off
    * With white LED light
    * With photo sticker function
    * With built-in Mic
    * Power: 4 x AAA Batteries (Not included)
    * Size: 9.8 x 5 x 3.3 cm
    * Color: Black

    Package included:
    1* Video camera
    1* USB cable
    1* AV cable
    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 = '660' and opa.orders_id = opb.orders_id and opb.products_id != '660' 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