batch fetch for all subscription query