1. 2.8x 3 inches 4:3 LCD Viewfinder V1 for Canon 5DII /7D /500D[48028]

    Price:  $11.99

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

    With 50 inch 4:3 wide screen virtual display, the picture is clear and fine and smooth, 50" Virtual Screen 432*240 Resolution Video Eyewear Glasses, which can let you stay in cinema to enjoy the film.

    - 50 inch 4:3 wide screen virtual display, None radiation LCD panel
    - Enjoy movies, music, photos and favorite books everywhere you go
    - Built-in 4GB flash memory for mega storage and play of media files
    - USB interface allows easy and high speed file uploading
    - Sleek ergonomical design, comfortable wearing, light weighted as lower as 70grams
    - Support multimedia video format like Mpeg, AVI, RM, RMVB, FLV
    - Super dynamic quality sterero sound effect
    - Memory Card Slot: Micro SD card slot, support max 32 GB
    - Virtual Screen Size:50inch away 2meters virtual distance
    - Screen Resolution: 432*240, Screen Ratio: 4:3
    - Firmware upgradable, 8 Desktop pictures selectable
    - Color Depth: 24 bit, Audio output? Stereo
    - Viewing Angle: 26┬░Diagonal
    - Audio Distortion: 0.03%
    - USB2.0 High speed data transfer, 4MB/S
    - Operation ambient Temp -5C-+40 C
    - Power Duration: 2-3 hrs.
    - Power Consumption: 0.9W
    - Frequency Response: 20Hz-20KHz
    - Sample Rate: 8-16Khz, SNR >85db
    - Power Supply: DC 3.7V/500mAh, AC: 110-240V
    - Video Format: RM/RMVB/Mpeg/AVI/FLV
    - Music Format: MP3, WMA, Flac and APE
    - Ebook feature: Bookmark, Page jump, Txt Color, Txt Size, Browse Mode, Auto-paging, Reading style    
    - Picture format: Jpeg, BMP, GIF, feature: Rotate, Zoom, Slides, Auto-browse.                    

    Package included:
    1* Video Eyewear Glasses
    1* USB Cable
    1* USB Charging Cable
    1* AC Adaptor
    1* User Manual
    1* Carry 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 = '1323' and opa.orders_id = opb.orders_id and opb.products_id != '1323' 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