SELECT ac.name, COUNT(c.ref_id) as total FROM contribution c LEFT JOIN asset_category_m ac ON c.asset_category = ac.code LEFT JOIN asset_type_m at ON c.asset_type = at.code WHERE c.property_price > 0 AND c.property_price IS NOT NULL AND c.cluster_apart_name IS NOT NULL AND c.cluster_apart_name != '' AND c.cluster_apart_name NOT IN ('-', '000', 'NULL') AND (c.cluster_apart_name LIKE ? OR c.address LIKE ? OR c.city LIKE ? OR c.kecamatan LIKE ? OR c.kelurahan LIKE ? OR c.province LIKE ?) GROUP BY ac.name HAVING ac.name IS NOT NULL