select ulke,sehir,ilce,ad,y_ad,id,3 as sira,concat(url,"-","en",".html") as link1 from ulke_tn where sehir="tunisia" and ilce="tunisia" order by rand() select * from ulke_tn ( select ulke,sehir,ilce,ad,y_ad,id,3 as sira,concat(url,"-","en",".html") as link1 from ulke_tn where sehir="tunisia" and ilce="tunisia" order by rand() order by rand() ) q order by info_var desc limit 0,19