L7 1080P HD WIFI spy pen camera

-The product only used for obtaining evidence for public security, procurator, court, reporter and attorney, etc.
-This is a video and audio recording pen with the high-definition of H.264 HD 1080P for conference and lectures. It has high-definition video images and high-fidelity audio .
-It is small in volume and convenience for use.The built-in aluminum battery of 950 miliampere can be used to record video for 1 hour
-It can support TF card

Video format MOV
Video coding H.264
Video resolution 1920*1080 30 frames 1080*720 30 frames
Photograph resolution Max 4032*3024
WIFI support system IOS6.1 and above, Android 4.0 and above
Image format JPG
WIFI function Image transmission, remote control, setting, album sync and share Light source frequency 50HZ/60HZ
Wave length of infrared light 940nm
Support system Windows me/2000/XP/2003/Vista;Mac os 10.4 Win7
Charge voltage DC-5V
Interface and storage medium MINI 5 Pin USB, HDMI, MicroSD TF
Battery type High-capacity polymer lithium battery, battery capacity is 4000MA
Dimensions 131*41*15MM
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'metangla_osco667.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 from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '70' and opa.orders_id = opb.orders_id and opb.products_id != '70' 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 6