1. Retro Camera Style Jacket Pack Case for iPhone 5 Free Standing with Extendable Lens 5 Colors[19556]

    Available Options:

    Price:  $5.65

    This product was added to our catalog on Thursday 01 January, 1970.

     This iPhone5 jacket pack features a facy camera style design with a optical zoom and a neck strap. With this strap you can not only wear your iPhone5 around your neck but also take photos or hold camera easily with single hand. The extendable lens can be act as a free standing which provide you an access to enjoy the music or MV to the fullest.


    * New generic designed protective jacket pack for iPhone 5
    * Strong and great protection against bumps and scratches.
    * Take Photos & hold camera easily with single hand
    * It's of standing function by extending the faux lens.
    * Wearing with neck strap provided.
    * Fits the iPhone 5 perfectly.
    * Gives you total access to all functionality and buttons without removing the case
    * Color: Black/White/Yellow/Rosy/Pink
    * Caes Size: 12.7 x 6.2 x 2.7cm
    * Package Size: 17 x 14 x 3cm
    * Weight: 105g

    Package includes:
    1 x iPhone 5 Case
    1 x Neck Strap


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