select ulke,sehir,ilce,ad,y_ad,id,3 as sira,concat(url,"-","de",".html") as link1 from ulke_de where sehir="lower saxony" and ilce="stadt hannover" order by rand() select * from ulke_de ( select ulke,sehir,ilce,ad,y_ad,id,3 as sira,concat(url,"-","de",".html") as link1 from ulke_de where sehir="lower saxony" and ilce="stadt hannover" order by rand() order by rand() ) q order by info_var desc limit 0,19