Strict Standards: Declaration of action_plugin_blog::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/blog/action.php on line 13

Strict Standards: Declaration of action_plugin_indexmenu::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/indexmenu/action.php on line 13

Strict Standards: Declaration of action_plugin_importoldchangelog::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/importoldchangelog/action.php on line 8

Strict Standards: Declaration of action_plugin_importoldindex::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/importoldindex/action.php on line 8

Strict Standards: Declaration of action_plugin_include::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/include/action.php on line 19

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 208

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 211

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 421

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 594

Strict Standards: Declaration of cache_instructions::retrieveCache() should be compatible with cache::retrieveCache($clean = true) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/cache.php on line 291

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/auth.php on line 154

Strict Standards: Only variables should be passed by reference in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/doku.php on line 73
ローン申込者リスト [開発チーム]

ローン申し込み経験者

 
-- 結構重いので最初にLIMITで制限して数件のテスト
-- 次にCSVに直接吐き出す(CSEでそのまま出そうとすると多分固まるから)
 
SELECT
me_uniqnum,
me_reg_time,
me_name,
me_kana,
me_mail,
get_codemaster(me_executive,'13') AS me_executive, -- 役職
get_codemaster(me_occupation,'12') AS me_occupation, -- 職種
me_zip1||'-'||me_zip2 AS me_zip,
get_codemaster(me_prefecture,'8') AS me_prefecture, -- 都道府県
me_address,
me_building_name,
me_tel1||'-'||me_tel2||'-'||me_tel3 AS me_tel,
me_fax1||'-'||me_fax2||'-'||me_fax3 AS me_fax,
me_birth_year||'-'||me_birth_month||'-'||me_birth_day AS me_birth, -- 誕生日
co_uniqnum,
co_name,
co_kana,
co_zip1||'-'||co_zip2 AS co_zip,
get_codemaster(co_prefecture,'8') AS co_prefecture, -- 都道府県
co_address,
co_building_name,
co_tel1||'-'||co_tel2||'-'||co_tel3 AS co_tel,
co_fax1||'-'||co_fax2||'-'||co_fax3 AS co_fax,
co_est_year||'-'||co_est_month  AS co_est, -- 設立
get_industry(co_large_category) AS co_large_category, -- 業種
get_industry(co_medium_category) AS co_medium_category , -- 業種
get_industry(co_small_category) AS co_small_category, -- 業種
get_industry(co_industry_category) AS co_industry_category , -- 業種
co_rep_name, -- 代表者
co_rep_kana,
get_codemaster(co_employee,'10') AS co_employee, -- 社員数
get_codemaster(co_capital,'14') AS co_capital, -- 資本金
get_codemaster(co_turnover,'11') AS co_turnover, -- 年商
get_codemaster(co_corporation,'9') AS co_corporation -- 法人形態
FROM
 me
INNER JOIN co
	ON me_co_uniqnum = co_uniqnum
WHERE
 me_withdraw_flag = 1 AND
 me_admail_flag = 1 AND
 me_uniqnum IN(
 SELECT
  mpa_me_uniqnum
 FROM
  mall_product_apply
 WHERE
  mpa_mc_uniqnum IN( 31,41)
 GROUP BY
  mpa_me_uniqnum
 )
LIMIT 50
ローン申込者リスト.txt · 最終更新: 2010/07/27 15:46 (外部編集)
www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0

Strict Standards: Only variables should be passed by reference in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/doku.php on line 81