TYPE=VIEW
query=select `dywtpn`.`games`.`name` AS `games_name`,`dywtpn`.`games`.`time_played` AS `time_played`,`dywtpn`.`games`.`play_count` AS `play_count`,`dywtpn`.`games`.`category` AS `category`,`dywtpn`.`games`.`completed` AS `completed`,`dywtpn`.`games`.`score` AS `score`,`dywtpn`.`library`.`name` AS `library_name` from (`dywtpn`.`games` join `dywtpn`.`library` on((`dywtpn`.`library`.`id` = `dywtpn`.`games`.`library`)))
md5=a7337ac8d3fed8b8af6dda056d02aba5
updatable=1
algorithm=0
definer_user=root
definer_host=127.0.0.1
suid=2
with_check_option=0
timestamp=2024-06-15 17:21:07
create-version=1
source=select games.name as games_name, games.time_played, play_count, category, completed, score, library.name as library_name from games INNER JOIN library ON library.id = games.library
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `dywtpn`.`games`.`name` AS `games_name`,`dywtpn`.`games`.`time_played` AS `time_played`,`dywtpn`.`games`.`play_count` AS `play_count`,`dywtpn`.`games`.`category` AS `category`,`dywtpn`.`games`.`completed` AS `completed`,`dywtpn`.`games`.`score` AS `score`,`dywtpn`.`library`.`name` AS `library_name` from (`dywtpn`.`games` join `dywtpn`.`library` on((`dywtpn`.`library`.`id` = `dywtpn`.`games`.`library`)))
