rendered paste body 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 |
+---------------------------------------------------------+----------------+----------+---------------------+