Los mejores parques tematicos en Barcelona
La capital de Cataluña y la segunda ciudad más grande de España es Barcelona, con sus casi 2 millones de habitantes. Está situada en... Leer más
xxxselect id, es, asc_3, asc_6, geotype_id from keops.geoplaces where
id and asc_6=497893369 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] => 498015526
[es] => Universitat de Barcelona
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[1] => Array
(
[id] => 498015518
[es] => Plaza de Catalunya
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[2] => Array
(
[id] => 498015569
[es] => Port Olímpic
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[3] => Array
(
[id] => 498015530
[es] => Rambla de Mar
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[4] => Array
(
[id] => 498063478
[es] => Museu Maritim-Drassanes Reials de Barcelona
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 30
)
[5] => Array
(
[id] => 498015504
[es] => La Rambla
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[6] => Array
(
[id] => 498015552
[es] => Parc de la Ciutadella
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 31
)
[7] => Array
(
[id] => 498015451
[es] => Museu de Cera
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 30
)
[8] => Array
(
[id] => 498086162
[es] => Fundación de Francisco Gaudia
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[9] => Array
(
[id] => 498015459
[es] => Museu Gaudí
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 30
)
[10] => Array
(
[id] => 498015478
[es] => La Catedral de Barcelona
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 23
)
[11] => Array
(
[id] => 498015551
[es] => Parc Güell
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 31
)
[12] => Array
(
[id] => 498015575
[es] => Arc del Triomf
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[13] => Array
(
[id] => 498015457
[es] => Museu Picasso
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 30
)
[14] => Array
(
[id] => 498015542
[es] => Palau Nacional
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[15] => Array
(
[id] => 498015508
[es] => Mercat de la Boqueria
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[16] => Array
(
[id] => 498015519
[es] => Paseo de Gràcia
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[17] => Array
(
[id] => 498113036
[es] => Centro de la ciudad
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 149
)
[18] => Array
(
[id] => 498015574
[es] => Monumento a Colón
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[19] => Array
(
[id] => 498015538
[es] => Villa Olímpica
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[20] => Array
(
[id] => 498015481
[es] => Temple Expiatori de la Sagrada Família
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 23
)
[21] => Array
(
[id] => 498063475
[es] => Museu Arquelògic
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 30
)
[22] => Array
(
[id] => 498086161
[es] => Fundación ANtonio Tabias
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[23] => Array
(
[id] => 498015484
[es] => Castillo de Montjuic
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[24] => Array
(
[id] => 498015511
[es] => Gran Teatre del Liceu
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
[25] => Array
(
[id] => 498015543
[es] => Poble Espanyol
[asc_3] => 560
[asc_6] => 497893369
[geotype_id] => 8
)
)