sumproduct函数的使用方法及实例

页面:/news/view-2291775/ | 耗时:0.9193 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2291775 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2291775 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2291775 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(3289204,469759,1101627,1116023,637876,499635,663883,600330,659450,1019503,728233,2222726,2742196,1119281,1630039,849331,3155898,1114310,1116329,1094319,432748,3406253,1127093,491621,1964901,3194944,1093222,680962,3442748,483258) ORDER BY field (ArticleID,3289204,469759,1101627,1116023,637876,499635,663883,600330,659450,1019503,728233,2222726,2742196,1119281,1630039,849331,3155898,1114310,1116329,1094319,432748,3406253,1127093,491621,1964901,3194944,1093222,680962,3442748,483258)