SELECT NAME,CODE,SOCR FROM kladr_new WHERE CODE IN ('0500000100000','2600000100000','8600001000000','2300000100000','8900000600000','0200000400000','5002000100000','Сахалин','6300000100000','3200000100000','1600000200000','0100000100000','6100000100000','8600001100000','7200000100000','2700000100000','7400000100000','2200000100000','0') GROUP BY CODE ORDER BY FIELD(CODE, '0500000100000','2600000100000','8600001000000','2300000100000','8900000600000','0200000400000','5002000100000','Сахалин','6300000100000','3200000100000','1600000200000','0100000100000','6100000100000','8600001100000','7200000100000','2700000100000','7400000100000','2200000100000','0')

  • Махачкала
  • Ставрополь
  • Сургут
  • Краснодар
  • Новый Уренгой
  • Октябрьский
  • Наро-Фоминск
  • Самара
  • Брянск
  • Набережные Челны
  • Майкоп
  • Ростов-на-Дону
  • Нижневартовск
  • Тюмень
  • Хабаровск
  • Челябинск
  • Барнаул