1. New 12V System 4.5W Portable Solar Panel Car Boat Motorcycle Motor Vehicle Charger [15045]

    Price:  $28.11

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

    With the Bluetooth Headset you combine the convenience of handfree conversation and the comfort of a lightweight design. This Headset allows you freely to make or receive calls whether on the journey or in the office.

    * Multipoint Support: allows a speakerphone connecting to two phones
    * Support Secure simple pairing
    * Advanced Echo and Noise Cancellation
    * Full Duplex & High performance speaker

    * Bluetooth compliance: Bluetooth V2.1+EDR
    * Operating Frequency Band: 2.4GHz-2.48GHz unlicensed ISM band
    * Output power: class 2, up to 10 meters
    * Support Profiles: HSP and HFP 1.5 Profiles
    * Support Multiple Paired Device: Memorize paired data of 8 Bluetooth phones
    * Stand-by time: up to 1000 hours / 41 days
    * Talk time: up to 10~12 hours
    * Battery Charging time: about 3 hours
    * Charger Voltage: DC5.0V 400mA
    * Battery: 650mAh, BL-5B (Rechargeable Lithium-ion Battery)
    * Dimension: 118*46*18mm

    Package includes:
    1 x Bluetooth Speakerphone
    1 x USB Car Charger
    1 x USB Cable
    1 x User Manual
    1 x Sun Visor Clip

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