1. 4.3" TFT Screen 8GB MP4/MP5/PMP/Camera Game Player w/TF Slot/TV-Out - Black[38928]

    Price:  $34.53

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

    The system is a dynamic enterainment medium that can access a wide range of digital functions including games, audio, video, photos and the internet, it built-in 8GB memory and support TF card expansion. Also, it built-in 1.3 MP camera.

    * 4.3" TFT  screen
    * Built-in 8GB memory
    * Built-in 1.3MP camera
    * Support video recorder and PC camera
    * Support TF card expansion
    * Music function: support MP3, WMA, WAV
    * Support directly RM, RMVB, AVI format files
    * Browsing photo, support JPEG, BMP, GIF, TIF
    * Support music player, video player, sound recorder, ebook
    * Game function: Game function: support 8-32 bit NES/GBA games, game can be downloaded from Internet
    * Built-in many kinds of games
    * Support FM, ebook, calculator, calendar, stopwatch, recorder
    * Interface: TF card slot, TV-OUT, earphone jack, mini USB
    * Language: english, chinese, japanese, korean, french, deutsch, italian, nederlands, portuguese, spanish, svenska, cesky dansk, polski, russia, turkish,, thai, hungarian, arabic, indonesia etc

    Package Include:
    * PMP x 1
    * USB cable x 1
    * Power adapter x 1
    * Earphone cable x 1

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