$count_sql = "SELECT COUNT(*) AS num_all FROM wy_wxuser_income_record income WHERE NOT EXISTS (SELECT * FROM wy_editgame pay WHERE pay.item_id = income.item_id AND pay.paid = 1) AND income.remark = 'send_redpacket'"; $count = $m->query($count_sql); $Page = new Page ( $count[0]['num_all'], 50 ); $sql = "SELECT income.* FROM wy_wxuser_income_record income WHERE NOT EXISTS (SELECT * FROM wy_editgame pay WHERE pay.item_id = income.item_id AND pay.paid = 1) AND income.remark = 'send_redpacket' ORDER BY id DESC LIMIT ".$Page->firstRow.','.$Page->listRows;
多表连贯查询不存在
最新推荐文章于 2022-08-03 19:17:03 发布