SELECT * FROM `joboffers` WHERE (volnemisto_vyraditdne >= DAY( CURDATE( ) ) OR volnemisto_vyraditdne = '') AND (obor LIKE '%;14;%' OR obor LIKE '14;%') AND firma_nazev <> '' AND profese_doplnek <> '' AND klient = 0 AND (klient_do <='2025-04-19' OR klient_do ='0000-00-00') AND pracoviste_okresKod = '3407' AND ( pracpravni_vztah_ppvztahDpp = 'A' OR pracpravni_vztah_ppvztahDpc = 'A') AND ( min_vzdelani_kod >= 'K' AND min_vzdelani_kod <= 'P' ) ORDER BY volnemisto_zmena DESC LIMIT 100 OFFSET -100