added COMPARE_IN_SUBQUERY to differentiate from COMPARE_IN for LIST