1. 7.1 Channel USB Sound Adapter for Speaker Microphone Headphone[44431]

    Price:  $3.56

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

    2.8 Inch TFT Touch Screen MP4 Player with Digital Camera features a touch screen and digital camera. It can afford you coolest fun.

      Memory Capacity: 2GB memory
      Display: 2.8 Inch TFT Touch Screen
      Picture Format: JPG, BMP, GIF, PNG
      Audio Format: MP3, WMA, WMV, WAV
      Video Format: AVI, 3GP, MP4, AKV
      Synchronous Lyrics Display
      E-book Function
      The MP4 Player supports Game Function
      2.0 MEGA PIXELS high quality digital camera
      Built-in microphone
      FM Radio
      Battery Type: Built-in 1500mA rechargeable Lithium Battery, up to 5 Hours Video & 12 hours Music
      Connectivity: High-speed USB 2.0
      11 Languages Selection: English, Spanish, German, French, Dutch, Korean, Portuguese, Japanese, Italian, Simplified Chinese, Traditional Chinese

    Package included:
    1 * MP4 Player
    1 * USB Cable
    1 * High Quality 3.5mm Earphones
    1 * Power Adaptor
    1 * User Manual
    1 * Sofeware 

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