Consulta SQL

-- Query B: future paid_at values
SELECT id, start_date, end_date, paid_at, total_price, status, payment_status
FROM bookings
WHERE paid_at > CURDATE()
ORDER BY paid_at DESC;

Consulta SQL

-- Query A: the 48 orphans
SELECT id, start_date, created_at, paid_at, total_price, status
FROM bookings
WHERE payment_status = 'paid' AND paid_at IS NULL
ORDER BY start_date;

Resultado

id,start_date,created_at,paid_at,total_price,status
136,2026-09-12 00:00:00,2026-09-12 18:17:54,"","285.60",completed
6,2026-09-16 00:00:00,2026-09-11 10:45:43,"","201.60",completed
3092,2026-09-16 00:00:00,2026-09-19 16:37:38,"","50.00",completed
179,2026-09-17 00:00:00,2026-09-13 19:23:09,"","126.00",completed
3088,2026-09-18 00:00:00,2026-09-19 13:38:41,"","21.00",completed
180,2026-09-18 00:00:00,2026-09-13 19:26:21,"","151.20",completed
3091,2026-09-19 00:00:00,2026-09-19 15:57:30,"","100.00",completed
3074,2026-09-20 00:00:00,2026-09-18 00:10:23,"","130.50",completed
183,2026-09-24 00:00:00,2026-09-13 19:30:40,"","70.00",completed
6841,2026-09-24 00:00:00,2026-09-24 09:24:22,"","126.00",completed
86,2026-09-24 12:00:00,2026-09-11 10:45:44,"","42.00",completed
84,2026-09-24 12:00:00,2026-09-11 10:45:44,"","123.20",completed
3,2026-09-25 00:00:00,2026-09-11 10:45:43,"","28.00",completed
28,2026-09-25 00:00:00,2026-09-11 10:45:43,"","44.80",completed
3082,2026-09-25 00:00:00,2026-09-18 13:01:03,"","31.50",completed
6832,2026-09-25 00:00:00,2026-09-23 11:44:16,"","28.00",completed
6848,2026-09-25 00:00:00,2026-09-24 16:22:02,"","28.00",completed
110,2026-09-25 00:00:00,2026-09-11 10:45:44,"","89.60",completed
3119,2026-09-26 00:00:00,2026-09-20 19:18:46,"","28.00",completed
6855,2026-09-26 00:00:00,2026-09-25 08:05:29,"","14.00",completed
3093,2026-09-26 00:00:00,2026-09-19 20:07:33,"","14.00",completed
2242,2026-09-26 00:00:00,2026-09-16 06:58:03,"","43.50",completed
6831,2026-09-26 00:00:00,2026-09-23 11:00:40,"","29.00",completed
6843,2026-09-26 00:00:00,2026-09-24 10:00:17,"","14.00",completed
6847,2026-09-26 00:00:00,2026-09-24 16:20:01,"","14.50",completed
24,2026-09-26 12:00:00,2026-09-11 10:45:43,"","22.40",completed
102,2026-09-27 00:00:00,2026-09-11 10:45:44,"","134.40",completed
67,2026-09-27 12:00:00,2026-09-11 10:45:44,"","14.00",completed
65,2026-09-28 00:00:00,2026-09-11 10:45:44,"","112.00",completed
6862,2026-09-28 00:00:00,2026-09-25 15:46:30,"","56.00",completed
3100,2026-09-30 00:00:00,2026-09-20 12:44:06,"","154.00",completed
2240,2026-09-30 00:00:00,2026-09-15 17:56:06,"","98.00",completed
3071,2026-09-30 00:00:00,2026-09-17 16:01:42,"","130.50",completed
71,2026-10-01 12:00:00,2026-09-11 10:45:44,"","56.00",completed
6907,2026-10-02 00:00:00,2026-10-02 08:30:07,"","42.00",completed
114,2026-10-02 00:00:00,2026-09-11 10:45:44,"","112.00",completed
6865,2026-10-02 00:00:00,2026-09-25 17:19:57,"","28.00",completed
6839,2026-10-02 00:00:00,2026-09-23 20:13:53,"","29.00",completed
2241,2026-10-02 00:00:00,2026-09-15 17:57:42,"","28.00",completed
2237,2026-10-02 00:00:00,2026-09-15 16:05:11,"","23.40",completed
19,2026-10-03 00:00:00,2026-09-11 10:45:43,"","14.00",completed
3081,2026-10-03 00:00:00,2026-09-18 10:42:35,"","22.40",completed
6902,2026-10-05 00:00:00,2026-10-01 15:29:34,"","12.00",completed
6906,2026-10-05 00:00:00,2026-10-01 18:50:30,"","8.00",completed
117,2026-10-05 12:00:00,2026-09-11 10:45:44,"","67.20",completed
6924,2026-10-06 00:00:00,2026-10-05 07:07:26,"","12.00",completed
6942,2026-10-07 00:00:00,2026-10-07 06:26:31,"","14.00",completed
6915,2026-10-08 00:00:00,2026-10-03 10:34:52,"","23.40",completed
6943,2026-10-08 00:00:00,2026-10-07 06:57:34,"","14.50",completed
6935,2026-10-09 00:00:00,2026-10-06 06:14:18,"","14.00",completed
6936,2026-10-09 00:00:00,2026-10-06 09:27:21,"","14.00",completed

Consulta SQL

SELECT a.id AS id_a, b.id AS id_b,
  a.start_date, a.end_date,
  ca.name AS cliente_a, cb.name AS cliente_b
,ca.id  ,a.customer_id
FROM bookings a
JOIN bookings b ON b.id > a.id
  AND b.start_date < a.end_date
  AND b.end_date > a.start_date
  AND b.status NOT IN ('cancelled','rejected')
  AND a.status NOT IN ('cancelled','rejected')
JOIN customers ca ON ca.id = a.customer_id
JOIN customers cb ON cb.id = b.customer_id
LIMIT 50