UPDATE planwise_seat_availabilities PSA SET PSA.sold_seats = (SELECT COUNT(id) FROM flight_ticket_prices FTP 
        WHERE FTP.ticket_date = PSA.flight_date AND FTP.flight_id = PSA.flight_id AND booked_status = 1 )

WHERE PSA.plan_no = 1


UPDATE planwise_seat_availabilities PSA SET PSA.infant_seats = ( SELECT COUNT(FBD.id) FROM 
  flight_booking_details FBD 
  LEFT JOIN flight_bookings FB ON FB.patner_booking_id = FBD.id
  WHERE FB.flight_id = PSA.flight_id AND FB.departure_date = PSA.flight_date
  AND FB.seat_book_status = 1
  AND FBD.flight_ticket_price_id = 0)
  
WHERE PSA.plan_no = 1


UPDATE planwise_seat_availabilities PSA SET PSA.blocked_seats = ( SELECT COUNT(id) FROM
  flight_ticket_prices FTP 
  WHERE FTP.flight_id = PSA.flight_id AND FTP.ticket_date = PSA.flight_date AND FTP.booked_status = 2 )

WHERE PSA.plan_no = 1


UPDATE planwise_seat_availabilities PSA SET PSA.date_blocked = ( SELECT IF(COUNT(id) > 0, 1, 0) AS blocked FROM
  flight_ticket_prices FTP
  WHERE FTP.flight_id = PSA.flight_id AND FTP.ticket_date = PSA.flight_date AND FTP.booked_status = 4 )

WHERE PSA.plan_no = 1


UPDATE planwise_seat_availabilities PSA SET PSA.price = ( SELECT MIN(plan_1) FROM 
  flight_ticket_prices FTP
  WHERE FTP.ticket_date = PSA.flight_date AND FTP.flight_id = PSA.flight_id AND FTP.booked_status != 1 )

WHERE PSA.plan_no = 1