witam
mam 3 tabele które trzeba połączyć.

[SQL] pobierz, plaintext 
CREATE TABLE IF NOT EXISTS `ekwipunek_graczy` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_gracza` bigint(20) UNSIGNED NOT NULL,
  `slot_1` int(10) UNSIGNED NOT NULL,
  `slot_2` int(10) UNSIGNED NOT NULL,
  `slot_3` int(10) UNSIGNED NOT NULL,
  `slot_4` int(10) UNSIGNED NOT NULL,
  `slot_5` int(10) UNSIGNED NOT NULL,
  `slot_6` int(10) UNSIGNED NOT NULL,
  `slot_7` int(10) UNSIGNED NOT NULL,
  `slot_8` int(10) UNSIGNED NOT NULL,
  `slot_9` int(10) UNSIGNED NOT NULL,
  `slot_10` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=2 ;
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
CREATE TABLE IF NOT EXISTS `konta_graczy` (
  `id` mediumint(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nick` varchar(50) NOT NULL,
  `haslo` varchar(50) NOT NULL,
  `level` int(11) UNSIGNED NOT NULL,
  `gildia` varchar(100) NOT NULL,
  `stat_1` int(11) UNSIGNED NOT NULL,
  `stat_2` int(11) UNSIGNED NOT NULL,
  `stat_3` int(11) UNSIGNED NOT NULL,
  `stat_4` int(11) UNSIGNED NOT NULL,
  `stat_5` int(11) UNSIGNED NOT NULL,
  `stat_6` int(11) UNSIGNED NOT NULL,
  `stat_final_1` int(11) UNSIGNED NOT NULL,
  `stat_final_2` int(11) UNSIGNED NOT NULL,
  `stat_final_3` int(11) UNSIGNED NOT NULL,
  `stat_final_4` int(11) UNSIGNED NOT NULL,
  `stat_final_5` int(11) UNSIGNED NOT NULL,
  `stat_final_6` int(11) UNSIGNED NOT NULL,
  `wyglad` int(11) NOT NULL,
  `exp` int(11) UNSIGNED NOT NULL,
  `klasa` int(11) UNSIGNED NOT NULL,
  `kasa` mediumint(9) UNSIGNED NOT NULL,
  `rasa` int(10) UNSIGNED NOT NULL,
  `mount` int(10) UNSIGNED NOT NULL,
  `email` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `nick` (`nick`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=13 ;
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
CREATE TABLE IF NOT EXISTS `przedmioty` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nazwa` varchar(150) collate utf8_polish_ci NOT NULL,
  `lvl_min` int(10) UNSIGNED NOT NULL,
  `lvl_max` int(10) UNSIGNED NOT NULL,
  `tekst` text collate utf8_polish_ci NOT NULL,
  `dmg_min` bigint(20) UNSIGNED NOT NULL,
  `dmg_max` bigint(20) UNSIGNED NOT NULL,
  `obrona` int(10) UNSIGNED NOT NULL,
  `block` int(10) UNSIGNED NOT NULL,
  `Stat_1` int(10) UNSIGNED NOT NULL,
  `Stat_2` int(10) UNSIGNED NOT NULL,
  `Stat_3` int(10) UNSIGNED NOT NULL,
  `Stat_4` int(10) UNSIGNED NOT NULL,
  `Stat_5` int(10) UNSIGNED NOT NULL,
  `Stat_6` int(10) UNSIGNED NOT NULL,
  `special` tinyint(3) UNSIGNED NOT NULL,
  `typ` smallint(5) UNSIGNED NOT NULL,
  `klasa` smallint(5) UNSIGNED NOT NULL,
  `rasa` smallint(5) UNSIGNED NOT NULL,
  `Min_1` int(10) UNSIGNED NOT NULL,
  `Min_2` int(10) UNSIGNED NOT NULL,
  `Min_3` int(10) UNSIGNED NOT NULL,
  `Min_4` int(10) UNSIGNED NOT NULL,
  `Min_5` int(10) UNSIGNED NOT NULL,
  `Min_6` int(10) UNSIGNED NOT NULL,
  `obrazek` varchar(100) collate utf8_polish_ci NOT NULL,
  `typ_obrazen` int(10) UNSIGNED NOT NULL,
  `cena_gold` int(10) UNSIGNED NOT NULL,
  `cena_premium` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=101 ;
[SQL] pobierz, plaintext 

potrzebuje listę przedmiotów (nazwy i id pobierane z tabeli przedmioty), lista ta jest pobierana z tabeli ekwipunek graczy.

Wygląda to tak że ekwipunek_graczy ma kilka wpisów z lista ID przedmiotów w kilku kolumnach (slot_1, slot_2 itp)
wiem jak to połączyć z jednym slotem, ale nie wiem jak z kilkoma,
Nie chce tego robić przez 10 podzapytań bo to zajedzie serwer.

Macie jakieś pomysły?

[SQL] pobierz, plaintext 
SELECT *
FROM `ekwipunek_graczy` eg, przedmioty p
WHERE p.id
IN (
eg.slot_1, eg.slot_2, eg.slot_3, eg.slot_4, eg.slot_5, eg.slot_6
)
LIMIT 0 , 30
[SQL] pobierz, plaintext