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.042s. Rows: 1426
--> Fetching MongoDB Data... Done in 0.690s. Rows: 1393

--------------------------------------------------
COMPARISON RESULTS
--------------------------------------------------
Metric                    | MySQL (V2)      | MongoDB (V3)    | Diff      
---------------------------------------------------------------------------
Total Rows (Agg)          | 1426            | 1393            | -33       
Total Available Units     | 1804            | 1800            | -4        
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: 11003943|0|2025-12-25|2025-12-26|2025-12-19 (Val: 0)
  - Extra in Mongo: 9191287|919128707|2025-12-25|2025-12-26|2025-12-19 (Val: 1)
  - Extra in Mongo: 9191287|919128705|2025-12-25|2025-12-26|2025-12-19 (Val: 1)
  - Extra in Mongo: 5790446|0|2025-12-25|2025-12-26|2025-12-19 (Val: 0)
  - Extra in Mongo: 15046719|0|2025-12-25|2025-12-26|2025-12-18 (Val: 0)
  ... Total Missing in Mongo: 369
  ... Total Extra in Mongo: 265

--------------------------------------------------
COMPARISON: COMPETITOR POSITIONS (properties_order)
--------------------------------------------------
--> Fetching MySQL Positions... Failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hotel_id' in 'where clause'
--> Fetching Mongo Positions... Done.
Metric                    | MySQL           | MongoDB        
------------------------------------------------------------
Count                     | 0               | 0              
Avg Pos                   | 0               | 0              
Min Pos                   | 0               | -              
Max Pos                   | 0               | -