VHS Landkreis Pfaffenhofen: Kultur

Pfaffenhofen >> Kultur & Kreatives

SELECT KNr, Gewichtung, Von, Bis FROM web_kurshighlights wk join kurse k on wk.knr = k.nr WHERE (('2017-07-22 00:00' >= wk.Von AND '2017-07-22 00:00' <= wk.Bis) or ((wk.von is null or wk.von = '1899-12-30') and wk.bis >= '2017-07-22 00:00') or ((wk.bis is null or wk.bis = '1899-12-30') and wk.von <= '2017-07-22 00:00') or ((wk.bis is null or wk.bis = '1899-12-30') and (wk.von is null or wk.von = '1899-12-30'))) and ifnull(k.internetaktiv, 'F') ='W' and ifnull(k.ausfall, 'F') <>'J' AND k.internetaktiv = 'W' AND (('2017-07-22' >=k.internetvon AND '2017-07-22' <= k.internetbis) or ('2017-07-22' >= k.internetvon and (k.internetbis is null or k.internetbis = '1899-12-30')) or ((k.internetvon is null or k.internetvon = '1899-12-30') and k.internetbis >= '2017-07-22') or ((k.internetvon is null or k.internetvon = '1899-12-30') and (k.internetbis is null or k.internetbis = '1899-12-30'))) AND k.typ != 'B' AND k.semester in ('1/17') AND k.nr in ('171A5101', '171A5102', '171A5103', '171A5104', '171A5105', '171A5301', '171A5302', '171A5300', '171A5301_1', '171A5501', '171A5502', '171A5503', '171A5504', '171A5508', '171A5509', '171A5511', '171A5512', '171A5515', '171A5516', '171A5517', '171A5518', '171A6055', '171A6056', '171A6069', '171A6070', '171A6057', '171A5603', '171A5604', '171A5601', '171A5602', '171A5607', '171A5608', '171A5610', '171A5611', '171A5613', '171A5615', '171A5616', '171A5617', '171A5618', '171A5612', '171A5620', '171A5619', '171A5627', '171A5628', '171A5701', '171A5710', '171A5702', '171A5704', '171A5714', '171A5712', '171A5706', '171A5708', '171A5720', '171A5718', '171A5716', '171A2371', '171A5703', '171A5730', '171A5731', '171A5732', '171A5733', '171A5735', '171A5736', '171A5821', '171A5822', '171A5820', '171A5803', '171A5804', '171A5805', '171A5806', '171A5807', '171A5809', '171A5811', '171A5812', '171A5810', '171A5813', '171A5814', '171A5823', '171A5815', '171A5803-1', '171A5806-1', '171A5801', '171A5802', '171A5802-1', '171A5901', '171A5902', '171A5909', '171A5910', '171A5911', '171A5915', '171A5916', '171A5926', '171A5930', '171A5931', '171A5932', '171A5917', '171A5915-1', '171A5915-2', '171A5940', '171A5941', '171A5942', '171A5943', '171A5951', '171A5944', '171A5955', '171A5956', '171A5820', '171A6502', '171A6501', '171A6572', '171A6530', '171A6581', '171A6519', '171A6520', '171A6522', '171A6523', '171A6510', '171A6511', '171A6513', '171A6514', '171A6515', '171A6516', '171A6582', '171A6560', '171A6517', '171A6512', '171A6518', '171A6540', '171A6570', '171A6571', '171A6573', '171A6574', '171A6575', '171A6576', '171A6505', '171A6506', '171A6507', '171A6508', '171A6525', '171A6526', '171A6542', '171A6561', '171A6525-1', '171A6515-1', '171A6091', '171A6092', '171A6093', '171A6094', '171A6603', '171A6602', '171A6605', '171A6606', '171A6601', '171A6601-1') AND ( (SELECT max(datum) FROM kurstage kurst WHERE kurst.knr = k.nr) >= '2017-07-22') AND ( (SELECT count(*) FROM belegung b WHERE b.knr = k.nr AND (b.status_1 in ('A','T','P',' ','') or b.status_1 is null) ) < k.teil_max ) ORDER BY Gewichtung DESC

Aktuelle Kursangebote - Kultur & Kreatives

Aktuell gibt es leider keine Kursvorschläge.

Fachbereichsleitung

Nina Haslauer
Telefon 08441 490480
E-Mail schreiben

Anmeldung

Lena Thalmeier
Telefon 08441 490480
E-Mail schreiben

Literatur (5)

vhs-Studienreisen (3)

Zeichnen - Malen (17)

Künstlerisches Gestalten (17)

Fotografie und Bildbearbeitung (13)

Filmkunsttage: Der besondere Film (6)

Musik (17)

Gesang (3)

Standard- und Lateinamerikanische Tänze (14)

Internationale Tänze (8)

Konzert (1)

Essen und Genießen (36)

Textiles Gestalten (9)

Aktuelle Kursangebote - Kultur & Kreatives

Fachbereichsleitung

Anmeldung

Kurse in Ihrer Nähe