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 (A.TENTANG LIKE '%08%' OR A.ABOUT LIKE '%08%') AND A.KATEGORI_ID LIKE '14%' ORDER BY A.TAHUN DESC, A.TANGGAL DESC Array ( [0] => %all% [1] => all [2] => %08% [3] => %14% )