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 asc
Editor is loading...