user warning: Unknown column 'State' in 'order clause'
query: SELECT DISTINCT(n.nid) as assoc, n2.nid, n2.title as org, n3.title as country, n4.title as term
FROM node n
INNER JOIN content_type_adopt_country_link cl ON cl.nid = n.nid and cl.vid = n.vid
INNER JOIN node n2 on n2.nid = cl.field_person_or_organization_nid
INNER JOIN node n3 on n3.nid = cl.field_country_nid
INNER JOIN category_node cn on cn.nid = cl.nid
INNER JOIN node n4 on n4.nid = cn.cid
INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 5556 AND na.realm = 'og_subscriber'))) AND ( cl.field_country_nid = 2973) ORDER BY State/Province ASC in /var/www/poundpuplegacy.org/includes/database.mysqli.inc on line 151.
