array(4) {
  ["code"]=>
  int(936)
  ["message"]=>
  string(35) "ORA-00936: 式がありません。"
  ["offset"]=>
  int(848)
  ["sqltext"]=>
  string(3096) "SELECT COUNT(C_MEMBER_ID) cnt FROM (SELECT MT.C_MEMBER_ID FROM ( SELECT M.C_MEMBER_ID, M.GIRLS_NAME, M.GIRLS_KANA, M.GIRLS_YEARS, M.GIRLS_HEIGHT, M.GIRLS_BUST, M.GIRLS_CUP, M.GIRLS_WAIST, M.GIRLS_HIP, M.GIRLS_CATCH, M.GIRLS_RECOMMEND_ORDER, M.GIRLS_ONEPOINT_FLG, M.GIRLS_ENTERING_DATE, M.girl_message_setting_kbn, M.AREA_ID, M.GIRLS_LOOKS_ID, M.UPDATE_DATE, M.SORT_UPDATE_DATE, M.GIRLS_MOVIE_FILENAME GIRLS_MOVIE_FILENAME, D.EXIST_DIARY, C.NAME, NVL(C.OPTION_AMT, 0) OPTION_AMT, C.SHOP_DIRECTRY_NAME, BLT.BUSSINES_DISP_NAME, SA.SMALL_AREA_SHOWN, GW.GIRLS_ID GIRLS_WORK, CASE C.SHOP_LANK   WHEN '01' THEN 1   WHEN '02' THEN 2   WHEN '03' THEN 2   WHEN '04' THEN 2   WHEN '05' THEN 3 ELSE 9 END AS RANK_ORDER FROM C_MEMBER M INNER JOIN C_COMMU C ON C.LOGICAL_DEL_FLG = 0 AND C.KEISAI_STATE = '01' AND M.C_COMMU_ID = C.C_COMMU_ID AND C.DISTRICT_ID =  AND C.BUSSINES_TYPE_ID LIKE '240002%' INNER JOIN MT_BUSSINES_TYPE BT ON BT.LOGICAL_DEL_FLG = 0 AND C.BUSSINES_TYPE_ID = BT.BUSSINES_TYPE_ID INNER JOIN MT_BUSSINES_LARGE_TYPE BLT ON BLT.LOGICAL_DEL_FLG = 0 AND BT.DISTRICT_ID = BLT.DISTRICT_ID AND BT.BUSSINES_TYPE_LARGE_ID = BLT.BUSSINES_TYPE_LARGE_ID AND BLT.DISTRICT_ID =  INNER JOIN MT_AREA A ON A.LOGICAL_DEL_FLG = 0 AND A.DISPLAY_EXIST = '01' AND C.AREA_ID = A.AREA_ID INNER JOIN MT_LARGE_AREA LA ON LA.LOGICAL_DEL_FLG = 0 AND LA.DISPLAY_EXIST = '01' AND A.DISTRICT_ID = LA.DISTRICT_ID AND A.PREF_ID = LA.PREF_ID AND A.LARGE_AREA_ID = LA.LARGE_AREA_ID AND LA.DISTRICT_ID =  INNER JOIN MT_MIDDLE_AREA MA ON MA.LOGICAL_DEL_FLG = 0 AND MA.DISPLAY_EXIST = '01' AND A.PREF_ID = MA.PREF_ID AND A.LARGE_AREA_ID = MA.LARGE_AREA_ID AND A.MIDDLE_AREA_ID = MA.MIDDLE_AREA_ID INNER JOIN MT_SMALL_AREA SA ON SA.LOGICAL_DEL_FLG = 0 AND A.PREF_ID = SA.PREF_ID AND A.LARGE_AREA_ID = SA.LARGE_AREA_ID AND A.MIDDLE_AREA_ID = SA.MIDDLE_AREA_ID AND A.SMALL_AREA_ID = SA.SMALL_AREA_ID INNER JOIN TR_GIRLS_WORKING GW ON GW.LOGICAL_DEL_FLG = 0 AND M.C_MEMBER_ID =  GW.GIRLS_ID AND TRUNC(GW.BASE_DAY) = TRUNC(to_date('2025/07/14', 'yyyy/mm/dd')) AND ( CASE WHEN GW.END_TIME <= '060000' THEN TO_NUMBER(GW.END_TIME) + 240000 ELSE TO_NUMBER(GW.END_TIME) END ) >= ( CASE WHEN TO_CHAR(SYSDATE,'hh24miss') < '060000' THEN TO_NUMBER(TO_CHAR(SYSDATE,'hh24miss') + 240000) ELSE TO_NUMBER(TO_CHAR(SYSDATE,'hh24miss')) END) LEFT JOIN (SELECT AC.GIRLS_ID EXIST_DIARY FROM TR_DIARY_ARCHIVES AC INNER JOIN C_COMMU C ON C.LOGICAL_DEL_FLG = 0 AND AC.C_COMMU_ID = C.C_COMMU_ID AND C.DISTRICT_ID =  AND C.DISTRICT_ID = '' GROUP BY AC.GIRLS_ID ) D ON D.EXIST_DIARY = M.C_MEMBER_ID WHERE M.LOGICAL_DEL_FLG = 0 AND M.MEMBER_ATTRIBUTE = '02' AND M.AREA_ID IS NOT NULL AND M.GIRLS_DISP_FLG IN ('01', '02') AND (M.GIRLS_CUP IN(06,07,08,09) OR M.GIRLS_CUP >= '09') AND M.AREA_ID LIKE '%' ORDER BY RANK_ORDER, OPTION_AMT DESC, M.UPDATE_DATE DESC ) MT) MAST LEFT JOIN (SELECT GIRLS_ID, MIN(PIC_DTL_NO) PIC_DTL_NO FROM TR_GIRLS_PHOTO WHERE LOGICAL_DEL_FLG = 0 AND PIC_OPEN_FLG IN('01','02') GROUP BY GIRLS_ID ) GP ON GP.GIRLS_ID = MAST.C_MEMBER_ID LEFT JOIN TR_GIRLS_PHOTO GP2 ON GP2.GIRLS_ID = MAST.C_MEMBER_ID AND GP2.PIC_DTL_NO = GP.PIC_DTL_NO"
}
array(2) {
  [1]=>
  array(7) {
    ["file"]=>
    string(52) "/var/NightsFunApp/libs/app/dao/CHMTGirlSearchDao.php"
    ["line"]=>
    int(837)
    ["function"]=>
    string(15) "queryEntityList"
    ["class"]=>
    string(9) "CHBaseDao"
    ["object"]=>
    object(CHMTGirlSearchDao)#1 (8) {
      ["conn:protected"]=>
      resource(4) of type (oci8 connection)
      ["self_connected:private"]=>
      NULL
      ["transaction_mode:private"]=>
      int(32)
      ["connectkey:private"]=>
      string(18) "nfuser-nfuser-scdb"
      ["db_mode"]=>
      string(7) "default"
      ["connect_sid"]=>
      string(4) "scdb"
      ["default_prefetch:protected"]=>
      int(100)
      ["_lastSql"]=>
      string(3096) "SELECT COUNT(C_MEMBER_ID) cnt FROM (SELECT MT.C_MEMBER_ID FROM ( SELECT M.C_MEMBER_ID, M.GIRLS_NAME, M.GIRLS_KANA, M.GIRLS_YEARS, M.GIRLS_HEIGHT, M.GIRLS_BUST, M.GIRLS_CUP, M.GIRLS_WAIST, M.GIRLS_HIP, M.GIRLS_CATCH, M.GIRLS_RECOMMEND_ORDER, M.GIRLS_ONEPOINT_FLG, M.GIRLS_ENTERING_DATE, M.girl_message_setting_kbn, M.AREA_ID, M.GIRLS_LOOKS_ID, M.UPDATE_DATE, M.SORT_UPDATE_DATE, M.GIRLS_MOVIE_FILENAME GIRLS_MOVIE_FILENAME, D.EXIST_DIARY, C.NAME, NVL(C.OPTION_AMT, 0) OPTION_AMT, C.SHOP_DIRECTRY_NAME, BLT.BUSSINES_DISP_NAME, SA.SMALL_AREA_SHOWN, GW.GIRLS_ID GIRLS_WORK, CASE C.SHOP_LANK   WHEN '01' THEN 1   WHEN '02' THEN 2   WHEN '03' THEN 2   WHEN '04' THEN 2   WHEN '05' THEN 3 ELSE 9 END AS RANK_ORDER FROM C_MEMBER M INNER JOIN C_COMMU C ON C.LOGICAL_DEL_FLG = 0 AND C.KEISAI_STATE = '01' AND M.C_COMMU_ID = C.C_COMMU_ID AND C.DISTRICT_ID =  AND C.BUSSINES_TYPE_ID LIKE '240002%' INNER JOIN MT_BUSSINES_TYPE BT ON BT.LOGICAL_DEL_FLG = 0 AND C.BUSSINES_TYPE_ID = BT.BUSSINES_TYPE_ID INNER JOIN MT_BUSSINES_LARGE_TYPE BLT ON BLT.LOGICAL_DEL_FLG = 0 AND BT.DISTRICT_ID = BLT.DISTRICT_ID AND BT.BUSSINES_TYPE_LARGE_ID = BLT.BUSSINES_TYPE_LARGE_ID AND BLT.DISTRICT_ID =  INNER JOIN MT_AREA A ON A.LOGICAL_DEL_FLG = 0 AND A.DISPLAY_EXIST = '01' AND C.AREA_ID = A.AREA_ID INNER JOIN MT_LARGE_AREA LA ON LA.LOGICAL_DEL_FLG = 0 AND LA.DISPLAY_EXIST = '01' AND A.DISTRICT_ID = LA.DISTRICT_ID AND A.PREF_ID = LA.PREF_ID AND A.LARGE_AREA_ID = LA.LARGE_AREA_ID AND LA.DISTRICT_ID =  INNER JOIN MT_MIDDLE_AREA MA ON MA.LOGICAL_DEL_FLG = 0 AND MA.DISPLAY_EXIST = '01' AND A.PREF_ID = MA.PREF_ID AND A.LARGE_AREA_ID = MA.LARGE_AREA_ID AND A.MIDDLE_AREA_ID = MA.MIDDLE_AREA_ID INNER JOIN MT_SMALL_AREA SA ON SA.LOGICAL_DEL_FLG = 0 AND A.PREF_ID = SA.PREF_ID AND A.LARGE_AREA_ID = SA.LARGE_AREA_ID AND A.MIDDLE_AREA_ID = SA.MIDDLE_AREA_ID AND A.SMALL_AREA_ID = SA.SMALL_AREA_ID INNER JOIN TR_GIRLS_WORKING GW ON GW.LOGICAL_DEL_FLG = 0 AND M.C_MEMBER_ID =  GW.GIRLS_ID AND TRUNC(GW.BASE_DAY) = TRUNC(to_date('2025/07/14', 'yyyy/mm/dd')) AND ( CASE WHEN GW.END_TIME <= '060000' THEN TO_NUMBER(GW.END_TIME) + 240000 ELSE TO_NUMBER(GW.END_TIME) END ) >= ( CASE WHEN TO_CHAR(SYSDATE,'hh24miss') < '060000' THEN TO_NUMBER(TO_CHAR(SYSDATE,'hh24miss') + 240000) ELSE TO_NUMBER(TO_CHAR(SYSDATE,'hh24miss')) END) LEFT JOIN (SELECT AC.GIRLS_ID EXIST_DIARY FROM TR_DIARY_ARCHIVES AC INNER JOIN C_COMMU C ON C.LOGICAL_DEL_FLG = 0 AND AC.C_COMMU_ID = C.C_COMMU_ID AND C.DISTRICT_ID =  AND C.DISTRICT_ID = '' GROUP BY AC.GIRLS_ID ) D ON D.EXIST_DIARY = M.C_MEMBER_ID WHERE M.LOGICAL_DEL_FLG = 0 AND M.MEMBER_ATTRIBUTE = '02' AND M.AREA_ID IS NOT NULL AND M.GIRLS_DISP_FLG IN ('01', '02') AND (M.GIRLS_CUP IN(06,07,08,09) OR M.GIRLS_CUP >= '09') AND M.AREA_ID LIKE '%' ORDER BY RANK_ORDER, OPTION_AMT DESC, M.UPDATE_DATE DESC ) MT) MAST LEFT JOIN (SELECT GIRLS_ID, MIN(PIC_DTL_NO) PIC_DTL_NO FROM TR_GIRLS_PHOTO WHERE LOGICAL_DEL_FLG = 0 AND PIC_OPEN_FLG IN('01','02') GROUP BY GIRLS_ID ) GP ON GP.GIRLS_ID = MAST.C_MEMBER_ID LEFT JOIN TR_GIRLS_PHOTO GP2 ON GP2.GIRLS_ID = MAST.C_MEMBER_ID AND GP2.PIC_DTL_NO = GP.PIC_DTL_NO"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(3096) "SELECT COUNT(C_MEMBER_ID) cnt FROM (SELECT MT.C_MEMBER_ID FROM ( SELECT M.C_MEMBER_ID, M.GIRLS_NAME, M.GIRLS_KANA, M.GIRLS_YEARS, M.GIRLS_HEIGHT, M.GIRLS_BUST, M.GIRLS_CUP, M.GIRLS_WAIST, M.GIRLS_HIP, M.GIRLS_CATCH, M.GIRLS_RECOMMEND_ORDER, M.GIRLS_ONEPOINT_FLG, M.GIRLS_ENTERING_DATE, M.girl_message_setting_kbn, M.AREA_ID, M.GIRLS_LOOKS_ID, M.UPDATE_DATE, M.SORT_UPDATE_DATE, M.GIRLS_MOVIE_FILENAME GIRLS_MOVIE_FILENAME, D.EXIST_DIARY, C.NAME, NVL(C.OPTION_AMT, 0) OPTION_AMT, C.SHOP_DIRECTRY_NAME, BLT.BUSSINES_DISP_NAME, SA.SMALL_AREA_SHOWN, GW.GIRLS_ID GIRLS_WORK, CASE C.SHOP_LANK   WHEN '01' THEN 1   WHEN '02' THEN 2   WHEN '03' THEN 2   WHEN '04' THEN 2   WHEN '05' THEN 3 ELSE 9 END AS RANK_ORDER FROM C_MEMBER M INNER JOIN C_COMMU C ON C.LOGICAL_DEL_FLG = 0 AND C.KEISAI_STATE = '01' AND M.C_COMMU_ID = C.C_COMMU_ID AND C.DISTRICT_ID =  AND C.BUSSINES_TYPE_ID LIKE '240002%' INNER JOIN MT_BUSSINES_TYPE BT ON BT.LOGICAL_DEL_FLG = 0 AND C.BUSSINES_TYPE_ID = BT.BUSSINES_TYPE_ID INNER JOIN MT_BUSSINES_LARGE_TYPE BLT ON BLT.LOGICAL_DEL_FLG = 0 AND BT.DISTRICT_ID = BLT.DISTRICT_ID AND BT.BUSSINES_TYPE_LARGE_ID = BLT.BUSSINES_TYPE_LARGE_ID AND BLT.DISTRICT_ID =  INNER JOIN MT_AREA A ON A.LOGICAL_DEL_FLG = 0 AND A.DISPLAY_EXIST = '01' AND C.AREA_ID = A.AREA_ID INNER JOIN MT_LARGE_AREA LA ON LA.LOGICAL_DEL_FLG = 0 AND LA.DISPLAY_EXIST = '01' AND A.DISTRICT_ID = LA.DISTRICT_ID AND A.PREF_ID = LA.PREF_ID AND A.LARGE_AREA_ID = LA.LARGE_AREA_ID AND LA.DISTRICT_ID =  INNER JOIN MT_MIDDLE_AREA MA ON MA.LOGICAL_DEL_FLG = 0 AND MA.DISPLAY_EXIST = '01' AND A.PREF_ID = MA.PREF_ID AND A.LARGE_AREA_ID = MA.LARGE_AREA_ID AND A.MIDDLE_AREA_ID = MA.MIDDLE_AREA_ID INNER JOIN MT_SMALL_AREA SA ON SA.LOGICAL_DEL_FLG = 0 AND A.PREF_ID = SA.PREF_ID AND A.LARGE_AREA_ID = SA.LARGE_AREA_ID AND A.MIDDLE_AREA_ID = SA.MIDDLE_AREA_ID AND A.SMALL_AREA_ID = SA.SMALL_AREA_ID INNER JOIN TR_GIRLS_WORKING GW ON GW.LOGICAL_DEL_FLG = 0 AND M.C_MEMBER_ID =  GW.GIRLS_ID AND TRUNC(GW.BASE_DAY) = TRUNC(to_date('2025/07/14', 'yyyy/mm/dd')) AND ( CASE WHEN GW.END_TIME <= '060000' THEN TO_NUMBER(GW.END_TIME) + 240000 ELSE TO_NUMBER(GW.END_TIME) END ) >= ( CASE WHEN TO_CHAR(SYSDATE,'hh24miss') < '060000' THEN TO_NUMBER(TO_CHAR(SYSDATE,'hh24miss') + 240000) ELSE TO_NUMBER(TO_CHAR(SYSDATE,'hh24miss')) END) LEFT JOIN (SELECT AC.GIRLS_ID EXIST_DIARY FROM TR_DIARY_ARCHIVES AC INNER JOIN C_COMMU C ON C.LOGICAL_DEL_FLG = 0 AND AC.C_COMMU_ID = C.C_COMMU_ID AND C.DISTRICT_ID =  AND C.DISTRICT_ID = '' GROUP BY AC.GIRLS_ID ) D ON D.EXIST_DIARY = M.C_MEMBER_ID WHERE M.LOGICAL_DEL_FLG = 0 AND M.MEMBER_ATTRIBUTE = '02' AND M.AREA_ID IS NOT NULL AND M.GIRLS_DISP_FLG IN ('01', '02') AND (M.GIRLS_CUP IN(06,07,08,09) OR M.GIRLS_CUP >= '09') AND M.AREA_ID LIKE '%' ORDER BY RANK_ORDER, OPTION_AMT DESC, M.UPDATE_DATE DESC ) MT) MAST LEFT JOIN (SELECT GIRLS_ID, MIN(PIC_DTL_NO) PIC_DTL_NO FROM TR_GIRLS_PHOTO WHERE LOGICAL_DEL_FLG = 0 AND PIC_OPEN_FLG IN('01','02') GROUP BY GIRLS_ID ) GP ON GP.GIRLS_ID = MAST.C_MEMBER_ID LEFT JOIN TR_GIRLS_PHOTO GP2 ON GP2.GIRLS_ID = MAST.C_MEMBER_ID AND GP2.PIC_DTL_NO = GP.PIC_DTL_NO"
    }
  }
  [2]=>
  array(7) {
    ["file"]=>
    string(58) "/var/NightsFunApp/libs/app/action/CHA3GirlSearchAction.php"
    ["line"]=>
    int(139)
    ["function"]=>
    string(19) "findGirlByCondition"
    ["class"]=>
    string(17) "CHMTGirlSearchDao"
    ["object"]=>
    object(CHMTGirlSearchDao)#1 (8) {
      ["conn:protected"]=>
      resource(4) of type (oci8 connection)
      ["self_connected:private"]=>
      NULL
      ["transaction_mode:private"]=>
      int(32)
      ["connectkey:private"]=>
      string(18) "nfuser-nfuser-scdb"
      ["db_mode"]=>
      string(7) "default"
      ["connect_sid"]=>
      string(4) "scdb"
      ["default_prefetch:protected"]=>
      int(100)
      ["_lastSql"]=>
      string(3096) "SELECT COUNT(C_MEMBER_ID) cnt FROM (SELECT MT.C_MEMBER_ID FROM ( SELECT M.C_MEMBER_ID, M.GIRLS_NAME, M.GIRLS_KANA, M.GIRLS_YEARS, M.GIRLS_HEIGHT, M.GIRLS_BUST, M.GIRLS_CUP, M.GIRLS_WAIST, M.GIRLS_HIP, M.GIRLS_CATCH, M.GIRLS_RECOMMEND_ORDER, M.GIRLS_ONEPOINT_FLG, M.GIRLS_ENTERING_DATE, M.girl_message_setting_kbn, M.AREA_ID, M.GIRLS_LOOKS_ID, M.UPDATE_DATE, M.SORT_UPDATE_DATE, M.GIRLS_MOVIE_FILENAME GIRLS_MOVIE_FILENAME, D.EXIST_DIARY, C.NAME, NVL(C.OPTION_AMT, 0) OPTION_AMT, C.SHOP_DIRECTRY_NAME, BLT.BUSSINES_DISP_NAME, SA.SMALL_AREA_SHOWN, GW.GIRLS_ID GIRLS_WORK, CASE C.SHOP_LANK   WHEN '01' THEN 1   WHEN '02' THEN 2   WHEN '03' THEN 2   WHEN '04' THEN 2   WHEN '05' THEN 3 ELSE 9 END AS RANK_ORDER FROM C_MEMBER M INNER JOIN C_COMMU C ON C.LOGICAL_DEL_FLG = 0 AND C.KEISAI_STATE = '01' AND M.C_COMMU_ID = C.C_COMMU_ID AND C.DISTRICT_ID =  AND C.BUSSINES_TYPE_ID LIKE '240002%' INNER JOIN MT_BUSSINES_TYPE BT ON BT.LOGICAL_DEL_FLG = 0 AND C.BUSSINES_TYPE_ID = BT.BUSSINES_TYPE_ID INNER JOIN MT_BUSSINES_LARGE_TYPE BLT ON BLT.LOGICAL_DEL_FLG = 0 AND BT.DISTRICT_ID = BLT.DISTRICT_ID AND BT.BUSSINES_TYPE_LARGE_ID = BLT.BUSSINES_TYPE_LARGE_ID AND BLT.DISTRICT_ID =  INNER JOIN MT_AREA A ON A.LOGICAL_DEL_FLG = 0 AND A.DISPLAY_EXIST = '01' AND C.AREA_ID = A.AREA_ID INNER JOIN MT_LARGE_AREA LA ON LA.LOGICAL_DEL_FLG = 0 AND LA.DISPLAY_EXIST = '01' AND A.DISTRICT_ID = LA.DISTRICT_ID AND A.PREF_ID = LA.PREF_ID AND A.LARGE_AREA_ID = LA.LARGE_AREA_ID AND LA.DISTRICT_ID =  INNER JOIN MT_MIDDLE_AREA MA ON MA.LOGICAL_DEL_FLG = 0 AND MA.DISPLAY_EXIST = '01' AND A.PREF_ID = MA.PREF_ID AND A.LARGE_AREA_ID = MA.LARGE_AREA_ID AND A.MIDDLE_AREA_ID = MA.MIDDLE_AREA_ID INNER JOIN MT_SMALL_AREA SA ON SA.LOGICAL_DEL_FLG = 0 AND A.PREF_ID = SA.PREF_ID AND A.LARGE_AREA_ID = SA.LARGE_AREA_ID AND A.MIDDLE_AREA_ID = SA.MIDDLE_AREA_ID AND A.SMALL_AREA_ID = SA.SMALL_AREA_ID INNER JOIN TR_GIRLS_WORKING GW ON GW.LOGICAL_DEL_FLG = 0 AND M.C_MEMBER_ID =  GW.GIRLS_ID AND TRUNC(GW.BASE_DAY) = TRUNC(to_date('2025/07/14', 'yyyy/mm/dd')) AND ( CASE WHEN GW.END_TIME <= '060000' THEN TO_NUMBER(GW.END_TIME) + 240000 ELSE TO_NUMBER(GW.END_TIME) END ) >= ( CASE WHEN TO_CHAR(SYSDATE,'hh24miss') < '060000' THEN TO_NUMBER(TO_CHAR(SYSDATE,'hh24miss') + 240000) ELSE TO_NUMBER(TO_CHAR(SYSDATE,'hh24miss')) END) LEFT JOIN (SELECT AC.GIRLS_ID EXIST_DIARY FROM TR_DIARY_ARCHIVES AC INNER JOIN C_COMMU C ON C.LOGICAL_DEL_FLG = 0 AND AC.C_COMMU_ID = C.C_COMMU_ID AND C.DISTRICT_ID =  AND C.DISTRICT_ID = '' GROUP BY AC.GIRLS_ID ) D ON D.EXIST_DIARY = M.C_MEMBER_ID WHERE M.LOGICAL_DEL_FLG = 0 AND M.MEMBER_ATTRIBUTE = '02' AND M.AREA_ID IS NOT NULL AND M.GIRLS_DISP_FLG IN ('01', '02') AND (M.GIRLS_CUP IN(06,07,08,09) OR M.GIRLS_CUP >= '09') AND M.AREA_ID LIKE '%' ORDER BY RANK_ORDER, OPTION_AMT DESC, M.UPDATE_DATE DESC ) MT) MAST LEFT JOIN (SELECT GIRLS_ID, MIN(PIC_DTL_NO) PIC_DTL_NO FROM TR_GIRLS_PHOTO WHERE LOGICAL_DEL_FLG = 0 AND PIC_OPEN_FLG IN('01','02') GROUP BY GIRLS_ID ) GP ON GP.GIRLS_ID = MAST.C_MEMBER_ID LEFT JOIN TR_GIRLS_PHOTO GP2 ON GP2.GIRLS_ID = MAST.C_MEMBER_ID AND GP2.PIC_DTL_NO = GP.PIC_DTL_NO"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(6) {
      [0]=>
      &array(3) {
        ["bt"]=>
        string(6) "240002"
        ["cup"]=>
        array(4) {
          [0]=>
          string(2) "06"
          [1]=>
          string(2) "07"
          [2]=>
          string(2) "08"
          [3]=>
          string(2) "09"
        }
        ["hsk"]=>
        string(1) "y"
      }
      [1]=>
      &NULL
      [2]=>
      &NULL
      [3]=>
      &NULL
      [4]=>
      &int(30)
      [5]=>
      &bool(false)
    }
  }
}