发布时间:2019-10-08 16:00 发布者:飞闪网 浏览数:4
更新内容:
1 修复部分用户二级目录站点无法绑定核销员问题
2 导出核销记录增加 核销状态导出(全部、未核销、已核销)
3 修复用户重复提交订单时丢单问题
SELECT t1.tid,t2.id,t2.title,t2.url,t2.date,t3.id FROM king_content_tag_bind t1 LEFT OUTER JOIN (king_content t2,king_content_tag_bind t3) ON t2.id=t3.id WHERE t2.mid=4 and t2.status=1 and t1.id=354 and t3.tid=t1.tid and t2.id<>354 GROUP BY t2.id desc LIMIT 8
SELECT t1.title,t1.url,t1.image,t2.cid,t4.tu FROM king_content t1 LEFT OUTER JOIN (king_content_categroy_bind t2,king_content_categroy t3,king_content__case t4) ON t1.id=t2.id and t2.cid=t3.cid and t2.id=t4.id WHERE t1.mid=2 and t1.status=1 and t3.cid1=22 GROUP BY t1.hit desc LIMIT 10
公众号
飞闪网微信公众号
企业微信
飞闪助手君¹企微