I’d like to execute some small piece of code like the following one:
global $wpdb;
$rows = $wpdb->query('SELECT DATE(post_date) AS date, COUNT(*) AS count FROM ' . $wpdb->posts . ' GROUP BY DATE(post_date) ORDER BY DATE(post_date)');
foreach ($rows as $row) {
echo $row->date . ': ' . $row->count . '<br>';
}
But I don’t want to write a plugin for this small task. How can I manage it?