SELECT
 vvg.Name AS a1,
 '' AS a2,
 max(CASE WHEN vrc.PeriodSelector = 0 AND vrc.PeriodFrom = 0 AND vrc.PeriodTo = 1
 THEN vvt.ShortName ELSE '' END) AS a3,
 max(CASE WHEN vrc.PeriodSelector = 0 AND vrc.PeriodFrom = 3 AND vrc.PeriodTo = 7
 THEN vvt.ShortName ELSE '' END) AS a4,
 max(CASE WHEN vrc.PeriodSelector = 1 AND vrc.PeriodFrom = 1 AND vrc.PeriodTo = 1
 THEN vvt.ShortName ELSE '' END) AS a5,
 max(CASE WHEN vrc.PeriodSelector = 1 AND vrc.PeriodFrom = 2 AND vrc.PeriodTo = 2
 THEN vvt.ShortName ELSE '' END) AS a6,
 max(CASE WHEN vrc.PeriodSelector = 1 AND vrc.PeriodFrom = 3 AND vrc.PeriodTo = 3
 THEN vvt.ShortName ELSE '' END) AS a7,
 max(CASE WHEN vrc.PeriodSelector = 0 AND vrc.PeriodFrom = 130 AND vrc.PeriodTo = 150
 THEN vvt.ShortName ELSE '' END) AS a8,
 max(CASE WHEN vrc.PeriodSelector = 1 AND vrc.PeriodFrom = 6 AND vrc.PeriodTo = 6
 THEN vvt.ShortName ELSE '' END) AS a9,
 max(CASE WHEN vrc.PeriodSelector = 1 AND vrc.PeriodFrom = 7 AND vrc.PeriodTo = 7
 THEN vvt.ShortName ELSE '' END) AS a10,
 max(CASE WHEN vrc.PeriodSelector = 1 AND vrc.PeriodFrom = 12 AND vrc.PeriodTo = 12
 THEN vvt.ShortName ELSE '' END) AS a11,
 max(CASE WHEN vrc.PeriodSelector = 1 AND vrc.PeriodFrom = 15 AND vrc.PeriodTo = 15
 THEN vvt.ShortName ELSE '' END) AS a12,
 max(CASE WHEN vrc.PeriodSelector = 1 AND vrc.PeriodFrom = 18 AND vrc.PeriodTo = 18
 THEN vvt.ShortName ELSE '' END) AS a13,
 max(CASE WHEN vrc.PeriodSelector = 1 AND vrc.PeriodFrom = 20 AND vrc.PeriodTo = 20
 THEN vvt.ShortName ELSE '' END) AS a14,
 max(CASE WHEN vrc.PeriodSelector = 2 AND vrc.PeriodFrom = 6 AND vrc.PeriodTo = 6
 THEN vvt.ShortName ELSE '' END) AS a15,
 max(CASE WHEN vrc.PeriodSelector = 2 AND vrc.PeriodFrom = 6 AND vrc.PeriodTo = 7
 THEN vvt.ShortName ELSE '' END) AS a16,
 max(CASE WHEN vrc.PeriodSelector = 2 AND vrc.PeriodFrom = 7 AND vrc.PeriodTo = 7
 THEN vvt.ShortName ELSE '' END) AS a17,
 max(CASE WHEN vrc.PeriodSelector = 2 AND vrc.PeriodFrom = 14 AND vrc.PeriodTo = 14
 THEN vvt.ShortName ELSE '' END) AS a18,
 max(CASE WHEN vrc.PeriodSelector = 2 AND vrc.PeriodFrom = 18 AND vrc.PeriodTo = 18
 THEN vvt.ShortName ELSE '' END) AS a19
FROM vcn_VaccinationGroup vvg
 inner join vcn_Inoculation vi on vi.rf_VaccinationGroupID=vvg.VaccinationGroupID
    and vi.InoculationID>0
 inner join vcn_VaccinationType vvt ON vvt.VaccinationTypeID = vi.rf_VaccinationTypeID
    and vvt.VaccinationTypeID>0
 inner join vcn_RegionalCalendar vrc ON vrc.rf_VaccinationTypeID=vvt.VaccinationTypeID
    and vrc.RegionalCalendarID>0
    and vrc.rf_MKBID > 0
 where vvg.VaccinationGroupID>0
GROUP BY vvg.Code, vvg.Name
ORDER BY vvg.Code