Advertising

Incontenible

Opinión Gráfica

Billboard: Power to women in Zenit Tattoo

THE NEWS IN YOUR MAILBOX

Subscribe to our newsletters to be aware of the most relevant articles published on OnCuba.

THE NEWS IN YOUR MAILBOX

Diario

Semanal

Breaking News

Media

Díaz-Canel: We are not renouncing communism
138537

Other articles

', $after = '', $show_pass_post = false, $duration='') { global $wpdb; $request = "SELECT ID, post_title, post_author,(SELECT user_nicename from $wpdb->users where ID = post_author)as post_author_name, COUNT($wpdb->comments.comment_post_ID) AS 'comment_count' FROM $wpdb->posts, $wpdb->comments"; $request .= " WHERE comment_approved = '1' AND $wpdb->posts.ID=$wpdb->comments.comment_post_ID AND post_status = 'publish'"; if(!$show_pass_post) $request .= " AND post_password =''"; if($duration !="") { $request .= " AND DATE_SUB(CURDATE(),INTERVAL ".$duration." DAY) < post_date "; } $request .= " GROUP BY $wpdb->comments.comment_post_ID ORDER BY comment_count DESC LIMIT $no_posts"; $posts = $wpdb->get_results($request); $output = ''; if ($posts) { foreach ($posts as $post) { $post_title = stripslashes($post->post_title); $comment_count = $post->comment_count; $permalink = get_permalink($post->ID); $output .= $before . '' . $post_title . ' (' . $comment_count.')'.$post->post_author_name . $after; } } else { $output .= $before . "No hay nada" . $after; } echo $output; } entradas_mas_comentadas(); */?>