File:view.html
Method:query.table(columns,*where,*order,*top)
资源池 'default' 没有足够的系统内存来运行此查询。
select top 12 GoodsId,GoodsName,Pic,ParaType,UserId,ManufactorId FROM goods_goods WHERE Status=1 and AreaId=1 and CatalogId=925 and ManufactorId=992 and GoodsId<>1105485 and GoodsId in(select GoodsId from goods_para where GoodsId in(select GoodsId from goods_goods where Status=1 and AreaId=1 and CatalogId=925) and Status=1) and ManufactorId in(select ManufactorId from usmanufactor where mStatus=0 and Status=1) ORDER BY newid(),GoodsId desc
数据库执行错误
xmls/goodsview.xmls
...row[GoodsId];
@query[ManufactorId]=@row[ManufactorId];
//@Sametable=@query.table(['GoodsId,GoodsName,Pic,ParaType,UserId,ManufactorId'],['Status=1 and AreaId=1 and CatalogId={*CatalogId} and GoodsId<>{*GoodsId} and GoodsId in(select GoodsId from goods_para where GoodsId in(select GoodsId from goods_goods where Status=1 and AreaId=1 and CatalogId={*CatalogId}) and Status=1) and ManufactorId in(select ManufactorId from usmanufactor where mStatus=0 and Status=1)'],['newid(),GoodsId desc'],12);
@Sametable=@query.table(['GoodsId,GoodsName,Pic,ParaType,UserId,ManufactorId'],['Status=1 and AreaId=1 and CatalogId={*CatalogId} and ManufactorId={*ManufactorId} and GoodsId<>{*GoodsId} and GoodsId in(select GoodsId from goods_para where GoodsId in(select GoodsId from goods_goods where Status=1 and AreaId=1 and CatalogId={*CatalogId}) and Status=1) and ManufactorId in(select ManufactorId from usmanufactor where mStatus=0 and Status=1)'],['newid(),GoodsId desc'],12);
@sameView=@Sametable.for...