[2025-11-10 22:16:25] [repricer] Lock acquired successfully. PID: 2723403
 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: 1406300365 (lastbbcheck: 2025-11-10 06:34:08)<br/>ASIN: 1900360209 (lastbbcheck: 2025-11-10 06:34:09)<br/>ASIN: 0273712519 (lastbbcheck: 2025-11-10 06:36:03)<br/>ASIN: 0099514192 (lastbbcheck: 2025-11-10 06:36:04)<br/>ASIN: 1171408196 (lastbbcheck: 2025-11-10 06:36:04)<br/>ASIN: 1857993055 (lastbbcheck: 2025-11-10 06:36:04)<br/>ASIN: 1529324343 (lastbbcheck: 2025-11-10 06:36:04)<br/>ASIN: 1577171330 (lastbbcheck: 2025-11-10 06:36:05)<br/>ASIN: 0747220107 (lastbbcheck: 2025-11-10 06:36:05)<br/>ASIN: 884761418X (lastbbcheck: 2025-11-10 06:36:05)<br/>ASIN: 0002187701 (lastbbcheck: 2025-11-10 06:36:06)<br/>ASIN: 0593034791 (lastbbcheck: 2025-11-10 06:36:06)<br/>ASIN: 1760340677 (lastbbcheck: 2025-11-10 06:36:06)<br/>ASIN: 0571221335 (lastbbcheck: 2025-11-10 06:36:07)<br/>ASIN: 0754830837 (lastbbcheck: 2025-11-10 06:36:07)<br/><br/>SKU: U1-S-C-new_MIKISTGEAJ, DB Price: £22.440000, Min Price: £4.750000vs API Price: £. vs FE Price: £ winner:no newprice:22.440000<br/>ASIN: 1900360209 DB Price: £58.400000 vs API Price: £58.4. vs FE Price: £<br/>Competition: Position 1 of 1, Gap: £N/A<br/>SKU: U1-S-CB-new_BMCXOOTOLK, DB Price: £30.390000, Min Price: £4.750000vs API Price: £. vs FE Price: £ winner:no newprice:30.390000<br/>ASIN: 0099514192 DB Price: £5.660000 vs API Price: £5.66. vs FE Price: £<br/>Competition: Position 1 of 1, Gap: £N/A<br/>ASIN: 1171408196 DB Price: £15.790000 vs API Price: £14.99. vs FE Price: £15.63<br/>ASIN: 1857993055 DB Price: £50.440000 vs API Price: £50.44. vs FE Price: £<br/>Competition: Position 1 of 1, Gap: £N/A<br/>ASIN: 1529324343 DB Price: £12.150000 vs API Price: £11.85. vs FE Price: £11.9<br/>ASIN: 1577171330 DB Price: £21.400000 vs API Price: £21.4. vs FE Price: £23.86<br/>Competition: Position 1 of 1, Gap: £N/A<br/>ASIN: 0747220107 DB Price: £28.900000 vs API Price: £28.9. vs FE Price: £<br/>Competition: Position 1 of 1, Gap: £N/A<br/>ASIN: 884761418X DB Price: £41.250000 vs API Price: £41.25. vs FE Price: £<br/>Competition: Position 1 of 1, Gap: £N/A<br/>ASIN: 0002187701 DB Price: £9.300000 vs API Price: £9.3. vs FE Price: £<br/>Competition: Position 1 of 1, Gap: £N/A<br/>ASIN: 0593034791 DB Price: £7.900000 vs API Price: £7.9. vs FE Price: £<br/>Competition: Position 1 of 1, Gap: £N/A<br/>ASIN: 1760340677 DB Price: £4.890000 vs API Price: £4.89. vs FE Price: £5.04<br/>Competition: Position 1 of 1, Gap: £N/A<br/>ASIN: 0571221335 DB Price: £13.050000 vs API Price: £13.05. vs FE Price: £13.8<br/>Competition: Position 1 of 1, Gap: £N/A<br/>ASIN: 0754830837 DB Price: £7.850000 vs API Price: £7.85. vs FE Price: £<br/>Competition: Position 1 of 1, Gap: £N/A<br/>I==  1Page processed in 5.7269 seconds.[2025-11-10 22:16:31] [repricer] Lock released successfully.