SELECT U.id, U.name, U.company_name, U.city, U.gst_no, (SELECT SUM(FB.total_book_seats) FROM flight_bookings FB LEFT JOIN flights F ON F.user_id = U.id WHERE FB.flight_id = F.id AND FB.seat_book_status = 1 AND (FB.booking_date BETWEEN '2023-02-01' AND '2023-02-28') ) AS seats_booked, 15 AS rate, (SELECT SUM(FB.total_book_seats) * 15 FROM flight_bookings FB LEFT JOIN flights F ON F.user_id = U.id WHERE FB.flight_id = F.id AND FB.seat_book_status = 1 AND (FB.booking_date BETWEEN '2023-02-01' AND '2023-02-28') ) AS total_before_tax FROM users U WHERE U.role_id IN (3) AND U.id NOT IN (3, 4, 19, 245) /// BOOK N TRAVEL SELECT U.name, U.company_name, U.city, U.gst_no, (SELECT SUM(FB.total_book_seats) FROM flight_bookings FB WHERE FB.flight_id = 0 AND FB.seat_book_status = 1 AND (FB.booking_date BETWEEN '2023-01-01' AND '2023-01-31') AND FB.user_id = U.id ) AS seats_booked, 15 AS rate, (SELECT SUM(FB.total_book_seats) * 15 FROM flight_bookings FB WHERE FB.flight_id = 0 AND FB.seat_book_status = 1 AND (FB.booking_date BETWEEN '2023-01-01' AND '2023-01-31') AND FB.user_id = U.id ) AS total_before_tax FROM users U WHERE U.role_id IN (3, 5) AND U.id NOT IN (3, 4, 19, 245)