SELECT customer_id FROM Customers WHERE customer_email != "leann.hamill@example.org" UNION SELECT customer_id FROM Customer_Addresses WHERE "address_id" < 1 AND date_from = "2014-06-09 06:31:49" <table_name> : Customers col : customer_id | payment_method | customer_name | customer_phone | customer_email | date_became_customer row 1 : 1 | Visa | Ron Emard | 1-382-503-5179x53639 | shaniya45@example.net | 2011-04-25 22:20:35 row 2 : 2 | MasterCard | Gabe Schroeder | 1-728-537-4293x0885 | alexandra91@example.net | 2011-10-17 16:08:25 row 3 : 3 | Discover | Candace Schneider | 940.575.3682x7959 | tkassulke@example.com | 2012-01-11 21:17:01 row 4 : 4 | Visa | Jaden Lang | 361.151.3489x7272 | dedric17@example.org | 2009-12-29 17:38:10 row 5 : 5 | Visa | Geovanni Grady | 1-005-644-2495 | elmira.langworth@example.org | 2017-05-21 07:09:55 row 6 : 6 | Visa | Dr. Karine Farrell | +49(2)0677806107 | reichel.winnifred@example.org | 2010-11-06 08:42:56 row 7 : 7 | Discover | Emmanuel Reilly | 129.959.6420 | gleichner.ethelyn@example.net | 2013-11-29 06:15:22 row 8 : 8 | MasterCard | Keenan Kuhic | 686-517-9923x348 | dallin76@example.org | 2013-04-09 18:17:05 row 9 : 9 | American | Rusty Morar | 1-123-197-9677x7194 | njenkins@example.org | 2015-09-09 09:29:06 row 10 : 10 | Visa | Lila Howe | 1-492-284-1097 | leann.hamill@example.org | 2014-02-04 04:51:58 row 11 : 11 | Visa | Amalia Hudson DDS | 003-991-1506x483 | danika49@example.com | 2014-02-25 19:39:51 row 12 : 12 | Discover | Verda Streich | 06730471330 | xgraham@example.org | 2008-10-12 12:19:27 row 13 : 13 | Discover | Patience Yundt | 969-208-8932x715 | kira82@example.com | 2017-03-25 18:48:04 row 14 : 14 | Visa | Annabell Walsh | (881)096-1281x6448 | adriana83@example.org | 2017-06-30 19:02:11 row 15 : 15 | Visa | Aracely Borer V | 531-617-3230 | rollin95@example.net | 2015-09-13 22:39:50 <table_name> : Customer_Addresses col : customer_id | address_id | date_from | address_type | date_to row 1 : 5 | 6 | 2016-09-06 19:23:46 | House | 2018-02-25 15:34:58 row 2 : 14 | 5 | 2016-12-21 03:49:54 | House | 2018-03-13 21:20:21 row 3 : 2 | 2 | 2014-06-09 06:31:49 | Flat | 2018-03-02 21:56:40 row 4 : 10 | 6 | 2011-05-24 21:49:34 | House | 2018-03-18 12:45:44 row 5 : 14 | 2 | 2011-12-06 16:49:10 | Flat | 2018-02-24 20:18:08 row 6 : 10 | 1 | 2012-05-24 11:47:54 | House | 2018-03-14 20:26:33 row 7 : 7 | 3 | 2016-08-17 17:45:20 | Flat | 2018-03-16 14:09:24 row 8 : 4 | 9 | 2009-08-03 03:17:03 | House | 2018-03-15 23:45:59 row 9 : 3 | 7 | 2010-12-29 11:01:39 | House | 2018-03-22 02:54:10 row 10 : 12 | 6 | 2012-08-31 15:41:03 | Flat | 2018-03-02 23:42:49 row 11 : 12 | 11 | 2008-04-02 08:23:13 | Apartment | 2018-03-17 12:51:37 row 12 : 14 | 10 | 2011-08-18 09:40:49 | House | 2018-03-06 15:48:13 row 13 : 1 | 11 | 2014-12-20 18:58:32 | House | 2018-02-27 00:53:48 row 14 : 8 | 6 | 2013-05-06 00:49:45 | Flat | 2018-03-05 01:34:02 row 15 : 12 | 5 | 2017-11-01 10:59:35 | Flat | 2018-03-09 05:05:17
col : customer_id row 1 : 1 row 2 : 2 row 3 : 3 row 4 : 4 row 5 : 5 row 6 : 6 row 7 : 7 row 8 : 8 row 9 : 9 row 10 : 11 row 11 : 12 row 12 : 13 row 13 : 14 row 14 : 15