removed highlight exclusion for has_structures=false and has_ab=false
fixed bug with retrieved division name by restoring subquery
spelling
used 'is not true' rather than 'is false'
fixed bug that excluded new orders by converting an implicit inner join to a left join