Historia de Eslovaquia
En el siglo IX, las tribus checa y eslovaca - provenientes de diferentes lugares de Europa - forman el Gran Imperio de Moravia, tras haber colonizado alrededor del si... Leer más
xxxselect id, es, asc_3, asc_6, geotype_id from keops.geoplaces where
id and asc_3=558 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] => 498080627
[es] => Castillo de Devín
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 8
)
[1] => Array
(
[id] => 498025465
[es] => Palacio Reduta
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 34
)
[2] => Array
(
[id] => 498024689
[es] => Iglesia Franciscana de la Anunciación
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 23
)
[3] => Array
(
[id] => 498025466
[es] => Teatro Nacional de Eslovaquia
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 38
)
[4] => Array
(
[id] => 498080621
[es] => Catedral de San Martín
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 23
)
[5] => Array
(
[id] => 498025751
[es] => Sinagoga
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 27
)
[6] => Array
(
[id] => 498080622
[es] => Torre Miguel
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 8
)
[7] => Array
(
[id] => 498080625
[es] => Galería Nacional de Eslovaquia
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 30
)
[8] => Array
(
[id] => 498025797
[es] => Slavín War Memorial
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 8
)
[9] => Array
(
[id] => 498080624
[es] => Galería de Arte de la Ciudad
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 30
)
[10] => Array
(
[id] => 498025690
[es] => Casa Mozart
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 50
)
[11] => Array
(
[id] => 498112956
[es] => Centro de la ciudad
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 149
)
[12] => Array
(
[id] => 498080626
[es] => Nová Scéna
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 38
)
[13] => Array
(
[id] => 498025715
[es] => Museo Municipal
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 30
)
[14] => Array
(
[id] => 498024692
[es] => Palacio de la Cámara Real
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 34
)
[15] => Array
(
[id] => 498025703
[es] => Iglesia del Sagrado Salvador
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 23
)
[16] => Array
(
[id] => 498080623
[es] => Librería Universitaria
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 8
)
[17] => Array
(
[id] => 498024690
[es] => Castillo de Bratislava
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 8
)
[18] => Array
(
[id] => 498024691
[es] => Palacio Mirbach
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 34
)
[19] => Array
(
[id] => 498080618
[es] => Museo de los Relojes
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 30
)
[20] => Array
(
[id] => 498024687
[es] => Museo Nacional Eslovaco
[asc_3] => 558
[asc_6] => 107227
[geotype_id] => 30
)
)