관광지테마검색

SELECT '1' AS goodsOrd, SELL_PROD_CD, TG_NO AS goodsNo, TG_NAME AS goodsName, TG_LIST_IMG AS goodsListImg, TG_MOBILE_IMG AS goodsListImg2, TG_ORD AS ord, TG_CATE AS category, TG_SIGNDATE AS regDate, TG_SELL AS sell , TG_RSV AS res, TG_GIFT AS gift, TG_AFP AS pospay, TG_KEYWORD AS keyword , (SELECT C_NO FROM FRONTDB.CP_CATEGORY_GOODS WHERE C_NO IN('126', '191', '192') AND GOODS_NO = FRONTDB.CP_TOUR_GOODS.TG_NO GROUP BY C_NO ORDER BY C_NO DESC limit 1) AS sCate , 'DAN' AS goodsType, CONCAT('DAN', TG_NO) AS pkey, 0 AS dis, 0 AS sPrice, 0 AS uPrice, 0 AS nPrice , (SELECT GROUP_CONCAT(C_NO SEPARATOR ',') AS cate FROM FRONTDB.CP_CATEGORY_GOODS WHERE CG_KIND='tour_goods' AND GOODS_NO=FRONTDB.CP_TOUR_GOODS.TG_NO) AS cate FROM FRONTDB.CP_TOUR_GOODS WHERE CPN_CO_CD='1025' AND TG_BLIND='N' AND (TG_USEFLAG = 'Y' OR '1713503657' BETWEEN TG_STIME AND TG_ETIME) AND TG_OPT1 IN('', 0, 2) and (TG_NO IN (SELECT GOODS_NO FROM FRONTDB.CP_CATEGORY_GOODS WHERE CG_KIND = 'tour_goods' AND C_NO in (151l)) OR TG_CATE in (151l)) ORDER BY TG_ORD, TG_NAME, TG_SIGNDATE DESC

1054 : Unknown column '151l' in 'where clause'

error file : /www/item/coupon.html