Untitled

select t1.serialnumber, t1.bin, t1.location, t2.serialnumber , max(t2.scandate) as lastscandate
from alliance.allianceinventoryitem t1
left join inventoryscanitem t2
on t1.serialnumber = t2.serialnumber
where qtyonhand=1 and t1.location like '7-%'
and t1.serialNumber = 172732409
group by t1.serialnumber, t1.bin, t1.location, t2.serialnumber 
limit 1000000;