';
        echo "[COUNT SQL]\n\n";
      //  echo htmlspecialchars($countDebugSql, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8');
        echo $countDebugSql;
        echo "\n\n------------------------------\n\n";
    }
    
    $stmtCount->execute();
    $totalCount = (int)$stmtCount->fetchColumn();
    
    // ---------------------------------------------------------
    // 목록 조회
    // ---------------------------------------------------------
    $sql = "
        SELECT
            c.content_id,
            c.category_code,
            c.category_group,
            c.title,
            c.content_url,
            c.thumbnail_url,
            c.sort_order,
            c.created_at,
            c.updated_at,
            
            lh.content_id AS lh_content_id,
            lh.watch_tm,
            lh.content_tm,
            lh.last_viewed_at,
            
            CASE
                WHEN cw.content_id IS NOT NULL THEN 1
                ELSE 0
            END AS is_bookmarked,
            
            COALESCE(vs.view_cnt, 0) AS view_cnt,
            COALESCE(vs.total_all_tm, 0) AS total_all_tm,
            
            GROUP_CONCAT(
                DISTINCT ck.keyword_code
                ORDER BY ck.keyword_code
                SEPARATOR ','
            ) AS keywords
            
        FROM edu_contents c
        
        LEFT JOIN edu_learning_histories lh
               ON lh.content_id = c.content_id
              AND lh.member_id = :member_id
              AND lh.sys_comp_code = :sys_comp_code
              
        LEFT JOIN edu_content_wishlist cw
               ON cw.content_id = c.content_id
              AND cw.member_id = :member_id2
              AND cw.sys_comp_code = :sys_comp_code2
              AND (cw.is_active = '1' OR cw.is_active = 'Y')
              
        LEFT JOIN (
            SELECT
                content_id,
                COUNT(*) AS view_cnt,
                COALESCE(SUM(all_tm), 0) AS total_all_tm
            FROM edu_learning_histories
            GROUP BY content_id
        ) vs
               ON vs.content_id = c.content_id
               
        LEFT JOIN edu_content_keywords ck
               ON ck.content_id = c.content_id
               
        WHERE {$whereSql}
        
        GROUP BY c.content_id
        
        ORDER BY {$orderBy}

        LIMIT :limit OFFSET :offset

    ";
    
    /*LIMIT :limit OFFSET :offset*/
    $stmt = $pdo->prepare($sql);
    
    $stmt->bindValue(':member_id', $memberId, PDO::PARAM_STR);
    $stmt->bindValue(':sys_comp_code', $sysCompCode, PDO::PARAM_STR);
    $stmt->bindValue(':member_id2', $memberId, PDO::PARAM_STR);
    $stmt->bindValue(':sys_comp_code2', $sysCompCode, PDO::PARAM_STR);
    
    foreach ($bind as $key => $value) {
        $stmt->bindValue($key, $value, PDO::PARAM_STR);
    }
    
    $stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
    $stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
    
    if ($DEBUG_SQL) {
        $debugParams = [
            ':member_id'      => $memberId,
            ':sys_comp_code'  => $sysCompCode,
            ':member_id2'     => $memberId,
            ':sys_comp_code2' => $sysCompCode,
            ':limit'          => $limit,
            ':offset'         => $offset,
        ];
        
        if (!empty($bind)) {
            $debugParams = array_merge($debugParams, $bind);
        }
        
        $debugSql = buildDebugSql($sql, $debugParams);
        
        echo "[LIST SQL]\n\n";
        //echo htmlspecialchars($debugSql, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8');
        echo $debugSql;
        echo '

/>