1. NEW Sense Flash light LED Color Changed Case Cover Dragon Figure for Apple iPhone4/4G-Black[36734]

    Price:  $3.22

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

    This case is designed only for iPone owners who prefer minimalist-style protection Which can offer complete front and backside protection for your iPhone 4S/4G. The case can light shine flash when calling and answering sending and receiving message.


    * 100% Brand New High Quality
    * Perfectly slim fit with iPhone 4S/4G
    * All interface ports and buttons available for directly use
    * Conveniently to access and remove
    * Figure of dragon
    * Protect & beautify your iPhone
    * Weight: 39g
    * Powered by button battery(included)

    1* Flash light Case
    1* Battery


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