[2025-12-26 02:37:22] [test_repricer_query] Lock acquired successfully. PID: 3226222
 Testing products with NULL lastbbcheck:<br/>Found 0 products with NULL lastbbcheck<br/><br/><br/>Looking for ASIN 0718183568:<br/>Found target product:<br/>ID: 79683<br/>ASIN: 0718183568<br/>lastbbcheck: 2025-06-30 12:19:28<br/>fulfillable_quantity: 0<br/>repricer: 1<br/>pcondition: NewItem<br/>active: 0<br/>❌ lastbbcheck is not NULL<br/>❌ fulfillable_quantity <= 0<br/>❌ active != 1<br/><br/><br/>Testing repricer query...<br/>SQL: SELECT ap.* FROM amazon_products ap INNER JOIN (
            SELECT asin, MIN(lastbbcheck) as min_lastbbcheck
            FROM amazon_products
WHERE (lastbbcheck IS NULL OR lastbbcheck < DATE_SUB(NOW(), INTERVAL 30 MINUTE))
              AND fulfillable_quantity > 0
              AND repricer = 1 and pcondition='NewItem'
              AND active = 1
            GROUP BY asin
        ) grouped_ap ON ap.asin = grouped_ap.asin
        AND (ap.lastbbcheck = grouped_ap.min_lastbbcheck OR ap.lastbbcheck IS NULL AND grouped_ap.min_lastbbcheck IS NULL)
        WHERE ap.fulfillable_quantity > 0
        ORDER BY 
            CASE WHEN ap.lastbbcheck IS NULL THEN 0 ELSE 1 END,
            ap.bb_loss_streak DESC,
            ap.lastbbcheck ASC, 
            ap.id ASC
        LIMIT 15;<br/><br/>Found 15 products<br/><br/>ASIN: B0CD85V8QL | SKU: MD-IIFZ-UXZ6 | lastbbcheck: 2025-12-25 12:14:05 | bb_loss_streak: 751 | price: 5.000000 | min: 5.000000<br/>ASIN: B0C94WYHC2 | SKU: J3-43T7-JRLL | lastbbcheck: 2025-12-25 12:12:04 | bb_loss_streak: 750 | price: 5.000000 | min: 5.000000<br/>ASIN: B0CD7SL9M5 | SKU: KP-C6A8-2VHA | lastbbcheck: 2025-12-25 12:12:06 | bb_loss_streak: 750 | price: 5.000000 | min: 5.000000<br/>ASIN: 1407198688 | SKU: new_SGABXCXORY | lastbbcheck: 2025-12-25 21:46:05 | bb_loss_streak: 628 | price: 5.000000 | min: 5.000000<br/>ASIN: 0192769553 | SKU: new_IYINGMGBB | lastbbcheck: 2025-12-25 21:46:05 | bb_loss_streak: 627 | price: 4.990000 | min: 4.990000<br/>ASIN: 0192746537 | SKU: new_GWMXLAJFC | lastbbcheck: 2025-12-25 19:22:04 | bb_loss_streak: 624 | price: 3.990000 | min: 3.990000<br/>ASIN: 1804184438 | SKU: new_FKWVEONLC | lastbbcheck: 2025-12-25 21:50:05 | bb_loss_streak: 620 | price: 5.000000 | min: 5.000000<br/>ASIN: 0141324929 | SKU: new_ZHLJNTZSCC | lastbbcheck: 2025-12-25 21:48:05 | bb_loss_streak: 619 | price: 5.000000 | min: 5.000000<br/>ASIN: 1408303779 | SKU: new_MIHUVWIHXZ | lastbbcheck: 2025-12-25 21:50:05 | bb_loss_streak: 609 | price: 5.000000 | min: 5.000000<br/>ASIN: 1408808331 | SKU: new_GJEKQIJYL | lastbbcheck: 2025-12-25 21:48:04 | bb_loss_streak: 581 | price: 5.000000 | min: 5.000000<br/>ASIN: 1844483746 | SKU: new_YVFHGZSCGD | lastbbcheck: 2025-12-26 01:56:06 | bb_loss_streak: 503 | price: 4.890000 | min: 4.890000<br/>ASIN: 0763634034 | SKU: new_NOXBTBBEPU | lastbbcheck: 2025-12-26 01:54:05 | bb_loss_streak: 485 | price: 22.790000 | min: 5.000000<br/>ASIN: 0743489667 | SKU: U1-S-W-new_CBYQVBPFOC | lastbbcheck: 2025-12-25 21:26:04 | bb_loss_streak: 478 | price: 4.750000 | min: 4.750000<br/>ASIN: 1925559726 | SKU: U1-S-R-new_NENMMYVDDC | lastbbcheck: 2025-12-25 21:18:04 | bb_loss_streak: 477 | price: 4.750000 | min: 4.750000<br/>ASIN: 0857059793 | SKU: U1-S-X-new_AXUYUOGXQE | lastbbcheck: 2025-12-25 21:32:05 | bb_loss_streak: 477 | price: 4.750000 | min: 4.750000<br/><br/><br/>Testing specifically for ASIN 0718183568:<br/>Product found:<br/>ASIN: 0718183568<br/>SKU: new_FUTHIOFXLA<br/>fulfillable_quantity: 0<br/>repricer: 1<br/>pcondition: NewItem<br/>active: 0<br/>lastbbcheck: 2025-06-30 12:19:28<br/>bb_loss_streak: 12<br/>price: 6.710000<br/>min: 5.000000<br/> [2025-12-26 02:37:22] [test_repricer_query] Lock released successfully.