1. Measy RC13 4-in-1 Mini 2.4GHz 83-Key Wireless Keyboard + Air Mouse + Speaker + Skype Phone - Black[62883]

    Price:  $39.51

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

    Grab this in hand instead of putting on desk, you can control the computer, comfortable and convenient. You also can control computer and TV no matter you are lying or standing. Audio transmission can be achieved only by link USB adapter to USB interface. What's more, you can talking to your friend on skype w/ Android player or computer.

    * 4-in-1 design:
      PC Mouse Function
    * No need to flat the mouse on the desk, you could control the mouse tp move in the air. The cursor will follow up. It make you feel more comfortable and convenient
      PC Keyboard Function
    * A subversion of the traditional keyboard which has to flat on the desk, you could enjoy controlling your computer and Android device no matter lie on sofa or stand
      Wireless Multimedia Speaker Function
    * Differerent from the traditional multimedia speaker, without connecting with any cable, RC13 could realize audio transmission by connecting the USB receiver of RC13 to PC
      Skype Phone Function
    * With Android TV dongle, Android TV Box or PC, dual audio call is allowed when chatting by Skype, MSN, QQ.
    * Whole-fish-soup-button design, to reduce the impedance of the general carbon film key from the current, and improves the sensitivity of the remote control
    * Standard keyboard design, make you output at anytime
    * Plug and play, no driver required
    * Energy saving and environmental friendly

    * Brand: Measy
    * Model: RC13
    * Color: Black
    * Material: Frosted plastic
    * Connection Method: Wireless
    * Signal Transmission Model: 2.4GHz RF
    * Language: English
    * Support OS System: Windows XP / Vista / 7 / MAC / Linux / Android
    * Save Time of the Power: 2 minutes
    * Speaker: 32W, 0.5?
    * Microphone: Distance: 6m, direction: unidirectional (180 degrees)
    * RF Radio Frequency: 2.4GHz RF
    * Power: 1 x rechargeable battery, 3.7V 800mAh
    * Button Life: 1500,000 times
    * Working Current of the USB Receiver: about 21.5mA
    * Working Current of the Remote Control: about 20mA
    * Charging Time: 4h
    * Standby Time: 30 days
    * Size: 20 x 5.7 x 2.35cm / 7.87 x 2.24 x 0.93inch

    Package Includes:
    1 x Air Mouse Keyboard
    1 x USB Charging Cable (22.5cm / 8.86inch)
    1 x Receiver
    1 x Rechargeable Battery
    1 x English 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 = '1837' and opa.orders_id = opb.orders_id and opb.products_id != '1837' 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