Untitled

mail@pastecode.io avatar
unknown
mysql
8 months ago
1.4 kB
5
Indexable
Never
select concat('s', serialnumber) serial, bin, location, lastscandate from inventoryitem where bin in ('b17919210',
'b17919212',
'b17919213',
'b17919208',
'b17919214',
'b17919215',
'b17919209',
'b17919211',
'b17919200',
'b17919184',
'b17919201',
'b17919185',
'b37979568',
'b17919256',
'b17919168',
'b37979568',
'b17919177',
'b17919176',
'b17919222',
'b17919219',
'b17919220',
'b17919223',
'b17919218',
'b17919221',
'b17919217',
'b17919216',
'b17919245',
'b17919246',
'b17919163',
'b17919161',
'b17919167',
'b17919166',
'b17919165',
'b17919164',
'b17919159',
'b17919171',
'b17919162',
'b17919160',
'b17919234',
'b17919226',
'b17919240',
'b17919228',
'b17919266',
'b17919265',
'b37979566',
'b37775168',
'b17919264',
'b37775167',
'b17919225',
'b17919224',
'b17919229',
'b17919230',
'b17919232',
'b17919244',
'b17919243',
'b17919233',
'b17919231',
'b17919242',
'b17919241',
'b17919261',
'b17919251',
'b27959605',
'b17919170',
'b17919267',
'b17919250',
'b37961585',
'b17919203',
'b37961584',
'b17919204',
'b17919180',
'b17919202',
'b17919199',
'b17919181',
'b17919186',
'b17919178',
'b37961583',
'b37961588',
'b37961587',
'b37961586',
'b37979567',
'b17919255',
'b17919169',
'b37961581',
'b17919191',
'b17919260',
'b17919238',
'b17919190',
'b17932334',
'b17919182',
'b17919263',
'b17919192',
'b37961582',
'b37961580',
'b17919205') and qtyonhand = 1
order by bin asc
Leave a Comment