changes in footer and dashboard view query for count a unpaid subscription