Query Sql - 3 Left Loin

Olá

Preciso dar um LEFT JOIN em 3 tabelas:

char.charid = picklog.char_id

item_db.id = picklog.nameid

Alguém poderia me dar uma ajuda, para identificar o que estou fazendo de errado, pois quando uso

assim funciona:

$strSQL = "SELECT `char`.name, picklog.id, picklog.time, picklog.char_id, picklog.type, picklog.nameid, picklog.amount, picklog.refine, picklog.card0, picklog.card1, picklog.card2, picklog.card3, picklog.map FROM picklog LEFT JOIN `char` ON(picklog.char_id = `char`.char_id) WHERE type='T' AND `char`.account_id = $accountID order by picklog.id limit 15";
$rs = mysql_query($strSQL);

while($row = mysql_fetch_array($rs)) { } Já deste modo não lista nada.

$strSQL = "SELECT `item_db`.id, `item_db`.name_japanese, `char`.name, picklog.id, picklog.time, picklog.char_id, picklog.type, picklog.nameid, picklog.amount, picklog.refine, picklog.card0, picklog.card1, picklog.card2, picklog.card3, picklog.map FROM picklog LEFT JOIN `char` ON(picklog.char_id = `char`.char_id) LEFT JOIN `item_db` ON(picklog.nameid = `item_db`.id) WHERE type='T' AND `char`.account_id = $accountID order by picklog.id limit 15";
$rs = mysql_query($strSQL);

while($row = mysql_fetch_array($rs)) { } Muito obrigado pela atenção e colaboração.