。。。。省略
if($benxiao>0)
{
$sql_where.=" and huodong.mobile not in (SELECT mother_mobile FROM ".$fdyu->table('oa_xueyuan')." where school_id=".$school_id.") and huodong.mobile not in (SELECT father_mobile FROM ".$fdyu->table('oa_xueyuan')." where school_id=".$school_id.") and huodong.mobile not in (SELECT home_tel FROM ".$fdyu->table('oa_xueyuan')." where school_id=".$school_id.")";//這里如果oa_xueyuan這張表里的資料多的話，搜索起來就很慢，有什么其它的方法可以快一點嗎？
}
$sql = "SELECT huodong.* FROM
".$fdyu->table('oa_huodong_baoming')." as huodong
".$sql_title." ".$sql_benxiao." ".$sql_where." order by feiyong desc,huodong_baoming_id desc";
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/73690.html
標籤：MySQL
上一篇：熱點網格圖層