select state, increment_id, grand_total, created_at, quote_id as q, (select count(x.quote_id) from sales_flat_order as x where x.quote_id = q group by x.quote_id) as count  from sales_flat_order having count > 1 order by quote_id desc, created_at desc