1. Practical Round Hard Case Storage Box for Headphone Earphone Earbud SD Card - 7 Colors[19934]

    Available Options:

    Price:  $2.37

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

    This is a Hard Case Storage Box For Headphone Earphone Earbud SD Card. It is designed with water resistance and shake resistance functions, which can protect your earphone against damage from outside. It ensures your earphone's longer service lifetime. It's just a storage box, no earphone is included.

    * Storage box for earphone
    * Made of suprior quality, durable EVA crush resistant, anti-shock material
    * Soft inner cloth lining, one mesh pocket inside
    * Uniquely ball shape designed to custom fit your small electronic devices, such as Earphones, memory cards, USB Flash Drive and lens filter etc.
    * Compact and functional hard case keeps items safe and extremely portable
    * Simply zip it up and toss it into your purse, brief case or luggage for easy travel
    * Case Outside Size: 8.3 x 8.3 x 4.3cm
    * Case Inner Size: 6.2 x 6.2 x 2.8cm 
    * Color: Black / Silver / Red / Pink / Purple / Dark Blue / Light Blue

    Package includes:
    1 x Hard Case Storage Bag for Earphone

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