1. Waterproof Adjustable 360 Degree Rotation Bicycle Holder with Cover Case for iPhone 4/4S - Black[19379]

    Price:  $14.75

    This product was added to our catalog on Saturday 25 October, 2014.

    This item is a 360 degree multi-direction phone holder for bicycle. It helps you support your phone when you are biking. Additional it is cover case which can give great protection for your phone. That's really a useful and convenient gadget for you.


    * Specially designed for iPhone 4/4S
    * Easy to install on and remove from your bicycle
    * Space saving and make great convenience for you biking
    * Adjustable with 360 degree rotation easy to adjust to any angle that you want phone can be mounted horizontally or vertically
    * With waterproof cover case to give great protection for phone and good view for you
    * Double lock design
    * Expanded lens: Wide-angle lens
    * Waterproof design standards: IPX8
    * Material: ABS
    * Lining material: Silicone tray
    * Disassemble: Free tool for assembling and disassembling
    * Color: Black

    Package included:
    1* Bicycle holder


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