| @@ -39,11 +39,8 @@ | ||
| 39 | 39 | $prepare_ids = QueryHelper::prepare_in_clause( $course_ids ); |
| 40 | 40 | $course_in_clause = "AND course.ID IN ({$prepare_ids})"; |
| 41 | 41 | } |
| 42 | 42 | |
| 43 | - $post_status = QueryHelper::prepare_in_clause( array( 'publish', 'future', 'draft', 'private', 'pending' ) ); | |
| 44 | - $post_status_in_clause = "AND course.post_status IN ({$post_status})"; | |
| 45 | - | |
| 46 | 43 | $sql = "SELECT COUNT(DISTINCT lesson.ID) |
| 47 | 44 | FROM {$wpdb->posts} lesson |
| 48 | 45 | INNER JOIN {$wpdb->posts} topic ON lesson.post_parent=topic.ID |
| 49 | 46 | INNER JOIN {$wpdb->posts} course ON topic.post_parent=course.ID |
| @@ -50,14 +47,13 @@ | ||
| 50 | 47 | WHERE 1 = 1 |
| 51 | 48 | {$course_in_clause} |
| 52 | 49 | AND lesson.post_type = %s |
| 53 | 50 | AND lesson.post_status = %s |
| 54 | - {$post_status_in_clause} | |
| 51 | + AND course.post_status = %s | |
| 55 | 52 | AND topic.post_status = %s"; |
| 56 | 53 | |
| 57 | 54 | //phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared |
| 58 | - $result = $wpdb->get_var( $wpdb->prepare( $sql, $lesson_type, 'publish', 'publish' ) ); | |
| 59 | - return $result; | |
| 55 | + return $wpdb->get_var( $wpdb->prepare( $sql, $lesson_type, 'publish', 'publish', 'publish' ) ); | |
| 60 | 56 | } |
| 61 | 57 | |
| 62 | 58 | /** |
| 63 | 59 | * Get total lesson count by a course |
