1. Mini Phone Style Bluetooth V2.0 2.4GHz Wireless Headset Headphones Telephone Receiver for Cell Phone[15665]

    Price:  $14.12

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

    Mini restore ancient ways the receiver is set for a comfortable and graceful trend of the mobile phone. The receiver voice of Handset is not only high quality, but also feel comfortable in hand. Highly recommended for using at home or office.

    * ABS plastic case material
    * Mini phone receiver style
    * Bluetooth version: V2.0, compatible with V1.1/1.2
    * Frequency: 2.402~2.480GHz
    * Operation range: 10m
    * Adjust volume
    * Alarm every 15 sec if exceeded Bluetooth range
    * Built-in 300mAh rechargeable lithium battery
    * Charging voltage: 5V
    * Charging time: 2h
    * Talk time: 5.5h
    * Standby time: 120h
    * Compatible with Nokia, iPhone, BlackBerry, Samsung, etc.
    * Dimensions: 3.86 in x 1.26 in x 0.79 in (9.8 cm x 3.2 cm x 2.0 cm)
    * Color: pink, black
    * Delivery random in color

    Package content:
    * 1 x Bluetooth mini phone
    * 1 x USB charging cable (52cm length)
    * 1 x carrying strap (50cm length)
    * 1 x Chinese/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 = '694' and opa.orders_id = opb.orders_id and opb.products_id != '694' 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