INSERT INTO k9ti_combine_data_sale (subid, transactionid, sale_date, amount, product, refunded, payment_plan,installment_payment_count, paymentgateway, time, src, fname, lname, email, phone, state, country, utm_source, utm_medium, utm_campaign, utm_term, utm_content, subscribe_date) SELECT k9ti_successful_transactions.subid, k9ti_successful_transactions.transactionid, k9ti_successful_transactions.sale_date, k9ti_successful_transactions.amount, k9ti_successful_transactions.product, k9ti_successful_transactions.refunded, k9ti_successful_transactions.payment_plan, k9ti_successful_transactions.installment_payment_count, k9ti_successful_transactions.paymentgateway, k9ti_successful_transactions.time, k9ti_customers.src, k9ti_customers.fname, k9ti_customers.lname, k9ti_customers.email, k9ti_customers.phone, k9ti_customers.state, k9ti_customers.country, k9ti_subscribers.utm_source, k9ti_subscribers.utm_medium, k9ti_subscribers.utm_campaign, k9ti_subscribers.utm_term, k9ti_subscribers.utm_content, k9ti_subscribers.date FROM k9ti_successful_transactions LEFT JOIN k9ti_customers ON k9ti_customers.subid = k9ti_successful_transactions.subid LEFT JOIN k9ti_subscribers ON k9ti_subscribers.subid = k9ti_successful_transactions.subid WHERE k9ti_successful_transactions.successfultransactionid > 10198UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1742799352_9069'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1742818184_9073'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1742881528_9074'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1742882271_9074'UPDATE k9ti_combine_data_sale SET refunded = refunded+100.00 WHERE transactionid = '1742905546_9081'UPDATE k9ti_combine_data_sale SET refunded = refunded+50.00 WHERE transactionid = '1742905546_9081'UPDATE k9ti_combine_data_sale SET refunded = refunded+289.00 WHERE transactionid = '1742969842_9086'UPDATE k9ti_combine_data_sale SET refunded = refunded+97.00 WHERE transactionid = '1742969705_9086'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1742973830_9087'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1742987666_9091'UPDATE k9ti_combine_data_sale SET refunded = refunded+497.00 WHERE transactionid = '1743163835_9095'UPDATE k9ti_combine_data_sale SET refunded = refunded+56.00 WHERE transactionid = '1743163844_9095'UPDATE k9ti_combine_data_sale SET refunded = refunded+100.00 WHERE transactionid = '1743402282_9097'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743406801_9098'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743415088_9099'UPDATE k9ti_combine_data_sale SET refunded = refunded+100.00 WHERE transactionid = '1743415131_9099_addon'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743415140_9099'UPDATE k9ti_combine_data_sale SET refunded = refunded+99.00 WHERE transactionid = '1743415564_9100'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743415628_9100_addon'UPDATE k9ti_combine_data_sale SET refunded = refunded+197.00 WHERE transactionid = '1743415895_9102'UPDATE k9ti_combine_data_sale SET refunded = refunded+50.00 WHERE transactionid = '1743415948_9102_addon'UPDATE k9ti_combine_data_sale SET refunded = refunded+47.00 WHERE transactionid = '1743659359_0'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743659971_9113_addon'UPDATE k9ti_combine_data_sale SET refunded = refunded+47.00 WHERE transactionid = '1743673398_0'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743673926_9130'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743674670_9131'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743675244_9132'UPDATE k9ti_combine_data_sale SET refunded = refunded+97.00 WHERE transactionid = '1743677813_0'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743677878_9133_addon'UPDATE k9ti_combine_data_sale SET refunded = refunded+34.00 WHERE transactionid = '1743748500_0'UPDATE k9ti_combine_data_sale SET refunded = refunded+47.00 WHERE transactionid = '1743748644_0'UPDATE k9ti_combine_data_sale SET refunded = refunded+497.00 WHERE transactionid = '1743765431_9159'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743765963_9160'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743766099_9161'UPDATE k9ti_combine_data_sale SET refunded = refunded+497.00 WHERE transactionid = '1743766230_9162'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743766447_9163'UPDATE k9ti_combine_data_sale SET refunded = refunded+497.00 WHERE transactionid = '1743766553_9163_addon'UPDATE k9ti_combine_data_sale SET refunded = refunded+47.00 WHERE transactionid = '1743766972_0'UPDATE k9ti_combine_data_sale SET refunded = refunded+56.00 WHERE transactionid = '1743767026_9164_addon'UPDATE k9ti_combine_data_sale SET refunded = refunded+297.00 WHERE transactionid = '1743767159_9165'UPDATE k9ti_combine_data_sale SET refunded = refunded+50.00 WHERE transactionid = '1743767634_9166'UPDATE k9ti_combine_data_sale SET refunded = refunded+198.00 WHERE transactionid = '1744176240_9177'UPDATE k9ti_combine_data_sale SET refunded = refunded+200.00 WHERE transactionid = '1744183521_9178'