select  b.store_name,a.machine_serial,a.status,a.shipping_date from machine as a,store as b where a.machine_parent = b.store_id and a.machine_id in (15486, 15528, 15530, 15535, 15543, 15801, 15903, 15914, 16001, 16007, 16052, 18538, 19275, 19276) and a.status in ('LIVE', 'SHIPPING') order by a.shipping_date;
+---------------------------------------------------------+----------------+----------+---------------------+
| store_name                                              | machine_serial | status   | shipping_date       |
+---------------------------------------------------------+----------------+----------+---------------------+
| Helzberg Diamonds #647 - Wilshire Plaza [647.7760.4]    | mbox16323      | LIVE     | 2006-10-26 16:30:13 |
| Helzberg Diamonds #275 - Clay Terrace [275.7760.4]      | mbox16321      | LIVE     | 2006-10-26 16:41:14 |
| Helzberg Diamonds #194 - Tuttle Crossing [194.7760.4]   | mbox16845      | SHIPPING | 2006-12-26 15:15:56 |
| Helzberg Diamonds #257 - Spotsylvania Mall [257.7760.4] | mbox19331      | SHIPPING | 2007-06-22 14:50:49 |
| Helzberg #331                                           | mbox20069      | LIVE     | 2007-09-27 09:46:58 |
| Helzberg Diamonds #328 - Victorville, CA [328.7760.4]   | mbox20068      | SHIPPING | 2007-09-27 09:49:37 |
+---------------------------------------------------------+----------------+----------+---------------------+