Vzajemne zapasy

CREATE TABLE IF NOT EXISTS `zapasy_hraci` (
  `zapasID` mediumint(9) NOT NULL,
  `hracID` mediumint(9) NOT NULL,
  `tymID` mediumint(9) NOT NULL,
  `grt_pos_before_match` smallint(6) NOT NULL,
  `grt_pos_after_match` smallint(6) NOT NULL,
  UNIQUE KEY `zapasID` (`zapasID`,`hracID`,`tymID`),
  KEY `hracID` (`hracID`),
  KEY `zapasID_2` (`zapasID`),
  KEY `tymID` (`tymID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

SELECT 
t1.hracID,
t1.zapasID,
t2.hracID,
t2.zapasID
FROM zapasy_hraci t1 JOIN zapasy_hraci t2
ON t2.zapasID = t1.zapasID 
WHERE 
t1.hracID = 1116 AND t2.hracID = 1


Vysledek dotazu
id 	select_type 	table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
1 	SIMPLE 	t1 	ref 	zapasID,hracID,zapasID_2 	hracID 	3 	const 	19 	Using index
1 	SIMPLE 	t2 	ref 	zapasID,hracID,zapasID_2 	zapasID 	6 	1012_pes2.t1.zapasID,const 	1 	Using index

id 	select_type 	table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
1 	SIMPLE 	t1 	ref 	zapasID,hracID,zapasID_2,slozeny 	hracID 	3 	const 	19 	 
1 	SIMPLE 	t2 	ref 	zapasID,hracID,zapasID_2,slozeny 	zapasID 	6 	1012_pes2.t1.zapasID,const 	1