$sample = R::getAll('SELECT game_text_info.title, game_text_info.descr,games.* FROM game_text_info,games WHERE game_text_info.game_id = games.id AND game_text_info.local = :local AND game_text_info.title LIKE :search UNION SELECT game_text_info.title, game_text_info.descr,games.* FROM game_text_info,games WHERE game_text_info.game_id = games.id AND game_text_info.local = "en" AND game_text_info.title LIKE :search',[':local'=>$test_local,':search'=>'%'.$_GET['searchtext'].'%']);
$user = R::findOne('users,'id = :id ',[':id'=> айди_юзера]);
<img src="<?$user['avatar']?>" alt="">
$user = R::getRow('SELECT avatars.*,users.* FROM avatars,users WHERE users.id = :id AND avatars.user_id = users.id',[':id'=> айди_юзера]');