Historia de Estonia
Estonia y Las Cruzadas Germánicas Pueblos eslavos y escandinavos llegaron al territorio en los siglos VIII y XII, pero la mayor influencia llegó con los germanos en e... Leer más
xxxselect id, es, asc_3, asc_6, geotype_id from keops.geoplaces where
id and asc_3=533 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] => 498030526
[es] => La Catedral
[asc_3] => 533
[asc_6] => 150981
[geotype_id] => 23
)
[1] => Array
(
[id] => 498030452
[es] => Puerta Viru
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 8
)
[2] => Array
(
[id] => 498041223
[es] => Teatro Estonia
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 38
)
[3] => Array
(
[id] => 498030445
[es] => Catedral de Alexandr Nevsky
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 23
)
[4] => Array
(
[id] => 498030430
[es] => Museo de Arte Estonio
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 30
)
[5] => Array
(
[id] => 498030468
[es] => Torre TV
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 8
)
[6] => Array
(
[id] => 498030529
[es] => Puente del Angel
[asc_3] => 533
[asc_6] => 150981
[geotype_id] => 123
)
[7] => Array
(
[id] => 498041224
[es] => Teatro de Títeres
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 38
)
[8] => Array
(
[id] => 498030449
[es] => Castillo Toompea
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 8
)
[9] => Array
(
[id] => 498030472
[es] => Jardín Zoológico de Tallin
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 163
)
[10] => Array
(
[id] => 498030525
[es] => Iglesia de San Juan
[asc_3] => 533
[asc_6] => 150981
[geotype_id] => 23
)
[11] => Array
(
[id] => 498030480
[es] => Lago Maardu
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 15
)
[12] => Array
(
[id] => 498030434
[es] => Casa Museo de Anton Hansen Tammsaare
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 30
)
[13] => Array
(
[id] => 498030467
[es] => El Cementerio del Bosque
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 8
)
[14] => Array
(
[id] => 498030459
[es] => Pikk
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 8
)
[15] => Array
(
[id] => 498030530
[es] => Río Emajogi y Lago Peipus
[asc_3] => 533
[asc_6] => 150981
[geotype_id] => 15
)
[16] => Array
(
[id] => 498030443
[es] => Iglesia de Santa Catalina
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 23
)
[17] => Array
(
[id] => 498112949
[es] => Centro de la ciudad
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 149
)
[18] => Array
(
[id] => 498030451
[es] => Paks Margareeta
[asc_3] => 533
[asc_6] => 151858
[geotype_id] => 8
)
)
Garantizamos el mejor precio en sus paquetes vacacionales