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
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.
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
