select B.idx, B.product_name, B.product_lv, B.product_simple, B.product_thumb, B.recruit_status
             , B.class_start, B.class_end, B.product_nomal_price, B.class_explain, A.category, A.second_category
             , CASE
                WHEN CONVERT(DATE, GETDATE()) BETWEEN CONVERT(DATE, B.start_date1) AND CONVERT(DATE, B.end_date1)
                    THEN B.discount_price1
                WHEN CONVERT(DATE, GETDATE()) BETWEEN CONVERT(DATE, B.start_date2) AND CONVERT(DATE, B.end_date2)
                    THEN B.disocunt_price2
                ELSE B.product_price
             END AS product_price 
        from portal_english.dbo.en_product B left outer join
            (select D.target_idx as product_idx , E.co_uid, E.category, E.second_category, D.category_idx
                from portal_english.dbo.en_company_product D
                    inner join portal_english.dbo.en_company_category E ON D.category_idx = E.idx
                where E.use_yn = 'Y') A ON A.product_idx = B.idx
        where B.view_yn = 'Y' and B.use_yn = 'Y' and B.co_id = '43'  AND A.category_idx IN () order by B.idx desc
    

Array
(
    [0] => Array
        (
            [0] => 42000
            [SQLSTATE] => 42000
            [1] => 102
            [code] => 102
            [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]')' 근처의 구문이 잘못되었습니다.
            [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]')' 근처의 구문이 잘못되었습니다.
        )

)

1