1. Camera Rainwear Raincoat Rainproof Rain Cover Rain/Dust Protector[48679]

    Price:  $9.61

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

    This digital camera has a set of features you are looking at over all the others for your kids, smallest, light weight and compact design, thanks to its sensor and unis lens, it present us 300K pixels image.

    - Image sensor: 300K pixels CMOS
    - LCD Display: 1.0"CST (96*64pixels)
    - Image resolution: 1280*960(pixel up), 640*480
    - Memory: built-in 4*16Mb SDRAM
    - Lens: F/NO=2.5 f=4mm
    - Power: 2*AAA(1.5v) batteries/USB 5V/support charge battery
    - Standard mode: 1280*960 about 24 photos, 640*480 about 93 photo
    - Compression mode: 1280*960 about 49 photos, 640*480 about 187 photos
    - System requirements: Window XP/Vista/7/Mac OS X
    - Size: 84*58*24 mm

    Package included:
    1* digital camera
    1* USB cable
    1* manual

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