| caller | t3lib_DB::exec_SELECTquery |
| ERROR | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND tx_ltgtreecache_cache.num_ratings > 3 GROUP BY tx_ltgtreecache_cache.page' at line 4 |
| lastBuiltQuery | SELECT DISTINCT tx_ltgtreecache_cache.page_uid,tx_ltgtreecache_cache.url,tx_ltgtreecache_cache.ave_rating,tx_ltgtreecache_cache.num_ratings,pages.title,pages.subtitle,pages.crdate FROM pages_tx_ltgdbstructures_propertytype_mm AS mm,tx_ltgtreecache_cache,pages WHERE mm.uid_local = pages.uid AND mm.uid_foreign IN (3072) AND AND tx_ltgtreecache_cache.num_ratings > 3 GROUP BY tx_ltgtreecache_cache.page_uid ORDER BY tx_ltgtreecache_cache.ave_rating DESC |
| debug_backtrace | tslib_fe->intincscript // tslib_cobj->user // tslib_cobj->calluserfunction // call_user_method // tx_ltgextendedmenus_pi2->ts_getleftmenus // tx_ltgextendedmenus_pi2->_getboxforlistpages // ltgtree->gettopchildpages // t3lib_db->exec_select_queryarray // t3lib_db->exec_selectquery // t3lib_db->debug |






75%
Close box
Chorrillos, which means a 'constant trickle of water,' is a lesser-known neighborhood in Lima. Once a beach resort town, it was the scene of heavy fighting during the war between Peru and Chile in 1880-1881 and much of it was destroyed.
Today, Chorrillos is tucked up against the Pacific Ocean and offers stunning panoramic views of the bay of Lima and the island of San Lorenzo in El Callao. With an atmosphere that resembles a fish market and décor to match, the mood is very relaxed in Chorrillos. Famous for its beach resorts at La Herradura and restaurants specializing in spicy dishes, this neighborhood is not without its attractions. The astronomical observatory 'El Planetario' is located here and built on the historical Morro Solar. El Malecón is the area's boardwalk and a great place to spend a lazy afternoon.
| ¿Llamé su atención? También llamo la atención de sus clientes potenciales. El "Text Ad" es la herramienta más efectiva y simple para obtener más ventas online. www.vivatravelguides.com/anuncio/text-ads/ |
Once considered the Soul of Chorrillos, locals used to spend lazy afternoons and moonlit evenings on t...
This astronomical observatory was erected on the historical Morro Solar, the landmark location of impo...
The Villa Swamps is a Metropolitan Ecological park just 30 minutes from downtown Lima and is the only ...
Hotel Olaya is located in a quiet, residential area just 20 minutes from Lima's Historical Center and 45 minutes...







If you want meat –if you really, really want meat– we're talking a nice, big, juicy steak served with golde...







Staying true to Chorrillos's fishing roots, this restaurant serves up fresh seafood at a reasonable price....







This massive and modern shopping complex in Chorrillos is a consumer heaven. It features Peru's large...







![]() | Buy the world's most up-to-date guidebook about Peru. Get it from Amazon or direct from V!VA. Or download free chapters from this book. |
![]() | V!VA List Latin America, 333 Places and Experiences that People Love Packed with tales of travels from Tijuana to Tierra del Fuego, this compilation provides firsthand knowledge about places to visit, things to do, and where to stay, as well as insight into local cultures and customs.Get it from Amazon, Barnes&Noble or direct from V!VA. Download free chapters from this book. Download free Google Earth version chapters. |
Activities | Popular Lima Destinations | Lima HotelsTop Lima Hotels | Other Lima pages
|