Message: |
MySQL Query fail: SELECT rank, news_id, news_typeid, news_title, news_content, news_is_top, news_is_show, news_start_time, news_end_time, news_create_time, newstype_id, newstype_name, newstype_background_color
FROM(
SELECT @rn:=@rn+1 AS rank, news_id, news_typeid, news_title, news_content, news_is_top, news_is_show, news_start_time, news_end_time, news_create_time, newstype_id, newstype_name, newstype_background_color
FROM (
SELECT news_id, news_typeid, news_title, news_content, news_is_top, news_is_show, news_start_time, news_end_time, news_create_time, newstype_id, newstype_name, newstype_background_color
FROM rabbit_news LEFT JOIN rabbit_newstype ON news_typeid = newstype_id
WHERE news_is_show = 1 AND ((news_start_time = '0000-00-00' OR news_start_time <= '2024-12-31') AND (news_end_time = '0000-00-00' OR news_end_time >= '2024-12-31'))
ORDER BY news_is_top DESC, news_create_time DESC
) t1, (SELECT @rn:=0) t2) t3 WHERE rank < ORDER BY rank DESC LIMIT 1 |
MySQL Error: | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', news_id, news_typeid, news_title, news_content, news_is_top, news_is_show, new' at line 1 |