SQL: SELECT count(*) as c FROM `dj_1_news` WHERE `dj_1_news`.`tag` = "上海动画制作" AND ((`dj_1_news`.`title` LIKE "%上海动画制作%" OR `dj_1_news`.`keywords` LIKE "%上海动画制作%")) AND `dj_1_news`.`status` = 9 ORDER BY NULL这是有bug呀, AND ((`dj_1_news`.`title` LIKE "%上海动画制作%" OR `dj_1_news`.`keywords` LIKE "%上海动画制作%")) ,应该有 tag=$tag.tags 就不应该再去匹配标题和关键词了。`dj_1_news`.`tag` = "上海动画制作"这里也不应该是=,因为同一条内容会有多个tag标签
SQL: SELECT count(*) as c FROM `dj_1_news` WHERE `dj_1_news`.`tag` = "上海动画制作"
AND ((`dj_1_news`.`title` LIKE "%上海动画制作%" OR `dj_1_news`.`keywords` LIKE "%上海动画制作%"))
AND `dj_1_news`.`status` = 9 ORDER BY NULL
这是有bug呀, AND ((`dj_1_news`.`title` LIKE "%上海动画制作%" OR `dj_1_news`.`keywords` LIKE "%上海动画制作%")) ,
应该有 tag=$tag.tags 就不应该再去匹配标题和关键词了。
`dj_1_news`.`tag` = "上海动画制作"这里也不应该是=,因为同一条内容会有多个tag标签