Problem 5
Is there a difference?
SELECT … FROM … WHERE …
   AND :B1 = 1
UNION SELECT … FROM … WHERE …
   AND :B1 = 2;
Versus:
SELECT … FROM … WHERE …
   AND :B1 = 1
UNION ALL SELECT … FROM … WHERE …
   AND :B1 = 2;