MySQL query for getting blog records/content Drupal7? I want to customize the and limit the content from the blog entry. If I want hook the sql query output for blog entry, How can i do it?
Please help me.
The limit is controlled through a variable called default_nodes_main. You can change it by executing the following code:

// This would increase the number of nodes on the blog page to 20.
variable_set('default_nodes_main', 20);


If you have Devel module installed, you can do this at /devel/php.