Adding a condition to a query

$sql = <<<QUERY
SELECT 
  `s`.`session_id` AS ID,
  DATE_FORMAT(
    `s`.`session_date`,
    "%W, %M, %d, %Y"
  ) AS `DATE`,
  TIME_FORMAT(
    CONCAT(`s`.`time_slot_id`, ":00:00"),
    "%h:%i %p"
  ) AS `TIME`,
  `s`.`session_type` AS `TYPE`,
  `t`.`therapist_name` AS `THERAPIST`,
  `sc`.`session_status` AS `STATUS` 
FROM
  tbl_session_client sc 
  LEFT JOIN tbl_session s 
    ON `s`.`session_id` = `sc`.`session_id` 
  LEFT JOIN `tbl_therapist` `t` 
    ON `t`.`therapist_id` = `s`.`therapist_id` 
WHERE `sc`.`client_id` = :client_id 
  AND `s`.`session_status` = "Booked" 
ORDER BY `session_date` DESC
QUERY;

Select allOpen in new window