SELECT B.*, (SELECT COUNT(*) FROM PRODUK A LEFT JOIN PRODUK_KOMODITI C ON C.PRODUK_ID = A.ID LEFT JOIN KATEGORI D ON D.ID = A.KATEGORI_ID WHERE A.STATUS = 'Rilis' AND C.KOMODITI_ID = B.ID AND A.KATEGORI_ID = '10') TOTAL FROM KOMODITI B ORDER BY B.URUT