{"table_name":"aieo_cumulative_order_stats","full_table_name":"wp_aieo_cumulative_order_stats","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","create_sql":"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`);","columns":[],"plugin":{"slug":"ai-eshop-optimizer","name":"Rooster One","active_installs":10,"version":"11.2.2","wp_org_url":"https://wordpress.org/plugins/ai-eshop-optimizer/"}}