0) { $sql = "SELECT st.* , d.* , d.nm_hp as dealer_nm_hp , d.dt_insert as dealer_dt_insert from ( select t.cd_dealer_p, count(*) cnt from sale_master s inner join tender_master t on (s.cd_sale = t.cd_sale and s.ds_status = 'ZS' and t.ds_status = 'Z0' AND t.ds_delind = 'N') $add_sql group by t.cd_dealer_p ) st inner join aap_master d on (st.cd_dealer_p = d.cd_dealer and d.ds_type = 'D0') $add_sql1 $orderby LIMIT $pagestartpoint,$PageSize"; $r = mysql_query($sql); $i=1; while($col = mysql_fetch_array($r)) { $tmpNum =$totalrows-($PageSize*($PageNo-1)); $no = ($tmpNum - $i)+1; ?>

번호	업체명	연락처	구매확정차량	회원가입일
등록된 정보가 없습니다.