2024-08-06 01:00:03 -- 將會員中心id寫入data-lake
2024-08-06 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-08-05%';
        
2024-08-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378564'
                WHERE ordernumber = 'P180805110107620' 
            
2024-08-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190805110230982' 
            
2024-08-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133443'
                WHERE ordernumber = 'P180805110503376' 
            
2024-08-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405493'
                WHERE ordernumber = 'P200805110603156' 
            
2024-08-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238273'
                WHERE ordernumber = 'P200805110949731' 
            
2024-08-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405495'
                WHERE ordernumber = 'P180805111216134' 
            
2024-08-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405496'
                WHERE ordernumber = 'P420805111229840' 
            
2024-08-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323980'
                WHERE ordernumber = 'P180805111334659' 
            
2024-08-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405497'
                WHERE ordernumber = 'P420805111507417' 
            
2024-08-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P200805111726393' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405500'
                WHERE ordernumber = 'P420805111748537' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405501'
                WHERE ordernumber = 'P420805111919486' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93992'
                WHERE ordernumber = 'P590805111923358' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '35290'
                WHERE ordernumber = 'P420805112125304' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400648'
                WHERE ordernumber = 'P420805112557298' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377912'
                WHERE ordernumber = 'P180805112639552' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405502'
                WHERE ordernumber = 'P180805113400930' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405505'
                WHERE ordernumber = 'P180805114004600' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405506'
                WHERE ordernumber = 'P420805114045810' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402011'
                WHERE ordernumber = 'P180805114510705' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P200805115040453' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103594'
                WHERE ordernumber = 'P180805115451899' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374183'
                WHERE ordernumber = 'P420805115509524' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355358'
                WHERE ordernumber = 'P420805115554613' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405510'
                WHERE ordernumber = 'P180805115659717' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180805120233654' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348028'
                WHERE ordernumber = 'P180805120503860' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405512'
                WHERE ordernumber = 'P180805120553239' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405513'
                WHERE ordernumber = 'P420805120647444' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82364'
                WHERE ordernumber = 'P180805121948497' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405514'
                WHERE ordernumber = 'P180805122350728' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245393'
                WHERE ordernumber = 'P200805122601467' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227746'
                WHERE ordernumber = 'P420805123426654' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405516'
                WHERE ordernumber = 'P420805123604193' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405517'
                WHERE ordernumber = 'P200805123639411' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405520'
                WHERE ordernumber = 'P420805124415434' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405521'
                WHERE ordernumber = 'P180805124538774' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328001'
                WHERE ordernumber = 'P420805124614506' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405523'
                WHERE ordernumber = 'P200805124927704' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405523'
                WHERE ordernumber = 'P200805125205726' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355358'
                WHERE ordernumber = 'P420805125625343' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355358'
                WHERE ordernumber = 'P420805125721111' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405525'
                WHERE ordernumber = 'P190805125738278' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304578'
                WHERE ordernumber = 'P200805130034529' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302881'
                WHERE ordernumber = 'P200805130532601' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384980'
                WHERE ordernumber = 'P200805131202205' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294872'
                WHERE ordernumber = 'P180805131709760' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405531'
                WHERE ordernumber = 'P420805131750394' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405533'
                WHERE ordernumber = 'P180805132423161' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P420805133126989' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405535'
                WHERE ordernumber = 'P420805133446218' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120228'
                WHERE ordernumber = 'P180805133745785' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344546'
                WHERE ordernumber = 'P420805133814783' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405538'
                WHERE ordernumber = 'P420805135039207' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405540'
                WHERE ordernumber = 'P180805135229832' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281362'
                WHERE ordernumber = 'P180805135855461' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330295'
                WHERE ordernumber = 'P420805135859166' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405541'
                WHERE ordernumber = 'P200805140020851' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200805140529460' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405542'
                WHERE ordernumber = 'P180805140702839' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405543'
                WHERE ordernumber = 'P180805140819143' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119418'
                WHERE ordernumber = 'P180805142924165' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405550'
                WHERE ordernumber = 'P180805144556532' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303485'
                WHERE ordernumber = 'P180805144820961' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405552'
                WHERE ordernumber = 'P190805144922769' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274717'
                WHERE ordernumber = 'P180805145039129' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224548'
                WHERE ordernumber = 'P200805150206513' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405554'
                WHERE ordernumber = 'P180805150209284' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405555'
                WHERE ordernumber = 'P420805150617234' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405559'
                WHERE ordernumber = 'P190805150724636' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211164'
                WHERE ordernumber = 'P190805151046545' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161965'
                WHERE ordernumber = 'P200805151235447' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405561'
                WHERE ordernumber = 'P420805151346365' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405562'
                WHERE ordernumber = 'P420805151709598' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403135'
                WHERE ordernumber = 'P190805152051618' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180805152532121' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133492'
                WHERE ordernumber = 'P200805153106456' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397933'
                WHERE ordernumber = 'P420805153221728' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319694'
                WHERE ordernumber = 'P200805153852579' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405568'
                WHERE ordernumber = 'P180805153957116' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405568'
                WHERE ordernumber = 'P180805154113705' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405570'
                WHERE ordernumber = 'P420805155123625' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272572'
                WHERE ordernumber = 'P420805155536545' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405408'
                WHERE ordernumber = 'P180805155953761' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344885'
                WHERE ordernumber = 'P420805160510476' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316185'
                WHERE ordernumber = 'P420805160654519' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405572'
                WHERE ordernumber = 'P180805160714908' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405576'
                WHERE ordernumber = 'P420805160820814' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420805161047882' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332953'
                WHERE ordernumber = 'P420805161218530' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405575'
                WHERE ordernumber = 'P180805161421286' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405579'
                WHERE ordernumber = 'P420805161653813' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405582'
                WHERE ordernumber = 'P200805161819193' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405578'
                WHERE ordernumber = 'P630805161833240' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405584'
                WHERE ordernumber = 'P200805162303234' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405586'
                WHERE ordernumber = 'P180805162322433' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143595'
                WHERE ordernumber = 'P200805162419381' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405587'
                WHERE ordernumber = 'P420805163217633' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386765'
                WHERE ordernumber = 'P200805163305598' 
            
