Panoramic Wireless IP Camera 720P - FV-1201

Technical Specifications:
Lens :1.4mm (180 degree Fish eye)
Display Max. Resolution: 1280 x 720
Networking: Wireless standard: IEEE802.11b/g/n
A/V Out: 720p
Storage: up to 128 GB
Interface Provided: 1x Power port
Power Supply DC: 5V 1.5A
Power Comsumption : <5W
Maximum Frame Rate : 25 Frames
Infrared Distance : 10 Meters
Frequency range: 2.4GHz-2.4835GHz
Intercom : Support
Video compression standard: H.264
Audio compression standard: G.711
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 = '71' and opa.orders_id = opb.orders_id and opb.products_id != '71' 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