SELECT *, label AS label, ( ctrl_show = 1 AND ( ctrl_show_from < NOW() OR ctrl_show_from = "0000-00-00" ) AND ( ctrl_show_until > NOW() OR ctrl_show_until = "0000-00-00" ) ) AS is_active FROM job WHERE 1 AND ( true AND ( ctrl_show = 1 AND ( ctrl_show_from < NOW() OR ctrl_show_from = "0000-00-00" ) AND ( ctrl_show_until > NOW() OR ctrl_show_until = "0000-00-00" ) ) ) ORDER BY ctrl_referencedate DESC
SELECT *, label AS label, ( ctrl_show = 1 AND ( ctrl_show_from < NOW() OR ctrl_show_from = "0000-00-00" ) AND ( ctrl_show_until > NOW() OR ctrl_show_until = "0000-00-00" ) ) AS is_active FROM job WHERE 1 AND ( true AND ( ctrl_show = 1 AND ( ctrl_show_from < NOW() OR ctrl_show_from = "0000-00-00" ) AND ( ctrl_show_until > NOW() OR ctrl_show_until = "0000-00-00" ) ) AND ( `job_kat` = 2 ) ) ORDER BY ctrl_referencedate DESC
SELECT *, label AS label, ( ctrl_show = 1 AND ( ctrl_show_from < NOW() OR ctrl_show_from = "0000-00-00" ) AND ( ctrl_show_until > NOW() OR ctrl_show_until = "0000-00-00" ) ) AS is_active FROM job WHERE 1 AND ( true AND ( ctrl_show = 1 AND ( ctrl_show_from < NOW() OR ctrl_show_from = "0000-00-00" ) AND ( ctrl_show_until > NOW() OR ctrl_show_until = "0000-00-00" ) ) AND ( `job_kat` = 1 ) ) ORDER BY ctrl_referencedate DESC
Kolpinghäuser - Verband der Kolpinghäuser
Kolpinghäuser in
Die Kolpinghäuser
Anfangs dienten die Kolpinghäuser als Hospitien für Handwerksgesellen.

Heute jedoch bieten die Kolpinghäuser über 230 Mal in Europa ein vielseitiges und differenziertes Angebot.

Die neuen Standards unserer Häuser sind am internationalen Qualitätsniveau ausgerichtet.
WIR ZIEHEN UM!

Sehr geehrte Besucher:innen,
wir ziehen um! Ab dem 10.05.2021 finden Sie uns in der St.-Apern-Str. 32 in 50667 Köln.

Ihr VKH-Team

 

schließen
SELECT *, label AS label, ctrl_show = true AS is_active FROM house h WHERE 1 AND ( true AND ctrl_show = true )
SELECT *, headline AS label, ( n.ctrl_show = true AND ( n.ctrl_show_from <= NOW() OR ( n.ctrl_show_from = "0000-00-00" OR ISNULL(n.ctrl_show_from) ) ) AND ( n.ctrl_show_until >= NOW() OR ( n.ctrl_show_until = "0000-00-00" OR ISNULL(n.ctrl_show_until) ) ) ) AS is_active FROM news n WHERE 1 AND ( ( 1 AND ( n.ctrl_show = true AND ( n.ctrl_show_from <= NOW() OR ( n.ctrl_show_from = "0000-00-00" OR ISNULL(n.ctrl_show_from) ) ) AND ( n.ctrl_show_until >= NOW() OR ( n.ctrl_show_until = "0000-00-00" OR ISNULL(n.ctrl_show_until) ) ) ) ) ) ORDER BY ctrl_referencedate DESC LIMIT 0, 2