MySQL Query : SELECT COUNT(DISTINCT n.`id`) AS total FROM `v9_tag_news_relation` r INNER JOIN `v9_news` n ON n.`id`=r.`news_id` WHERE r.`tag_id`=92359 AND r.`status`=1 AND r.`news_special_status`=0 AND n.`status`=99 AND IFNULL(n.`gys`,0)=0 AND IFNULL(n.`no_search`,0)=0 AND IFNULL(n.`qp_cp`,0)=0 AND IFNULL(n.`www_404`,0)=0 AND IFNULL(n.`shielding`,0)=0
MySQL Error : Unknown column 'r.news_special_status' in 'where clause'
MySQL Errno : 1054
Message : Unknown column 'r.news_special_status' in 'where clause'
Need Help?