AHD DVR Standalone 4ch , HDMI, HYBRID, 720P
Spesifikasi :
  • Only Analog(DVR) 8*HD1 snapshot / 4*720P
  • Local+Network input 2*D1+1*1080P+1*720P
  • Only IP(NVR 9*D1 8*960H /4*720P 2*1080P/1*720 + 7*D1/1*1080P+1*720P+2*D1
  • HDD 2 SATA (each maximum support 3T)
  • Video Input 8ch BNC(1.0Vp-p,75
  • Video Output 1ch BNC(1.0Vp-p,75), 1ch VGA, 1ch HDMI
  • Power Supply 12V/4A
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'balirepl_toko.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, pd.products_name from orders_products opa, orders_products opb, orders o, products p LEFT JOIN products_description pd on p.products_id = pd.products_id where opa.products_id = '1040' and opa.orders_id = opb.orders_id and opb.products_id != '1040' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' and pd.language_id = '2' group by p.products_id order by o.date_purchased desc limit 6