QL-query: 
EXPLAIN SELECT *
FROM db_chars a
LEFT JOIN db_rankings b ON a.char_id = b.char_id
LEFT JOIN db_profiles c ON a.char_id = c.char_id
 [Edit] [Skip Explain SQL] [Create PHP Code]



id 	select_type 	table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
1 	SIMPLE 	a 	ALL 	NULL 	NULL 	NULL 	NULL 	2613907 	 
1 	SIMPLE 	b 	ref 	char_id 	char_id 	4 	wowguru_db.a.char_id 	1 	 
1 	SIMPLE 	c 	eq_ref 	PRIMARY 	PRIMARY 	4 	wowguru_db.a.char_id 	1 	

db_chars

char_id 	int(11) 	  	PRI 	NULL 	auto_increment
name 	varchar(255) 	  	MUL 	  	 
server 	varchar(255) 	  	MUL 	  	 
locale 	char(2) 	  	  	  	 
class_id 	int(11) 	  	MUL 	0 	 
race_id 	int(11) 	  	MUL 	0 	 
author 	varchar(255) 	  	  	  	 
gender_id 	char(1) 	  	  	0 	 
level 	int(11) 	  	  	0 	 
faction 	char(1) 	  	  	  	 
guild_id 	int(11) 	  	MUL 	0 	 
lastseen 	int(11) 	  	  	0 	  

db_profiles

char_id  	int(11)  	   	PRI  	NULL  	auto_increment
guild_title 	varchar(255) 	YES 	  	NULL 	 
guild_rank 	int(11) 	  	  	0 	 
guild_note 	varchar(255) 	YES 	  	NULL 	 
intel 	int(11) 	  	  	0 	 
spirit 	int(11) 	  	  	0 	 
sta 	int(11) 	  	  	0 	 
agi 	int(11) 	  	  	0 	 
str 	int(11) 	  	  	0 	 
arcane_resist 	int(11) 	  	  	0 	 
fire_resist 	int(11) 	  	  	0 	 
frost_resist 	int(11) 	  	  	0 	 
nature_resist 	int(11) 	  	  	0 	 
shadow_resist 	int(11) 	  	  	0 	 
feetslot 	varchar(255) 	YES 	  	NULL 	 
wristslot 	varchar(255) 	YES 	  	NULL 	 
mainhandslot 	varchar(255) 	YES 	  	NULL 	 
neckslot 	varchar(255) 	  	  	  	 
rangedslot 	varchar(255) 	  	  	  	 
finger0slot 	varchar(255) 	YES 	  	NULL 	 
finger1slot 	varchar(255) 	YES 	  	NULL 	 
trinket0slot 	varchar(255) 	  	  	0 	 
trinket1slot 	varchar(255) 	  	  	0 	 
backslot 	varchar(255) 	YES 	  	NULL 	 
handslot 	varchar(255) 	YES 	  	NULL 	 
legslot 	varchar(255) 	YES 	  	NULL 	 
waistslot 	varchar(255) 	YES 	  	NULL 	 
chestslot 	varchar(255) 	YES 	  	NULL 	 
headslot 	varchar(255) 	YES 	  	NULL 	 
shoulderslot 	varchar(255) 	YES 	  	NULL 	 
tabardslot 	varchar(255) 	YES 	  	NULL 	 
secondaryhandslot 	varchar(255) 	YES 	  	NULL 	 
shirtslot 	varchar(255) 	YES 	  	NULL 	 
ranged_power 	int(11) 	  	  	0 	 
ranged_damage_min 	int(11) 	  	  	0 	 
ranged_damage_max 	int(11) 	  	  	0 	 
melee_attack 	int(11) 	  	  	0 	 
coins 	int(11) 	  	  	0 	 
mana 	int(11) 	  	  	0 	 
health 	int(11) 	  	  	0 	 
ranged_attack 	int(11) 	  	  	0 	 
armor 	int(11) 	  	  	0 	 
melee_power 	int(11) 	  	  	0 	 
melee_damage_min 	int(11) 	  	  	0 	 
melee_damage_max 	int(11) 	  	  	0 	 
timestamp 	int(11) 	  	  	0 	 
xp_current 	int(11) 	  	  	0 	 
xp_level 	int(11) 	  	  	0 	 
intel_adj 	int(11) 	  	  	0 	 
spirit_adj 	int(11) 	  	  	0 	 
sta_adj 	int(11) 	  	  	0 	 
agi_adj 	int(11) 	  	  	0 	 
str_adj 	int(11) 	  	  	0 	 
armor_adj 	int(11) 	  	  	0 	 

db_rankings

ranking_id  	int(11)  	   	PRI  	NULL  	auto_increment
char_id 	int(11) 	  	MUL 	0 	 
position 	int(11) 	  	MUL 	0 	 
global_position 	int(11) 	  	  	0 	 
guild_position 	int(11) 	  	MUL 	0 	 
server_position 	int(11) 	  	MUL 	0 	 
rank 	int(11) 	  	MUL 	0 	 
lhk 	int(11) 	  	MUL 	0 	 
ldk 	int(11) 	  	MUL 	0 	 
rating 	int(11) 	  	MUL 	0 	 
timestamp 	int(11) 	  	  	0