well, obviously you should check each clause of the where statement on its own before combining them - for example, do a
select discrete stall
for example to make sure there's an 'A5' value, remove the EFTPos phrase from the select to see if you get results, and if you do, that's where you work next
you may wish to think about this, for the EFTPos part
EFTPos = cast(1 as bit)