Queries · q036 · Chief Operating Officer · week 1, night 4
“As of now, how exposed are our fulfillment sites to stockouts, and how many SKUs are already at or below their reorder point?”
Fictional people at a fictional company, each played by a language-model agent. Who they are and what they are told
The manager, at the start of week 1
Subject: Getting my bearings on fulfillment — questions for this week
Hi Lena,
Thanks for taking these on. I'm new here and coming from the logistics side, so my first priority is understanding whether the delivery promise we make to shoppers actually holds up — that's the lens for most of what's below. Given the slot budget, here's what matters most, roughly in priority order:
What I'll use this for: I'm forming my first impressions of operational health in this area and want to walk into conversations with merchants and carrier partners armed with facts, not assumptions. I'd rather have a smaller number of really clear answers than a lot of surface-level ones — so if you need to cut scope to fit your slots this week, prioritize #1 and #2, and we can pick up the rest next week.
Thanks — looking forward to Friday's memo.
Priya
The analyst · week 1, night 4, request 3 of 3
Night 3 nailed down priority #3 cleanly, so I'm done there and pivoting all of tonight's slots to priority #4 (inventory/replenishment), which I haven't touched yet. Key night-3 findings for the memo: (a) the complete Q4 carrier table confirms three chronically-weak carriers -- Landfall Freight (13.6% within 3 days, worst all year), Lowlands Express (44.6%), and now Albion Parcel -- together carrying ~32% of Q4 volume; (b) Albion Parcel's monthly breakdown shows it was perfectly fine through October (75.7% within 3 days) then catastrophically broke in November (28.2%) and got worse, not better, in December (p90 blew out to 20.7 days, pct_delivered slipped to 94.2%) -- this is an acute, ongoing carrier failure, not a peak blip that self-resolved, and is the single most actionable finding for a carrier conversation; (c) the carrier-mix report confirms the merchant-level variance from Night 1 is almost entirely explained by carrier assignment, not the merchant or warehouse itself -- e.g. Grind Collective's Kennet Freight leg hits 88.7% within 3 days while its Landfall Freight leg on the very same business hits 19.4%; the "best" merchants simply route nearly all volume through the strong carriers (Strombogen Kurier, Liberty Ground, Alpenpaket, Trailhead Express), while "worst" merchants have meaningful share stuck on the weak ones. That resolves priority #3 well enough to write up without further queries. Tonight (last night) I'm spending all 3 slots on priority #4: whether replenishment from suppliers keeps pace (purchase order lead times, by supplier and by quarter to check for a peak-season backlog) and a current snapshot of stockout exposure by warehouse. I'm leaving returns (#5) for a future week per Priya's explicit prioritization.
The engineer · 1 dry run on the empty schema, then the submission
WITH t0 AS ( SELECT t4.warehouse_id AS warehouse_id, t4.variant_id AS variant_id, SUM(t4.quantity) AS total_quantity, SUM(t4.reserved_quantity) AS total_reserved_quantity, SUM(t4.reorder_point) AS total_reorder_point FROM ( SELECT si.variant_id AS variant_id, sl.warehouse_id AS warehouse_id, si.quantity AS quantity, si.reserved_quantity AS reserved_quantity, si.reorder_point AS reorder_point FROM stock_items si JOIN stock_locations sl ON sl.id = si.stock_location_id ) t4 GROUP BY t4.warehouse_id, t4.variant_id ) SELECT w0.name AS warehouse_name, t9.name AS tenant_name, t1.variants_tracked AS variants_tracked, COALESCE(t2.variants_out_of_stock, 0) AS variants_out_of_stock, ROUND(100.0 * COALESCE(t2.variants_out_of_stock, 0) / t1.variants_tracked, 1) AS pct_out_of_stock, COALESCE(t3.variants_at_or_below_reorder_point, 0) AS variants_at_or_below_reorder_point, ROUND(100.0 * COALESCE(t3.variants_at_or_below_reorder_point, 0) / t1.variants_tracked, 1) AS pct_at_or_below_reorder FROM warehouses w0 JOIN tenants t9 ON t9.id = w0.tenant_id JOIN ( SELECT warehouse_id, COUNT(DISTINCT variant_id) AS variants_tracked FROM t0 GROUP BY warehouse_id ) t1 ON t1.warehouse_id = w0.id LEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_out_of_stock FROM t0 WHERE (total_quantity - total_reserved_quantity) <= 0 GROUP BY warehouse_id ) t2 ON t2.warehouse_id = w0.id LEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_at_or_below_reorder_point FROM t0 WHERE total_reorder_point IS NOT NULL AND total_quantity <= total_reorder_point GROUP BY warehouse_id ) t3 ON t3.warehouse_id = w0.id WHERE t1.variants_tracked >= 20 ORDER BY pct_out_of_stock DESC, warehouse_name ASC LIMIT 50
“Query compiles and returns the requested columns. Submitting.”
“Submitted. Summary of what the query does:
- Builds a variant×warehouse aggregate (t0) by summing quantity, reserved_quantity, and reorder_point from stock_items across all stock_locations within each warehouse.
- variants_tracked: distinct variants with any stock row in the warehouse.
- variants_out_of_stock: variants where summed quantity minus summed reserved quantity ≤ 0.
- variants_at_or_below_reorder_point: variants where the summed reorder point is not null and summed on-hand quantity ≤ that threshold.
- Percentages rounded to 1 decimal, warehouses with fewer than 20 tracked variants excluded, ordered by pct_out_of_stock desc then warehouse_name asc, capped at 50 rows.
Noted in the submit note that this is a point-in-time snapshot (no historical stockout log), and that multi-location variants had quantity, reserved quantity, and reorder point all summed before testing.”
As Lena Hartmann saw it, from the small dataset the agents worked on
warehouse_name | tenant_name | variants_tracked | variants_out_of_stock | pct_out_of_stock | variants_at_or_below_reorder_point | pct_at_or_below_reorder --------------------------------------+-------------------------------+------------------+-----------------------+------------------+------------------------------------+------------------------ Köln Fulfilment Centre | Brennquell Kaffee | 854 | 127 | 14.9 | 244 | 28.6 San Francisco Fulfilment Centre | Honeycomb Larder | 255 | 28 | 11.0 | 59 | 23.1 Newcastle upon Tyne Fulfilment Centre | Deskline Supplies | 191 | 18 | 9.4 | 21 | 11.0 San Antonio Fulfilment Centre | Castell Fasteners | 314 | 29 | 9.2 | 32 | 10.2 Oslo Fulfilment Centre | OfficeHub Nordic | 352 | 31 | 8.8 | 37 | 10.5 Liège Fulfilment Centre | Spice Route Box | 397 | 32 | 8.1 | 61 | 15.4 Manchester Fulfilment Centre | Grind Collective | 411 | 33 | 8.0 | 68 | 16.5 Galway Fulfilment Centre | Ballycorran Industrial Supply | 806 | 59 | 7.3 | 66 | 8.2 Hannover Fulfilment Centre | Hanse Industriebedarf | 286 | 21 | 7.3 | 26 | 9.1 Berlin Fulfilment Centre | Kontor24 Bürobedarf | 373 | 27 | 7.2 | 29 | 7.8 Dublin Fulfilment Centre | Sourdough Club | 287 | 18 | 6.3 | 57 | 19.9 Berlin Fulfilment Centre | Wiesgrund Wohnen | 681 | 36 | 5.3 | 102 | 15.0 Uppsala Fulfilment Centre | Juniper Apothecary | 416 | 22 | 5.3 | 54 | 13.0 Amsterdam Fulfilment Centre | Linden & Loom | 750 | 39 | 5.2 | 118 | 15.7 Lund Fulfilment Centre | Saffron & Sage | 257 | 13 | 5.1 | 46 | 17.9 Liverpool Fulfilment Centre | Fennel & Flint | 904 | 42 | 4.6 | 121 | 13.4 Leeds Fulfilment Centre | The Balm Room | 308 | 14 | 4.5 | 37 | 12.0 Oslo Fulfilment Centre | Purrfect Pantry | 155 | 7 | 4.5 | 20 | 12.9 Houston Fulfilment Centre | Tail Wag Supply | 196 | 8 | 4.1 | 20 | 10.2 Paris Fulfilment Centre | Mirelle | 294 | 12 | 4.1 | 27 | 9.2 Rotterdam Fulfilment Centre | Midland Safety Wear | 460 | 19 | 4.1 | 21 | 4.6 Manchester Fulfilment Centre | Willow & Wren | 460 | 18 | 3.9 | 56 | 12.2 Bromley Fulfilment Centre | Petalcourt Beauty | 920 | 35 | 3.8 | 118 | 12.8 Innsbruck Fulfilment Centre | Buchstabe | 260 | 10 | 3.8 | 19 | 7.3 Liège Fulfilment Centre | Polder Packaging | 234 | 9 | 3.8 | 11 | 4.7 Odense Fulfilment Centre | Nordic Bloom Cosmetics | 468 | 18 | 3.8 | 62 | 13.2 Amsterdam Fulfilment Centre | Whisker Works | 272 | 10 | 3.7 | 35 | 12.9 Nürnberg Fulfilment Centre | Wohnglück | 557 | 20 | 3.6 | 56 | 10.1 Göteborg Fulfilment Centre | Coastline Interiors | 550 | 19 | 3.5 | 65 | 11.8 Bromley Fulfilment Centre | Kibblewick | 522 | 18 | 3.4 | 101 | 19.3 Charlotte Fulfilment Centre | Roast Republic | 212 | 7 | 3.3 | 31 | 14.6 Bordeaux Fulfilment Centre | Chocolaterie Mireille | 157 | 5 | 3.2 | 18 | 11.5 Köln Fulfilment Centre | Pfotenglück | 242 | 7 | 2.9 | 33 | 13.6 Hamburg Fulfilment Centre | Ampfeld Elektronik | 1515 | 39 | 2.6 | 171 | 11.3 Berlin Fulfilment Centre | Kaffeekontor Nord | 83 | 2 | 2.4 | 2 | 2.4 Amsterdam Fulfilment Centre | Ampere & Co. | 441 | 10 | 2.3 | 38 | 8.6 Augsburg Fulfilment Centre | Hautnah | 345 | 8 | 2.3 | 35 | 10.1 Houston Fulfilment Centre | Feather & Fin | 386 | 9 | 2.3 | 66 | 17.1 Zaandam Fulfilment Centre | Sorella Skin | 260 | 6 | 2.3 | 33 | 12.7 Bergen Fulfilment Centre | Hus & Hem | 274 | 6 | 2.2 | 30 | 10.9 Preston Fulfilment Centre | Rosehip Lab | 193 | 4 | 2.1 | 8 | 4.1 Dublin Fulfilment Centre | Basecamp Nord | 658 | 11 | 1.7 | 27 | 4.1 Amersfoort Fulfilment Centre | Kettle & Key | 310 | 5 | 1.6 | 17 | 5.5 Orlando Fulfilment Centre | Stoneware Studio | 378 | 6 | 1.6 | 16 | 4.2 Atlanta Fulfilment Centre | Cragsley Outfitters | 16301 | 251 | 1.5 | 1045 | 6.4 Eindhoven Fulfilment Centre | Hound Hamper | 200 | 3 | 1.5 | 19 | 9.5 Göteborg Fulfilment Centre | Paperplane Press | 265 | 4 | 1.5 | 28 | 10.6 Birmingham Fulfilment Centre | Folio & Fern | 309 | 4 | 1.3 | 30 | 9.7 Exeter Fulfilment Centre | Kayak Corner | 1598 | 21 | 1.3 | 65 | 4.1 Stockholm Fulfilment Centre | Barkley & Co. | 149 | 2 | 1.3 | 15 | 10.1 (50 rows)
Changed only where the benchmark needs the same result on every system
WITH t0 AS ( SELECT t4.warehouse_id AS warehouse_id, t4.variant_id AS variant_id, SUM(t4.quantity) AS total_quantity, SUM(t4.reserved_quantity) AS total_reserved_quantity, SUM(t4.reorder_point) AS total_reorder_point FROM ( SELECT si.variant_id AS variant_id, sl.warehouse_id AS warehouse_id, si.quantity AS quantity, si.reserved_quantity AS reserved_quantity, si.reorder_point AS reorder_point FROM stock_items si JOIN stock_locations sl ON sl.id = si.stock_location_id ) t4 GROUP BY t4.warehouse_id, t4.variant_id)SELECT w0.name AS warehouse_name, t9.name AS tenant_name, t1.variants_tracked AS variants_tracked, COALESCE(t2.variants_out_of_stock, 0) AS variants_out_of_stock, ROUND(100.0 * COALESCE(t2.variants_out_of_stock, 0) / t1.variants_tracked, 1) AS pct_out_of_stock, 100.0 * COALESCE(t2.variants_out_of_stock, 0) / t1.variants_tracked AS pct_out_of_stock, COALESCE(t3.variants_at_or_below_reorder_point, 0) AS variants_at_or_below_reorder_point, ROUND(100.0 * COALESCE(t3.variants_at_or_below_reorder_point, 0) / t1.variants_tracked, 1) AS pct_at_or_below_reorder 100.0 * COALESCE(t3.variants_at_or_below_reorder_point, 0) / t1.variants_tracked AS pct_at_or_below_reorderFROM warehouses w0JOIN tenants t9 ON t9.id = w0.tenant_idJOIN ( SELECT warehouse_id, COUNT(DISTINCT variant_id) AS variants_tracked FROM t0 GROUP BY warehouse_id) t1 ON t1.warehouse_id = w0.idLEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_out_of_stock FROM t0 WHERE (total_quantity - total_reserved_quantity) <= 0 GROUP BY warehouse_id) t2 ON t2.warehouse_id = w0.idLEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_at_or_below_reorder_point FROM t0 WHERE total_reorder_point IS NOT NULL AND total_quantity <= total_reorder_point GROUP BY warehouse_id) t3 ON t3.warehouse_id = w0.idWHERE t1.variants_tracked >= 20ORDER BY pct_out_of_stock DESC, warehouse_name ASCLIMIT 50ORDER BY pct_out_of_stock DESC NULLS FIRST, warehouse_name ASC NULLS LAST, w0.id ASC NULLS LAST{{fetch_first(50)}}
WITH t0 AS ( SELECT t4.warehouse_id AS warehouse_id, t4.variant_id AS variant_id, SUM(t4.quantity) AS total_quantity, SUM(t4.reserved_quantity) AS total_reserved_quantity, SUM(t4.reorder_point) AS total_reorder_point FROM ( SELECT si.variant_id AS variant_id, sl.warehouse_id AS warehouse_id, si.quantity AS quantity, si.reserved_quantity AS reserved_quantity, si.reorder_point AS reorder_point FROM stock_items si JOIN stock_locations sl ON sl.id = si.stock_location_id ) t4 GROUP BY t4.warehouse_id, t4.variant_id ) SELECT w0.name AS warehouse_name, t9.name AS tenant_name, t1.variants_tracked AS variants_tracked, COALESCE(t2.variants_out_of_stock, 0) AS variants_out_of_stock, 100.0 * COALESCE(t2.variants_out_of_stock, 0) / t1.variants_tracked AS pct_out_of_stock, COALESCE(t3.variants_at_or_below_reorder_point, 0) AS variants_at_or_below_reorder_point, 100.0 * COALESCE(t3.variants_at_or_below_reorder_point, 0) / t1.variants_tracked AS pct_at_or_below_reorder FROM warehouses w0 JOIN tenants t9 ON t9.id = w0.tenant_id JOIN ( SELECT warehouse_id, COUNT(DISTINCT variant_id) AS variants_tracked FROM t0 GROUP BY warehouse_id ) t1 ON t1.warehouse_id = w0.id LEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_out_of_stock FROM t0 WHERE (total_quantity - total_reserved_quantity) <= 0 GROUP BY warehouse_id ) t2 ON t2.warehouse_id = w0.id LEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_at_or_below_reorder_point FROM t0 WHERE total_reorder_point IS NOT NULL AND total_quantity <= total_reorder_point GROUP BY warehouse_id ) t3 ON t3.warehouse_id = w0.id WHERE t1.variants_tracked >= 20 ORDER BY pct_out_of_stock DESC NULLS FIRST, warehouse_name ASC NULLS LAST, w0.id ASC NULLS LAST FETCH FIRST 50 ROWS ONLY
WITH t0 AS ( SELECT t4.warehouse_id AS warehouse_id, t4.variant_id AS variant_id, SUM(t4.quantity) AS total_quantity, SUM(t4.reserved_quantity) AS total_reserved_quantity, SUM(t4.reorder_point) AS total_reorder_point FROM ( SELECT si.variant_id AS variant_id, sl.warehouse_id AS warehouse_id, si.quantity AS quantity, si.reserved_quantity AS reserved_quantity, si.reorder_point AS reorder_point FROM stock_items si JOIN stock_locations sl ON sl.id = si.stock_location_id ) t4 GROUP BY t4.warehouse_id, t4.variant_id ) SELECT w0.name AS warehouse_name, t9.name AS tenant_name, t1.variants_tracked AS variants_tracked, COALESCE(t2.variants_out_of_stock, 0) AS variants_out_of_stock, 100.0 * COALESCE(t2.variants_out_of_stock, 0) / t1.variants_tracked AS pct_out_of_stock, COALESCE(t3.variants_at_or_below_reorder_point, 0) AS variants_at_or_below_reorder_point, 100.0 * COALESCE(t3.variants_at_or_below_reorder_point, 0) / t1.variants_tracked AS pct_at_or_below_reorder FROM warehouses w0 JOIN tenants t9 ON t9.id = w0.tenant_id JOIN ( SELECT warehouse_id, COUNT(DISTINCT variant_id) AS variants_tracked FROM t0 GROUP BY warehouse_id ) t1 ON t1.warehouse_id = w0.id LEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_out_of_stock FROM t0 WHERE (total_quantity - total_reserved_quantity) <= 0 GROUP BY warehouse_id ) t2 ON t2.warehouse_id = w0.id LEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_at_or_below_reorder_point FROM t0 WHERE total_reorder_point IS NOT NULL AND total_quantity <= total_reorder_point GROUP BY warehouse_id ) t3 ON t3.warehouse_id = w0.id WHERE t1.variants_tracked >= 20 ORDER BY pct_out_of_stock DESC NULLS FIRST, warehouse_name ASC NULLS LAST, w0.id ASC NULLS LAST LIMIT 50
The agents' own records, as the role play wrote them; only the personal data of the person who ran it is redacted
Report request from Lena Hartmann (analyst for the Chief Operating Officer): Title: Current stockout exposure by warehouse, as of 2025-12-31 Question: As of now, how exposed are our fulfillment sites to stockouts, and how many SKUs are already at or below their reorder point? Grain: one row per warehouse Columns: - warehouse_name - tenant_name - variants_tracked (distinct variant_id with a stock_items row at a location in this warehouse) - variants_out_of_stock (quantity - reserved_quantity <= 0, summed across the warehouse's locations per variant, i.e. no sellable units left) - pct_out_of_stock - variants_at_or_below_reorder_point (reorder_point is not null and on-hand quantity <= reorder_point) - pct_at_or_below_reorder Details: Tables: stock_items (variant_id, stock_location_id, quantity, reserved_quantity, reorder_point) joined to stock_locations (warehouse_id) joined to warehouses (name, tenant_id) joined to tenants (name). This reflects the current live snapshot as replicated into the warehouse (effectively as of 2025-12-31) -- note in the report that this is a point-in-time view, not a trend over the year, since we don't have a reliable historical stockout event log. For variants present at multiple locations within the same warehouse, aggregate (sum quantity and reserved_quantity) to one on-hand figure per variant per warehouse before applying the out-of-stock and reorder-point tests. Round pct columns to 1 decimal (as %). Include only warehouses with at least 20 tracked variants. Order by pct_out_of_stock descending, tie-break by warehouse_name ascending. Cap at 50 rows. Check your query with the warehouse's dry_run tool, then hand it in with submit.
dry_runWITH t0 AS ( SELECT t4.warehouse_id AS warehouse_id, t4.variant_id AS variant_id, SUM(t4.quantity) AS total_quantity, SUM(t4.reserved_quantity) AS total_reserved_quantity, SUM(t4.reorder_point) AS total_reorder_point FROM ( SELECT si.variant_id AS variant_id, sl.warehouse_id AS warehouse_id, si.quantity AS quantity, si.reserved_quantity AS reserved_quantity, si.reorder_point AS reorder_point FROM stock_items si JOIN stock_locations sl ON sl.id = si.stock_location_id ) t4 GROUP BY t4.warehouse_id, t4.variant_id ) SELECT w0.name AS warehouse_name, t9.name AS tenant_name, t1.variants_tracked AS variants_tracked, COALESCE(t2.variants_out_of_stock, 0) AS variants_out_of_stock, ROUND(100.0 * COALESCE(t2.variants_out_of_stock, 0) / t1.variants_tracked, 1) AS pct_out_of_stock, COALESCE(t3.variants_at_or_below_reorder_point, 0) AS variants_at_or_below_reorder_point, ROUND(100.0 * COALESCE(t3.variants_at_or_below_reorder_point, 0) / t1.variants_tracked, 1) AS pct_at_or_below_reorder FROM warehouses w0 JOIN tenants t9 ON t9.id = w0.tenant_id JOIN ( SELECT warehouse_id, COUNT(DISTINCT variant_id) AS variants_tracked FROM t0 GROUP BY warehouse_id ) t1 ON t1.warehouse_id = w0.id LEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_out_of_stock FROM t0 WHERE (total_quantity - total_reserved_quantity) <= 0 GROUP BY warehouse_id ) t2 ON t2.warehouse_id = w0.id LEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_at_or_below_reorder_point FROM t0 WHERE total_reorder_point IS NOT NULL AND total_quantity <= total_reorder_point GROUP BY warehouse_id ) t3 ON t3.warehouse_id = w0.id WHERE t1.variants_tracked >= 20 ORDER BY pct_out_of_stock DESC, warehouse_name ASC LIMIT 50
STATUS: COMPILES (dry run on the empty schema, no data read) COLUMNS: warehouse_name, tenant_name, variants_tracked, variants_out_of_stock, pct_out_of_stock, variants_at_or_below_reorder_point, pct_at_or_below_reorder
submitWITH t0 AS ( SELECT t4.warehouse_id AS warehouse_id, t4.variant_id AS variant_id, SUM(t4.quantity) AS total_quantity, SUM(t4.reserved_quantity) AS total_reserved_quantity, SUM(t4.reorder_point) AS total_reorder_point FROM ( SELECT si.variant_id AS variant_id, sl.warehouse_id AS warehouse_id, si.quantity AS quantity, si.reserved_quantity AS reserved_quantity, si.reorder_point AS reorder_point FROM stock_items si JOIN stock_locations sl ON sl.id = si.stock_location_id ) t4 GROUP BY t4.warehouse_id, t4.variant_id ) SELECT w0.name AS warehouse_name, t9.name AS tenant_name, t1.variants_tracked AS variants_tracked, COALESCE(t2.variants_out_of_stock, 0) AS variants_out_of_stock, ROUND(100.0 * COALESCE(t2.variants_out_of_stock, 0) / t1.variants_tracked, 1) AS pct_out_of_stock, COALESCE(t3.variants_at_or_below_reorder_point, 0) AS variants_at_or_below_reorder_point, ROUND(100.0 * COALESCE(t3.variants_at_or_below_reorder_point, 0) / t1.variants_tracked, 1) AS pct_at_or_below_reorder FROM warehouses w0 JOIN tenants t9 ON t9.id = w0.tenant_id JOIN ( SELECT warehouse_id, COUNT(DISTINCT variant_id) AS variants_tracked FROM t0 GROUP BY warehouse_id ) t1 ON t1.warehouse_id = w0.id LEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_out_of_stock FROM t0 WHERE (total_quantity - total_reserved_quantity) <= 0 GROUP BY warehouse_id ) t2 ON t2.warehouse_id = w0.id LEFT JOIN ( SELECT warehouse_id, COUNT(*) AS variants_at_or_below_reorder_point FROM t0 WHERE total_reorder_point IS NOT NULL AND total_quantity <= total_reorder_point GROUP BY warehouse_id ) t3 ON t3.warehouse_id = w0.id WHERE t1.variants_tracked >= 20 ORDER BY pct_out_of_stock DESC, warehouse_name ASC LIMIT 50
Submitted to tonight's batch. Your work on this request is done.