Taebu / prq

prq.co.kr
MIT License
1 stars 0 forks source link

소비자 콜로그 DB 추출 요청 #55

Closed moonsungjun closed 8 years ago

moonsungjun commented 8 years ago

대리점 코드 DS0001PT0012

위 코드 소비자 콜로그 DB 엑셀파일로 추출 요청

Taebu commented 8 years ago
select mb_email from prq_member where prq_fcode like 'DS0001PT0012%';

05074550072@naver.com
028563300@naver.com
028560133@naver.com
0226898958@naver.com
0226895919@naver.com
0226888888@naver.com
0226888292@naver.com
0226873388@naver.com
0226855673@naver.com
0226851082@naver.com
0226848992@naver.com
0226839922@naver.com
0226821482@naver.com
0226818883@naver.com
0226815592@naver.com
0226810623@naver.com
0226764833@naver.com
0226755569@naver.com
0226254457@naver.com
0226186789@naver.com
0226178295@naver.com
0226168292@naver.com
0226165011@naver.com
0226164900@naver.com
0226163344@naver.com
0226159208@naver.com
0226156912@naver.com
0226152003@naver.com
0226134330@naver.com
0226134330@naver.com
0226133734@naver.com
0226127666@naver.com
0226122777@naver.com
0226118958@naver.com
0226116002@naver.com
0226115982@naver.com
0226114002@naver.com
0226112866@naver.com
0220667732@naver.com
0220664146@naver.com
0220663939@naver.com
0220662599@naver.com
0220609230@naver.com
0220606855@naver.com
0220603377@naver.com
015778080@naver.com

select cd_callerid from prq_cdr where cd_id in (select mb_email from prq_member where prq_fcode like 'DS0001PT0012%');

20160827_ata_2369.xlsx

Taebu commented 8 years ago
/**
* url : http://cashq.co.kr/test/bdmt_ata.php
*/
/* bdmt_ata.php 2016-08-27 (토) 2369건 */
include_once './data/20160827.php';