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