Query in latest version is returning empty results
54 views
Skip to first unread message
Ajay Bhide
Feb 12, 2022, 2:17:05 AM2/12/22
to H2 Database
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' )
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' )
Andreas Reichel
Feb 12, 2022, 3:08:21 AM2/12/22
to h2-da...@googlegroups.com
On Fri, 2022-02-11 at 11:57 -0800, Ajay Bhide wrote:
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?
Based on your example, you may better ask the Perl obfuscation contest for help.
Best regards
Andreas
cbvm...@googlemail.com
Feb 12, 2022, 4:09:25 AM2/12/22
to H2 Database
In order to diagnose such an issue you need to strip the query down to a reasonable small sized example. To get an idea what you can do:
1) decopose the union parts of the query and check for differences
2) analyze the AND claues in the where condition to see which part possibly causes the differnce
Developers need a very comprehensive standalone testcase in order to further diagnose a possible issue.
Reards,
Christian
Reply all
Reply to author
Forward
Message has been deleted
0 new messages