[2025-09-19 23:19:08] INFO  Filters prepared (compression) {"qdf":"2025-09-05","qdt":"2025-09-19","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-09-19 23:19:08] INFO  DB connected (compression) 
[2025-09-19 23:19:09] INFO  Filters prepared (compression) {"qdf":"2025-09-05","qdt":"2025-09-19","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-09-19 23:19:09] INFO  DB connected (compression) 
[2025-09-19 23:19:09] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-05","2025-09-19"]}
[2025-09-19 23:19:09] INFO  SQL market avail for compression {"sql":"SELECT p.checkin, p.checkout, DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n                   FROM properties p\n                    WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                     AND DATE(p.query_date) IN (?,?)\n                     AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                  GROUP BY p.checkin, p.checkout, DATE(p.query_date)","pCount":33}
[2025-09-19 23:19:09] INFO  SQL market PPN (dCurr) {"sql":"SELECT p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                  WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                   AND DATE(p.query_date)=?\n                   AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                 GROUP BY p.id, p.checkin, p.checkout","pCount":32}
[2025-09-19 23:19:10] INFO  SQL our PPN (dCurr) {"sql":"SELECT p.id, p.name, p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                WHERE p.query_date > ?\n                  AND DATE(p.query_date)=?\n                  AND p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n                  AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                GROUP BY p.id, p.checkin, p.checkout","pCount":76}
[2025-09-19 23:19:10] ERROR Unhandled exception {"msg":"SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'booking_analysis.p.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by","trace":"#0 \/var\/www\/mssql.danmarcrm.com\/hotel\/v3\/compression_analytics.php(271): PDOStatement->execute()\n#1 \/var\/www\/mssql.danmarcrm.com\/hotel\/v3\/compression_api.php(32): CompressionAnalytics::compressionTable()\n#2 {main}"}
[2025-09-19 23:26:41] INFO  Filters prepared (compression) {"qdf":"2025-09-05","qdt":"2025-09-19","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-09-19 23:26:41] INFO  DB connected (compression) 
[2025-09-19 23:26:41] INFO  Filters prepared (compression) {"qdf":"2025-09-05","qdt":"2025-09-19","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-09-19 23:26:41] INFO  DB connected (compression) 
[2025-09-19 23:26:41] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-05","2025-09-19"]}
[2025-09-19 23:26:41] INFO  SQL market avail for compression {"sql":"SELECT p.checkin, p.checkout, DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n                   FROM properties p\n                    WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                     AND DATE(p.query_date) IN (?,?)\n                     AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                  GROUP BY p.checkin, p.checkout, DATE(p.query_date)","pCount":33}
[2025-09-19 23:26:41] INFO  SQL market PPN (dCurr) {"sql":"SELECT p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                  WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                   AND DATE(p.query_date)=?\n                   AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                 GROUP BY p.id, p.checkin, p.checkout","pCount":32}
[2025-09-19 23:26:42] INFO  SQL our PPN (dCurr) {"sql":"SELECT p.id, p.name, p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                WHERE p.query_date > ?\n                  AND DATE(p.query_date)=?\n                  AND p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n                  AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                GROUP BY p.id, p.checkin, p.checkout","pCount":76}
[2025-09-19 23:26:43] INFO  SQL rank pos (dCurr) {"sql":"SELECT po.id, po.checkin, po.checkout, MIN(po.pos) AS pos\n                 FROM properties_order po\n                WHERE DATE(po.query_date)=?\n                  AND ((po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?))\n                GROUP BY po.id, po.checkin, po.checkout","pCount":29}
[2025-09-19 23:26:45] INFO  Filters prepared (compression) {"qdf":"2025-09-05","qdt":"2025-09-19","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-09-19 23:26:45] INFO  DB connected (compression) 
[2025-09-19 23:26:45] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-05","2025-09-19"]}
[2025-09-19 23:26:47] INFO  Filters prepared (compression) {"qdf":"2025-09-05","qdt":"2025-09-19","ci":"2025-09-18","co":"2025-09-19","name":null,"ids":[],"limitW":14}
[2025-09-19 23:26:47] INFO  DB connected (compression) 
[2025-09-19 23:26:47] INFO  SQL pickup series {"sql":"SELECT DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n                AND p.checkin=? AND p.checkout=?\n             GROUP BY DATE(p.query_date)\n             ORDER BY DATE(p.query_date)","ci":"2025-09-18","co":"2025-09-19"}
[2025-09-20 14:59:10] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-20","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-09-20 14:59:10] INFO  DB connected (compression) 
[2025-09-20 14:59:10] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-20","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-09-20 14:59:10] INFO  DB connected (compression) 
[2025-09-20 14:59:10] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-20"]}
[2025-09-20 14:59:11] INFO  SQL market avail for compression {"sql":"SELECT p.checkin, p.checkout, DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n                   FROM properties p\n                    WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                     AND DATE(p.query_date) IN (?,?)\n                     AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                  GROUP BY p.checkin, p.checkout, DATE(p.query_date)","pCount":33}
[2025-09-20 14:59:11] INFO  SQL market PPN (dCurr) {"sql":"SELECT p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                  WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                   AND DATE(p.query_date)=?\n                   AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                 GROUP BY p.id, p.checkin, p.checkout","pCount":32}
[2025-09-20 14:59:12] INFO  SQL our PPN (dCurr) {"sql":"SELECT p.id, p.name, p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                WHERE p.query_date > ?\n                  AND DATE(p.query_date)=?\n                  AND p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n                  AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                GROUP BY p.id, p.checkin, p.checkout","pCount":76}
[2025-09-20 14:59:13] INFO  SQL rank pos (dCurr) {"sql":"SELECT po.id, po.checkin, po.checkout, MIN(po.pos) AS pos\n                 FROM properties_order po\n                WHERE DATE(po.query_date)=?\n                  AND ((po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?))\n                GROUP BY po.id, po.checkin, po.checkout","pCount":29}
[2025-09-20 14:59:14] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-20","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-09-20 14:59:14] INFO  DB connected (compression) 
[2025-09-20 14:59:14] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-20"]}
[2025-09-20 14:59:15] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-20","ci":"2025-09-18","co":"2025-09-19","name":null,"ids":[],"limitW":14}
[2025-09-20 14:59:15] INFO  DB connected (compression) 
[2025-09-20 14:59:15] INFO  SQL pickup series {"sql":"SELECT DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n                AND p.checkin=? AND p.checkout=?\n             GROUP BY DATE(p.query_date)\n             ORDER BY DATE(p.query_date)","ci":"2025-09-18","co":"2025-09-19"}
[2025-09-20 14:59:24] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-20","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-09-20 14:59:24] INFO  DB connected (compression) 
[2025-09-20 14:59:25] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-09-20 14:59:25] INFO  DB connected (compression) 
[2025-09-20 14:59:25] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-09-20 14:59:25] INFO  SQL market avail for compression {"sql":"SELECT p.checkin, p.checkout, DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n                   FROM properties p\n                    WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                     AND DATE(p.query_date) IN (?,?)\n                     AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                  GROUP BY p.checkin, p.checkout, DATE(p.query_date)","pCount":33}
[2025-09-20 14:59:25] INFO  SQL market PPN (dCurr) {"sql":"SELECT p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                  WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                   AND DATE(p.query_date)=?\n                   AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                 GROUP BY p.id, p.checkin, p.checkout","pCount":32}
[2025-09-20 14:59:26] INFO  SQL our PPN (dCurr) {"sql":"SELECT p.id, p.name, p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                WHERE p.query_date > ?\n                  AND DATE(p.query_date)=?\n                  AND p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n                  AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                GROUP BY p.id, p.checkin, p.checkout","pCount":76}
[2025-09-20 14:59:27] INFO  SQL rank pos (dCurr) {"sql":"SELECT po.id, po.checkin, po.checkout, MIN(po.pos) AS pos\n                 FROM properties_order po\n                WHERE DATE(po.query_date)=?\n                  AND ((po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?))\n                GROUP BY po.id, po.checkin, po.checkout","pCount":29}
[2025-09-20 14:59:28] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-09-20 14:59:28] INFO  DB connected (compression) 
[2025-09-20 14:59:28] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-09-20 14:59:29] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":"2025-09-18","co":"2025-09-19","name":null,"ids":[],"limitW":14}
[2025-09-20 14:59:29] INFO  DB connected (compression) 
[2025-09-20 14:59:29] INFO  SQL pickup series {"sql":"SELECT DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n                AND p.checkin=? AND p.checkout=?\n             GROUP BY DATE(p.query_date)\n             ORDER BY DATE(p.query_date)","ci":"2025-09-18","co":"2025-09-19"}
[2025-10-05 18:01:18] INFO  Filters prepared (compression) {"qdf":"2025-09-21","qdt":"2025-10-05","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-05 18:01:18] INFO  DB connected (compression) 
[2025-10-05 18:01:18] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-05 18:01:18] INFO  DB connected (compression) 
[2025-10-05 18:01:18] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-05 18:01:18] INFO  SQL market avail for compression {"sql":"SELECT p.checkin, p.checkout, DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n                   FROM properties p\n                    WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                     AND DATE(p.query_date) IN (?,?)\n                     AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                  GROUP BY p.checkin, p.checkout, DATE(p.query_date)","pCount":33}
[2025-10-05 18:01:18] INFO  SQL market PPN (dCurr) {"sql":"SELECT p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                  WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                   AND DATE(p.query_date)=?\n                   AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                 GROUP BY p.id, p.checkin, p.checkout","pCount":32}
[2025-10-05 18:01:20] INFO  SQL our PPN (dCurr) {"sql":"SELECT p.id, p.name, p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                WHERE p.query_date > ?\n                  AND DATE(p.query_date)=?\n                  AND p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n                  AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                GROUP BY p.id, p.checkin, p.checkout","pCount":76}
[2025-10-05 18:01:22] INFO  SQL rank pos (dCurr) {"sql":"SELECT po.id, po.checkin, po.checkout, MIN(po.pos) AS pos\n                 FROM properties_order po\n                WHERE DATE(po.query_date)=?\n                  AND ((po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?))\n                GROUP BY po.id, po.checkin, po.checkout","pCount":29}
[2025-10-05 18:01:24] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-05 18:01:24] INFO  DB connected (compression) 
[2025-10-05 18:01:24] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-05 18:01:26] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":"2025-09-18","co":"2025-09-19","name":null,"ids":[],"limitW":14}
[2025-10-05 18:01:26] INFO  DB connected (compression) 
[2025-10-05 18:01:26] INFO  SQL pickup series {"sql":"SELECT DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n                AND p.checkin=? AND p.checkout=?\n             GROUP BY DATE(p.query_date)\n             ORDER BY DATE(p.query_date)","ci":"2025-09-18","co":"2025-09-19"}
[2025-10-06 12:30:16] INFO  Filters prepared (compression) {"qdf":"2025-09-22","qdt":"2025-10-06","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-06 12:30:16] INFO  DB connected (compression) 
[2025-10-06 12:30:18] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-06 12:30:18] INFO  DB connected (compression) 
[2025-10-06 12:30:18] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-06 12:30:18] INFO  SQL market avail for compression {"sql":"SELECT p.checkin, p.checkout, DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n                   FROM properties p\n                    WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                     AND DATE(p.query_date) IN (?,?)\n                     AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                  GROUP BY p.checkin, p.checkout, DATE(p.query_date)","pCount":33}
[2025-10-06 12:30:18] INFO  SQL market PPN (dCurr) {"sql":"SELECT p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                  WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                   AND DATE(p.query_date)=?\n                   AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                 GROUP BY p.id, p.checkin, p.checkout","pCount":32}
[2025-10-06 12:30:20] INFO  SQL our PPN (dCurr) {"sql":"SELECT p.id, p.name, p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                WHERE p.query_date > ?\n                  AND DATE(p.query_date)=?\n                  AND p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n                  AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                GROUP BY p.id, p.checkin, p.checkout","pCount":76}
[2025-10-06 12:30:22] INFO  SQL rank pos (dCurr) {"sql":"SELECT po.id, po.checkin, po.checkout, MIN(po.pos) AS pos\n                 FROM properties_order po\n                WHERE DATE(po.query_date)=?\n                  AND ((po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?))\n                GROUP BY po.id, po.checkin, po.checkout","pCount":29}
[2025-10-06 12:30:25] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-06 12:30:25] INFO  DB connected (compression) 
[2025-10-06 12:30:25] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-06 12:30:25] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":"2025-09-18","co":"2025-09-19","name":null,"ids":[],"limitW":14}
[2025-10-06 12:30:25] INFO  DB connected (compression) 
[2025-10-06 12:30:25] INFO  SQL pickup series {"sql":"SELECT DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n                AND p.checkin=? AND p.checkout=?\n             GROUP BY DATE(p.query_date)\n             ORDER BY DATE(p.query_date)","ci":"2025-09-18","co":"2025-09-19"}
[2025-10-12 14:39:38] INFO  Filters prepared (compression) {"qdf":"2025-09-28","qdt":"2025-10-12","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-12 14:39:38] INFO  DB connected (compression) 
[2025-10-12 14:39:40] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-12 14:39:40] INFO  DB connected (compression) 
[2025-10-12 14:39:40] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-12 14:39:40] INFO  SQL market avail for compression {"sql":"SELECT p.checkin, p.checkout, DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n                   FROM properties p\n                    WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                     AND DATE(p.query_date) IN (?,?)\n                     AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                  GROUP BY p.checkin, p.checkout, DATE(p.query_date)","pCount":33}
[2025-10-12 14:39:40] INFO  SQL market PPN (dCurr) {"sql":"SELECT p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                  WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                   AND DATE(p.query_date)=?\n                   AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                 GROUP BY p.id, p.checkin, p.checkout","pCount":32}
[2025-10-12 14:39:48] INFO  SQL our PPN (dCurr) {"sql":"SELECT p.id, p.name, p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                WHERE p.query_date > ?\n                  AND DATE(p.query_date)=?\n                  AND p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n                  AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                GROUP BY p.id, p.checkin, p.checkout","pCount":76}
[2025-10-12 14:39:54] INFO  SQL rank pos (dCurr) {"sql":"SELECT po.id, po.checkin, po.checkout, MIN(po.pos) AS pos\n                 FROM properties_order po\n                WHERE DATE(po.query_date)=?\n                  AND ((po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?))\n                GROUP BY po.id, po.checkin, po.checkout","pCount":29}
[2025-10-12 14:40:00] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-12 14:40:00] INFO  DB connected (compression) 
[2025-10-12 14:40:00] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-12 14:40:03] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":"2025-09-18","co":"2025-09-19","name":null,"ids":[],"limitW":14}
[2025-10-12 14:40:03] INFO  DB connected (compression) 
[2025-10-12 14:40:03] INFO  SQL pickup series {"sql":"SELECT DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n                AND p.checkin=? AND p.checkout=?\n             GROUP BY DATE(p.query_date)\n             ORDER BY DATE(p.query_date)","ci":"2025-09-18","co":"2025-09-19"}
[2025-10-12 16:02:14] INFO  Filters prepared (compression) {"qdf":"2025-09-28","qdt":"2025-10-12","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-12 16:02:14] INFO  DB connected (compression) 
[2025-10-12 16:02:14] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-12 16:02:14] INFO  DB connected (compression) 
[2025-10-12 16:02:14] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-12 16:02:15] INFO  SQL market avail for compression {"sql":"SELECT p.checkin, p.checkout, DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n                   FROM properties p\n                    WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                     AND DATE(p.query_date) IN (?,?)\n                     AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                  GROUP BY p.checkin, p.checkout, DATE(p.query_date)","pCount":33}
[2025-10-12 16:02:15] INFO  SQL market PPN (dCurr) {"sql":"SELECT p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                  WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                   AND DATE(p.query_date)=?\n                   AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                 GROUP BY p.id, p.checkin, p.checkout","pCount":32}
[2025-10-12 16:02:17] INFO  SQL our PPN (dCurr) {"sql":"SELECT p.id, p.name, p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                WHERE p.query_date > ?\n                  AND DATE(p.query_date)=?\n                  AND p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n                  AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                GROUP BY p.id, p.checkin, p.checkout","pCount":76}
[2025-10-12 16:02:19] INFO  SQL rank pos (dCurr) {"sql":"SELECT po.id, po.checkin, po.checkout, MIN(po.pos) AS pos\n                 FROM properties_order po\n                WHERE DATE(po.query_date)=?\n                  AND ((po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?))\n                GROUP BY po.id, po.checkin, po.checkout","pCount":29}
[2025-10-12 16:02:22] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-12 16:02:22] INFO  DB connected (compression) 
[2025-10-12 16:02:22] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-12 16:02:23] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":"2025-09-18","co":"2025-09-19","name":null,"ids":[],"limitW":14}
[2025-10-12 16:02:23] INFO  DB connected (compression) 
[2025-10-12 16:02:23] INFO  SQL pickup series {"sql":"SELECT DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n                AND p.checkin=? AND p.checkout=?\n             GROUP BY DATE(p.query_date)\n             ORDER BY DATE(p.query_date)","ci":"2025-09-18","co":"2025-09-19"}
[2025-10-14 19:36:26] INFO  Filters prepared (compression) {"qdf":"2025-09-30","qdt":"2025-10-14","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-14 19:36:26] INFO  DB connected (compression) 
[2025-10-14 19:36:27] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-14 19:36:27] INFO  DB connected (compression) 
[2025-10-14 19:36:27] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-14 19:36:27] INFO  SQL market avail for compression {"sql":"SELECT p.checkin, p.checkout, DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n                   FROM properties p\n                    WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                     AND DATE(p.query_date) IN (?,?)\n                     AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                  GROUP BY p.checkin, p.checkout, DATE(p.query_date)","pCount":33}
[2025-10-14 19:36:27] INFO  SQL market PPN (dCurr) {"sql":"SELECT p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                  WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                   AND DATE(p.query_date)=?\n                   AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                 GROUP BY p.id, p.checkin, p.checkout","pCount":32}
[2025-10-14 19:36:31] INFO  SQL our PPN (dCurr) {"sql":"SELECT p.id, p.name, p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                WHERE p.query_date > ?\n                  AND DATE(p.query_date)=?\n                  AND p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n                  AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                GROUP BY p.id, p.checkin, p.checkout","pCount":76}
[2025-10-14 19:36:33] INFO  SQL rank pos (dCurr) {"sql":"SELECT po.id, po.checkin, po.checkout, MIN(po.pos) AS pos\n                 FROM properties_order po\n                WHERE DATE(po.query_date)=?\n                  AND ((po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?))\n                GROUP BY po.id, po.checkin, po.checkout","pCount":29}
[2025-10-14 19:36:45] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-14 19:36:45] INFO  DB connected (compression) 
[2025-10-14 19:36:45] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-14 19:36:46] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":"2025-09-18","co":"2025-09-19","name":null,"ids":[],"limitW":14}
[2025-10-14 19:36:46] INFO  DB connected (compression) 
[2025-10-14 19:36:46] INFO  SQL pickup series {"sql":"SELECT DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n                AND p.checkin=? AND p.checkout=?\n             GROUP BY DATE(p.query_date)\n             ORDER BY DATE(p.query_date)","ci":"2025-09-18","co":"2025-09-19"}
[2025-10-21 11:52:32] INFO  Filters prepared (compression) {"qdf":"2025-10-07","qdt":"2025-10-21","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-21 11:52:32] INFO  DB connected (compression) 
[2025-10-21 11:52:33] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-21 11:52:33] INFO  DB connected (compression) 
[2025-10-21 11:52:33] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-21 11:52:33] INFO  SQL market avail for compression {"sql":"SELECT p.checkin, p.checkout, DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n                   FROM properties p\n                    WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                     AND DATE(p.query_date) IN (?,?)\n                     AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                  GROUP BY p.checkin, p.checkout, DATE(p.query_date)","pCount":33}
[2025-10-21 11:52:33] INFO  SQL market PPN (dCurr) {"sql":"SELECT p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                  WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                   AND DATE(p.query_date)=?\n                   AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                 GROUP BY p.id, p.checkin, p.checkout","pCount":32}
[2025-10-21 11:52:37] INFO  SQL our PPN (dCurr) {"sql":"SELECT p.id, p.name, p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                WHERE p.query_date > ?\n                  AND DATE(p.query_date)=?\n                  AND p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n                  AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                GROUP BY p.id, p.checkin, p.checkout","pCount":76}
[2025-10-21 11:52:40] INFO  SQL rank pos (dCurr) {"sql":"SELECT po.id, po.checkin, po.checkout, MIN(po.pos) AS pos\n                 FROM properties_order po\n                WHERE DATE(po.query_date)=?\n                  AND ((po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?))\n                GROUP BY po.id, po.checkin, po.checkout","pCount":29}
[2025-10-21 11:52:42] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-10-21 11:52:42] INFO  DB connected (compression) 
[2025-10-21 11:52:42] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-09-06","2025-09-22"]}
[2025-10-21 11:52:42] INFO  Filters prepared (compression) {"qdf":"2025-09-06","qdt":"2025-09-22","ci":"2025-09-18","co":"2025-09-19","name":null,"ids":[],"limitW":14}
[2025-10-21 11:52:42] INFO  DB connected (compression) 
[2025-10-21 11:52:42] INFO  SQL pickup series {"sql":"SELECT DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n                AND p.checkin=? AND p.checkout=?\n             GROUP BY DATE(p.query_date)\n             ORDER BY DATE(p.query_date)","ci":"2025-09-18","co":"2025-09-19"}
[2025-11-01 13:55:45] INFO  Filters prepared (compression) {"qdf":"2025-10-18","qdt":"2025-11-01","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-11-01 13:55:45] INFO  DB connected (compression) 
[2025-11-01 13:55:45] INFO  Filters prepared (compression) {"qdf":"2025-10-18","qdt":"2025-11-01","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-11-01 13:55:45] INFO  DB connected (compression) 
[2025-11-01 13:55:45] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-10-18","2025-11-01"]}
[2025-11-01 13:55:45] INFO  SQL market avail for compression {"sql":"SELECT p.checkin, p.checkout, DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n                   FROM properties p\n                    WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                     AND DATE(p.query_date) IN (?,?)\n                     AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                  GROUP BY p.checkin, p.checkout, DATE(p.query_date)","pCount":33}
[2025-11-01 13:55:45] INFO  SQL market PPN (dCurr) {"sql":"SELECT p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                  WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n                   AND DATE(p.query_date)=?\n                   AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                 GROUP BY p.id, p.checkin, p.checkout","pCount":32}
[2025-11-01 13:55:45] INFO  SQL our PPN (dCurr) {"sql":"SELECT p.id, p.name, p.checkin, p.checkout,\n                      MIN(CASE WHEN rd.staying_nights>0 THEN rd.raw_price\/rd.staying_nights END) AS ppn\n                 FROM properties p\n                 JOIN room_details rd\n                   ON rd.hotel_id=p.id\n                  AND rd.checkin=p.checkin AND rd.checkout=p.checkout\n                  AND DATE(rd.query_date)=DATE(p.query_date)\n                WHERE p.query_date > ?\n                  AND DATE(p.query_date)=?\n                  AND p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n                  AND ((p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?) OR (p.checkin=? AND p.checkout=?))\n                GROUP BY p.id, p.checkin, p.checkout","pCount":227}
[2025-11-01 13:55:45] INFO  SQL rank pos (dCurr) {"sql":"SELECT po.id, po.checkin, po.checkout, MIN(po.pos) AS pos\n                 FROM properties_order po\n                WHERE DATE(po.query_date)=?\n                  AND ((po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?) OR (po.checkin=? AND po.checkout=?))\n                GROUP BY po.id, po.checkin, po.checkout","pCount":29}
[2025-11-01 13:55:48] INFO  Filters prepared (compression) {"qdf":"2025-10-18","qdt":"2025-11-01","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-11-01 13:55:48] INFO  DB connected (compression) 
[2025-11-01 13:55:48] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-10-18","2025-11-01"]}
[2025-11-01 13:55:49] INFO  Filters prepared (compression) {"qdf":"2025-10-18","qdt":"2025-11-01","ci":"2025-10-18","co":"2025-10-19","name":null,"ids":[],"limitW":14}
[2025-11-01 13:55:49] INFO  DB connected (compression) 
[2025-11-01 13:55:49] INFO  SQL pickup series {"sql":"SELECT DATE(p.query_date) AS qd, SUM(p.total_rooms) AS avail\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n                AND p.checkin=? AND p.checkout=?\n             GROUP BY DATE(p.query_date)\n             ORDER BY DATE(p.query_date)","ci":"2025-10-18","co":"2025-10-19"}
[2025-11-24 17:24:35] INFO  Filters prepared (compression) {"qdf":"2025-11-10","qdt":"2025-11-24","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-11-24 17:24:35] INFO  DB connected (compression) 
[2025-11-24 17:24:35] INFO  Filters prepared (compression) {"qdf":"2025-11-10","qdt":"2025-11-24","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-11-24 17:24:35] INFO  DB connected (compression) 
[2025-11-24 17:24:35] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-11-10","2025-11-24"]}
[2025-11-24 17:24:35] INFO  Filters prepared (compression) {"qdf":"2025-11-10","qdt":"2025-11-24","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-11-24 17:24:35] INFO  DB connected (compression) 
[2025-11-24 17:24:35] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-11-10","2025-11-24"]}
[2025-11-24 17:24:39] INFO  Filters prepared (compression) {"qdf":"2025-11-10","qdt":"2025-11-24","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-11-24 17:24:39] INFO  DB connected (compression) 
[2025-11-24 17:24:39] INFO  Filters prepared (compression) {"qdf":"2025-11-10","qdt":"2025-11-24","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-11-24 17:24:39] INFO  DB connected (compression) 
[2025-11-24 17:24:39] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-11-10","2025-11-24"]}
[2025-11-24 17:24:39] INFO  Filters prepared (compression) {"qdf":"2025-11-10","qdt":"2025-11-24","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-11-24 17:24:39] INFO  DB connected (compression) 
[2025-11-24 17:24:39] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-11-10","2025-11-24"]}
[2025-11-24 17:24:48] INFO  Filters prepared (compression) {"qdf":"2025-11-10","qdt":"2025-11-24","ci":null,"co":null,"name":null,"ids":[],"limitW":14}
[2025-11-24 17:24:48] INFO  DB connected (compression) 
[2025-11-24 17:24:48] INFO  Filters prepared (compression) {"qdf":"2025-11-10","qdt":"2025-11-24","ci":"2025-11-24","co":"2025-11-30","name":null,"ids":[],"limitW":14}
[2025-11-24 17:24:48] INFO  DB connected (compression) 
[2025-11-24 17:24:48] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-11-10","2025-11-24","2025-11-24","2025-11-30"]}
[2025-11-24 17:24:48] INFO  Filters prepared (compression) {"qdf":"2025-11-10","qdt":"2025-11-24","ci":"2025-11-24","co":"2025-11-30","name":null,"ids":[],"limitW":14}
[2025-11-24 17:24:48] INFO  DB connected (compression) 
[2025-11-24 17:24:48] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-11-10","2025-11-24","2025-11-24","2025-11-30"]}
[2025-11-24 19:34:44] INFO  Filters prepared (compression) {"qdf":"2025-11-10","qdt":"2025-11-24","ci":"2025-11-24","co":"2025-11-30","name":null,"ids":[],"limitW":14}
[2025-11-24 19:34:44] INFO  DB connected (compression) 
[2025-11-24 19:34:44] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-11-10","2025-11-24","2025-11-24","2025-11-30"]}
[2025-11-24 19:34:44] INFO  Filters prepared (compression) {"qdf":"2025-11-10","qdt":"2025-11-24","ci":"2025-11-24","co":"2025-11-30","name":null,"ids":[],"limitW":14}
[2025-11-24 19:34:44] INFO  DB connected (compression) 
[2025-11-24 19:34:44] INFO  SQL windows (compression) {"sql":"SELECT p.checkin, p.checkout\n              FROM properties p\n               WHERE p.query_date > ? AND DATE(p.query_date) >= ? AND DATE(p.query_date) <= ? AND p.checkin >= ? AND p.checkout <= ? \n             GROUP BY p.checkin, p.checkout\n             ORDER BY p.checkin ASC, p.checkout ASC\n             LIMIT 14","p":["2025-09-18","2025-11-10","2025-11-24","2025-11-24","2025-11-30"]}
