get_var( $wpdb->prepare( "SELECT MAX(ID) FROM {$wpdb->posts} WHERE post_type=%s", 'attachment' ) ); } /** * Select current eligible IDs with a bounded keyset query. * * @param array $state State. * @param int $after After. * @param int $limit Limit. * @param bool $count Count. * @return mixed */ public static function select( array $state, int $after = 0, int $limit = 1, bool $count = false ) { global $wpdb; $fields = $count ? 'COUNT(DISTINCT p.ID)' : 'DISTINCT p.ID'; $sql = "SELECT $fields FROM {$wpdb->posts} p LEFT JOIN {$wpdb->postmeta} a ON a.post_id=p.ID AND a.meta_key=%s LEFT JOIN {$wpdb->postmeta} s ON s.post_id=p.ID AND s.meta_key=%s WHERE p.post_type=%s AND p.post_status=%s AND p.post_mime_type LIKE %s AND p.ID>%d AND p.ID<=%d AND (s.meta_id IS NULL OR s.meta_value NOT IN (%s,%s,%s))"; $args = array( '_wp_attachment_image_alt', '_altlumen_status', 'attachment', 'inherit', 'image/%', $after, $state['max_id'], 'manual', 'skipped', 'decorative' ); if ( ! empty( $state['missing'] ) ) { $sql .= ' AND (a.meta_id IS NULL OR TRIM(a.meta_value)=%s)'; $args[] = ''; } if ( ! empty( $state['ids'] ) ) { $sql .= ' AND p.ID IN (' . implode( ',', array_fill( 0, count( $state['ids'] ), '%d' ) ) . ')'; $args = array_merge( $args, array_map( 'absint', $state['ids'] ) ); } if ( ! $count ) { $sql .= ' ORDER BY p.ID ASC LIMIT %d'; $args[] = max( 1, min( 50000, $limit ) ); } // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- SQL fragments and placeholders are internal constants; all values are prepared. Current candidates must reflect edits after job start. if ( $count ) { // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Prepared above; fresh snapshot count. return (int) $wpdb->get_var( $wpdb->prepare( $sql, $args ) ); } // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Prepared above; bounded keyset selection. return array_map( 'intval', $wpdb->get_col( $wpdb->prepare( $sql, $args ) ) ); } }