func (p PlaylistRepository) GetPlaylistItemsByPlaylistID(ctx context.Context, id uint, limit, offset int) (result *models.PlaylistItemWithMediaList, err error) {
	var (
		dbPlaylistItems []dbmodels.PlaylistItemWithMedia
		count           int64
	)
	if err = p.db.WithContext(ctx).
		Select(
			"pi.created_at as item_created_at",
			"pi.detail as item_detail",
			"pi.id as item_id",
			"pi.\"order\" as item_order",
			"pi.playlist_id as item_playlist_id",
			"pi.fixed as item_fixed",
			"m.id as media_id",
			"m.uuid as media_uuid",
			"m.ext as media_ext",
			"m.url as media_url",
			"m.thumbnail as media_thumbnail",
			"m.title as media_title",
			"m.type as media_type",
			"m.storage_type as media_storage_type",
			"m.size as media_size",
			"m.customer_id as media_customer_id",
			"m.user_id as user_id",
			"m.info as media_info",
			"m.checksum as media_checksum",
			"u.full_name as user_full_name",
			"u.job_title as user_job_title",
			"u.email as user_email",
			"u.mobile_number as user_mobile_number",
			"u.department as user_department",
		).
		Table("playlist_items pi").
		Joins(
			"left join media m on m.id = pi.media_id " 
				"left join users u on m.user_id = u.id",
		).
		Where("pi.playlist_id = ?", id).
		Count(&count).Limit(limit).Offset(offset).
		Find(&dbPlaylistItems).Error; err != nil {
		err = fmt.Errorf("get playlist items by playlist id / find : %w", err)
		return
	}

	playlistItems := make([]*models.PlaylistItemWithMedia, 0, len(dbPlaylistItems))

	for i := range dbPlaylistItems {
		var pm *models.PlaylistItemWithMedia

		if pm, err = dbPlaylistItems[i].To(); err != nil {
			err = fmt.Errorf("get playlist items by playlist id / convert to : %w", err)
			return
		}

		playlistItems = append(playlistItems, pm)
	}

	result = &models.PlaylistItemWithMediaList{
		Items:  playlistItems,
		Count:  count,
		Limit:  limit,
		Offset: offset,
	}
	return
}