1. Prober Pview Side by Side 3D Video Glasses[19541]

    Price:  $389.07

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

    The product is pview side by Side 3D video glasses.

    16:9 98" jumbo size 3D virtual screen      
    Enjoy the natural 3D experience for games and movies with side by side LCD screens.     
    The most popular side by side 3D dedicating an individual screen to each eye for a real 3D.     
    Enjoy 3D games and  movies when connect to PC and Laptop  directly.     
    Enjoy 3D games and movies with your Smart Phones or Tablet PC(MHL/HDMI-VGA Convertor)     
    A must and powerful equipment for game-con and movie-con.     
    Only 90 grams (Head Mounted Unit,Cable not included,almost 1/4 of Sony HMZ-T2)
    2 meters cable let your can enjoy the game or movie in your comfortable sofa and bed     
    Hot plug and play, powered by USB      
    Hight quality stereo sound, true dynamic theatre enjoyment     
    High-tech optical system, anti-vertigo design ,Sleek ergonomical design
    Light weight, comfortable wearing     
    Virtual Screen: 98inch virtual screen (1.5m away)     
    Resolution : 854*480 (WVGA)    16:9     
    Display : LCD (Kopin)     
    Life time : 50000 hours      
    Power Supply: 5v, 500mA     
    Sound : Full stereo      
    Size: 9x21x14cm
    Working/Preserving  temperature: -5-55?/ -10-70?     
    Working System:Windows2000/XP/Vista/7/8 Android.iOs

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