select ulke,sehir,ilce,ad,y_ad,id,3 as sira,concat(url,"-","en",".html") as link1 from ulke_th where sehir="ratchaburi" and ilce="amphoe chom bueng" order by rand() select * from ulke_th ( select ulke,sehir,ilce,ad,y_ad,id,3 as sira,concat(url,"-","en",".html") as link1 from ulke_th where sehir="ratchaburi" and ilce="amphoe chom bueng" order by rand() order by rand() ) q order by info_var desc limit 0,13