Operand should contain 1 column(s) | 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=203, 220 OR pcs.CodColaborador=203, 220 OR pcss.CodColaborador=203, 220) GROUP BY p.CodPublication ORDER BY p.Ano DESCOperand should contain 1 column(s) | 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=203, 220) GROUP BY p.CodPublication ORDER BY p.Ano DESCOperand should contain 1 column(s) | 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=203, 220) GROUP BY p.CodPublication ORDER BY p.Ano DESCOperand should contain 1 column(s) | 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=203, 220) GROUP BY p.CodPublication ORDER BY p.Ano DESCOperand should contain 1 column(s) | 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=203, 220) GROUP BY p.CodPublication ORDER BY p.Ano DESCOperand should contain 1 column(s) | 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=203, 220) GROUP BY p.CodPublication ORDER BY p.Ano DESC