Workstation AG Personaldienstleistungen - Jobbörse
Jobsuche
Alles auf einen Blick. Täglich aktualisiert. Bundesweit.
In unserer Jobbörse finden Sie regelmäßig die neuesten Stellenangebote für alle Branchen.
Nachschauen lohnt sich. Finden Sie Ihren Traumjob, bevor es jemand anderes macht.
1 Stellenanzeigen
Seite 0 von 1
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-20, 20' at line 32
SELECT CONCAT(k_s.id, k_s_a.id) AS id ,
k_s.id AS stellen_id ,
k_s.eintrittsdatum AS stellen_eintrittsdatum ,
k_s.mitarbeiter_id AS stellen_mitarbeiter_id ,
k_s_a.id AS anzeigen_id ,
k_s_titel.name AS anzeigen_titel ,
k_s_text.text AS anzeigen_text ,
k_s_a_o.ort AS anzeigen_ort,
k_s_a_o.plz AS anzeigen_plz,
k_s_a_o.id AS ort_id,
k_s_a.ba_startDate
FROM
kunden_stellen as k_s
INNER JOIN
kunden_stellen_anzeigen AS k_s_a
ON
k_s.id = k_s_a.stellen_id
INNER JOIN
kunden_stellen_anzeigen_orte AS k_s_a_o
ON
k_s_a_o.anzeigen_id = k_s_a.id
INNER JOIN
kunden_stellen_titelvorlagen AS k_s_titel
ON k_s_titel.id = k_s_a.titel_id
INNER JOIN
kunden_stellen_textvorlagen AS k_s_text
ON k_s_text.id = k_s_a.textvorlage_id
INNER JOIN
berufe AS berufe
ON berufe.id = k_s_a.beruf_id1
INNER JOIN jobboerse_kategorien_textvorlagen AS jk ON jk.textvorlagen_id = k_s_text.id AND jk.jobboerse_kategorien_id = 6
WHERE k_s_a.aktiv = 1 ORDER BY k_s_a_o.ort ASC, IF(LENGTH(k_s_a_o.plz)=5, k_s_a_o.plz, CONCAT('0',k_s_a_o.plz)) ASC, CONCAT(k_s.id, k_s_a.id) DESC LIMIT -20, 20