select customer_email, sab.firstname
from fhs_sales_flat_order o
join fhs_customer_entity ce on ce.entity_id = o.customer_id
JOIN fhs_sales_flat_order_address sab      ON o.billing_address_id = sab.entity_id
where o.increment_id in ('100949169','400119925','400119927','100949175','100949190','100949225','100949246','100949251','400119958','400119961','100949286','400119965','400119968','400119973','100949325','100949375','400119998','100949471','100949497','100949512','400120008','100949525','100949534','100949539','100949545','100949558','400120031','100949585','100949587','100949590','400120038','100949600','400120039','400120040','400120041','400120044','400120045','100949616','400120047','100949624','100949630','100949631','100949636','400120050','400120052','100949660','100949670','400120068','400120071','100949747','400120077','400120078','100949764','100949769','100949788','100949808','100949810','100949827','100949838','100949844','400120100','400120105','100949899','400120106','400120107','400120109','400120110','100949957','400120115','100949993','100950000','100950003','100950004','100950011','400120127','100950025','400120128','100950040','400120130','100950056','400120152','400120157','400120160','400120161','400120170','100950116','100950117','400120174','400120176','100950140','400120178','100950149','400120182','400120183','100950164','400120184','400120186','400120187','400120188','100950173','100950177','400120190','100950183','400120192','400120193','400120194','100950196','100950207','400120197','100950210','400120198','400120201','100950220','400120204','100950227','100950228','400120206','100950240','100950245','100950252','100950253','100950262','400120216','100950273','100950274','100950276','100950279','100950280','400120219','400120222','100950291','400120223','100950307','100950317','100950318','400120228','400120230','100950328','100950339','400120236','100950341','100950342','100950347','400120241','100950356','100950357','100950366','100950372','100950374','100950384','100950392','400120249','400120250','100950408','400120251','100950412','400120256','100950418','100950430','400120265','400120266','100950456','100950462','100950465','400120269','400120271','100950476','100950483','400120274','400120276','100950496','100950502','100950505','100950520','100950531','100950563','100950583','100950606','100950626','100950631','100950675','100950680','100950704','100950707','100950718','400120320','100950754','100950763','100950790','100950799','100950800','100950803','400120354','100950847','100950851','400120375','100950890','100950892','400120386','100950912','400120391','100950929','100950931','400120401','400120402','100950942','100950970','100950974','100950983','100951024','400120432','100951082','400120446','100951168','100951178','100951183','400120458','400120463','100951226','100951272','400120484','100951284','400120489','400120592','400120602','100951418','100951470','100951483','100951509','400120670','400120671','100951579','100951586','100951591','100951600','100951601','100951603','100951625','400120734','100951677','400120743','100951686','100951691','100951699','100951708','400120751','100951719','100951758','400120770','100951806','100951819','100951820','400120784','100951838','400120793','100951861','100951902','100951904','400120810','100951923','400120823','100951963','100951974','400120827','400120830','100952011','400120869','400120878')
group by o.customer_email;