changed the query for event order, getting serial numbers from b_allocat...

...ion,b_owned_hardware