Everyone, help me, I'm dying, thank you! !! !!

boltcrank

Is it possible to consider changing the table structure of the database?

hcpalex

There is no way to change the table structure

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

Is this really useful? do not understand……

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
I feel this will fulfill your query requirements

If pagination, use the limit

$page=20;//20 messages per page
$p=$_GET["page"];//Get the transfer parameters
$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? Okay? Ugh……

awetogg

Subquery, be careful of mysql blocking