and { only { filter_not_eq { all_rows ; deleted ; - } } ; eq { hop { filter_not_eq { all_rows ; deleted ; - } ; name } ; mowbray engineering } } = true
select the rows whose deleted record is not equal to  . there is only one such row in the table . the name record of this unqiue row is mowbray engineering .