Untitled
unknown
mysql
2 years ago
995 B
9
Indexable
SELECT ROUND(FORMAT(j2.cost, 'c')) cost, ROUND(FORMAT(p.retailprice, 'c')) retail, CONCAT('s', j2.serialnumber) serialnumber, j2.product, j2.size, j2.location, j1.source FROM (SELECT YEAR(updatedate) yr, MONTH(updatedate) mo, t1.productcode, t1.option1, serialnumber, source FROM inventoryupdate t1 JOIN inventoryupdate_extend t2 ON t1.id = t2.inventoryupdateid WHERE reasoncode = '54' AND source IN ('Manual Adjust by Ruben Esparza' , 'Manual Adjust by Jenny Yip') AND quantity > prevupdatequantity AND date(updatedate) >= '2023-09-01' AND date(updatedate) <= '2023-10-31' LIMIT 100000000) j1 LEFT JOIN inventoryitem j2 ON j1.serialnumber = j2.serialnumber AND location = 'Inventory Defect Pending' AND qtyonhand = 1 JOIN product p ON p.code = j2.product LIMIT 10000000000
Editor is loading...