ERROR: SELECT properties.ref, IF(properties.description_en='',properties.description_en,properties.description_en) AS description,
		IF(locations.label_en='',locations.label_en,locations.label_en) AS location,
		IF(countries.label_en='',countries.label_en,countries.label_en) AS country,
		IF(states.label_en='',states.label_en,states.label_en) AS state,
		IF(cities.label_en='',cities.label_en,cities.label_en) AS city,
		IF(types.label_en='',types.label_en,types.label_en) 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'