Magento导出订单中的客户email（所有客户） 

  select customer_email
    from sales_flat_order

Magento导出订单中的客户email（已经付款的客户） 

  select customer_email
    from sales_flat_order
   where status = 'complete'

sales_flat_order中还有其他一些十分有用的信息： 

SELECT
  entity_id,
  state,
  status,
  coupon_code,
  protect_code,
  shipping_description,
  is_virtual,
  store_id,
  customer_id,
  base_discount_amount,
  base_discount_canceled,
  base_discount_invoiced,
  base_discount_refunded,
  base_grand_total,
  base_shipping_amount,
  base_shipping_canceled,
  base_shipping_invoiced,
  base_shipping_refunded,
  base_shipping_tax_amount,
  base_shipping_tax_refunded,
  base_subtotal,
  base_subtotal_canceled,
  base_subtotal_invoiced,
  base_subtotal_refunded,
  base_tax_amount,
  base_tax_canceled,
  base_tax_invoiced,
  base_tax_refunded,
  base_to_global_rate,
  base_to_order_rate,
  base_total_canceled,
  base_total_invoiced,
  base_total_invoiced_cost,
  base_total_offline_refunded,
  base_total_online_refunded,
  base_total_paid,
  base_total_qty_ordered,
  base_total_refunded,
  discount_amount,
  discount_canceled,
  discount_invoiced,
  discount_refunded,
  grand_total,
  shipping_amount,
  shipping_canceled,
  shipping_invoiced,
  shipping_refunded,
  shipping_tax_amount,
  shipping_tax_refunded,
  store_to_base_rate,
  store_to_order_rate,
  subtotal,
  subtotal_canceled,
  subtotal_invoiced,
  subtotal_refunded,
  tax_amount,
  tax_canceled,
  tax_invoiced,
  tax_refunded,
  total_canceled,
  total_invoiced,
  total_offline_refunded,
  total_online_refunded,
  total_paid,
  total_qty_ordered,
  total_refunded,
  can_ship_partially,
  can_ship_partially_item,
  customer_is_guest,
  customer_note_notify,
  billing_address_id,
  customer_group_id,
  edit_increment,
  email_sent,
  forced_shipment_with_invoice,
  payment_auth_expiration,
  quote_address_id,
  quote_id,
  shipping_address_id,
  adjustment_negative,
  adjustment_positive,
  base_adjustment_negative,
  base_adjustment_positive,
  base_shipping_discount_amount,
  base_subtotal_incl_tax,
  base_total_due,
  payment_authorization_amount,
  shipping_discount_amount,
  subtotal_incl_tax,
  total_due,
  weight,
  customer_dob,
  increment_id,
  applied_rule_ids,
  base_currency_code,
  customer_email,
  customer_firstname,
  customer_lastname,
  customer_middlename,
  customer_prefix,
  customer_suffix,
  customer_taxvat,
  discount_description,
  ext_customer_id,
  ext_order_id,
  global_currency_code,
  hold_before_state,
  hold_before_status,
  order_currency_code,
  original_increment_id,
  relation_child_id,
  relation_child_real_id,
  relation_parent_id,
  relation_parent_real_id,
  remote_ip,
  shipping_method,
  store_currency_code,
  store_name,
  x_forwarded_for,
  customer_note,
  created_at,
  updated_at,
  total_item_count,
  customer_gender,
  hidden_tax_amount,
  base_hidden_tax_amount,
  shipping_hidden_tax_amount,
  base_shipping_hidden_tax_amnt,
  hidden_tax_invoiced,
  base_hidden_tax_invoiced,
  hidden_tax_refunded,
  base_hidden_tax_refunded,
  shipping_incl_tax,
  base_shipping_incl_tax,
  paypal_ipn_customer_notified,
  gift_message_id
FROM
  sales_flat_order;

适用于Magento1.5, Magento1.6