SELECT A.*, B.KATEGORI, B.SINGKATAN, B.CATEGORY, B.ABBREVIATION FROM PRODUK A LEFT JOIN KATEGORI B ON B.ID = A.KATEGORI_ID WHERE A.STATUS = 'Rilis' AND (SELECT COUNT(*) FROM PRODUK_KOMODITI WHERE PRODUK_ID = A.ID) > 0 AND A.ID IN (SELECT PRODUK_ID FROM PRODUK_KOMODITI WHERE KOMODITI_ID = ?) ORDER BY A.TAHUN DESC, A.TANGGAL DESC