where 条件重复问题

甲骨文

在查询之前，先做了一个count请问（这里面的where条件跟查询语句是一样的），在使用查询时发生了重复的情况。
如下：
SELECT * FROM (`pictures`) WHERE `width` = 190 AND `height` = 90 AND `cid` = 13 AND `seller_score` >= 251 AND `seller_score` <= 20000 AND `hard` = 1 AND `width` = 190 AND `height` = 90 AND `cid` = 13 AND `seller_score` >= 251 AND `seller_score` <= 20000 AND `hard` = 1 ORDER BY `created` desc, `down_datetime` desc LIMIT 8, 8

skeay

额 没明白楼主想要说什么

jeongee

其实我也没太明白，你最好还是代码吧

zhouli520

楼主是要where里嵌套select查询语句吧.