| 3번째 줄: | 3번째 줄: | ||
|from=ITEM_SHOP | |from=ITEM_SHOP | ||
|where='misl_s03_ir_vncl_chaos'=ITEM_SHOP_CLASS | |where='misl_s03_ir_vncl_chaos'=ITEM_SHOP_CLASS | ||
| − | |data= | + | |data=ITEM_SHOP_CLASS=ITEM_SHOP_CLASS,ITEM_SHOP_TYPE=ITEM_SHOP_TYPE,ITEM_SHOP_AREA18_SHOP_NAME=ITEM_SHOP_AREA18_SHOP_NAME, |
| + | ITEM_SHOP_AREA18_SHOP_CLASS=ITEM_SHOP_AREA18_SHOP_CLASS,ITEM_SHOP_AREA18_PRICE=ITEM_SHOP_AREA18_PRICE,ITEM_SHOP_BAIJINI_SHOP_NAME=ITEM_SHOP_BAIJINI_SHOP_NAME,ITEM_SHOP_BAIJINI_SHOP_CLASS=ITEM_SHOP_BAIJINI_SHOP_CLASS,ITEM_SHOP_BAIJINI_SHOP_PRICE=ITEM_SHOP_BAIJINI_SHOP_PRICE,ITEM_SHOP_ARC_L1_SHOP_NAME=ITEM_SHOP_ARC_L1_SHOP_NAME,ITEM_SHOP_ARC_L1_SHOP_CLASS=ITEM_SHOP_ARC_L1_SHOP_CLASS,ITEM_SHOP_ARC_L1_SHOP_PRICE=ITEM_SHOP_ARC_L1_SHOP_PRICE,ITEM_SHOP_ARC_L2_SHOP_NAME=ITEM_SHOP_ARC_L2_SHOP_NAME,ITEM_SHOP_ARC_L2_SHOP_CLASS=ITEM_SHOP_ARC_L2_SHOP_CLASS,ITEM_SHOP_ARC_L2_SHOP_PRICE=ITEM_SHOP_ARC_L2_SHOP_PRICE,ITEM_SHOP_ARC_L3_SHOP_NAME=ITEM_SHOP_ARC_L3_SHOP_NAME,ITEM_SHOP_ARC_L3_SHOP_CLASS=ITEM_SHOP_ARC_L3_SHOP_CLASS,ITEM_SHOP_ARC_L3_SHOP_PRICE=ITEM_SHOP_ARC_L3_SHOP_PRICE,ITEM_SHOP_ARC_L4_SHOP_NAME=ITEM_SHOP_ARC_L4_SHOP_NAME,ITEM_SHOP_ARC_L4_SHOP_CLASS=ITEM_SHOP_ARC_L4_SHOP_CLASS,ITEM_SHOP_ARC_L4_SHOP_PRICE=ITEM_SHOP_ARC_L4_SHOP_PRICE,ITEM_SHOP_ARC_L5_SHOP_NAME=ITEM_SHOP_ARC_L5_SHOP_NAME,ITEM_SHOP_ARC_L5_SHOP_CLASS=ITEM_SHOP_ARC_L5_SHOP_CLASS,ITEM_SHOP_ARC_L5_SHOP_PRICE=ITEM_SHOP_ARC_L5_SHOP_PRICE,ITEM_SHOP_LORVILLE_NAME=ITEM_SHOP_LORVILLE_NAME,ITEM_SHOP_LORVILLE_CLASS=ITEM_SHOP_LORVILLE_CLASS,ITEM_SHOP_LORVILLE_PRICE=ITEM_SHOP_LORVILLE_PRICE,ITEM_SHOP_EVERUS_NAME=ITEM_SHOP_EVERUS_NAME,ITEM_SHOP_EVERUS_CLASS=ITEM_SHOP_EVERUS_CLASS,ITEM_SHOP_EVERUS_PRICE=ITEM_SHOP_EVERUS_PRICE,ITEM_SHOP_HUR_L1_NAME=ITEM_SHOP_HUR_L1_NAME,ITEM_SHOP_HUR_L1_CLASS=ITEM_SHOP_HUR_L1_CLASS,ITEM_SHOP_HUR_L1_PRICE=ITEM_SHOP_HUR_L1_PRICE,ITEM_SHOP_HUR_L2_NAME=ITEM_SHOP_HUR_L2_NAME,ITEM_SHOP_HUR_L2_CLASS=ITEM_SHOP_HUR_L2_CLASS,ITEM_SHOP_HUR_L2_PRICE=ITEM_SHOP_HUR_L2_PRICE,ITEM_SHOP_HUR_L3_NAME=ITEM_SHOP_HUR_L3_NAME,ITEM_SHOP_HUR_L3_CLASS=ITEM_SHOP_HUR_L3_CLASS,ITEM_SHOP_HUR_L3_PRICE=ITEM_SHOP_HUR_L3_PRICE,ITEM_SHOP_HUR_L4_NAME=ITEM_SHOP_HUR_L4_NAME,ITEM_SHOP_HUR_L4_CLASS=ITEM_SHOP_HUR_L4_CLASS,ITEM_SHOP_HUR_L4_PRICE=ITEM_SHOP_HUR_L4_PRICE,ITEM_SHOP_HUR_L5_NAME=ITEM_SHOP_HUR_L5_NAME,ITEM_SHOP_HUR_L5_CLASS=ITEM_SHOP_HUR_L5_CLASS,ITEM_SHOP_HUR_L5_PRICE=ITEM_SHOP_HUR_L5_PRICE,ITEM_SHOP_NEW_BABBAGE_NAME=ITEM_SHOP_NEW_BABBAGE_NAME,ITEM_SHOP_NEW_BABBAGE_CLASS=ITEM_SHOP_NEW_BABBAGE_CLASS,ITEM_SHOP_NEW_BABBAGE_PRICE=ITEM_SHOP_NEW_BABBAGE_PRICE,ITEM_SHOP_TRESSLER_NAME=ITEM_SHOP_TRESSLER_NAME,ITEM_SHOP_TRESSLER_CLASS=ITEM_SHOP_TRESSLER_CLASS,ITEM_SHOP_TRESSLER_PRICE=ITEM_SHOP_TRESSLER_PRICE,ITEM_SHOP_MIC_L1_NAME=ITEM_SHOP_MIC_L1_NAME,ITEM_SHOP_MIC_L1_CLASS=ITEM_SHOP_MIC_L1_CLASS,ITEM_SHOP_MIC_L1_PRICE=ITEM_SHOP_MIC_L1_PRICE,ITEM_SHOP_MIC_L2_NAME=ITEM_SHOP_MIC_L2_NAME,ITEM_SHOP_MIC_L2_CLASS=ITEM_SHOP_MIC_L2_CLASS,ITEM_SHOP_MIC_L2_PRICE=ITEM_SHOP_MIC_L2_PRICE,ITEM_SHOP_MIC_L3_NAME=ITEM_SHOP_MIC_L3_NAME,ITEM_SHOP_MIC_L3_CLASS=ITEM_SHOP_MIC_L3_CLASS,ITEM_SHOP_MIC_L3_PRICE=ITEM_SHOP_MIC_L3_PRICE,ITEM_SHOP_MIC_L4_NAME=ITEM_SHOP_MIC_L4_NAME,ITEM_SHOP_MIC_L4_CLASS=ITEM_SHOP_MIC_L4_CLASS,ITEM_SHOP_MIC_L4_PRICE=ITEM_SHOP_MIC_L4_PRICE,ITEM_SHOP_MIC_L5_NAME=ITEM_SHOP_MIC_L5_NAME,ITEM_SHOP_MIC_L5_CLASS=ITEM_SHOP_MIC_L5_CLASS,ITEM_SHOP_MIC_L5_PRICE=ITEM_SHOP_MIC_L5_PRICE,ITEM_SHOP_ORISON_NAME=ITEM_SHOP_ORISON_NAME,ITEM_SHOP_ORISON_CLASS=ITEM_SHOP_ORISON_CLASS,ITEM_SHOP_ORISON_PRICE=ITEM_SHOP_ORISON_PRICE,ITEM_SHOP_OLISAR_NAME=ITEM_SHOP_OLISAR_NAME,ITEM_SHOP_OLISAR_CLASS=ITEM_SHOP_OLISAR_CLASS,ITEM_SHOP_OLISAR_PRICE=ITEM_SHOP_OLISAR_PRICE,ITEM_SHOP_CRU_L1_NAME=ITEM_SHOP_CRU_L1_NAME,ITEM_SHOP_CRU_L1_CLASS=ITEM_SHOP_CRU_L1_CLASS,ITEM_SHOP_CRU_L1_PRICE=ITEM_SHOP_CRU_L1_PRICE,ITEM_SHOP_CRU_L2_NAME=ITEM_SHOP_CRU_L2_NAME,ITEM_SHOP_CRU_L2_CLASS=ITEM_SHOP_CRU_L2_CLASS,ITEM_SHOP_CRU_L2_PRICE=ITEM_SHOP_CRU_L2_PRICE,ITEM_SHOP_CRU_L3_NAME=ITEM_SHOP_CRU_L3_NAME,ITEM_SHOP_CRU_L3_CLASS=ITEM_SHOP_CRU_L3_CLASS,ITEM_SHOP_CRU_L3_PRICE=ITEM_SHOP_CRU_L3_PRICE,ITEM_SHOP_CRU_L4_NAME=ITEM_SHOP_CRU_L4_NAME,ITEM_SHOP_CRU_L4_CLASS=ITEM_SHOP_CRU_L4_CLASS,ITEM_SHOP_CRU_L4_PRICE=ITEM_SHOP_CRU_L4_PRICE,ITEM_SHOP_CRU_L5_NAME=ITEM_SHOP_CRU_L5_NAME,ITEM_SHOP_CRU_L5_CLASS=ITEM_SHOP_CRU_L5_CLASS,ITEM_SHOP_CRU_L5_PRICE=ITEM_SHOP_CRU_L5_PRICE}} | ||
}} | }} | ||
{{#ifeq:-|2|SAME|{{#external_value: ITEM_SHOP_AREA18_NAME}}}} | {{#ifeq:-|2|SAME|{{#external_value: ITEM_SHOP_AREA18_NAME}}}} | ||
2022년 8월 23일 (화) 13:30 판
SELECT item_shop_class,item_shop_type,item_shop_area18_shop_name,item_shop_area18_shop_class,item_shop_area18_price,item_shop_baijini_shop_name,item_shop_baijini_shop_class,item_shop_baijini_shop_price,item_shop_arc_l1_shop_name,item_shop_arc_l1_shop_class,item_shop_arc_l1_shop_price,item_shop_arc_l2_shop_name,item_shop_arc_l2_shop_class,item_shop_arc_l2_shop_price,item_shop_arc_l3_shop_name,item_shop_arc_l3_shop_class,item_shop_arc_l3_shop_price,item_shop_arc_l4_shop_name,item_shop_arc_l4_shop_class,item_shop_arc_l4_shop_price,item_shop_arc_l5_shop_name,item_shop_arc_l5_shop_class,item_shop_arc_l5_shop_price,item_shop_lorville_name,item_shop_lorville_class,item_shop_lorville_price,item_shop_everus_name,item_shop_everus_class,item_shop_everus_price,item_shop_hur_l1_name,item_shop_hur_l1_class,item_shop_hur_l1_price,item_shop_hur_l2_name,item_shop_hur_l2_class,item_shop_hur_l2_price,item_shop_hur_l3_name,item_shop_hur_l3_class,item_shop_hur_l3_price,item_shop_hur_l4_name,item_shop_hur_l4_class,item_shop_hur_l4_price,item_shop_hur_l5_name,item_shop_hur_l5_class,item_shop_hur_l5_price,item_shop_new_babbage_name,item_shop_new_babbage_class,item_shop_new_babbage_price,item_shop_tressler_name,item_shop_tressler_class,item_shop_tressler_price,item_shop_mic_l1_name,item_shop_mic_l1_class,item_shop_mic_l1_price,item_shop_mic_l2_name,item_shop_mic_l2_class,item_shop_mic_l2_price,item_shop_mic_l3_name,item_shop_mic_l3_class,item_shop_mic_l3_price,item_shop_mic_l4_name,item_shop_mic_l4_class,item_shop_mic_l4_price,item_shop_mic_l5_name,item_shop_mic_l5_class,item_shop_mic_l5_price,item_shop_orison_name,item_shop_orison_class,item_shop_orison_price,item_shop_olisar_name,item_shop_olisar_class,item_shop_olisar_price,item_shop_cru_l1_name,item_shop_cru_l1_class,item_shop_cru_l1_price,item_shop_cru_l2_name,item_shop_cru_l2_class,item_shop_cru_l2_price,item_shop_cru_l3_name,item_shop_cru_l3_class,item_shop_cru_l3_price,item_shop_cru_l4_name,item_shop_cru_l4_class,item_shop_cru_l4_price,item_shop_cru_l5_name,item_shop_cru_l5_class,item_shop_cru_l5_price FROM `ITEM_SHOP` WHERE 'misl_s03_ir_vncl_chaos'=ITEM_SHOP_CLASS 쿼리는 유효하지 않습니다. (Error 1054: Unknown column 'item_shop_area18_shop_name' in 'field list' (127.0.0.1:3307) Function: EDConnectorRdbms::fetch Query: SELECT item_shop_class,item_shop_type,item_shop_area18_shop_name,item_shop_area18_shop_class,item_shop_area18_price,item_shop_baijini_shop_name,item_shop_baijini_shop_class,item_shop_baijini_shop_price,item_shop_arc_l1_shop_name,item_shop_arc_l1_shop_class,item_shop_arc_l1_shop_price,item_shop_arc_l2_shop_name,item_shop_arc_l2_shop_class,item_shop_arc_l2_shop_price,item_shop_arc_l3_shop_name,item_shop_arc_l3_shop_class,item_shop_arc_l3_shop_price,item_shop_arc_l4_shop_name,item_shop_arc_l4_shop_class,item_shop_arc_l4_shop_price,item_shop_arc_l5_shop_name,item_shop_arc_l5_shop_class,item_shop_arc_l5_shop_price,item_shop_lorville_name,item_shop_lorville_class,item_shop_lorville_price,item_shop_everus_name,item_shop_everus_class,item_shop_everus_price,item_shop_hur_l1_name,item_shop_hur_l1_class,item_shop_hur_l1_price,item_shop_hur_l2_name,item_shop_hur_l2_class,item_shop_hur_l2_price,item_shop_hur_l3_name,item_shop_hur_l3_class,item_shop_hur_l3_price,item_shop_hur_l4_name,item_shop_hur_l4_class,item_shop_hur_l4_price,item_shop_hur_l5_name,item_shop_hur_l5_class,item_shop_hur_l5_price,item_shop_new_babbage_name,item_shop_new_babbage_class,item_shop_new_babbage_price,item_shop_tressler_name,item_shop_tressler_class,item_shop_tressler_price,item_shop_mic_l1_name,item_shop_mic_l1_class,item_shop_mic_l1_price,item_shop_mic_l2_name,item_shop_mic_l2_class,item_shop_mic_l2_price,item_shop_mic_l3_name,item_shop_mic_l3_class,item_shop_mic_l3_price,item_shop_mic_l4_name,item_shop_mic_l4_class,item_shop_mic_l4_price,item_shop_mic_l5_name,item_shop_mic_l5_class,item_shop_mic_l5_price,item_shop_orison_name,item_shop_orison_class,item_shop_orison_price,item_shop_olisar_name,item_shop_olisar_class,item_shop_olisar_price,item_shop_cru_l1_name,item_shop_cru_l1_class,item_shop_cru_l1_price,item_shop_cru_l2_name,item_shop_cru_l2_class,item_shop_cru_l2_price,item_shop_cru_l3_name,item_shop_cru_l3_class,item_shop_cru_l3_price,item_shop_cru_l4_name,item_shop_cru_l4_class,item_shop_cru_l4_price,item_shop_cru_l5_name,item_shop_cru_l5_class,item_shop_cru_l5_price FROM `ITEM_SHOP` WHERE 'misl_s03_ir_vncl_chaos'=ITEM_SHOP_CLASS ) }}
오류: 지역 변수가 설정되어 있지 않습니다.