Untitled

mail@pastecode.io avatar
unknown
mysql
6 months ago
2.9 kB
12
Indexable
Never
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 asc