返回

信息管理

展示中(Say:
SELECT count(*) FROM `shyl_tupianzhanshi` WHERE memberid= and isshow=1 and (paystatus=1 or first=1) LIMIT 1) 置顶中(Say:
SELECT count(*) FROM `shyl_tupianzhanshi` WHERE memberid= and isshow=1 and zuixin=1 and yxq>'2025-04-11 23:57:50' and (paystatus=1 or first=1) LIMIT 1) 待支付(Say:
SELECT count(*) FROM `shyl_tupianzhanshi` WHERE memberid= and paystatus=0 and first!=1 LIMIT 1) 已下架(Say:
SELECT count(*) FROM `shyl_tupianzhanshi` WHERE memberid= and isshow=0 and (paystatus=1 or first=1) LIMIT 1)
Say:
select a.*,b.name,b.image,b.renzheng from shyl_tupianzhanshi a left join shyl_member b on a.memberid=b.id where a.navid=1 and a.isshow=1 and (a.paystatus=1 or a.first=1) and a.memberid= order by a.paixu desc,a.date desc,a.id desc limit 0,300
琼ICP备2024038288号-1

首页

发布

我的