1. Digital Bluetooth Smart Watch Built-in Mic Handsfree Speakerphone Pair with Caller ID/Time display - Black[68863]

    Price:  $34.92

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

    The bt watch is a revolutionary product that gives the user easy way of answering the call. It is very convenient to use. With it, you won't miss a call. With the call function, you can directly search contacts, make and receive calls, you don't have to carry you large phone all the time. With answer waiting call function, long press the "Function Button" to switch between two calls.

    * Stylish Bluetooth Digital Watch
    * Supports Bluetooth hands-free bluetooth 3.0
    * Bluetooth compliance: A2DP, AVRCP, HFP and HSP
    * Compatible with all Bluetooth enabled devices such as smart phones, tablets and so on
    * Wireless Range: 10 meters(33 feet)
    * One key operation for: pairing, answering a call, ending a call, Caller ID display with super bright LCD back light
    * Built-in microphone
    * Built-in speaker
    * Play your favorite music through the watch
    * Display time, day/date
    * Alarm clock function
    * Answer waiting call function
    * Bulit-in 250mAh rechargeable battery
    * Up to 6 hours of talking time (actual times may vary with each charge)
    * Standby time: 80 hours
    * Music play time: 2-3 hours
    * Watch dimension: 55 x 48 x 17mm
    * Whole length: 265mm
    * Weight: 60g
    * Color: Black

    Package includes:
    1* Bluetooth digital watch
    1* USB charging cable
    1* 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 = '1924' and opa.orders_id = opb.orders_id and opb.products_id != '1924' 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