Hi ,
The exact same query which returns the expected result-set in the version
1.4.187, is returning empty result set with both the versions 2.0.206 and
2.1.210. Can someone be able to help on this?
SELECT 80 AS EDCBA FROM abc_defghijkl_mnop_qrst_uvwx
WHERE id_abcdefghi_jkl = '0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( QW_ERTY <> 'CDEFG' )
AND ( QW_ERTY <> 'CDE' )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.85 )
AND ( MN_ZXCVA IN ('10 GH IJKL') )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 81 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( MNB_RTYU_LKJ_DSA <= 12 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( QW_ERTY <> 'CDE' )
AND ( MN_ZXCVA IN ('01 BCDE', '02 UV') )
AND ( JKL_ASD_POIUY = 'NO' )
AND ( ASDF1 = 1 ) UNION SELECT 82 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LM', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( QW_ERTY <> 'CDEFG' )
AND ( QW_ERTY <> 'CDE' )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.85 )
AND ( MN_ZXCVA IN ('01 MN GHIJ') )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 83 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( VBN_TYUIO = 'Y'
AND RS_TUVW_XYZAB <> '635510' )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 84 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( BIG_DECI_ORNGL_VAL/1000 <= 999 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 85 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( BIG_DECI_ORNGL_VAL/1000 <= 999 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( 1 = 2 )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 87 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( BIG_DECI_ORNGL_VAL/1000 <= 125 )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 88 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( 1 = 2 )
AND ( QW_ERTY <> 'CDE' )
AND ( BIG_DECI_ORNGL_VAL/1000 <= 125 )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 90 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( BIG_DECI_ORNGL_VAL/1000 <= 150 )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 91 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( 1 = 2 )
AND ( QW_ERTY <> 'CDE' )
AND ( BIG_DECI_ORNGL_VAL/1000 <= 150 )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 93 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( BIG_DECI_ORNGL_VAL/1000 <= 175 )
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 94 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( BIG_DECI_ORNGL_VAL/1000 <= 175 )
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( 1 = 2 )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 96 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( BIG_DECI_ORNGL_VAL/1000 <= 200 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 97 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( (BIG_DECI_ORNGL_VAL/1000) <= 85 )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 98 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( 1 = 2 )
AND ( QW_ERTY <> 'CDE' )
AND ( (BIG_DECI_ORNGL_VAL/1000) <= 85 )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 100 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( QWE_POIU = 'N' )
AND ( MN_ZXCVA IN ('20 GRH', '25 QWE', '99 QWE', '99 YUI 125', '99 YUI
999', '99 FHAQWE', '99 GRH', '99 LKJ 125') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 101 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QWE_POIU_MNBV_ZXC < 700 )
AND ( QW_ERTY <> 'CDE' )
AND ( QWE_POIU_MNBV_ZXC > 0 )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 102 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( 1 = 2 )
AND ( QWE_POIU_MNBV_ZXC < 700 )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 103 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( 1 = 2 ) UNION SELECT 104 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( 1 = 2 ) UNION SELECT 105 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( BN_LOPI_HGFDSA = 'I' )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 106 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( BN_LOPI_HGFDSA = 'I' )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( 1 = 2 )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 107 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( MN_ZXCVA_PURP IN ( 'ZWESDC') )
AND ( QW_ERTY <> 'CDE' )
AND ( TYU_GHJKL_ZAS_QAWSE > 99
AND TYU_GHJKL_ZAS_QAWSE <= 105 )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 108 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( MN_ZXCVA_PURP IN ( 'ZWESDC') )
AND ( QW_ERTY <> 'CDE' )
AND ( TYU_GHJKL_ZAS_QAWSE > 94
AND TYU_GHJKL_ZAS_QAWSE < 100 )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 109 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ((AB_WERTY_HJKLK_FGH <> '0X00'
AND AB_WERTY_HJKLK_FGH <> 'LMNOPQR'
AND AB_WERTY_HJKLK_FGH <> '1X00'
AND AB_WERTY_HJKLK_FGH <> '2X00'
AND AB_WERTY_HJKLK_FGH <> '3X00'
AND AB_WERTY_HJKLK_FGH <> '4X00'
AND AB_WERTY_HJKLK_FGH <> '5X00'
AND AB_WERTY_HJKLK_FGH <> '6X00'
AND AB_WERTY_HJKLK_FGH <> '7X00'
AND AB_WERTY_HJKLK_FGH <> '8X00'
AND AB_WERTY_HJKLK_FGH <> '9X00'
AND AB_WERTY_HJKLK_FGH <> '10X00'
AND AB_WERTY_HJKLK_FGH <> '11X00'
AND AB_WERTY_HJKLK_FGH <> '12X00'
AND AB_WERTY_HJKLK_FGH <> '1X01'
AND AB_WERTY_HJKLK_FGH <> '2X01'
AND AB_WERTY_HJKLK_FGH <> '3X01'
AND AB_WERTY_HJKLK_FGH <> '4X01'
AND AB_WERTY_HJKLK_FGH <> '5X01'
AND AB_WERTY_HJKLK_FGH <> '6X01'
AND AB_WERTY_HJKLK_FGH <> '7X01'
AND AB_WERTY_HJKLK_FGH <> '8X01'
AND AB_WERTY_HJKLK_FGH <> '9X01'
AND AB_WERTY_HJKLK_FGH <> '10X01'
AND AB_WERTY_HJKLK_FGH <> '11X01'
AND AB_WERTY_HJKLK_FGH <> '12X01') OR (ab_coded <> 'ABCDEF'
AND ab_coded <> 'BCDEFG') OR nb_qwer_tyu <= GETDATE())
AND (POI_VBNMCV_TYUUYT = 'N') OR QW_ERTY = 'ZYXXWV' )
AND ( QW_ERTY <> 'CDE' )
AND ( MN_ZXCVA IN ('23 125 SDF', '23 999 SDF', '00 BC', '00 JKLM', '10 GH
IJKL', '25 125 SDF', '25 999 SDF', '25 QWE', '02 UV', '01 BCDE', '01 MN
GHIJ', '25 BN BLN', '99 100SDF', '99 125 SDF', '99 999 SDF', '99 AFF MER',
'00AS 15/15', '99 BIC', '99 BIN', '99 BIW', '99 BIWQWE', '99 QWE', '99 YUI
125', '99 YUI 999', '99 FHAQWE', '99 GRH', '99 LKJ 125', '99 LKJ 999', '99
GRHQWE', '99 TYU', '99 TYUQWE', '00 RS', '99 SIMP', '99 SIMPQWE', '99 UF',
'99 UFQWE', '00 BCDE', '99 BN BLN', '99 BN BLNM', '00AS 10/20', '00AS
15/15', '30QWE', '30UA', '30UAQWE', '5 NBVC', '5 BN BLN', '7 NBVC', '7 BN
BLN', '7 BN BLNMO') )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 999 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( ZX_CVBN_NM = 'FG' )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 111 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( 1 = 2 )
AND ( ZX_CVBN_NM = 'FG' )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 112 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( MN_ZXCVA IN ('99 AFF MER', '99 BIC', '99 BIN', '99 BIW', '99
BIWQWE', '99 LKJ 125', '99 LKJ 999', '99 GRHQWE', '99 TYU', '99 TYUQWE',
'99 SIMP', '99 SIMPQWE', '99 UF', '99 UFQWE', '99 BN BLNM', '00AS 10/20',
'00AS 15/15', '30QWE', '30UA', '30UAQWE', '5 NBVC', '5 BN BLN', '7 NBVC',
'7 BN BLN', '7 BN BLNMO') )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 114 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' )
AND ( ZX_LKJHGFD = '4' ) UNION SELECT 115 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( 1 = 2 )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 116 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( 1 = 2 )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 117 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( QWE_POIU = 'Y' )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('20 125 SDF', '23 125 SDF', '25 125 SDF', '99 125
SDF') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 118 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( QWE_POIU = 'Y' )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( QW_ERTY <> 'CDE' )
AND ( MN_ZXCVA IN ('23 999 SDF', '25 999 SDF', '99 999 SDF', '20 999
SDF') )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 125 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( MNB_RTYU_LKJ_DSA<=6 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( MN_ZXCVA IN ('20 SC', '20 NBVC', '00 BC', '00 JKLM', '02 UV', '01
BCDE', '00 RS', '00 BCDE') )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' )
AND ( ISNULL(HIJK2, 'N') <> 'Y' ) UNION SELECT 133 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( MNB_RTYU_LKJ_DSA > 12 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDEFG' )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' )
AND ( ISNULL(HIJK2, 'N') <> 'Y' ) UNION SELECT 139 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( MN_ZXCVA_PURP IN ('LKJHGFDS') )
AND ( QW_ERTY <> 'CDE' )
AND ( TYU_GHJKL_ZAS_QAWSE > 94
AND TYU_GHJKL_ZAS_QAWSE < 106 )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 140 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( QW_ERTY = 'ABCDEF_ABCDEF' )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND nb_qwer_tyu > GETDATE()
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01') )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 142 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( BIG_DECI_ORNGL_VAL/1000 <= 225 )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 143 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( ZX_CVBN_NM = 'VB' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 145 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( ZX_CVBN_NM = 'FG' )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' )
AND ( ZX_LKJHGFD = '4' ) UNION SELECT 146 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( QW_ERTY = 'BCDE' OR (MNB_RTYU_LKJ_DSA > 12
AND QW_ERTY<>'ABCDEF_ABCDEF') )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 152 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( 1 = 2 ) UNION SELECT 153 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( PO_IUYT_REWQL_KJH IN ('H') )
AND ( MN_ZXCVA_PURP IN ('LKJHGFDS') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 155 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( MNB_RTYU_LKJ_DSA <= 12 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( RS_TUVW_XYZAB = 159184 )
AND ( JKL_ASD_POIUY = 'NO' )
AND ( HIJK4 IS NULL )
AND ( ISNULL(HIJK2, 'N') <> 'Y' ) UNION SELECT 158 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' )
AND ( QW_ERTY = 'BCDE'
AND ZX_LKJHGFD = '4' ) UNION SELECT 159 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( MNB_RTYU_LKJ_DSA<=12 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( MN_ZXCVA IN ('20 SC', '20 NBVC', '00 BC', '00 JKLM', '02 UV', '01
BCDE', '00 RS', '00 BCDE') )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' )
AND ( ISNULL(HIJK2, 'N') <> 'Y' ) UNION SELECT 164 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( ZX_CVBN_NM = 'XY' )
AND ( JKL_ASD_POIUY = 'NO' ) UNION SELECT 169 AS EDCBA FROM
abc_defghijkl_mnop_qrst_uvwx WHERE id_abcdefghi_jkl =
'0A2BCDE3-F456-789F-01GH-I2JKL3456M78'
AND ( ZXCV_MNB_QWER_LKJHG > 0 )
AND ( LKJH_GFDS > 0
AND LKJH_GFDS <= 0.50 )
AND ( ab_coded IN ('ABCDEF', 'BCDEFG')
AND AB_WERTY_HJKLK_FGH IN ('', '0X00', '1X00', 'LMNOPQR', '2X00', '3X00',
'4X00', '5X00', '6X00', '7X00', '8X00', '9X00', '10X00', '11X00', '12X00',
'1X01', '2X01', '3X01', '4X01', '5X01', '6X01', '7X01', '8X01', '9X01',
'10X01', '11X01', '12X01')
AND QW_ERTY <> 'ZYXXWV'
AND QW_ERTY <> 'ABCDEF_ABCDEF'
AND QW_ERTY <> 'BCDE' )
AND ( BIG_DECI_ORNGL_VAL/1000 <= 250 )
AND ( MN_ZXCVA IN ('00 BC', '00 JKLM', '02 UV', '01 BCDE', '00 RS', '00
BCDE') )
AND ( QW_ERTY <> 'CDE' )
AND ( JKL_ASD_POIUY = 'NO' )
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/dddcdf14-fdef-46af-80ce-b8afbad0ba24n%40googlegroups.com.
