1	SIMPLE	airport	NULL	ALL	PRIMARY	NULL	NULL	NULL	12	20.00	Using where; Using temporary; Using filesort
1	SIMPLE	airport_term	NULL	ALL	term_ID	NULL	NULL	NULL	212889	10.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	term	NULL	eq_ref	PRIMARY,hotel_ID	PRIMARY	4	cklub.airport_term.term_ID	1	100.00	NULL
1	SIMPLE	hotel	NULL	eq_ref	PRIMARY	PRIMARY	4	cklub.term.hotel_ID	1	100.00	NULL