Candidaturas > noticias > DATEDIFF(dy,CONVERT(smalldatetime,'25/06/2022 00:00:00',103),PAGINA.PAGINA_DATA_PUBLICACAO)<=0(DATEDIFF(dy,CONVERT(smalldatetime,'25/06/2022 00:00:00',103),PAGINA.PAGINA_DATA_ARQUIVO)>=0 OR PAGINA.PAGINA_DATA_ARQUIVO IS NULL)PAGINA.PAGINA_ACTIVO=1PAGINA.PAGINA_NOME_INTERNO = 'candidatura_initial'361Candidatura <img src="/mgallery/default.asp?obj=3499" title="Apresentação dos Cursos" border="0" />NullNullNullNull15/04/2016 17:30:17Null15/04/2016 17:30:171PortuguêsNull1NullNullcandidatura_initialNullPAGINAPáginas do siteNull0Conteúdos de uma página119db.default.table.conPAGINAPáginas do siteNull0Conteúdos de uma página100000000Erro ao obter registos... Informação adicional : SQL=SELECT WBFIELD_ID as ignore_xml_out_WBFIELD_ID, WBFIELD_NAME as name, WBFIELD_LABEL as label, (case when WBFIELD_HELP IS NULL then 0 else 1 end) as has_help, WBFIELD_TIP AS tooltip, (SELECT WBFIELD_NAME FROM WBFIELD AS WBF WHERE WBF.WBFIELD_ID=WBFIELD.WBFIELD_RELATED_FIELD_ID) AS source_field, (SELECT WBTABLE_NAME FROM WBFIELD AS WBF,WBTABLE AS WBT WHERE WBT.WBTABLE_ID=WBF.WBFIELD_TABLE_ID AND WBF.WBFIELD_ID=WBFIELD.WBFIELD_RELATED_FIELD_ID) AS source_table, (SELECT WBTABLE_CONSETTING FROM WBFIELD AS WBF,WBTABLE AS WBT WHERE WBT.WBTABLE_ID=WBF.WBFIELD_TABLE_ID AND WBF.WBFIELD_ID=WBFIELD.WBFIELD_RELATED_FIELD_ID) AS source_dbkey, (SELECT WBFIELDTYPE_TEMPLATENAME FROM WBFIELDTYPE WHERE WBFIELDTYPE_ID=WBFIELD_FIELDTYPE_ID) as template, ( case when ( (SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID) FROM WBCON_ROLE_FIELD WHERE WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID AND WBCON_ROLE_FIELD_ROLE_ID IN (17) AND WBCON_ROLE_FIELD_EDIT=1)>0 AND ( (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) )=0 OR (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) AND WBCON_ROLE_TABLE_PERM_EDIT=1)>0 ) ) OR ( (SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID) FROM WBCON_ROLE_FIELD WHERE WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID AND WBCON_ROLE_FIELD_ROLE_ID IN (17) )=0 AND (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) AND WBCON_ROLE_TABLE_PERM_EDIT=1)>0 ) then 1 else 0 end ) AS for_edit, (case when ( (SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID) FROM WBCON_ROLE_FIELD WHERE WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID AND WBCON_ROLE_FIELD_ROLE_ID IN (17) AND WBCON_ROLE_FIELD_ADD=1)>0 AND ( (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) )=0 OR (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) AND WBCON_ROLE_TABLE_PERM_ADD=1)>0 ) ) OR ( (SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID) FROM WBCON_ROLE_FIELD WHERE WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID AND WBCON_ROLE_FIELD_ROLE_ID IN (17) )=0 AND (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) AND WBCON_ROLE_TABLE_PERM_ADD=1)>0 ) then 1 else 0 end ) AS for_add, (case when ( (SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID) FROM WBCON_ROLE_FIELD WHERE WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID AND WBCON_ROLE_FIELD_ROLE_ID IN (17) AND WBCON_ROLE_FIELD_VIEW=1)>0 AND ( (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) )=0 OR (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) AND WBCON_ROLE_TABLE_PERM_VIEW=1)>0 ) ) OR ( (SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID) FROM WBCON_ROLE_FIELD WHERE WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID AND WBCON_ROLE_FIELD_ROLE_ID IN (17) )=0 AND (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) AND WBCON_ROLE_TABLE_PERM_VIEW=1)>0 ) then 1 else 0 end ) AS for_view, (case when ( (SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID) FROM WBCON_ROLE_FIELD WHERE WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID AND WBCON_ROLE_FIELD_ROLE_ID IN (17) AND WBCON_ROLE_FIELD_SEARCH=1)>0 AND ( (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) )=0 OR (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) AND WBCON_ROLE_TABLE_PERM_SEARCH=1)>0 ) ) OR ( (SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID) FROM WBCON_ROLE_FIELD WHERE WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID AND WBCON_ROLE_FIELD_ROLE_ID IN (17) )=0 AND (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) AND WBCON_ROLE_TABLE_PERM_SEARCH=1)>0 ) then 1 else 0 end ) AS for_search, (case when ( (SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID) FROM WBCON_ROLE_FIELD WHERE WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID AND WBCON_ROLE_FIELD_ROLE_ID IN (17) AND WBCON_ROLE_FIELD_LST=1)>0 AND ( (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) )=0 OR (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) AND WBCON_ROLE_TABLE_PERM_LST=1)>0 ) ) OR ( (SELECT COUNT(WBCON_ROLE_FIELD_FIELD_ID) FROM WBCON_ROLE_FIELD WHERE WBCON_ROLE_FIELD_FIELD_ID=WBFIELD_ID AND WBCON_ROLE_FIELD_ROLE_ID IN (17) )=0 AND (SELECT COUNT(WBCON_ROLE_TABLE_TABLE_ID) FROM WBCON_ROLE_TABLE WHERE WBCON_ROLE_TABLE_TABLE_ID=WBFIELD_TABLE_ID AND WBCON_ROLE_TABLE_ROLE_ID IN (17) AND WBCON_ROLE_TABLE_PERM_LST=1)>0 ) then 1 else 0 end ) AS for_list, WBFIELD_LISTABLE as listable, WBFIELD_EDITABLE as editable, WBFIELD_ADDABLE as addable, WBFIELD_VIEWABLE as viewable, WBFIELD_SEARCHABLE as searchable, WBFIELD_ORDERING as ordering, WBFIELD_IS_ID as is_ID, (case when WBFIELD_SIZE IS NULL then -1 else WBFIELD_SIZE end) as size, WBFIELD_WIZARD_PAGENUM as wizard_page FROM WBFIELD WHERE WBFIELD_TABLE_ID=119 AND (WBFIELD_ACTIVE=1 OR WBFIELD_IS_ID=1) ORDER BY WBFIELD_WIZARD_PAGENUM ASC, WBFIELD_ORDER ASCType mismatch