Looking for PoolID: 7

Running query: SELECT t.*, p.ChargingMethod, p.ChargingAmount 
              FROM tblmaintenance_tasks t 
              LEFT JOIN tblpools p ON t.PoolID = p.ID 
              WHERE t.ID = '131'

=== Result from LEFT JOIN query ===
ChargingMethod from JOIN: Per Visit
ChargingAmount from JOIN: 25.00
PoolID from task: 7

=== Calculation ===
floatval(ChargingAmount) = 25
HoursWorked = 5.61
TotalAmount = 25 * 5.61 = 140.25