innerjoin('field_data_field_registration_type', 't', 'n.nid = t.entity_id'); $query->innerjoin('field_data_field_webtrac_module', 'j', 'n.nid = j.entity_id'); $query->leftjoin('field_data_field_webtrac_location', 'w', 'n.nid = w.entity_id'); $query->condition('n.type', 'facility', '='); $query->condition('n.status', '1', '='); $query->fields('n', array('nid','uid', 'title')); $query->fields('t', array('field_registration_type_value')); $query->fields('j', array('field_webtrac_module_value')); $query->fields('w', array('field_webtrac_location_value')); $query->orderBy('title', 'ASC'); $results = $query->execute(); foreach ($results as $result) { if ($result->field_registration_type_value == 'webtrac' && $result->field_webtrac_module_value == 'AR') { echo '' . strtoupper($result->title). ''; } if ($result->field_registration_type_value == 'oac') { echo '' . strtoupper($result->title). ''; } } ?>