Company of Heroes

Query : SELECT A.id FROM xcoins_helpinghans.xcoins_user A LEFT JOIN xcoins_common_tables.twitch_user B ON A.name_id = B.id WHERE B.name = ?
Data : s, juribel
Query : SELECT A.id, timestamp_firstseen, timestamp_lastseen, timestamp_joined_army, message_count, balance, comments, xcoins_won, xcoins_lost, bets_on_win, bets_on_lose, current_streak, max_pos_streak, max_neg_streak, successes, correct, incorrect, name, donated, subscribed, customTitleEnabled, customTitle, D.title as rankTitle, D.abbreviation as rankAbbreviation, D.imageURL as rankImageURL, E.title as armyTitle, E.abbreviation as armyAbbreviation, E.imageURL as armyImageURL, rank_id, army_id, importance_id, cost, min_success_required, ranks_available, F.importance FROM xcoins_helpinghans.xcoins_user A NATURAL JOIN xcoins_helpinghans.xcoins_user_stats B LEFT JOIN xcoins_common_tables.twitch_user C ON A.name_id = C.id LEFT JOIN xcoins_common_tables.xcoins_rank D ON A.rank_id = D.id LEFT JOIN xcoins_common_tables.xcoins_army E ON D.army_id = E.id LEFT JOIN xcoins_common_tables.xcoins_importance F ON D.importance_id = F.id WHERE C.name = ?
Data : s, juribel