ASUS Zenfone 4 A400CG 4" Black White red blue 4 inchi LED Backlight WSVGA resolusi 800x480/ Intel Atom Multi-Core Z2520 Processor 1.2 GHz/ Android OS, v4.3 (Jelly Bean)dapat di upgrade ke android KitKat v4.4 / GPRS, EDGE, HSDPA, HSUPA, Wi-Fi 802.11 b/g/n, Wi-Fi Direct, Wi-Fi hotspot, Bluetooth v4.0 A2DP, microUSB v2.0/2G, 3G. Dual SIM //5 MP auto fokus, 0.3 MP Front Camera 1GB RAM, 8GB storage, microSD slot sampai 32 GB/ / Batery 1600mAh
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 = '59' and opa.orders_id = opb.orders_id and opb.products_id != '59' 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