CREATE ALGORITHM=UNDEFINED DEFINER=`minecraft`@`%` SQL SECURITY DEFINER VIEW `block_changes` AS
select `lb-main`.`id` AS `id`,`lb-main`.`date` AS `date`,`lb-players`.`playername` AS `playername`,`lb-main`.`replaced` AS `replaced`,`lb-main`.`type` AS `type`,`lb-main`.`data` AS `data`,`lb-main`.`x` AS `x`,`lb-main`.`y` AS `y`,`lb-main`.`z` AS `z`
from (`lb-players` join `lb-main`)
where (`lb-players`.`playerid` = `lb-main`.`playerid`)