dataexport: 32
This data as json
| id | dataQuery | dateCreated | dateLastModified | description | lastChangedUserId | name |
|---|---|---|---|---|---|---|
| 32 | SELECT p.num AS label_pn, p.description AS label_description, COUNT(DISTINCT w.id) AS total_work_orders, SUM(w.qtyOrdered) AS total_cables_built, MIN(w.dateFinished) AS earliest_wo, MAX(w.dateFinished) AS latest_wo, ROUND( SUM(w.qtyOrdered) / NULLIF(TIMESTAMPDIFF(MONTH, MIN(w.dateFinished), MAX(w.dateFinished)), 0) , 1) AS avg_monthly_usage, v.name AS vendor_name, vp.leadTime AS lead_time_days FROM woitem wi JOIN part p ON wi.partId = p.id JOIN wo w ON wi.woId = w.id LEFT JOIN vendorparts vp ON vp.partId = p.id AND vp.leadTime = ( SELECT MAX(vp2.leadTime) FROM vendorparts vp2 WHERE vp2.partId = p.id ) LEFT JOIN vendor v ON vp.vendorId = v.id WHERE p.num IN ('7176','7055','7061','7679','7220','7054','7060','7345','7680') AND w.dateFinished IS NOT NULL AND w.statusId = 40 GROUP BY p.num, p.description, v.name, vp.leadTime ORDER BY avg_monthly_usage DESC | 2026-05-05 17:01:21.707000 | 2026-05-05 17:01:21.707000 | 51 | Labels Run rate |