CREATE VIEW SALPERKS AS SELECT A.id as id,C.city_id as city_id, A.iso_code AS AA ,B.iata_code AS AB, C.iata_code AS AC, 
		      D.`translate` as countryEN,
		      E.`translate`  as countryRU ,
	              F.`translate` as cityEN,
		      G.`translate` as cityRU,
 		      H.`translate` as airportEN, 
                      K.`translate` as airportRU
FROM jos_ws_country AS A
	LEFT JOIN jos_ws_city AS B 
		ON (A.id = B.country_id)
	LEFT JOIN jos_ws_airport AS C
		ON (C.country_id = A.id AND C.city_id = B.id) 
	LEFT JOIN jos_ws_translate AS D
		 ON(D.key = A.iso_code AND D.language = 1 )
	LEFT JOIN jos_ws_translate AS E
		 ON(E.key = A.iso_code AND E.language = 2 )
	LEFT JOIN jos_ws_translate AS F
		 ON(F.key = B.iata_code AND F.language = 1 )
	LEFT JOIN jos_ws_translate AS G
		 ON(G.key = B.iata_code AND G.language = 2 )
	LEFT JOIN jos_ws_translate AS H
		 ON(H.key = C.iata_code AND H.language = 1 )
	LEFT JOIN jos_ws_translate AS K
		 ON(K.key = C.iata_code AND K.language = 2 )