SELECT	province.en AS provinceen,
						province_country.provinceid AS provinceid,provinceattribute.en AS provinceattributeen,provinceattribute.plen AS provinceattributeplen,province.pathen AS pathen FROM province,province_country,provinceattribute WHERE province_country.countryid= AND province.provinceid=province_country.provinceid AND provinceattribute.provinceattributeid=province.provinceattributeid ORDER BY province.en