2024-08-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399529'
                WHERE ordernumber = 'P200805164154426' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346474'
                WHERE ordernumber = 'P180805164555328' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405590'
                WHERE ordernumber = 'P180805164757748' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329666'
                WHERE ordernumber = 'P180805165849417' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286596'
                WHERE ordernumber = 'P180805165939186' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405592'
                WHERE ordernumber = 'P180805170114940' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306710'
                WHERE ordernumber = 'P180805170152631' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405594'
                WHERE ordernumber = 'P420805170448984' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159220'
                WHERE ordernumber = 'P200805170748905' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98527'
                WHERE ordernumber = 'P200805170836421' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297531'
                WHERE ordernumber = 'P200805171100214' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405596'
                WHERE ordernumber = 'P420805171403453' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396477'
                WHERE ordernumber = 'P420805171454896' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214805'
                WHERE ordernumber = 'P190805172014459' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137176'
                WHERE ordernumber = 'P630805172452465' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P200805172901162' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405598'
                WHERE ordernumber = 'P420805173158144' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235882'
                WHERE ordernumber = 'P630805173548937' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289556'
                WHERE ordernumber = 'P180805173857212' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405599'
                WHERE ordernumber = 'P420805174024621' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398350'
                WHERE ordernumber = 'P420805174132563' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159314'
                WHERE ordernumber = 'P200805174420897' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377483'
                WHERE ordernumber = 'P200805174716727' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405601'
                WHERE ordernumber = 'P420805174812653' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405603'
                WHERE ordernumber = 'P190805175014414' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237226'
                WHERE ordernumber = 'P180805175015913' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405605'
                WHERE ordernumber = 'P420805175505740' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405607'
                WHERE ordernumber = 'P200805175722495' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380197'
                WHERE ordernumber = 'P180805175833803' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405608'
                WHERE ordernumber = 'P200805175925270' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227586'
                WHERE ordernumber = 'P200805180042353' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357562'
                WHERE ordernumber = 'P180805180104222' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401765'
                WHERE ordernumber = 'P180805180608372' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377371'
                WHERE ordernumber = 'P180805182327839' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371704'
                WHERE ordernumber = 'P420805182850969' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95013'
                WHERE ordernumber = 'P180805183125770' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405614'
                WHERE ordernumber = 'P190805183155988' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '323717'
                WHERE ordernumber = 'P190805183925485' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116449'
                WHERE ordernumber = 'P200805183932351' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '267164'
                WHERE ordernumber = 'P190805184210846' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405409'
                WHERE ordernumber = 'P190805184240153' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405616'
                WHERE ordernumber = 'P190805184538939' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405617'
                WHERE ordernumber = 'P190805184751379' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405618'
                WHERE ordernumber = 'P190805184925478' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247255'
                WHERE ordernumber = 'P190805185115974' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P190805185320948' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405381'
                WHERE ordernumber = 'P190805185557742' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405620'
                WHERE ordernumber = 'P190805190910621' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '253771'
                WHERE ordernumber = 'P190805191026787' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '88568'
                WHERE ordernumber = 'P200805191908954' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405621'
                WHERE ordernumber = 'P200805192345704' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400231'
                WHERE ordernumber = 'P200805193805489' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405625'
                WHERE ordernumber = 'P200805193924832' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '223258'
                WHERE ordernumber = 'P190805193949903' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405627'
                WHERE ordernumber = 'P200805195002598' 
            
2024-08-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405628'
                WHERE ordernumber = 'P200805195506689'