[2025-12-26 00:59:26] [repricer_with_lock] Lock acquired successfully. PID: 3226202
 SQL Query: SELECT ap.* FROM amazon_products ap INNER JOIN (
                SELECT asin, fulfillment, MIN(COALESCE(lastbbcheck, '1900-01-01')) as min_lastbbcheck
                FROM amazon_products
                WHERE fulfillable_quantity > 0
                  AND repricer = 1 and pcondition='NewItem'
                  AND active = 1
                GROUP BY asin, fulfillment
            ) grouped_ap ON ap.asin = grouped_ap.asin 
            AND ap.fulfillment = grouped_ap.fulfillment
            AND (ap.lastbbcheck = grouped_ap.min_lastbbcheck OR (ap.lastbbcheck IS NULL AND grouped_ap.min_lastbbcheck = '1900-01-01'))
            WHERE ap.fulfillable_quantity > 0
            ORDER BY 
                CASE WHEN ap.lastbbcheck IS NULL THEN 0 ELSE 1 END,
                ap.lastbbcheck ASC
            LIMIT 15;<br/><br/>Found 15 products to process<br/>ASIN: 0300235771 (lastbbcheck: 2025-12-25 09:24:08)<br/>ASIN: 190828174X (lastbbcheck: 2025-12-25 09:24:08)<br/>ASIN: 0241399750 (lastbbcheck: 2025-12-25 09:24:08)<br/>ASIN: 1843175576 (lastbbcheck: 2025-12-25 09:26:03)<br/>ASIN: 1842555677 (lastbbcheck: 2025-12-25 09:26:03)<br/>ASIN: 1840923822 (lastbbcheck: 2025-12-25 09:26:04)<br/>ASIN: 184358297X (lastbbcheck: 2025-12-25 09:26:04)<br/>ASIN: 1472248589 (lastbbcheck: 2025-12-25 09:26:04)<br/>ASIN: 1783445041 (lastbbcheck: 2025-12-25 09:26:05)<br/>ASIN: 1785040383 (lastbbcheck: 2025-12-25 09:26:05)<br/>ASIN: 1861051956 (lastbbcheck: 2025-12-25 09:26:05)<br/>ASIN: 1842551310 (lastbbcheck: 2025-12-25 09:26:06)<br/>ASIN: 178295645X (lastbbcheck: 2025-12-25 09:26:06)<br/>ASIN: 024138656X (lastbbcheck: 2025-12-25 09:26:06)<br/>ASIN: 1849496757 (lastbbcheck: 2025-12-25 09:26:06)<br/><br/>Error processing competitive data: Unauthorized (401) Response: {"error_description":"Client authentication failed","error":"invalid_client"}<br/>SQL Query: SELECT ap.* FROM amazon_products ap INNER JOIN (
                SELECT asin, fulfillment, MIN(COALESCE(lastbbcheck, '1900-01-01')) as min_lastbbcheck
                FROM amazon_products
                WHERE fulfillable_quantity > 0
                  AND repricer = 1 and pcondition='NewItem'
                  AND active = 1
                GROUP BY asin, fulfillment
            ) grouped_ap ON ap.asin = grouped_ap.asin 
            AND ap.fulfillment = grouped_ap.fulfillment
            AND (ap.lastbbcheck = grouped_ap.min_lastbbcheck OR (ap.lastbbcheck IS NULL AND grouped_ap.min_lastbbcheck = '1900-01-01'))
            WHERE ap.fulfillable_quantity > 0
            ORDER BY 
                CASE WHEN ap.lastbbcheck IS NULL THEN 0 ELSE 1 END,
                ap.lastbbcheck ASC
            LIMIT 15;<br/><br/>Found 15 products to process<br/>ASIN: 0300235771 (lastbbcheck: 2025-12-25 09:24:08)<br/>ASIN: 190828174X (lastbbcheck: 2025-12-25 09:24:08)<br/>ASIN: 0241399750 (lastbbcheck: 2025-12-25 09:24:08)<br/>ASIN: 1843175576 (lastbbcheck: 2025-12-25 09:26:03)<br/>ASIN: 1842555677 (lastbbcheck: 2025-12-25 09:26:03)<br/>ASIN: 1840923822 (lastbbcheck: 2025-12-25 09:26:04)<br/>ASIN: 184358297X (lastbbcheck: 2025-12-25 09:26:04)<br/>ASIN: 1472248589 (lastbbcheck: 2025-12-25 09:26:04)<br/>ASIN: 1783445041 (lastbbcheck: 2025-12-25 09:26:05)<br/>ASIN: 1785040383 (lastbbcheck: 2025-12-25 09:26:05)<br/>ASIN: 1861051956 (lastbbcheck: 2025-12-25 09:26:05)<br/>ASIN: 1842551310 (lastbbcheck: 2025-12-25 09:26:06)<br/>ASIN: 178295645X (lastbbcheck: 2025-12-25 09:26:06)<br/>ASIN: 024138656X (lastbbcheck: 2025-12-25 09:26:06)<br/>ASIN: 1849496757 (lastbbcheck: 2025-12-25 09:26:06)<br/><br/>Error processing competitive data: Unauthorized (401) Response: {"error_description":"Client authentication failed","error":"invalid_client"}<br/>Script completed in 0.7237241268158 seconds<br/> [2025-12-26 00:59:27] [repricer_with_lock] Lock released successfully.