Going swimming the web is a bit of PHP code that's made to display lately up-to-date posts/pages in WordPress. After posting a request to experts-exchange for help, within moments, I'd the raw code I desired.

However, the initial PHP code still did not work with my WordPress installation. After a little tweaks and lots of additional features, I'd handled to patch together the code required to only display lately up-to-date posts.

At this time I request for assistance to show only posts from the specific category. Can you really show only posts from the specific category? Are you able to help?

this is actually the current code:

<div class="statistics">
<?php
$today = current_time('mysql', 1);
$howMany = 10; //Number of posts you want to display
if ($recentposts = $wpdb->get_results("SELECT ID, post_title, post_modified FROM $wpdb->posts    WHERE post_status = 'publish' AND post_type = 'post' AND post_name NOT LIKE  '%revision%' AND post_name NOT LIKE '%autosave%' AND post_modified_gmt < '$today' ORDER BY post_modified_gmt DESC LIMIT $howMany")) :
?>
<h2><?php _e('ULTIME SERIE TV AGGIORNATE'); ?></h2>         
<ul>
<?php
foreach($recentposts as $post) {
if ($post->post_title == '') {
$post->post_title = sprintf(__('Post #%s'), $post->ID);
}
/* If no post title exists one will be assigned to it. */
echo "<li><a href='".get_permalink($post->ID)."'>";
echo mysql2date('d/m/Y', $post->post_modified); 
echo "&nbsp;-&nbsp;";
echo $post->post_title;
echo '</a></li>';
}
?>
</ul>
<?php endif; ?>
</div>

The table would be the groups saved in wordpress_term_taxonomy and which technique is accustomed to store products within specific category database and it is ID (term_taxonomy_id) This can be a picture:

TABLE picture

Inside a wordpress plugin (recently-updated-posts) I discovered this function but I don't understand how to place it during my code...

if ($options['excludeCategory']) {
$select .= ", GROUP_CONCAT(`tt`.`term_id`) AS `terms`";
$from   .= " LEFT JOIN `{$wpdb->term_relationships}` AS `tr` ON `tr`.`object_id` = `p`.`ID`"
                     . " LEFT JOIN `{$wpdb->term_taxonomy}` AS `tt` ON `tt`.`term_taxonomy_id` =   `tr`.`term_taxonomy_id`";
 $where  .= " AND `tt`.`taxonomy` = 'category'"
 . " AND `tt`.`term_id` NOT IN ({$options['excludeCategory']})";
 $group  = "GROUP BY `ID`";
 }

Final code:

<div class="update">
<?php
$today = current_time('mysql', 1);
if ($recentposts = $wpdb->get_results("SELECT ID, post_title, post_modified FROM $wpdb->posts    WHERE post_status = 'publish' AND post_type = 'post' AND post_name NOT LIKE  '%revision%' AND post_name NOT LIKE '%autosave%' AND post_modified_gmt < '$today' ORDER BY post_modified_gmt")) :
?>
<h2><?php _e('GLI ULTIMI EPISODI AGGIUNTI'); ?></h2>        
<ul>
<?php $args = array('category' => '30', 'orderby'  => 'modified', 'post_status' => 'publish',   'posts_per_page' => 11);
$recent_posts = wp_get_recent_posts($args);
foreach ($recent_posts as $post) {
if ($post["post_title"] == ''){ $post["post_title"] = sprintf(__('Post #%s'), $post["ID"]);
}
?>
<li><?php echo mysql2date('d/m/Y', $post["post_modified"]) ?>
&nbsp;-&nbsp;
<a href='<?php echo get_permalink($post["ID"]) ?>'>
<?php echo $post["post_title"] ?>
</a></li> <?php } ?>
</ul>
</div>
<?php endif; ?>

I'd use wp_get_recent_posts and pass within the arguments for category.

<ul>
<?php
$args = array( 'category' => '5' );
$recent_posts = wp_get_recent_posts( $args );
foreach( $recent_posts as $post ){
if ($post["post_title"] == '') {
$post["post_title"] = sprintf(__('Post #%s'), $post["ID"]);
}
?>
<li><a href='<?php echo get_permalink($post["ID"]) ?>'>
<?php echo mysql2date('d/m/Y', $post["post_modified"])?>
&nbsp;-&nbsp;
<?php echo $post["post_title"]?>
</a></li>
}
?>
</ul>