@AlpieComeBack; 

Select
*
From T_ILLER t
Where t.bolge_no in (x,x,x,x)
Order by t.bolge_no,t.il_adi desc