SELECT SentryGroupID, SentryGroupID, *
FROM BattleDetails
WHERE ((Complete=0) AND (SecGroupID= " &vGroup & ") AND (GroupID<>" &vGroup & ")) OR ((Complete=0) AND (SecGroupID=4) AND (GroupID<>" &vGroup & ") AND (SentryGroupID=4)) Or  ((Complete=0) AND (SentryGroupID=" &vGroup & ")) ORDER BY Battleid;