franchise query was fixed