Cannot execute query: SELECT distinct trim(substring_index(place,',',-3)) as myplace, trim(place) as wholeplace, count(distinct place) as placecount, gedcom FROM tng_places WHERE trim(substring_index(place,',',-2)) = "n. y.  "Book of Grooms Canton,n. y." GROUP BY myplace ORDER by myplace