| QUERY: | select * from main_lingua where CodLingua = "EN" ORDER BY CodLingua | QUERY: | select * from main_traducao_det where CodLingua="EN" ORDER BY CodLingua | QUERY: | select * from bo_texto t INNER JOIN bo_tipo_texto tt on t.CodTipoTexto=tt.CodTipoTexto where t.CodTipoTexto="TC" | QUERY: | select * from bo_texto t INNER JOIN bo_tipo_texto tt on t.CodTipoTexto=tt.CodTipoTexto where t.CodTipoTexto="ED" | QUERY: | select *,c.CodColaborador,CONCAT(trim(c.Nome), " ",trim(c.Sobrenome)) NomeCompleto, GROUP_CONCAT(td.texto SEPARATOR ", ") as Categoria from bo_colaboradores c left join bo_colaboradores_categoria_link ccl on ccl.CodColaborador=c.CodColaborador left join bo_colaboradores_categoria cc on cc.CodCategoriaColaborador=ccl.CodCategoriaColaborador LEFT JOIN main_traducao_det td on td.CodTraducao=cc.NomeCategoriaColaborador and td.CodLingua = "EN" LEFT JOIN g_pais cp on cp.CodPais=c.CodPais where c.CodColaborador="2186" group by c.codcolaborador order by NomeCompleto | QUERY: | SELECT p.*,rg.CodResearchGroup, rgt.Titulo as TituloResearchGroup, GROUP_CONCAT( DISTINCT trim(pc.CodColaborador) separator ", ") as CodColaborador,GROUP_CONCAT( DISTINCT trim(c.Nome) separator ", ") as NomePI, GROUP_CONCAT( DISTINCT trim(ps.CodColaborador) separator ", ") as CodColaboradorCoordinator,GROUP_CONCAT( DISTINCT trim(c2.Nome) separator ", ") as NomeCoordinator, GROUP_CONCAT( DISTINCT trim(pcs.CodColaborador) separator ", ") as CodColaboradorOtherMember,GROUP_CONCAT( DISTINCT trim(c3.Nome) separator ", ") as NomeOtherMember, GROUP_CONCAT( DISTINCT trim(li.CodInstituicao) separator ", ") as CodLeadingInstituicao,GROUP_CONCAT( DISTINCT trim(i.NomeInstituicao) separator ", ") as LeadingInstituicao, GROUP_CONCAT( DISTINCT trim(oi.CodInstituicao) separator ", ") as CodOtherInstituicao,GROUP_CONCAT( DISTINCT trim(i2.NomeInstituicao) separator ", ") as OtherInstituicao, GROUP_CONCAT( DISTINCT trim(fi.CodInstituicao) separator ", ") as CodFundingInstituicao,GROUP_CONCAT( DISTINCT trim(i3.NomeInstituicao) separator ", ") as FundingInstituicao FROM bo_project p LEFT JOIN bo_project_pi_link pc on pc.CodProject = p.CodProject LEFT JOIN bo_project_coordinator_link ps on ps.CodProject = p.CodProject LEFT JOIN bo_project_other_members_link pcs on pcs.CodProject = p.CodProject LEFT JOIN bo_project_leading_instituicao_link li on li.CodProject = p.CodProject LEFT JOIN bo_project_instituicao_link oi on oi.CodProject = p.CodProject LEFT JOIN bo_project_funding_instituicao_link fi on fi.CodProject = p.CodProject LEFT JOIN bo_colaboradores c on pc.CodColaborador = c.CodColaborador LEFT JOIN bo_colaboradores c2 on ps.CodColaborador = c2.CodColaborador LEFT JOIN bo_colaboradores c3 on pcs.CodColaborador = c3.CodColaborador LEFT JOIN bo_instituicao i on li.CodInstituicao = i.CodInstituicao LEFT JOIN bo_instituicao i2 on oi.CodInstituicao = i2.CodInstituicao LEFT JOIN bo_instituicao i3 on fi.CodInstituicao = i3.CodInstituicao LEFT JOIN bo_project_research_group_link rg on rg.CodProject = p.CodProject LEFT JOIN bo_research_group rgt on rgt.CodResearchGroup = rg.CodResearchGroup LEFT JOIN bo_moeda mo on mo.CodMoeda = p.CodMoeda WHERE p.CodProject IS NOT NULL AND pc.CodColaborador="2186" OR ps.CodColaborador="2186" OR pcs.CodColaborador="2186" GROUP BY p.CodProject ORDER BY p.DataInicial DESC | QUERY: | SELECT p.*,GROUP_CONCAT( DISTINCT trim(pc.CodColaborador) separator ", ") as CodColaboradorStudent,GROUP_CONCAT( DISTINCT trim(c.Nome) separator ", ") as StudentName, GROUP_CONCAT( DISTINCT trim(ps.CodColaborador) separator ", ") as CodColaboradorSupervisor,GROUP_CONCAT( DISTINCT trim(c2.Nome) separator ", ") as SupervisorName, GROUP_CONCAT( DISTINCT trim(pcs.CodColaborador) separator ", ") as CodColaboradorCoSupervisor,GROUP_CONCAT( DISTINCT trim(c3.Nome) separator ", ") as CoSupervisorName, GROUP_CONCAT( DISTINCT trim(pcss.CodColaborador) separator ", ") as CodColaboradorCoSupervisor2,GROUP_CONCAT( DISTINCT trim(c4.Nome) separator ", ") as CoSupervisorName2, GROUP_CONCAT( DISTINCT trim(li.CodInstituicao) separator ", ") as CodUniversity,GROUP_CONCAT( DISTINCT trim(i.NomeInstituicao) separator ", ") as UniversityName, GROUP_CONCAT( DISTINCT trim(oi.CodInstituicao) separator ", ") as CodFundingInstitution,GROUP_CONCAT( DISTINCT trim(i2.NomeInstituicao) separator ", ") as FundingInstitutionName FROM bo_publication p LEFT JOIN bo_publication_student_link pc on pc.CodPublication = p.CodPublication LEFT JOIN bo_publication_supervisor_link ps on ps.CodPublication = p.CodPublication LEFT JOIN bo_publication_cosupervisor_link pcs on pcs.CodPublication = p.CodPublication LEFT JOIN bo_publication_cosupervisor_link pcss on pcss.CodPublication = p.CodPublication LEFT JOIN bo_publication_university_link li on li.CodPublication = p.CodPublication LEFT JOIN bo_publication_instituicao_link oi on oi.CodPublication = p.CodPublication LEFT JOIN bo_colaboradores c on pc.CodColaborador = c.CodColaborador LEFT JOIN bo_colaboradores c2 on ps.CodColaborador = c2.CodColaborador LEFT JOIN bo_colaboradores c3 on pcs.CodColaborador = c3.CodColaborador LEFT JOIN bo_colaboradores c4 on pcss.CodColaborador = c4.CodColaborador LEFT JOIN bo_instituicao i on li.CodInstituicao = i.CodInstituicao LEFT JOIN bo_instituicao i2 on oi.CodInstituicao = i2.CodInstituicao LEFT JOIN bo_publication_category_link cc on cc.CodPublication = p.CodPublication LEFT JOIN bo_moeda mo on mo.CodMoeda = p.CodMoeda WHERE p.CodPublication IS NOT NULL AND cc.CodPublicationCategory = 4 AND p.CodPublicationSubCategory = 16 AND (ps.CodColaborador=2186 OR pcs.CodColaborador=2186 OR pcss.CodColaborador=2186) GROUP BY p.CodPublication ORDER BY p.Ano DESC | QUERY: | SELECT p.*,GROUP_CONCAT( DISTINCT trim(pc.CodColaborador) separator ", ") as CodColaboradorMember,GROUP_CONCAT( DISTINCT trim(c.Nome) separator ", ") as MemberName, GROUP_CONCAT( DISTINCT trim(li.CodJournal) separator ", ") as CodJournalCode,GROUP_CONCAT( DISTINCT trim(i.Nome) separator ", ") as JournalName FROM bo_publication p LEFT JOIN bo_publication_colaborador_link pc on pc.CodPublication = p.CodPublication LEFT JOIN bo_publication_journal_link li on li.CodPublication = p.CodPublication LEFT JOIN bo_publication_category_link cc on cc.CodPublication = p.CodPublication LEFT JOIN bo_colaboradores c on pc.CodColaborador = c.CodColaborador LEFT JOIN bo_journal i on li.CodJournal = i.CodJournal LEFT JOIN bo_moeda mo on mo.CodMoeda = p.CodMoeda WHERE p.CodPublication IS NOT NULL AND cc.CodPublicationCategory = 2 AND p.Ano >= "2018" AND cc.CodPublicationCategory = 2 AND p.CodPublicationSubCategory = 5 AND (pc.CodColaborador=2186) GROUP BY p.CodPublication ORDER BY p.Ano DESC | QUERY: | SELECT p.*,GROUP_CONCAT( DISTINCT trim(pc.CodColaborador) separator ", ") as CodColaboradorMember,GROUP_CONCAT( DISTINCT trim(c.Nome) separator ", ") as MemberName FROM bo_publication p LEFT JOIN bo_publication_colaborador_link pc on pc.CodPublication = p.CodPublication LEFT JOIN bo_publication_category_link cc on cc.CodPublication = p.CodPublication LEFT JOIN bo_colaboradores c on pc.CodColaborador = c.CodColaborador LEFT JOIN bo_moeda mo on mo.CodMoeda = p.CodMoeda WHERE p.CodPublication IS NOT NULL AND cc.CodPublicationCategory = 3 AND cc.CodPublicationCategory = 3 AND (pc.CodColaborador=2186) GROUP BY p.CodPublication ORDER BY p.Ano DESC | QUERY: | SELECT p.*,GROUP_CONCAT( DISTINCT trim(pc.CodColaborador) separator ", ") as CodColaboradorMember,GROUP_CONCAT( DISTINCT trim(c.Nome) separator ", ") as MemberName FROM bo_publication p LEFT JOIN bo_publication_colaborador_link pc on pc.CodPublication = p.CodPublication LEFT JOIN bo_publication_category_link cc on cc.CodPublication = p.CodPublication LEFT JOIN bo_colaboradores c on pc.CodColaborador = c.CodColaborador LEFT JOIN bo_moeda mo on mo.CodMoeda = p.CodMoeda WHERE p.CodPublication IS NOT NULL AND cc.CodPublicationCategory = 1 AND cc.CodPublicationCategory = 1 AND p.CodPublicationSubCategory = 1 AND (pc.CodColaborador=2186) GROUP BY p.CodPublication ORDER BY p.Ano DESC | QUERY: | SELECT p.*,GROUP_CONCAT( DISTINCT trim(pc.CodColaborador) separator ", ") as CodColaboradorMember,GROUP_CONCAT( DISTINCT trim(c.Nome) separator ", ") as MemberName FROM bo_publication p LEFT JOIN bo_publication_colaborador_link pc on pc.CodPublication = p.CodPublication LEFT JOIN bo_publication_category_link cc on cc.CodPublication = p.CodPublication LEFT JOIN bo_colaboradores c on pc.CodColaborador = c.CodColaborador LEFT JOIN bo_moeda mo on mo.CodMoeda = p.CodMoeda WHERE p.CodPublication IS NOT NULL AND cc.CodPublicationCategory = 1 AND cc.CodPublicationCategory = 1 AND p.CodPublicationSubCategory = 3 AND (pc.CodColaborador=2186) GROUP BY p.CodPublication ORDER BY p.Ano DESC | QUERY: | SELECT p.*,GROUP_CONCAT( DISTINCT trim(pc.CodColaborador) separator ", ") as CodColaboradorMember,GROUP_CONCAT( DISTINCT trim(c.Nome) separator ", ") as MemberName FROM bo_publication p LEFT JOIN bo_publication_colaborador_link pc on pc.CodPublication = p.CodPublication LEFT JOIN bo_publication_category_link cc on cc.CodPublication = p.CodPublication LEFT JOIN bo_colaboradores c on pc.CodColaborador = c.CodColaborador LEFT JOIN bo_moeda mo on mo.CodMoeda = p.CodMoeda WHERE p.CodPublication IS NOT NULL AND cc.CodPublicationCategory = 1 AND cc.CodPublicationCategory = 1 AND p.CodPublicationSubCategory = 4 AND (pc.CodColaborador=2186) GROUP BY p.CodPublication ORDER BY p.Ano DESC