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 (('2018-04-23 00:00' >= wk.Von AND '2018-04-23 00:00' <= wk.Bis) or ((wk.von is null or wk.von = '1899-12-30') and wk.bis >= '2018-04-23 00:00') or ((wk.bis is null or wk.bis = '1899-12-30') and wk.von <= '2018-04-23 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 (('2018-04-23' >=k.internetvon AND '2018-04-23' <= k.internetbis) or ('2018-04-23' >= 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 >= '2018-04-23') 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/18') AND k.nr in ('172A5105', '172A5102', '172A5103', '172A5101', '172A5104', '172A5106', '172A5107', '172A5108', '172A5109', '181A5105', '181A5106', '181A5107', '181A5108', '181A5110', '181A5109', '181A5111', '181A5112', '181A5113', '172A5301', '172A5302', '172A5303', '181A5303', '181A5302', '172A5507', '172A5501', '172A5502', '172A5503', '172A5508', '172A5509', '172A5511', '172A5512', '172A5515', '172A5516', '172A5517', '172A5518', '172A6055', '172A6056', '172A6069', '172A6070', '172A5519', '181A5501', '181A5502', '181A5503', '181A5508', '181A5509', '181A5511', '181A5512', '181A5515', '181A5516', '181A5517', '181A5518', '181A5520', '181A6055', '181A6056', '181A6069', '181A6070', '181A5519', '181A5518+', '181A6071', '181A6072', '181A1609', '181A5504', '181A5505', '181A6072A', '181A6072B', '181A6072C', '172A5601', '172A5602', '172A5603', '172A5604', '172A5605', '172A5606', '172A5611', '172A5615', '172A5616', '172A5617', '172A5620', '172A5621', '172A5622', '172A5623', '172A5624', '172A5609', '172A5618', '172A5610', '172A5625', '172A6075', '172A5630', '172A5626', '181A5603', '181A5604', '181A5601', '181A5602', '181A5605', '181A5606', '181A5610', '181A5612', '181A5615', '181A5617', '181A5618', '181A5620', '181A5621', '181A5622', '181A5623', '181A5624', '181A6075', '181A5608', '181A5607', '181A5613', '181A5614', '181A6076', '181A6077', '172A2371', '172A5701', '172A5725', '172A5703', '172A5717', '172A5719', '172A5713', '172A5715', '172A5705', '172A5723', '172A5721', '172A5707', '172A5711', '172A5727', '172A5700', '172A5724', '172A1602', '172A5709', '181A5701', '181A5713', '181A5710', '181A5703', '181A5707', '181A5708', '181A5711', '181A5715', '181A5717', '181A5700', '181A5710_1', '181A5635', '181A5636', '181A5637', '172A5732', '172A5733', '172A5734', '172A5735', '172A5736', '181A5732', '181A5733', '181A5734', '181A5735', '181A5736', '181A5737', '181A5730', '172A5816', '172A5817', '172A5827', '172A5820', '172A5823', '172A5824', '172A5825', '172A5826', '172A5822', '172A5809', '172A5810', '172A5806', '172A5807', '172A5805', '172A5811', '172A5812', '172A5803', '172A5804', '172A5815', '172A5818', '172A5819', '172A5806+', '172A5804-1', '172A5817-2', '181A5806', '172A5800', '172A5817_', '172A58172_', '172A5819-1', '181A5803', '181A5804', '181A5807', '181A5808', '181A5809', '181A5816', '181A5817', '181A5819', '181A5820', '181A5821', '181A5822', '181A5823', '181A5826', '181A5827', '181A5828', '181A5810', '181A5811', '181A5808A', '181A5809_', '181A5805', '172A5802', '172A5823', '172A5801', '181A5801', '181A5802', '172A5802-1', '172A5802-2', '172A5901', '172A5902', '172A5915', '172A5917', '172A5919', '172A5920', '172A5926', '172A5930', '172A5931', '172A5916', '172A5918', '172A5925', '172A5913', '172A5909', '172A5910', '172A5911', '172A5912', '172A5914', '181A5901', '181A5902', '181A5909', '181A5910', '181A5912', '181A5915', '181A5917', '181A5918', '181A5919', '181A5925', '181A5926', '181A5930', '181A5931', '181A5932', '181A5933', '172A5920-1', '172A5940', '172A5941', '172A5942', '172A5943', '172A5951', '172A5944', '172A5952', '181A5941', '181A5942', '181A5951', '181A5952', '181A5944', '172A5827', '172A5820', '172A5824', '172A5825', '172A5822', '172A5826', '181A5826', '181A5827', '172A6560', '172A6582', '172A6530', '172A6581', '172A6561', '172A6562', '172A6544', '172A6545', '172A6510', '172A6509', '172A6515', '172A6514', '172A6539', '172A6517', '172A6516', '172A6513', '172A6571', '172A6572', '172A6519', '172A6501', '172A6502', '172A6503', '172A6504', '172A6580', '172A6570', '172A6573', '172A6574', '172A6575', '172A6576', '172A6577', '172A6520', '172A6521', '172A6522', '172A6523', '172A6511', '172A6512', '172A6523-1', '172A6523-2', '181A6582', '181A6560', '181A6521', '181A6520', '181A6512', '181A6511', '181A6505', '181A6510', '181A6506', '181A6507', '181A6508', '181A6570', '181A6572', '181A6574', '181A6576', '181A6578', '181A6580', '181A6581', '181A6501', '181A6502', '172A6091', '172A6092', '172A6093', '172A6094', '172A6603', '172A6605', '172A6604', '172A5607', '172A6601', '181A5609', '181A6091', '181A6092', '181A6093', '181A6094', '172A6604-1', '181A6603', '181A6604', '181A6605', '181A6601', '181A6602', '181A6604-1', '172A6901', '172A6902', '172A6903', '181A6901') AND ( (SELECT max(datum) FROM kurstage kurst WHERE kurst.knr = k.nr) >= '2018-04-23') 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 (9)

vhs-Studienreisen (2)

Zeichnen - Malen (26)

Künstlerisches Gestalten (23)

Fotografie und Bildbearbeitung (11)

Modellbahnbau (3)

Filmkunsttage: Der besondere Film (7)

Musik (21)

Gesang (2)

Standard- und Lateinamerikanische Tänze (15)

Internationale Tänze (5)

Konzert (2)

Essen und Genießen (24)

Textiles Gestalten (11)

Kartenspiel (1)

Aktuelle Kursangebote - Kultur & Kreatives

Fachbereichsleitung

Anmeldung

Kurse in Ihrer Nähe