sudo mysqlslap --user=root --password=k23ahachusuS --host=mulesoft.cndkso2j8v1v.us-west-2.rds.amazonaws.com  --concurrency=50 --iterations=10 --create-schema=spark --query="select this_.id as id92_3_, this_.created as created92_3_, this_.createdBy_id as createdBy7_92_3_, this_.deleted as deleted92_3_, this_.deletedBy_id as deletedBy8_92_3_, this_.modified as modified92_3_, this_.modifiedBy_id as modifiedBy9_92_3_, this_.version as version92_3_, this_.active as active92_3_, this_.order_id as order10_92_3_, this_.rule_id as rule11_92_3_, a_order1_.id as id88_0_, a_order1_.created as created88_0_, a_order1_.createdBy_id as createdBy11_88_0_, a_order1_.deleted as deleted88_0_, a_order1_.deletedBy_id as deletedBy12_88_0_, a_order1_.modified as modified88_0_, a_order1_.modifiedBy_id as modifiedBy13_88_0_, a_order1_.version as version88_0_, a_order1_.UUID as UUID88_0_, a_order1_.customer_id as customer14_88_0_, a_order1_.customerOrganization_id as custome15_88_0_, a_order1_.externalId as externalId88_0_, a_order1_.payment_id as payment16_88_0_, a_order1_.paymentOriginal_id as payment17_88_0_, a_order1_.shippingInfo_id as shippin18_88_0_, a_order1_.status as status88_0_, a_order1_.taxDate as taxDate88_0_, a_order1_.tax_service as tax10_88_0_, MONTH(a_order1_.created) as formula5_0_, YEAR(a_order1_.created) as formula6_0_, payment4_.id as id8_1_, payment4_.created as created8_1_, payment4_.createdBy_id as createdBy33_8_1_, payment4_.deleted as deleted8_1_, payment4_.deletedBy_id as deletedBy34_8_1_, payment4_.modified as modified8_1_, payment4_.modifiedBy_id as modifiedBy35_8_1_, payment4_.version as version8_1_, payment4_.amount as amount8_1_, payment4_.currency as currency8_1_, payment4_.comments as comments8_1_, payment4_.email as email8_1_, payment4_.addressType as address10_8_1_, payment4_.city as city8_1_, payment4_.country_alpha2Code as country36_8_1_, payment4_.latitude as latitude8_1_, payment4_.longitude as longitude8_1_, payment4_.postalCode as postalCode8_1_, payment4_.region as region8_1_, payment4_.street1 as street16_8_1_, payment4_.street2 as street17_8_1_, payment4_.externalId as externalId8_1_, payment4_.failureMessage as failure19_8_1_, payment4_.firstName as firstName8_1_, payment4_.invoiceNumber as invoice21_8_1_, payment4_.lastName as lastName8_1_, payment4_.notes as notes8_1_, payment4_.organization as organiz24_8_1_, payment4_.paymentMethod as payment25_8_1_, payment4_.phone as phone8_1_, payment4_.processedAmount as process27_8_1_, payment4_.processedCurrency as process28_8_1_, payment4_.status as status8_1_, payment4_.taxcountry_alpha2Code as taxcountry37_8_1_, payment4_.taxId as taxId8_1_, payment4_.valueAmount as valueAm31_8_1_, payment4_.valueCurrency as valueCu32_8_1_, payment4_1_.creditCardExpiryMonth as creditCa1_9_1_, payment4_1_.creditCardExpiryYear as creditCa2_9_1_, payment4_1_.creditCardNumber as creditCa3_9_1_, payment4_1_.creditCardVerificationNumber as creditCa4_9_1_, payment4_1_.description as descript5_9_1_, payment4_1_.ipAddress as ipAddress9_1_, payment4_1_.processingConfirmation as processi7_9_1_, payment4_1_.processingDate as processi8_9_1_, payment4_1_.type as type9_1_, payment4_2_.paymentMethod as paymentM1_10_1_, payment4_2_.purchaseOrderNumber as purchase2_10_1_, payment4_3_.account_id as account4_11_1_, payment4_3_.passkey as passkey11_1_, payment4_3_.trainingCredits as training2_11_1_, payment4_3_.transaction_id as transact5_11_1_, case when payment4_1_.id is not null then 1 when payment4_2_.id is not null then 2 when payment4_3_.id is not null then 3 when payment4_.id is not null then 0 end as clazz_1_, payment5_.id as id8_2_, payment5_.created as created8_2_, payment5_.createdBy_id as createdBy33_8_2_, payment5_.deleted as deleted8_2_, payment5_.deletedBy_id as deletedBy34_8_2_, payment5_.modified as modified8_2_, payment5_.modifiedBy_id as modifiedBy35_8_2_, payment5_.version as version8_2_, payment5_.amount as amount8_2_, payment5_.currency as currency8_2_, payment5_.comments as comments8_2_, payment5_.email as email8_2_, payment5_.addressType as address10_8_2_, payment5_.city as city8_2_, payment5_.country_alpha2Code as country36_8_2_, payment5_.latitude as latitude8_2_, payment5_.longitude as longitude8_2_, payment5_.postalCode as postalCode8_2_, payment5_.region as region8_2_, payment5_.street1 as street16_8_2_, payment5_.street2 as street17_8_2_, payment5_.externalId as externalId8_2_, payment5_.failureMessage as failure19_8_2_, payment5_.firstName as firstName8_2_, payment5_.invoiceNumber as invoice21_8_2_, payment5_.lastName as lastName8_2_, payment5_.notes as notes8_2_, payment5_.organization as organiz24_8_2_, payment5_.paymentMethod as payment25_8_2_, payment5_.phone as phone8_2_, payment5_.processedAmount as process27_8_2_, payment5_.processedCurrency as process28_8_2_, payment5_.status as status8_2_, payment5_.taxcountry_alpha2Code as taxcountry37_8_2_, payment5_.taxId as taxId8_2_, payment5_.valueAmount as valueAm31_8_2_, payment5_.valueCurrency as valueCu32_8_2_, payment5_1_.creditCardExpiryMonth as creditCa1_9_2_, payment5_1_.creditCardExpiryYear as creditCa2_9_2_, payment5_1_.creditCardNumber as creditCa3_9_2_, payment5_1_.creditCardVerificationNumber as creditCa4_9_2_, payment5_1_.description as descript5_9_2_, payment5_1_.ipAddress as ipAddress9_2_, payment5_1_.processingConfirmation as processi7_9_2_, payment5_1_.processingDate as processi8_9_2_, payment5_1_.type as type9_2_, payment5_2_.paymentMethod as paymentM1_10_2_, payment5_2_.purchaseOrderNumber as purchase2_10_2_, payment5_3_.account_id as account4_11_2_, payment5_3_.passkey as passkey11_2_, payment5_3_.trainingCredits as training2_11_2_, payment5_3_.transaction_id as transact5_11_2_, case when payment5_1_.id is not null then 1 when payment5_2_.id is not null then 2 when payment5_3_.id is not null then 3 when payment5_.id is not null then 0 end as clazz_2_ from DiscountUse this_ left outer join orders a_order1_ on this_.order_id=a_order1_.id left outer join Payment payment4_ on a_order1_.payment_id=payment4_.id left outer join CreditCardPayment payment4_1_ on payment4_.id=payment4_1_.id left outer join PurchaseOrderPayment payment4_2_ on payment4_.id=payment4_2_.id left outer join TrainingCreditPayment payment4_3_ on payment4_.id=payment4_3_.id left outer join Payment payment5_ on a_order1_.paymentOriginal_id=payment5_.id left outer join CreditCardPayment payment5_1_ on payment5_.id=payment5_1_.id left outer join PurchaseOrderPayment payment5_2_ on payment5_.id=payment5_2_.id left outer join TrainingCreditPayment payment5_3_ on payment5_.id=payment5_3_.id where (this_.active=1 and a_order1_.status='PENDING_SUBMISSION') order by this_.id asc;" --verbose