Invalid query: Unknown column 'pub_title' in 'field list'
Whole query: SELECT id, pub_id, pub_type, substr(pub_title, 1, instr(pub_title, '(')-1) as pub_title, pub_date, pub_place, pub_place_id, pubplace_coords, substr(pubplace_coords, instr(pubplace_coords, ',')+1) as poi_lng, substr(pubplace_coords, 1, instr(pubplace_coords, ',')-1) as poi_lat, pub_publisher, pub_summary, pub_thumb, pub_image FROM exportPublicationsMapInfo LEFT JOIN exportPublicationsPlaceInfo ON exportPublicationsMapInfo.pub_place_id= exportPublicationsPlaceInfo.pubplace_id WHERE pubplace_coords<>'';