大家帮帮忙啊，快急死了，谢谢！！！

boltcrank

是不是可以考虑下更改下数据库的表结构呢

hcpalex

表结构已经没有办法再改了啊

victory

SELECT a.id,a.username,a.name,a.ip,b.*
FROM eqs_users a
LEFT JOIN ws_users_info b on a.id=b.uid
WHERE a.uid
IN (
  SELECT uid FROM ws_cn_sell
  GROUP BY uid having count(uid)>1)
ORDER BY a.register_date DESC LIMIT 0, 20

迪迪安

SELECT COUNT(*) FROM eqs_users a LEFT JOIN ws_users_info b ON a.id=b.uid WHERE 1=1 HAVING sell_num >=10

这个真的有用？不明白……

SELECT COUNT(*) FROM eqs_users as a,ws_users_info as b,ws_cn_sell as c WHERE a.id=b.uid asd b.sell_num >=10
感觉这个就能实现你的查询要求了

如果分页，就的使用limit了

$page=20;//每页20条信息
$p=$_GET["page"];//获取传递参数
$sql="select * from eqs_users as a,ws_users_info as b,ws_cn_sell as c WHERE a.id=b.uid asd b.sell_num >=10 limit {$page*($p-1)},{$page*$p}";

OK?行了不？唉……

awetogg

子查询，小心mysql堵塞