SELECT DISTINCT code, title, perex, date_from, image, title_url, author, category FROM news_items WHERE (host='plzensko' OR regions LIKE '%plzensko%') AND admin_lock=0 AND state>=2 AND date_from<='30.08.2025 22:47:28' AND (date_to>='30.08.2025 22:47:28' OR date_to<'1.1.1990') AND (categories LIKE '%,9,%') ORDER BY date_from DESC OFFSET 17700 ROWS FETCH NEXT 15 ROWS ONLY