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
revision=4
timestamp=2016-12-14 13:47:25
create-version=1
source=SELECT
\n	`clientdetails`.`clSurname` AS `clSurname`,
\n	`clientdetails`.`clName` AS `clName`,
\n	`clientdetails`.`pk_client` AS `pk_client`,
\n	`job`.`fk_client` AS `fk_client`,
\n	`job`.`pk_job` AS `pk_job`,
\n	`survey`.`fk_job` AS `fk_job`,
\n	`survey`.`comments` AS `comments`,
\n	`survey`.`q3RateService` AS `q3RateService`
\nFROM
\n	(
\n		(
\n			`clientdetails`
\n			JOIN `job` ON(
\n				(
\n					`clientdetails`.`pk_client` = `job`.`fk_client`
\n				)
\n			)
\n		)
\n		JOIN `survey` ON(
\n			(
\n				`job`.`pk_job` = `survey`.`fk_job`
\n			)
\n		)
\n	)
\nWHERE q3RateService =\'Awesome\'