Comparing Data for:
  Check-in: 2025-12-19 to 2025-12-25
  Query Date: 2025-12-14 to 2025-12-19
  Filter: comp1
--------------------------------------------------

Filter IDs count: 13

--> Fetching MySQL Data... Done in 1.651s. Rows: 1426
--> Fetching MongoDB Data... [2025-12-20 19:59:14] [SUCCESS] Connected to MongoDB database: booking_analysis
Done in 0.101s. Rows: 1312

--------------------------------------------------
COMPARISON RESULTS
--------------------------------------------------
Metric                    | MySQL (V2)      | MongoDB (V3)    | Diff      
---------------------------------------------------------------------------
Total Rows (Agg)          | 1426            | 1312            | -114      
Total Available Units     | 1804            | 1686            | -118      
Unique Stay Windows       | 91              | 91              | 0         
Participating Hotels      | 13              | 13              | 0         

[!] Data Mismatch Detected. Detailed analysis of missing/extra items in Mongo:
  - Missing in Mongo: 11003943|1100394302|2025-12-19|2025-12-20|2025-12-14 (Val: 1)
  - Missing in Mongo: 11003943|1100394302|2025-12-19|2025-12-20|2025-12-15 (Val: 1)
  - Missing in Mongo: 11003943|1100394302|2025-12-19|2025-12-20|2025-12-16 (Val: 1)
  - Missing in Mongo: 11003943|1100394302|2025-12-19|2025-12-20|2025-12-17 (Val: 1)
  - Missing in Mongo: 11003943|1100394302|2025-12-19|2025-12-20|2025-12-18 (Val: 1)
  - Extra in Mongo: 15081492|0|2025-12-25|2025-12-26|2025-12-15 (Val: 0)
  - Extra in Mongo: 15081492|0|2025-12-21|2025-12-22|2025-12-18 (Val: 0)
  - Extra in Mongo: 15081492|0|2025-12-21|2025-12-22|2025-12-14 (Val: 0)
  - Extra in Mongo: 15046719|0|2025-12-25|2025-12-26|2025-12-18 (Val: 0)
  - Extra in Mongo: 15046719|0|2025-12-24|2025-12-25|2025-12-17 (Val: 0)
  ... Total Missing in Mongo: 437
  ... Total Extra in Mongo: 253

--------------------------------------------------
COMPARISON: COMPETITOR POSITIONS (properties_order)
--------------------------------------------------
--> Fetching MySQL Positions...