SELECT * FROM `joboffers` WHERE (volnemisto_vyraditdne >= DAY( CURDATE( ) ) OR volnemisto_vyraditdne = '') AND (obor LIKE '%;8;%' OR obor LIKE '8;%') AND firma_nazev <> '' AND profese_doplnek <> '' AND klient = 0 AND (klient_do <='2025-10-28' OR klient_do ='0000-00-00') AND ( pracoviste_okresKod = '3602' OR pracoviste_okresKod = '3604' OR pracoviste_okresKod = '3605' OR pracoviste_okresKod = '3607' OR pracoviste_okresKod = '3610') AND ( mzda_min <= '20000') ORDER BY volnemisto_zmena DESC LIMIT 100 OFFSET -100