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 '[[:<:]](904)[[:>:]]' AND date >= '2019-03-22 23:01:34' - INTERVAL 4 DAY AND (xfields LIKE '%typenews|gor2%' OR xfields LIKE '%typenews|ver2%')AND xfields LIKE '%type2news|A%' ORDER BY date desc limit 1
