Untitled
unknown
mysql
2 years ago
2.9 kB
14
Indexable
SELECT
CONCAT('s', serialnumber) serial,
inventoryid,
product,
size,
bin,
location,
PONum
FROM
inventoryitem
WHERE
serialnumber IN ('69988122' , '70716292',
'71140922',
'72152852',
'72152857',
'72152862',
'72152867',
'72152872',
'73520867',
'73521692',
'75298112',
'78403497',
'80289437',
'80595552',
'81590337',
'82536717',
'82987722',
'83115007',
'83194312',
'83336417',
'83341262',
'83352992',
'83383947',
'83706217',
'83711647',
'84748997',
'84749677',
'85317647',
'85324272',
'114072097',
'114111472',
'114111477',
'116662351',
'118300661',
'155864435',
'157278155',
'157903892',
'157904939',
'162670665',
'167084296',
'167094403',
'167094865',
'167095447',
'168421916',
'168421919',
'168421922',
'171053003',
'171053006',
'177689078',
'177841994',
'179019956',
'181178690',
'181199186',
'181200911',
'181200917',
'181200920',
'181200923',
'181903652',
'182645600',
'182645606',
'182645612',
'182645912',
'182645915',
'182646977',
'182647577',
'182647580',
'183952337',
'183969305',
'184265150',
'184300352',
'185871095',
'185871107',
'185989727',
'185989733',
'185989736',
'185989739',
'186422291',
'186422297',
'186422300',
'186422303',
'186425336',
'186769355',
'187000739',
'187884380',
'187884386',
'187884389',
'187884392',
'189051407',
'189827948',
'190371467',
'190371470',
'190371473',
'190371476',
'191558828',
'192614630',
'194345909',
'195160304',
'195270758',
'195270764',
'198419231',
'200303480',
'201558109',
'201558625',
'201558628',
'201558631',
'201734170',
'201751438',
'201780232',
'201922240',
'201959398',
'201964978',
'203314003',
'203504815',
'204469897',
'205087672',
'205088071',
'207494452',
'207495208',
'208844271',
'210182679',
'210524517',
'211628763',
'212956527',
'221842764',
'223401270',
'224341621',
'233155926') and inventoryid = '-1'
order by PONum, product ascEditor is loading...