CREATE TABLE IF NOT EXISTS `lang` (
  `lang_id` int(11) NOT NULL AUTO_INCREMENT,
  `_on` int(11) NOT NULL,
  `lang_name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`lang_id`),
  KEY `_on` (`_on`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

INSERT INTO `lang` (`lang_id`, `_on`, `lang_name`) VALUES
(1, 1, 'ru'),
(2, 1, 'en'),
(3, 0, 'pg');

CREATE TABLE IF NOT EXISTS `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

INSERT INTO `test` (`id`, `type`) VALUES
(1, 50),
(2, 60),
(3, 70),
(4, 80);

CREATE TABLE IF NOT EXISTS `test_lang` (
  `id` int(11) NOT NULL,
  `lang` int(11) NOT NULL,
  `name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  KEY `id` (`id`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `test_lang` (`id`, `lang`, `name`) VALUES
(1, 1, 'test1'),
(1, 2, 'test2'),
(1, 3, 'test3'),
(2, 1, 'test4'),
(2, 2, 'test5'),
(2, 3, 'test6'),
(3, 1, 'test7'),
(3, 2, 'test8'),
(3, 3, 'test9');

SELECT * FROM test AS t 
LEFT JOIN test_lang AS tl ON tl.id=t.id 
LEFT JOIN lang AS l ON l.lang_id=tl.lang
WHERE l._on='1'

SELECT l.lang_id AS sufix FROM lang AS l WHERE l._on="1" ORDER BY l.lang_id ASC