1. Novelty Funny Holga Lens & Filter Turret Hard Case Cover for iPhone 4/4S-Red[36642]

    Price:  $4.68

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

    Special Lens & Filter Turrt for iPhone 4/4S helps you creat fascinating photos with unique and magical effects. This roating device features 10 special effects for the result you desire. Simpley rotate the Holga 10 in 1 lens and filter turret and let it enhance your creativity and photo:taking experience.

    * Name of item:Holga Lens & Filter Turret Hard Case
    * Exclusively designed for iPhone 4/4S
    * Protect your phone from any angles and side against scratches bumps fingerprint and also protects your tablet in a stylish but practical manner
    * Easy to install and remove
    * Unique design allows easy access to all functions without having to remove the case
    * Keep your phone safe clean and scratch-free
    * 10 Lens(9 Holga Lens)
    * Dual Image Lens:Makes 2 identical images in one frame
    * Triple Image Lens : Makes 3 identical images in one frame
    * Quadruple Image Lens : Makes 4 identical images in one frame
    * Macro Lens : Get close-up on your subject for amazing detail
    * Red Filter with Clear Heart Shape Center : Red color filter with a clear heart:shaped center
    * Red Filter : For a rose-colored look
    * Green Filter : Give your photos a green tinge
    * Yellow Filter with Clear Center: A yellow color filter with a clear circle at the center
    * Blue Filter with Clear Center: A blue color filter with a clear circle at the center
    * Material:Plastic  

    Package included:
    1* Hard case


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