Třídová akce

Kód:

3

Tělo:

SELECT A.Store_ID, A.StoreBatch_ID
FROM StoreSubBatches A
WHERE
  (A.Store_ID = :Store1 AND A.StoreBatch_ID = :StoreBatch1) OR
  (A.Store_ID = :Store2 AND A.StoreBatch_ID = :StoreBatch2) OR
  (A.Store_ID = :Store3 AND A.StoreBatch_ID = :StoreBatch3) OR
  (A.Store_ID = :Store4 AND A.StoreBatch_ID = :StoreBatch4) OR
  (A.Store_ID = :Store5 AND A.StoreBatch_ID = :StoreBatch5) OR
  (A.Store_ID = :Store6 AND A.StoreBatch_ID = :StoreBatch6) OR
  (A.Store_ID = :Store7 AND A.StoreBatch_ID = :StoreBatch7) OR
  (A.Store_ID = :Store8 AND A.StoreBatch_ID = :StoreBatch8) OR
  (A.Store_ID = :Store9 AND A.StoreBatch_ID = :StoreBatch9) OR
  (A.Store_ID = :Store10 AND A.StoreBatch_ID = :StoreBatch10) OR
  (A.Store_ID = :Store11 AND A.StoreBatch_ID = :StoreBatch11) OR
  (A.Store_ID = :Store12 AND A.StoreBatch_ID = :StoreBatch12) OR
  (A.Store_ID = :Store13 AND A.StoreBatch_ID = :StoreBatch13) OR
  (A.Store_ID = :Store14 AND A.StoreBatch_ID = :StoreBatch14) OR
  (A.Store_ID = :Store15 AND A.StoreBatch_ID = :StoreBatch15) OR
  (A.Store_ID = :Store16 AND A.StoreBatch_ID = :StoreBatch16) OR
  (A.Store_ID = :Store17 AND A.StoreBatch_ID = :StoreBatch17) OR
  (A.Store_ID = :Store18 AND A.StoreBatch_ID = :StoreBatch18) OR
  (A.Store_ID = :Store19 AND A.StoreBatch_ID = :StoreBatch19) OR
  (A.Store_ID = :Store20 AND A.StoreBatch_ID = :StoreBatch20) OR
  (A.Store_ID = :Store21 AND A.StoreBatch_ID = :StoreBatch21) OR
  (A.Store_ID = :Store22 AND A.StoreBatch_ID = :StoreBatch22) OR
  (A.Store_ID = :Store23 AND A.StoreBatch_ID = :StoreBatch23) OR
  (A.Store_ID = :Store24 AND A.StoreBatch_ID = :StoreBatch24) OR
  (A.Store_ID = :Store25 AND A.StoreBatch_ID = :StoreBatch25) OR
  (A.Store_ID = :Store26 AND A.StoreBatch_ID = :StoreBatch26) OR
  (A.Store_ID = :Store27 AND A.StoreBatch_ID = :StoreBatch27) OR
  (A.Store_ID = :Store28 AND A.StoreBatch_ID = :StoreBatch28) OR
  (A.Store_ID = :Store29 AND A.StoreBatch_ID = :StoreBatch29) OR
  (A.Store_ID = :Store30 AND A.StoreBatch_ID = :StoreBatch30) OR
  (A.Store_ID = :Store31 AND A.StoreBatch_ID = :StoreBatch31) OR
  (A.Store_ID = :Store32 AND A.StoreBatch_ID = :StoreBatch32) OR
  (A.Store_ID = :Store33 AND A.StoreBatch_ID = :StoreBatch33) OR
  (A.Store_ID = :Store34 AND A.StoreBatch_ID = :StoreBatch34) OR
  (A.Store_ID = :Store35 AND A.StoreBatch_ID = :StoreBatch35) OR
  (A.Store_ID = :Store36 AND A.StoreBatch_ID = :StoreBatch36) OR
  (A.Store_ID = :Store37 AND A.StoreBatch_ID = :StoreBatch37) OR
  (A.Store_ID = :Store38 AND A.StoreBatch_ID = :StoreBatch38) OR
  (A.Store_ID = :Store39 AND A.StoreBatch_ID = :StoreBatch39) OR
  (A.Store_ID = :Store40 AND A.StoreBatch_ID = :StoreBatch40) OR
  (A.Store_ID = :Store41 AND A.StoreBatch_ID = :StoreBatch41) OR
  (A.Store_ID = :Store42 AND A.StoreBatch_ID = :StoreBatch42) OR
  (A.Store_ID = :Store43 AND A.StoreBatch_ID = :StoreBatch43) OR
  (A.Store_ID = :Store44 AND A.StoreBatch_ID = :StoreBatch44) OR
  (A.Store_ID = :Store45 AND A.StoreBatch_ID = :StoreBatch45) OR
  (A.Store_ID = :Store46 AND A.StoreBatch_ID = :StoreBatch46) OR
  (A.Store_ID = :Store47 AND A.StoreBatch_ID = :StoreBatch47) OR
  (A.Store_ID = :Store48 AND A.StoreBatch_ID = :StoreBatch48) OR
  (A.Store_ID = :Store49 AND A.StoreBatch_ID = :StoreBatch49) OR
  (A.Store_ID = :Store50 AND A.StoreBatch_ID = :StoreBatch50)

Generated by ABRA Software a.s. 27.10.2021 16:34:11