ERROR: SELECT properties.ref, IF(properties.description_es='',properties.description_en,properties.description_es) AS description,
		IF(locations.label_es='',locations.label_en,locations.label_es) AS location,
		IF(countries.label_es='',countries.label_en,countries.label_es) AS country,
		IF(states.label_es='',states.label_en,states.label_es) AS state,
		IF(cities.label_es='',cities.label_en,cities.label_es) AS city,
		IF(types.label_es='',types.label_en,types.label_es) AS type FROM locations, cities, states, countries, types, properties WHERE properties.location = locations.id AND locations.idCity = cities.id AND cities.idState = states.id AND states.idCountry = countries.id AND properties.type = types.id AND properties.ref = 'JI200'