Historia de Finlandia
Después de finalizar la época del deshielo se cree que aparecieron los primeros pobladores en la tierra conocida actualmente como Finlandia. Los asentamientos durant... Leer más
xxxselect id, es, asc_3, asc_6, geotype_id from keops.geoplaces where
id and asc_3=534 and important_6=1 and (geotype_id!=9 and
geotype_id!=153 and geotype_id!=154 and geotype_id!=155)
order by important_1 DESC, important_2 desc, important_3 desc, rand() limit 30 Array
(
[0] => Array
(
[id] => 498112945
[es] => Centro de la ciudad
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 149
)
[1] => Array
(
[id] => 498081321
[es] => Conjunto Lappia-Talo
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 8
)
[2] => Array
(
[id] => 498072153
[es] => La Estación de Ferrocarril
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 8
)
[3] => Array
(
[id] => 498006767
[es] => Päijanne
[asc_3] => 534
[asc_6] => 0
[geotype_id] => 15
)
[4] => Array
(
[id] => 498081333
[es] => El Círculo Polar Ártico
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 8
)
[5] => Array
(
[id] => 498024699
[es] => Aldea de Santa Claus
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 126
)
[6] => Array
(
[id] => 498081327
[es] => Museo de Pöykkölä
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 30
)
[7] => Array
(
[id] => 498024825
[es] => Tennispalatsi
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 38
)
[8] => Array
(
[id] => 498081318
[es] => Palacio de Finlandia
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 38
)
[9] => Array
(
[id] => 498081325
[es] => Arktikum
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 30
)
[10] => Array
(
[id] => 498052212
[es] => Avenida Mannerheimintie
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 8
)
[11] => Array
(
[id] => 498081334
[es] => Santa Park
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 126
)
[12] => Array
(
[id] => 498081326
[es] => Museo de Arte
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 30
)
[13] => Array
(
[id] => 498024746
[es] => Estatua y Fuente de Havis Amanda
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 8
)
[14] => Array
(
[id] => 498024708
[es] => Tarvaspää
[asc_3] => 534
[asc_6] => 152216
[geotype_id] => 8
)
[15] => Array
(
[id] => 498024707
[es] => Otaniemi
[asc_3] => 534
[asc_6] => 152216
[geotype_id] => 8
)
[16] => Array
(
[id] => 498081322
[es] => Jätkänkynttilä
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 123
)
[17] => Array
(
[id] => 498071990
[es] => Piscina Olímpica del Estadio
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 8
)
[18] => Array
(
[id] => 498081335
[es] => Estación de Esquí de Ounasvaara
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 126
)
[19] => Array
(
[id] => 498081324
[es] => Marttini Old Knife Factory
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 8
)
[20] => Array
(
[id] => 498081323
[es] => Iglesia Luterana de Rovaniemi
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 23
)
[21] => Array
(
[id] => 498081304
[es] => Estadio Olímpico
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 8
)
[22] => Array
(
[id] => 498081328
[es] => Museo Forestal de Laponia
[asc_3] => 534
[asc_6] => 153503
[geotype_id] => 30
)
[23] => Array
(
[id] => 498024744
[es] => Palacio Presidencial
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 34
)
[24] => Array
(
[id] => 498024747
[es] => Kaupungin Matkailutoimisto
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 8
)
[25] => Array
(
[id] => 498024758
[es] => Plaza del Senado
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 8
)
[26] => Array
(
[id] => 498006768
[es] => Saimaa
[asc_3] => 534
[asc_6] => 0
[geotype_id] => 15
)
[27] => Array
(
[id] => 498024762
[es] => Ópera Nacional Finlandesa
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 8
)
[28] => Array
(
[id] => 498071942
[es] => Monumento a Sibelius
[asc_3] => 534
[asc_6] => 152196
[geotype_id] => 8
)
[29] => Array
(
[id] => 498024706
[es] => Ciudad-jardín de Tapiola
[asc_3] => 534
[asc_6] => 152216
[geotype_id] => 8
)
)