barang yg tidak ada ordernya

CREATE TABLE barang(
id CHAR(3),
nama_barang VARCHAR(30)
);

INSERT INTO barang VALUES
('101','Macbook Air 11'),
('102','Asus Laptop'),
('103','Lenovo All in One'),
('104','Ac Split LG');

SELECT * FROM barang;
+------+-------------------+
| id   | nama_barang       |
+------+-------------------+
| 101  | Macbook Air 11    |
| 102  | Asus Laptop       |
| 103  | Lenovo All in One |
| 104  | Ac Split LG       |
+------+-------------------+
4 rows in set (0.00 sec)


CREATE TABLE order_barang(
id_order VARCHAR(11),
id_barang CHAR(3),
tahun_order CHAR(4)
);

INSERT INTO order_barang VALUES
('OR-001/2015','101','2015'),
('OR-002/2015','103','2015'),
('OR-003/2015','102','2015'),
('OR-120/2014','104','2014'),
('OR-119/2014','102','2014'),
('OR-118/2014','103','2014'),
('OR-117/2014','102','2014');

SELECT * FROM order_barang;
+-------------+-----------+-------------+
| id_order    | id_barang | tahun_order |
+-------------+-----------+-------------+
| OR-001/2015 | 101       | 2015        |
| OR-002/2015 | 103       | 2015        |
| OR-003/2015 | 102       | 2015        |
| OR-120/2014 | 104       | 2014        |
| OR-119/2014 | 102       | 2014        |
| OR-118/2014 | 103       | 2014        |
| OR-117/2014 | 102       | 2014        |
+-------------+-----------+-------------+
7 rows in set (0.00 sec)

SELECT x.tahun_order,d.nama_barang
FROM
(
SELECT DISTINCT a.id,b.tahun_order
FROM
barang a, order_barang b
) x
LEFT JOIN order_barang c ON c.tahun_order=x.tahun_order AND x.id=c.id_barang
JOIN barang d USING(id)
WHERE c.id_barang IS NULL;

+-------------+----------------+
| tahun_order | nama_barang    |
+-------------+----------------+
| 2015        | Ac Split LG    |
| 2014        | Macbook Air 11 |
+-------------+----------------+
2 rows in set (0.00 sec)

SELECT b.tahun_order,a.nama_barang
FROM barang a
JOIN (
SELECT DISTINCT tahun_order FROM order_barang
) b ON 1=1
LEFT JOIN order_barang c ON a.id=c.id_barang AND b.tahun_order=c.tahun_order
WHERE c.id_order IS NULL;

+-------------+----------------+
| tahun_order | nama_barang    |
+-------------+----------------+
| 2014        | Macbook Air 11 |
| 2015        | Ac Split LG    |
+-------------+----------------+
2 rows in set (0.00 sec)