<select><query_expression><query><select_list><source_column><source>s</source><column>splsid</column></source_column><source_column><source>s</source><column>wzjbxxId</column></source_column><source_column><source>s</source><column>SpZt</column></source_column><source_column><source>s</source><column>splzbID</column></source_column><source_column><source>s</source><column>StepID</column></source_column><source_column><source>s</source><column>StartTime</column></source_column><alised_column><bracket><query><select_list top="1"><column>stepid</column></select_list><from><table>spldyb</table></from><where><expression><column>splzbid</column><operator>=</operator><source_column><source>s</source><column>splzbid</column></source_column><operator>and</operator><column>stepid</column><operator>&gt;</operator><source_column><source>s</source><column>stepid</column></source_column></expression></where><order_by><column desc="0">stepid</column></order_by></query></bracket><column_alias>nextStepid</column_alias></alised_column><source_column><source>s</source><column>dqtpzt</column></source_column><source_column><source>d</source><column>tptgbl</column></source_column><alised_column><bracket><query><select_list><count><value>1</value></count></select_list><from><table>groupitem</table></from><where><expression><column>groupid</column><operator>=</operator><value>1</value></expression></where></query></bracket><column_alias>tprs</column_alias></alised_column><source_column><source>w</source><column>zt</column></source_column><source_column><source>w</source><column>zz</column></source_column><source_column><source>w</source><column>gpdm</column></source_column><source_column><source>w</source><column>gpmc</column></source_column><source_column><source>w</source><column>xghy</column></source_column><source_column><source>w</source><column>bgrq</column></source_column><source_column><source>w</source><column>bgflmc</column></source_column><source_column><source>w</source><column>tzjymc</column></source_column><source_column><source>w</source><column>zyxmc</column></source_column><source_column><source>w</source><column>wzmjmc</column></source_column></select_list><from><aliased_table><table>spls</table><table_alias>s</table_alias></aliased_table><aliased_table><table>vwwzjbxx2</table><table_alias>w</table_alias></aliased_table><aliased_table><table>spldyb</table><table_alias>d</table_alias></aliased_table></from><where><expression><source_column><source>d</source><column>splx</column></source_column><operator>=</operator><value>2</value><operator>and</operator><source_column><source>d</source><column>groupRoleID</column></source_column><operator>like</operator><value>'%1%'</value><operator>and</operator><source_column><source>s</source><column>splzbid</column></source_column><operator>=</operator><source_column><source>d</source><column>splzbid</column></source_column><operator>and</operator><source_column><source>s</source><column>stepid</column></source_column><operator>=</operator><source_column><source>d</source><column>stepid</column></source_column><operator>and</operator><source_column><source>s</source><column>Spzt</column></source_column><in><bracket><value>1</value></bracket></in><operator>and</operator><source_column><source>s</source><column>IsStepFinish</column></source_column><operator>=</operator><value>0</value><operator>and</operator><source_column><source>s</source><column>splsid</column></source_column><not_in><bracket><query><select_list><column>splsid</column></select_list><from><table>tpls</table></from><where><expression><column>tprid</column><operator>=</operator><value>220</value></expression></where></query></bracket></not_in><operator>and</operator><source_column><source>s</source><column>stepid</column></source_column><operator>&lt;&gt;</operator><value>99</value><operator>and</operator><source_column><source>w</source><column>wzjbxxid</column></source_column><operator>=</operator><source_column><source>s</source><column>wzjbxxid</column></source_column><operator>and</operator><source_column><source>w</source><column>scbz</column></source_column><operator>&lt;&gt;</operator><value>1</value></expression></where></query></query_expression></select>