SELECT id, eventdate, autor, date, short_story, SUBSTRING(full_story, 1, 15) as full_story, xfields, title, category, alt_name, comm_num, allow_comm, allow_rate, fixed, rating, vote_num, news_read, flag, editdate, editor, reason, view_edit, tags, p_img, p_b_img, img, newstype FROM dle_post WHERE approve  AND (category regexp '[[:<:]](12)[[:>:]]' OR category regexp '[[:<:]](13)[[:>:]]' OR category regexp '[[:<:]](920)[[:>:]]' OR category regexp '[[:<:]](922)[[:>:]]' OR category regexp '[[:<:]](21)[[:>:]]' OR category regexp '[[:<:]](24)[[:>:]]' OR category regexp '[[:<:]](80)[[:>:]]') AND date >= '2019-03-21 08:19:49' - INTERVAL 4 DAY AND (xfields LIKE '%typenews|gor2%' OR xfields LIKE '%typenews|ver2%')AND xfields LIKE '%type2news|A%' ORDER BY date desc limit 1
Система Orphus