gistfile1.txt

select * from (SELECT a.manifest_label,a.cos,x.status FROM manifest_approval a, manifest_approval_history h, manifest_approval_action x where manifest_label in ('commercesetupnodeweb-1.2.0_20190924210218860', 'commercesetupnodeweb-1.2.0_20190925124406157', 'commercesetupnodeweb-1.1.3_2019092415463768', 'commercesetupnodeweb-1.1.3_20190924144432630', 'commercesetupnodeweb-1.1.3_20190923164432256', 'commercesetupnodeweb-1.1.3_20190923154136989', 'commercesetupnodeweb-1.1.3_20190922225234618', 'commercesetupnodeweb-1.1.3_20190922233835112', 'commercesetupnodeweb-1.1.2_20190922145056771', 'commercesetupnodeweb-1.1.2_20190921220059754', 'commercesetupnodeweb-1.1.2_20190920220652189', 'commercesetupnodeweb-1.1.2_20190918124024272', 'commercesetupnodeweb-1.1.2_20190917132435888', 'commercesetupnodeweb-1.1.2_20190916164942679', 'commercesetupnodeweb-1.1.2_20190916165027142', 'commercesetupnodeweb-1.1.2_20190916134019187', 'commercesetupnodeweb-1.1.1_2019091310434924', 'commercesetupnodeweb-1.1.1_2019091216405973', 'commercesetupnodeweb-1.1.1_20190912162508741', 'commercesetupnodeweb-1.1.1_20190912114216308', 'commercesetupnodeweb-1.1.1_20190912094041932', 'commercesetupnodeweb-1.1.1_20190911174039688', 'commercesetupnodeweb-1.1.1_20190910154125865', 'commercesetupnodeweb-1.1.1_2019091012431910', 'commercesetupnodeweb-1.1.1_20190910121913227', 'commercesetupnodeweb-1.1.1_20190910074218896', 'commercesetupnodeweb-1.1.1_20190910063956903', 'commercesetupnodeweb-1.1.1_20190905104424865', 'commercesetupnodeweb-1.1.1_20190903144321668', 'commercesetupnodeweb-1.1.1_20190903110300717', 'commercesetupnodeweb-1.1.1_20190903104438698', 'commercesetupnodeweb-1.1.1_20190902215308750', 'commercesetupnodeweb-1.1.1_20190902084238717', 'commercesetupnodeweb-1.1.1_2019083015390879', 'commercesetupnodeweb-1.1.1_20190830153844817', 'commercesetupnodeweb-1.1.1_20190830124342557', 'commercesetupnodeweb-1.1.1_20190830114250907', 'commercesetupnodeweb-1.1.1_20190829110231814', 'commercesetupnodeweb-1.1.0_20190829122526891', 'commercesetupnodeweb-1.1.1_20190829101428223', 'commercesetupnodeweb-1.1.1_20190828164814712', 'commercesetupnodeweb-1.1.1_20190828164229503', 'commercesetupnodeweb-1.1.0_2019082815441860', 'commercesetupnodeweb-1.1.0_20190828145704442', 'commercesetupnodeweb-1.0.3_20190828144705222', 'commercesetupnodeweb-1.0.3_2019082813495486', 'commercesetupnodeweb-1.1.0_20190828124347852', 'commercesetupnodeweb-1.1.0_20190828102328670', 'commercesetupnodeweb-1.1.0_2019082612402784', 'commercesetupnodeweb-1.1.0_20190826123312174', 'commercesetupnodeweb-1.1.0_20190823153030993', 'commercesetupnodeweb-1.1.0_2019082314112613', 'commercesetupnodeweb-1.1.0_20190823134326919', 'commercesetupnodeweb-1.1.0_20190821113244373', 'commercesetupnodeweb-1.1.0_20190821121144145', 'commercesetupnodeweb-1.1.0_20190821114128918', 'commercesetupnodeweb-1.1.0_20190820160637116', 'commercesetupnodeweb-1.1.0_20190820154228292', 'commercesetupnodeweb-1.0.5_20190820153752676', 'commercesetupnodeweb-1.1.0_20190820151707269', 'commercesetupnodeweb-1.1.0_20190820151542493', 'commercesetupnodeweb-1.0.5_20190820150343366', 'commercesetupnodeweb-1.0.5_20190820145602708', 'commercesetupnodeweb-1.0.5_20190820144947439', 'commercesetupnodeweb-1.0.5_20190820143859821', 'commercesetupnodeweb-1.0.5_20190820141545901', 'commercesetupnodeweb-1.0.5_20190820135519924', 'commercesetupnodeweb-1.0.5_20190820120830558', 'commercesetupnodeweb-1.0.5_20190820111302426', 'commercesetupnodeweb-1.0.5_20190819154222239', 'commercesetupnodeweb-1.0.5_20190819143628839', 'commercesetupnodeweb-1.0.5_20190819135924418', 'commercesetupnodeweb-1.0.5_20190819130127162', 'commercesetupnodeweb-1.0.5_20190819095312442', 'commercesetupnodeweb-1.0.5_20190816193311188', 'commercesetupnodeweb-1.0.5_20190815111156856', 'commercesetupnodeweb-1.0.5_20190815101349478', 'commercesetupnodeweb-1.0.5_20190815090744450', 'commercesetupnodeweb-1.0.5_20190815084514609', 'commercesetupnodeweb-1.0.5_20190815010953569', 'commercesetupnodeweb-1.0.5_20190815001117612', 'commercesetupnodeweb-1.0.5_20190815000732204', 'commercesetupnodeweb-1.0.5_20190812161059852', 'commercesetupnodeweb-1.0.5_20190812154652844', 'commercesetupnodeweb-1.0.5_20190812124449147', 'commercesetupnodeweb-1.0.5_20190812120915488', 'commercesetupnodeweb-1.0.5_20190812070412871', 'commercesetupnodeweb-1.0.5_20190812064023204', 'commercesetupnodeweb-1.0.5_20190809170911285', 'commercesetupnodeweb-1.0.5_20190809164824263', 'commercesetupnodeweb-1.0.5_20190809121228748', 'commercesetupnodeweb-1.0.5_20190809115127255', 'commercesetupnodeweb-1.0.5_20190805144043241', 'commercesetupnodeweb-1.0.5_2019080516215441', 'commercesetupnodeweb-1.0.5_20190805155045811', 'commercesetupnodeweb-1.0.5_20190805151422277', 'commercesetupnodeweb-1.0.5_20190805145238580', 'commercesetupnodeweb-1.0.5_20190805130933499', 'commercesetupnodeweb-1.0.5_20190805125023231', 'commercesetupnodeweb-1.0.5_20190801174814408', 'commercesetupnodeweb-1.0.5_20190801171318676', 'commercesetupnodeweb-1.0.5_20190731225730407', 'commercesetupnodeweb-1.0.5_2019073122580201', 'commercesetupnodeweb-1.0.5_2019073122481252', 'commercesetupnodeweb-1.0.5_20190723230750912', 'commercesetupnodeweb-1.0.3_20190723230502866', 'commercesetupnodeweb-1.0.5_2019072316193369', 'commercesetupnodeweb-1.0.5_20190723155004921', 'commercesetupnodeweb-1.0.5_20190723131311642', 'commercesetupnodeweb-1.0.3_20190723122818959', 'commercesetupnodeweb-1.0.5_20190722135346503', 'commercesetupnodeweb-1.0.5_20190722130528601', 'commercesetupnodeweb-1.0.5_20190718164734459', 'commercesetupnodeweb-1.0.5_20190718170950392', 'commercesetupnodeweb-1.0.5_20190718165328638', 'commercesetupnodeweb-1.0.4_20190718154746782', 'commercesetupnodeweb-1.0.4_2019071815281065', 'commercesetupnodeweb-1.0.4_20190718141301673', 'commercesetupnodeweb-1.0.4_20190718134136171', 'commercesetupnodeweb-1.0.4_20190718121252167', 'commercesetupnodeweb-1.0.4_20190718114750314', 'commercesetupnodeweb-1.0.4_20190718101503493', 'commercesetupnodeweb-1.0.4_20190718094532291', 'commercesetupnodeweb-1.0.4_20190717114752332', 'commercesetupnodeweb-1.0.4_20190716202821802', 'commercesetupnodeweb-1.0.4_2019071620561267', 'commercesetupnodeweb-1.0.4_2019071616581259', 'commercesetupnodeweb-1.0.4_20190716165555382', 'commercesetupnodeweb-1.0.4_20190716155509129', 'commercesetupnodeweb-1.0.4_2019071615495575', 'commercesetupnodeweb-1.0.4_2019071615371169', 'commercesetupnodeweb-1.0.3_20190716135143859', 'commercesetupnodeweb-1.0.3_20190716134832337', 'commercesetupnodeweb-1.0.3_20190716131041747', 'commercesetupnodeweb-1.0.3_20190716105013815', 'commercesetupnodeweb-1.0.3_20190716101417219', 'commercesetupnodeweb-1.0.3_20190712204557857', 'commercesetupnodeweb-1.0.3_20190712201307673', 'commercesetupnodeweb-1.0.3_20190712170811910', 'commercesetupnodeweb-1.0.3_20190712164321690', 'commercesetupnodeweb-1.0.3_2019071113472680', 'commercesetupnodeweb-1.0.3_20190710154628993', 'commercesetupnodeweb-1.0.3_20190709124319440', 'commercesetupnodeweb-1.0.3_20190709121537715', 'commercesetupnodeweb-1.0.3_20190708204612309', 'commercesetupnodeweb-1.0.3_20190708154252871', 'commercesetupnodeweb-1.0.3_20190702094505650', 'commercesetupnodeweb-1.0.3_20190701144552561', 'commercesetupnodeweb-1.0.2_20190621204622920', 'commercesetupnodeweb-1.0.3_20190620225930928', 'commercesetupnodeweb-1.0.3_20190620215004337', 'commercesetupnodeweb-1.0.2_20190610202224702', 'commercesetupnodeweb-1.0.3_20190610144415207', 'commercesetupnodeweb-1.0.3_20190610141529767', 'commercesetupnodeweb-1.0.3_20190604104423944', 'commercesetupnodeweb-1.0.3_20190604101257789', 'commercesetupnodeweb-1.0.3_20190530173900513', 'commercesetupnodeweb-1.0.3_20190530174239750', 'commercesetupnodeweb-1.0.3_20190530171137876', 'commercesetupnodeweb-1.0.2_20190530164817144', 'commercesetupnodeweb-1.0.2_20190530161612649', 'commercesetupnodeweb-1.0.2_2019053015484613', 'commercesetupnodeweb-1.0.2_20190530151336411', 'commercesetupnodeweb-1.0.2_20190530134737803', 'commercesetupnodeweb-1.0.2_20190530111958629', 'commercesetupnodeweb-1.0.2_20190528124547329', 'commercesetupnodeweb-1.0.2_20190528122504982', 'commercesetupnodeweb-1.0.2_20190528114643131', 'commercesetupnodeweb-1.0.2_20190528095223792', 'commercesetupnodeweb-1.0.2_2019052802144546', 'commercesetupnodeweb-1.0.2_20190528014528645', 'commercesetupnodeweb-1.0.2_20190523151146698', 'commercesetupnodeweb-1.0.2_20190523144859785', 'commercesetupnodeweb-1.0.2_20190522182844388', 'commercesetupnodeweb-1.0.2_20190522144754159', 'commercesetupnodeweb-1.0.2_20190522141057847', 'commercesetupnodeweb-1.0.2_20190517105733397', 'commercesetupnodeweb-1.0.2_20190516114707898', 'commercesetupnodeweb-1.0.2_20190516111548919', 'commercesetupnodeweb-1.0.2_20190514214743666', 'commercesetupnodeweb-1.0.2_20190514174754325', 'commercesetupnodeweb-1.0.2_20190514171203391', 'commercesetupnodeweb-1.0.2_20190514171104108', 'commercesetupnodeweb-1.0.1_20190514164935356', 'commercesetupnodeweb-1.0.1_2019051414500768', 'commercesetupnodeweb-1.0.1_20190514131444854', 'commercesetupnodeweb-1.0.1_20190514124943699', 'commercesetupnodeweb-1.0.1_20190514123548461', 'commercesetupnodeweb-1.0.1_20190514123141623', 'commercesetupnodeweb-1.0.1_20190513215131199', 'commercesetupnodeweb-1.0.1_20190513184531956', 'commercesetupnodeweb-1.0.1_20190513184527804', 'commercesetupnodeweb-1.0.1_20190513183942598', 'commercesetupnodeweb-1.0.1_20190513174306823', 'commercesetupnodeweb-1.0.1_20190513171413124', 'commercesetupnodeweb-1.0.1_20190513171233842', 'commercesetupnodeweb-1.0.1_20190513164816334', 'commercesetupnodeweb-1.0.1_2019051316393767', 'commercesetupnodeweb-1.0.1_20190513125037942', 'commercesetupnodeweb-1.0.1_20190513121649123') and a.id=h.manifest_approval_id and h.step in ('MANIFEST_APPROVAL','RM_APPROVAL') and h.action ='Approve' and a.id = x.manifest_approval_id order by a.create_time desc ) t1 group by manifest_label, cos, status