*** EOGeneralAdaptorException while processing template http://cxportalinc.hrlinkit.be/cxContent/cxMain/vacanciesPublic.php?txtSearchTerm=0&chkFunctionGroups=0&selSearchCountry=0&selSearchRegion=0&thisPage=1&wpSite=&wpSiteID=410&wpHost=portal.oxida.be&wpHostInc=cxportal.carerix.com&openApplPubID=217&lang=pt&mediumCode=web: Postgres: ERROR: syntax error at or near "WHERE" LINE 20: WHERE crpublication.deleted = 0 ^ *** Exception info: { droppedConnection = 0; statement = "SELECT crpublication.publication_id as publication_id,\n\t\t\t\tcrpublication.title_information as title_information,\n\t\t\t\tCOALESCE(crpublication.work_location, '') as work_location,\n\t\t\t\tCOALESCE(join_function0.data_node_id, 0) as function0_id,\n\t\t\t\tCOALESCE(join_function0.value, '') as function0_value,\n\t\t\t\tcrpublication.publication_start as publication_start,\n\t\t\t\tCOALESCE(crpublication.intro_information, '') as intro_information\n\t\n\t\t\tFROM crpublication\n\t\t\t\n\t\t\tLEFT JOIN crmedium as join_medium\n\t\t\tON join_medium.medium_id = crpublication.medium_id\n\t\t\t\n\t\t\tLEFT JOIN crvacancy as join_vac\n\t\t\tON join_vac.vacancy_id = crpublication.vacancy_id\n\t\t\t\n\t\t\tLEFT JOIN crdatanodevalue as join_function0\n\t\t\tON join_function0.data_node_id = join_vac.function_level1_node_id AND join_function0.language_node_id=\n\n\t\t\tWHERE crpublication.deleted = 0\n\t\t\tAND crpublication.publication_start < '2020-04-10 00:00:00 +0200'\n\t\t\tAND (crpublication.publication_end is null OR crpublication.publication_end > '2020-04-09 00:00:00 +0200')\n\t\t\tAND join_medium.code = 'web'\n\t\t\tAND join_vac.is_hidden = 0\n\t\t\tAND join_vac.is_virtual = 0\n\t\t\tAND join_vac.deleted = 0\n\t\t\tAND join_vac.is_open_application = 0\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\tORDER BY crpublication.publication_start DESC\n\t\t\tLIMIT 10 OFFSET 0\n\t"; }