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 ('400118959','400119002','100947030','400119016','400119034','100947132','100947252','100947254','100947269','100947278','100947283','400119101','100947311','400119104','100947322','400119114','100947341','100947356','400119123','400119130','100947383','400119136','100947394','400119160','100947456','400119164','100947517','100947518','100947551','100947564','100947567','100947592','400119199','100947619','100947620','100947650','400119217','100947669','400119224','100947695','100947698','400119234','100947708','400119235','400119246','100947740','400119271','400119272','400119277','400119283','100947822','400119297','100947903','400119306','400119320','400119321','100947995','100948015','100948018','100948021','400119345','100948031','100948037','400119352','100948044','400119358','100948100','400119367','100948131','400119400','400119404','100948188','400119417','100948230','400119437','100948284','400119449','100948308','400119454','400119460','100948351','400119493','400119499','400119503','400119508','100948394','400119509','100948397','100948398','100948400','100948401','400119520','100948420','100948421','100948422','400119527','400119529','400119536','100948434','400119539','100948439','100948446','400119553','100948447','100948453','100948459','400119561','100948467','400119562','400119563','400119564','100948469','400119568','400119571','400119574','400119575','100948482','100948492','400119587','100948494','100948502','100948507','400119592','100948508','400119595','100948513','100948525','400119607','100948540','100948543','400119616','400119617','400119619','100948569','100948574','100948575','400119634','400119637','100948588','400119645','400119649','400119654','400119657','400119664','100948630','100948636','100948638','100948645','100948658','100948659','100948661','100948669','400119689','400119690','100948689','100948691','100948700','100948703','400119706','400119707','100948742','100948752','400119740','100948758','100948762','100948764','400119752','100948804','100948812','100948816','400119788','400119789','400119795','400119802','100948869','100948871','100948888','100948896','400119826','400119827','100948933','100948959','100948975','100948978','400119854','100948984','100948986','100949002','100949004','100949019','100949028','100949029','100949050','400119888','400119891','100949067','100949073','400119895','100949087','400119896','100949103','400119902','400119907','100949139','100949157','100949160','100949166')
group by o.customer_email;