=== TESTING LEFT JOINS ===

TEST 1: Check payment_transactions table
✅ payment_transactions table exists
Columns: id, transaction_ref, booking_id, user_id, gateway_id, gateway_name, amount, currency, status, payment_method, gateway_response, gateway_transaction_id, customer_email, customer_phone, metadata, paid_at, created_at, updated_at, 

TEST 2: Check inspection_schedules table
✅ inspection_schedules table exists
Columns: id, booking_id, inspection_type, scheduled_date, scheduled_time, meeting_link, meeting_location, status, completed_at, tenant_notes, landlord_notes, created_at, updated_at, 

TEST 3: Query WITHOUT LEFT JOINs


Fatal error:  Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, bool given in /home/fransamh/public_html/test_left_joins.php:63
Stack trace:
#0 {main}
  thrown in /home/fransamh/public_html/test_left_joins.php on line 63