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