<commit_before># --------------------------------------------------------
# Host:                         127.0.0.1
# Server version:               5.3.1-MariaDB
# Server OS:                    Win32
# HeidiSQL version:             6.0.0.3603
# Date/time:                    2011-10-16 19:39:53
# --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

use galaxy;

# Dumping structure for procedure galaxy.sp_GetPlayer
DELIMITER //
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_GetPlayer`(IN `object_id` BIGINT)
BEGIN
CALL sp_GetObject(object_id);
select * from player p, players_status_flags ps, players_profile_flags pp where p.id = object_id and ps.player_id = object_id and pp.player_id = object_id;
call sp_GetPlayerAbilities(object_id);
call sp_GetPlayerDraftSchematics(object_id);
call sp_GetFriends(object_id);
call sp_GetFSQuestList(object_id);
call sp_GetIgnoredList(object_id);
call sp_GetQuestJournal(object_id);<commit_msg>Updated select statement to get the data appropriatel.y<commit_after># --------------------------------------------------------
# Host:                         127.0.0.1
# Server version:               5.3.1-MariaDB
# Server OS:                    Win32
# HeidiSQL version:             6.0.0.3603
# Date/time:                    2011-10-16 19:39:53
# --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

use galaxy;

# Dumping structure for procedure galaxy.sp_GetPlayer
DELIMITER //
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_GetPlayer`(IN `object_id` BIGINT)
BEGIN
CALL sp_GetObject(object_id);

SELECT * 
FROM player
WHERE player.id = object_id ;

SELECT status_flag.flag
FROM status_flag
LEFT JOIN players_status_flags ON players_status_flags.status_flag_id = status_flag.id
WHERE players_status_flags.player_id = object_id;

SELECT profile_flag.flag
FROM profile_flag
LEFT JOIN players_profile_flags ON players_profile_flags.profile_flag_id = profile_flag.id
WHERE players_profile_flags.player_id = object_id;

call sp_GetPlayerAbilities(object_id);
call sp_GetPlayerDraftSchematics(object_id);
call sp_GetFriends(object_id);
call sp_GetFSQuestList(object_id);
call sp_GetIgnoredList(object_id);
call sp_GetQuestJournal(object_id);
{'fraction_non_alphanumeric': 0.1746384872080089, 'fraction_numerical': 0.04004449388209121, 'mean_word_length': 2.9560117302052786, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 4, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7048336', 'n_tokens_mistral': 938, 'n_tokens_neox': 865, 'n_words': 173}