SELECT B.*, (SELECT COUNT(*) FROM PRODUK A WHERE A.STATUS = 'Rilis' AND LEFT(A.KATEGORI_ID, 2) = B.ID  AND LEFT(A.KATEGORI_ID, 2) IN ('00', '01', '02', '03', '04', '05', '06', '07', '08', '09')  AND (A.TENTANG LIKE '%08%' OR A.ABOUT LIKE '%08%') ) TOTAL FROM KATEGORI B ORDER BY B.URUTAN