1. Mini Portable Great PC Beverage Cans USB Cooler USB Fridge Refrigerator White + Red[54302]

    Price:  $22.83

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

    This item offers superb quality, performance and exceptional value. If you are looking for a reliable product at a great price, this item presents you a perfect option. Creative design, practical usage and competitive advantage make you deserve to own one.

    * 100% Brand New and High Quality USB Mini Fridge
    * Stylized as a mini fridge, looks cool on any desktop
    * You can keep your beverage chilled and stay at your computer longer with this mini fridge by your side
    * It can reach 60~80 Degree when heating( red) and 8~10 Degree when cooling( yellow)
    * Powered by USB cable with a switch to change the two functions-heating and cooling, no batteries required
    * Easy installation, no driver required, plug & play.
    * Internal LED Light
    * Compatible with all platforms
    * Insulation material enhances the cooling and heating effect.

    * Working Voltage: 5v
    * Current: 500mA
    * USB Cable Length: 100cm approx / 39.37 inch
    * Color: Red
    * Fridge Size (Length x Width x Height): 90 x 80 x 195 mm / 3.54 x 3.15 x 7.68 inch
    * Inner Size (Length x Width x Height): 65 x 80 x 130 mm / 2.56 x 3.15 x 5.12 inch
    Package included:
    1 x Red USB Mini Fridge (Cans not include)
    1 x 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 = '1526' and opa.orders_id = opb.orders_id and opb.products_id != '1526' 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