trabulium · January 18, 2018 06:06
diff --git a/Update sales_flat_order_grid status to match sales_flat_order statuses b/Update sales_flat_order_grid status to match sales_flat_order statuses
 update
    sales_flat_order_grid as sfog
    inner join (
      select entity_id, status
      from sales_flat_order as sfotmp
      ) as sfo on sfo.entity_id = sfog.entity_id
  set sfog.status = sfo.status 
  #where sfog.entity_id in (111194)
	update
	sales_flat_order_grid as sfog
	inner join (
	select entity_id, status
	from sales_flat_order as sfotmp
	) as sfo on sfo.entity_id = sfog.entity_id
	set sfog.status = sfo.status
	#where sfog.entity_id in (111194)