sql 출력 관련 입니다.

if ($fr_date && $to_date) {
    $sql_search = " and SUBSTR(mb_datetime, 1,10) >= '".$fr_date."' and SUBSTR(mb_datetime, 1,10) <= '".$to_date."' ";
}

 

$sql = " select * from (select mb_recommend, count(*) as cnt from g5_member where mb_leave_date = '' and mb_addr1 != '' and mb_bank_name != '' and mb_recommend != '' {$sql_search} group by mb_recommend order by cnt desc) summary left outer join g5_member on g5_member.mb_id = summary.mb_recommend order by cnt desc limit 0, 10 ";
$result = sql_query($sql);