摘要:
(select * from table where (sid={$sid} and sender_deleted <> 1) or (mid={$mid} and receiver_deleted <> 1) order by create_at desc limit 999999) a grou 阅读全文
摘要:
SELECT T1.id,T1.`status`,if(FIND_IN_SET(pid,@pids) > 0,@pids := CONCAT(@pids,',',id),0) as ischild FROM (SELECT id,pid,`status` FROM table T WHERE 1 = 阅读全文
摘要:
SELECT @r AS _id, (SELECT @r := pid FROM table WHERE id = _id) AS pid, @l := @l + 1 AS lvl FROM (SELECT @r := {$id},@l := -1) vars,table h WHERE @r <> 阅读全文