Simply Static: Export all pages with shortcode in Single Export

functions.php

<?php

add_filter( 'ssp_single_export_additional_urls', function ( $related_urls ) {
	global $wpdb;

	// Get all pages that have a recent posts shortcode.
	$page_ids = $wpdb->get_row( "SELECT ID FROM {$wpdb->posts} WHERE post_content LIKE '%[recent_posts AND post_type='page'", ARRAY_A );

	foreach ( $page_ids as $id ) {
		$related_urls[] = get_permalink( $id );

		return $related_urls;
	}
} );

It seems to me the return statement should be outside the foreach loop.