wp_aieo_cumulative_order_stats

CREATE TABLE Statement

create table IF NOT EXISTS wp_aieo_cumulative_order_stats (INDEX order_id_idx (OrderID, CustomerEmail)) SELECT ws1.orderid as OrderID, ws1.customeremail as CustomerEmail, ws1.statsclientid as StatsClientID, ws1.postcode as Postcode, ws1.orderspend as OrderSpend, ws1.numberofitemsperorder as NumberOfItemsPerOrder, Round(a.avg_spend,2) as TotalAverageOrder, Round(ws1.orderspend/(ws1.numberofitemsperorder),2) as AveSpendOfUserPerItemPerOrder, ws1.numberoforders as TotalNumberofOrders, Round(a.avg_items,2) as AveItemsOfUserPerOrder, Round(a.std_items,2) as STDItemsOfUser, Round( a.std_items /a.min_items ,2) as STDPerMinItemsOfUser, Round( a.std_items /a.avg_items ,2) as STDPerAverageItemsOfUser, Round( a.std_items /a.max_items ,2) as STDPerMaxItemsOfUser, Round(a.avg_spend,2) as AveSpendOfUserPerOrder, Round(a.std_spend,2) as STDSpendOfUser, Round( a.std_spend /a.min_spend ,2) as STDPerMinSpendOfUser, Round( a.std_spend /a.avg_spend ,2) as STDPerAverageSpendOfUser, Round( a.std_spend /a.max_spend ,2) as STDPerMaxSpendOfUser, ws1.buyerspayrol as BuyersPayrol, ws1.buyersday as BuyersDay, ws1.buyerstime as BuyersTime, ws1.link_to_order_details as link_to_order_details FROM wp_aieo_order_stats ws1 JOIN _cum_cust a on a.customeremail = ws1.customeremail Order by ws1.customeremail; DROP TEMPORARY TABLE IF EXISTS _cum_cust; ALTER TABLE wp_aieo_cumulative_order_stats ADD COLUMN `id` BIGINT(45) UNSIGNED NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`);

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_aieo_cumulative_order_stats`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Rooster One