SELECT
*
FROM
(
SELECT
row_.*, ROWNUM rownum_
FROM
(
SELECT
pk_wf_instance,
startts
FROM
pub_wf_instance
WHERE
billtype IN (
'H544',
'H543',
'H546',
'H545',
'H542',
'2641',
'H5W0',
'H541',
'4A00-01',
'F0-Cxx-02',
'H5W5',
'F2-Cxx-04-sq',
'4A18',
'4A19',
'H583',
'263X',
'4A14',
'4A19-01',
'F2-Cxx-02',
'4A18-01',
'4A35-01',
'25-01',
'F0-Cxx-03',
'H541-Cxx-1',
'F2-Cxx-03-sh',
'264X-Cxx-S003',
'264X-Cxx-S002',
'264X-Cxx-S001',
'H58E',
'30-01',
'36D1-Cxx-005',
'36D1-Cxx-006',
'36D1-Cxx-003',
'5X',
'zdydj',
'36D1-Cxx-004',
'36D1-Cxx-001',
'36D1-Cxx-002',
'4A14-01',
'H583-Cxx-1',
'262X-Cxx--005-sjjt',
'H541-Cxx-01',
'H541-Cxx-02',
'25',
'264X',
'zdydj-Cxx-001-sq',
'36D1',
'F1',
'4A00',
'F0',
'H541-Cxx-04',
'30',
'H541-Cxx-03',
'F3',
'F2',
'263X-Cxx-TYJKD',
'36D1-Cxx-008',
'36D1-Cxx-007',
'F3-Cxx-04-gh',
'F3-Cxx-02',
'21-01',
'H5A1-Cxx-1',
'F0-Cxx-003-kp',
'F3-Cxx-03-zf',
'21',
'20',
'H5W5-02',
'H5W5-03',
'H5W5-04',
'4A35',
'H5W5-01',
'F1-Cxx-06',
'F1-Cxx-04',
'zdydj-Cxx-004-gcqs',
'F1-Cxx-004-zg',
'422X',
'F1-Cxx-003-sp',
'422X-01',
'H542-Cxx-04',
'262X',
'20-01',
'H542-Cxx-03',
'264X-Cxx-006-sjjn',
'H542-Cxx-02',
'H542-Cxx-01',
'D2',
'264X-Cxx-TYBXD',
'D3',
'F1-Cxx-006-sb',
'D0',
'H542-Cxx-1',
'D1',
'F1-Cxx-02',
'5X-01'
)
AND pk_wf_instance NOT IN (
SELECT
pk_wf_instance
FROM
pub_wf_task
WHERE
tasktype <> 1
AND taskstatus = 1
OR (tasktype = 1 AND taskstatus = 0)
)
AND billmaker = '0001A3100000000097MF'
AND workflow_type = 2
AND procstatus = 0
AND startts < '2019-06-14 23:59:59'
ORDER BY
startts DESC
) row_
WHERE
ROWNUM <= 10
)
WHERE
rownum_ > 0
