callert3lib_DB::exec_SELECTquery
ERRORYou 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
lastBuiltQuerySELECT 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 (2816) AND AND tx_ltgtreecache_cache.num_ratings > 3
GROUP BY tx_ltgtreecache_cache.page_uid
ORDER BY tx_ltgtreecache_cache.ave_rating DESC
debug_backtracetslib_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
Loja Travel Guide - Plan your Loja vacation. Loja flights, tours & hotel reviews
Home > South America > Ecuador > Andes > Southern Andes > Loja
Been to Loja?
Share your knowledge with other travelers.
What is this?
Loja Ratings:
0%
Based on 0 Ratings
  
V!VA Travel Guides WIKI
Share your knowledge on the web and get your review published in our next printed guidebook! Find out more about us.

Close box

 

Loja

Loja's Central Park
Loja's Central Park
+ Add a Photo

See all Loja Photos

V!VA User‘s Description

Founded in 1548 by Alonso de Mercadillo, Loja is somewhat of a political and cultural island, surrounded by mountains and stranded at the far southern end of Ecuador. Besides being the provincial capital, Loja warrants recognition as the first city in Ecuador to generate electricity (1897). Today, it is an intellectually and architecturally unique city, boasting two universities set among a peculiar mix of urban concrete and colonial structures. 

Read more...

Sponsors
Cazhuma: Cuenca & Galapagos Tours
Exciting Galapagos cruises for every budget, luxury and rugged jungle adventures, and tours to Ecuador's magnificent highlights, from the colonial jewel of Cuenca to breathtaking Cotopaxi national park.
www.cazhumatours.com
Ecuador Mountain Biking Tours - Aries Bike Company
Over 18 years of experience in Downhill, Mountain Biking and Hiking in Ecuador.Our tours take you around some of the most beautiful mountains and active volcanoes in the world.
www.ariesbikecompany.com
¿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/

All Activities in Loja

Museo de la Musica (Museum of Music)

This small museum set around a sunny courtyard is dedicated to the musicians and composers of Loja. Th...

Museo del Banco Central

This museum contains an extensive collection of archaeological pieces, including 10,000 year old weapo...

Parque Jipiro

One of the best known parks of Loja, Jipiro lies to the North of the city and spans 10 hectares. It is...

Top Rated Hotels


100% - 1 ratings
$36.50; 50 percent discount Friday-Sunday

Hotel Libertador

The Hotel Libertador is the best of the hotels located in Loja’s historic district. The interior is dimly li...


100% - 1 ratings
$45 - $61

Quo Vadis

One of the newest hotels in Loja (completed in early 2007), the Quo Vadis is a modern, reasonably priced hotel w...


100% - 1 ratings
$35 - $74.50

Top Rated Restaurants

Diego’s Café Restaurant

Hidden away in an old colonial house, Diego’s has very elegant upstairs seating overlooking a green courtyard....


0% - 0 ratings

Topoli

Come to Topoli if you are looking for a quick fix for your sweet tooth. Serving a variety of cakes and ice cream...


0% - 0 ratings

Gino Ginelli

This all-in-one pizzeria will satisfy the cravings of anyone. Though a bit dark, a long list of different pizzas...


0% - 0 ratings
Sponsors
Ecuador & Galapagos Tours with PTS
We are the #1 travel and tour operator for upscale cruises and soft-adventure vacation travel packages for Ecuador and the Galapagos Islands.
www.galapagoslegend.com
Great V!VA Travel Guides Books about Loja
Buy the world's most up-to-date guidebook about Ecuador.
Get it from Amazon, Barnes&Noble or direct from V!VA.
Or download free chapters from this book.
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.

 
South America | Central America and Mexico | Africa | Europe | Oceania | Asia | Antarctica | North America |
Advertise | Anúnciese | Jobs | Alliances | Alianzas | Terms of Use | Useful Sites | Contact Us | About Us |