function obtain_entities_by_type($entity_type,$bundle,$limit=10,$offset=0,$subject_nid=FALSE){
$query=new EntityFieldQuery();
$query->entityCondition('entity_type', $entity_type)
->entityCondition('bundle', $bundle)
->propertyCondition('status', 1)
->range($offset, $limit);
if($subject_nid)
$query->fieldCondition('field_subject','nid',$subject_nid);
$results=$query->execute();
if(array_key_exists('node',$results))
return entity_load($entity_type,array_keys($results[$entity_type]));
}
Useage
obtain_entities_by_type('node','page',10,0,432);
Or
<?php
$sql="SELECT node.nid AS nid,
node.title AS node_title,
node.created AS node_created,
node_data_field_weight.field_weight_value AS node_data_field_weight_field_weight_value
FROM node node
LEFT JOIN content_field_weight node_data_field_weight ON node.vid = node_data_field_weight.vid
WHERE (node.status <> 0)
ORDER BY node_data_field_weight_field_weight_value DESC";
$db_query=db_query($sql);
$items=array();
while($row=db_fetch_array($db_query))
$items[]=array( $row["node_title"], $row["node_created"], $row["nid"], $row["node_data_field_weight_field_weight_value"] );
echo("<pre>".print_r($items,TRUE)."</pre>\n\n");
?>
Or
<?php
function snag_drupal_pages(){
$sql_children="SELECT node.nid AS nid, node.vid AS node_vid, node.title AS node_title
FROM node node
WHERE node.type in ('page')";
$db_query_children = db_query($sql_children);
$pages=array();
foreach($db_query_children as $row){
$nd=node_load($row->nid);
$key=array_push( $pages,array() ) - 1;
$pages[$key]["id"] = $row->nid;
$pages[$key]["title"] = $nd->title;
$pages[$key]["date"] = $nd->created;
if( drupal_lookup_path('alias',"node/".$nd->nid) ) $pages[$key]["path"] = drupal_lookup_path('alias',"node/".$nd->nid);
else $pages[$key]["path"] = "node/".$nd->nid;
if( !empty($nd->field_parent_page) ) $pages[$key]["group"] = $nd->field_parent_page["und"][0]["nid"];
}
#echo("<pre>");print_r($pages);echo("</pre>\n");
return $pages;
}
?>