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 LEFT(A.KATEGORI_ID, 2) IN ('00', '01', '02', '03', '04', '05', '06', '07', '08', '09') AND (A.TENTANG LIKE ? OR A.ABOUT LIKE ?) AND A.KATEGORI_ID LIKE ? ORDER BY A.TAHUN DESC, A.TANGGAL DESC