SELECT users.*,nationalities.country, colors.color_value FROM bplay.users, bplay.nationalities, bplay.colors WHERE user_name='WEISS2' AND users.user_country=nationalities.id AND users.user_color = colors.color_id