[2025-08-05 01:42:25] [test_repricer_query] Lock acquired successfully. PID: 3580921
 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: B0C94WYHC2 | SKU: J3-43T7-JRLL | lastbbcheck: 2025-08-04 20:31:23 | bb_loss_streak: 397 | price: 5.000000 | min: 5.000000<br/>ASIN: B0CD7SL9M5 | SKU: KP-C6A8-2VHA | lastbbcheck: 2025-08-04 20:33:10 | bb_loss_streak: 397 | price: 5.000000 | min: 5.000000<br/>ASIN: 1473626781 | SKU: new_YEGMNXXFFJ | lastbbcheck: 2025-08-04 18:47:33 | bb_loss_streak: 395 | price: 4.490000 | min: 4.490000<br/>ASIN: B0CD85V8QL | SKU: MD-IIFZ-UXZ6 | lastbbcheck: 2025-08-04 20:39:05 | bb_loss_streak: 395 | price: 5.000000 | min: 5.000000<br/>ASIN: 1862309574 | SKU: new_NSZNJLSKO | lastbbcheck: 2025-08-04 22:37:06 | bb_loss_streak: 394 | price: 3.990000 | min: 3.990000<br/>ASIN: 144471144X | SKU: new_TCXRALNVC | lastbbcheck: 2025-08-05 01:03:31 | bb_loss_streak: 390 | price: 4.990000 | min: 4.990000<br/>ASIN: 1472126971 | SKU: ONMXHBQJV | lastbbcheck: 2025-08-04 20:31:22 | bb_loss_streak: 387 | price: 4.990000 | min: 4.990000<br/>ASIN: 073604681X | SKU: new_DYBWNOOJT | lastbbcheck: 2025-08-04 20:37:06 | bb_loss_streak: 347 | price: 18.480000 | min: 5.000000<br/>ASIN: 1844483746 | SKU: new_YVFHGZSCGD | lastbbcheck: 2025-08-04 20:57:04 | bb_loss_streak: 280 | price: 4.890000 | min: 4.890000<br/>ASIN: 0736911545 | SKU: U1-S-KG-new_EBPKAGSKLW | lastbbcheck: 2025-08-04 22:23:06 | bb_loss_streak: 280 | price: 19.230000 | min: 4.750000<br/>ASIN: 1853260355 | SKU: new_BZCFLRUQEM | lastbbcheck: 2025-08-04 20:37:11 | bb_loss_streak: 277 | price: 3.990000 | min: 3.990000<br/>ASIN: 1805076485 | SKU: U1-S-FF-new_KYBFKUPJKX | lastbbcheck: 2025-08-04 20:39:07 | bb_loss_streak: 277 | price: 1.000000 | min: 1.000000<br/>ASIN: 1842040812 | SKU: new_IUHRMPIKC | lastbbcheck: 2025-08-04 20:39:09 | bb_loss_streak: 277 | price: 3.990000 | min: 3.990000<br/>ASIN: 1853261408 | SKU: U1-S-JK-new_HSKVJOGCJP | lastbbcheck: 2025-08-04 20:39:13 | bb_loss_streak: 277 | price: 3.990000 | min: 3.990000<br/>ASIN: 1407171224 | SKU: new_VUFEAJXR | lastbbcheck: 2025-08-05 01:03:25 | bb_loss_streak: 277 | price: 4.780000 | min: 4.780000<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-08-05 02:42:25] [test_repricer_query] Lock released successfully.