Drupal 7 basic node query

query.php

$query = db_select('node', 'n');
$query ->condition('n.type', 'NODETYPE', '=');
$query ->condition('n.status', '1', '=');
$query->join('SOMEFIELDTABLE', 'l', 'n.nid = l.entity_id');
$query->fields('n', array('title', 'nid'));
$query->fields('l', array('FIELDCOLUMNNAME'));
$query->orderBy('n.title');
$result = $query->execute();
    
foreach ($result as $record) {
  $fids[] =  $record->FIELDCOLUMNNAME;
}