=== CHECKING ALL POOLS ===

Pool Table Columns:
  - ID (int(11))
  - CustomerID (int(11))
  - PoolName (varchar(100))
  - PoolType (enum('Δημόσια','Ιδιωτική'))
  - PoolSize (varchar(100))
  - Location (varchar(255))
  - ChemicalType (varchar(100))
  - Status (enum('Ενεργό','Ανενεργό'))
  - RegistrationDate (timestamp)
  - UpdatedDate (timestamp)
  - Notes (text)
  - ChargingMethod (varchar(20))
  - ChargingAmount (decimal(10,2))
  - CreatedBy (int(11))
  - FilterDetails (varchar(500))
  - FilterPhotos (longtext)
  - PumpDetails (varchar(500))
  - PumpPhotos (longtext)
  - PoolVolume (varchar(100))
  - SkimmerType (varchar(100))
  - OverflowType (varchar(100))


Pool Data:
  Pool #1: ID=4, Name=THE MASSERIA, Method=Per Hour, Amount=8.00
  Pool #2: ID=5, Name=House, Method=Per Hour, Amount=8.00
  Pool #3: ID=6, Name=Villa Pandesia, Method=Per Visit, Amount=25.00
  Pool #4: ID=7, Name=Viva Tourismo Resort naturist club, Method=Per Visit, Amount=25.00
  Pool #5: ID=9, Name=Paradissia Luxe Villa, Method=Per Visit, Amount=20.00
  Pool #6: ID=10, Name=Danae Hotel, Method=Per Visit, Amount=40.00


=== CHECKING COMPLETED TASKS ===

Task Table Columns (relevant):
  - ID (int(11))
  - PoolID (int(11))
  - TaskName (varchar(100))
  - Status (enum('Εκκρεμείς','Σε εξέλιξη','Ολοκληρωμένο'))
  - StartedAt (datetime)
  - CompletedDate (datetime)
  - HoursWorked (decimal(10,2))
  - TaskCost (decimal(10,2))
  - TotalAmount (decimal(10,2))


Last 3 Completed Tasks:
  Task #131: Pool=7, Name=Καθαρισμός
    TaskCost=25.00, HoursWorked=0.00, TotalAmount=25.00
    Started=2026-06-05 09:15:14
    Completed=2026-06-05 14:51:32

  Task #129: Pool=10, Name=Καθαρισμός
    TaskCost=40.00, HoursWorked=0.00, TotalAmount=40.00
    Started=2026-06-04 22:28:07
    Completed=2026-06-04 23:10:08

  Task #128: Pool=9, Name=Καθαρισμός
    TaskCost=20.00, HoursWorked=0.00, TotalAmount=20.00
    Started=2026-06-03 19:13:40
    Completed=2026-06-03 20:16:08

=== CHECKING IF LEFT JOIN WORKS ===

Last completed task with LEFT JOIN:
  Task ID: 99
  Pool ID: 9
  Pool Name: Paradissia Luxe Villa
  ChargingMethod: Per Visit
  ChargingAmount: 20.00