select ulke,sehir,ilce,ad,y_ad,id,3 as sira,concat(url,"-","de",".html") as link1 from ulke_at where sehir="upper austria" and ilce="linz land" select * from ulke_at ( select ulke,sehir,ilce,ad,y_ad,id,3 as sira,concat(url,"-","de",".html") as link1 from ulke_at where sehir="upper austria" and ilce="linz land" order by rand() ) q order by info_var desc limit 0,0