SELECT c.*,c.ID as commid, c.publish as publish, cc.County, ST_X(centroid(polygon2)) AS clat, ST_Y(centroid(polygon2)) AS clon from communities c, cities_in_counties cc where c.city=cc.city AND c.city = 'Marathon' AND dev = 'Ocean Isles Fishing Village' AND parent IS NULL