Jevents
I had not enabled the output of city,state and country in list views for the structured address mode because of performance concerns.
But give most sites using this approach will only have a limited number of cities/states/countries this is probably an unnecessary constraint.
If you insert this code at line 729 of plugins/jevlocations/jevlocations.php this it should work.
- $extrajoin[] = ' #__jevlocation_categories AS locmcity ON loc.catid = locmcity.id AND locmcity.section="com_jevlocations"';
$extrajoin[] = ' #__jevlocation_categories AS locmstate ON locmcity.parent_id = locmstate.id AND locmstate.section="com_jevlocations"';
$extrajoin[] = ' #__jevlocation_categories AS locmcountry ON locmstate.parent_id = locmcountry.id AND locmcountry.section="com_jevlocations"';
$extrafields .= ", locmcity.title AS loc_city, locmstate.title AS loc_state, locmcountry.title AS loc_country";
http://www.jevents.net/forum/viewtopic.php?f=23&t=13841