TYPE=VIEW
query=select `jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`job`.`fk_client` AS `fk_client`,`jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`survey`.`fk_job` AS `fk_job`,`jjlourens2`.`survey`.`comments` AS `comments`,`jjlourens2`.`survey`.`q3RateService` AS `q3RateService` from ((`jjlourens2`.`clientdetails` join `jjlourens2`.`job` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`survey` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`survey`.`fk_job`))) where (`jjlourens2`.`survey`.`q3RateService` = _latin1\'Awesome\')
md5=d880ce88a23721219d21dcb27242955d
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2023-10-09 10:39:24
create-version=1
source=SELECT \n        `jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,\n        `jjlourens2`.`clientdetails`.`clName` AS `clName`,\n        `jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,\n        `jjlourens2`.`job`.`fk_client` AS `fk_client`,\n        `jjlourens2`.`job`.`pk_job` AS `pk_job`,\n        `jjlourens2`.`survey`.`fk_job` AS `fk_job`,\n        `jjlourens2`.`survey`.`comments` AS `comments`,\n        `jjlourens2`.`survey`.`q3RateService` AS `q3RateService`\n    FROM\n        ((`jjlourens2`.`clientdetails`\n        JOIN `jjlourens2`.`job` ON ((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`)))\n        JOIN `jjlourens2`.`survey` ON ((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`survey`.`fk_job`)))\n    WHERE\n        (`jjlourens2`.`survey`.`q3RateService` = _LATIN1\'Awesome\')
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`job`.`fk_client` AS `fk_client`,`jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`survey`.`fk_job` AS `fk_job`,`jjlourens2`.`survey`.`comments` AS `comments`,`jjlourens2`.`survey`.`q3RateService` AS `q3RateService` from ((`jjlourens2`.`clientdetails` join `jjlourens2`.`job` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`survey` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`survey`.`fk_job`))) where (`jjlourens2`.`survey`.`q3RateService` = \'Awesome\')
mariadb-version=50568