SELECT *
FROM `customer_session` AS `s`
LEFT JOIN `visit` AS `v`
ON `v`.`session_id` = `s`.`session_id`
AND `v`.`customer_id` = `s`.`customer_id`
AND `v`.`date` = '2022-05-06'
WHERE `s`.`session_id` = 1
&
, угловые скобки как <
и >
.
newDiv
- переменная.'newDiv'
- строка.