gistfile1.php

<?php
function my_module_menu() {
  return array(
    'mypage' => array(
      'page callback' => 'mypage_callback',
      'access callback' => TRUE,
    )
  );
}

function mypage_callback() {
  //Instantiate a new query
  $query = new EntityFieldQuery();

  //Add conditions to the query
  $query->entityCondition('entity_type', 'node') //only return nodes (we could also return users, taxonomy terms, or any other drupal entity)
  ->entityCondition('bundle', 'article') //Only return articles
  ->propertyCondition('status', NODE_PUBLISHED) //Only return published nodes
  ->propertyCondition('title', 'K', '>') //only return nodes whose title starts with the letters L through Z.
  ->propertyOrderBy('title'); //alphabetize

  //Run the query
  $result = $query->execute();

  $nodes = array();

  if (!empty($result['node'])) {
    foreach ($result['node'] as $nid => $node_metadata) {
      //Load all of the nodes we found into a renderable array
      $nodes[] = node_view(node_load($nid), 'teaser');
    }
  }

  return $nodes;
}