Commercial / Residential

  • user warning: Unknown column 'node_data_field_ptype.field_ptype_value' in 'field list' query: SELECT COUNT(*) FROM (SELECT DISTINCT node_data_field_yr_acquired.field_yr_acquired_value AS node_data_field_yr_acquired_field_yr_acquired_value, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node_data_field_yr_acquired.field_job_no_value AS node_data_field_yr_acquired_field_job_no_value, node_data_field_yr_acquired.field_ptype_value AS node_data_field_yr_acquired_field_ptype_value, node.language AS node_language, node_data_field_marketsegment.field_marketsegment_value AS node_data_field_marketsegment_field_marketsegment_value, node_data_field_yr_acquired.field_bldgtype_value AS node_data_field_yr_acquired_field_bldgtype_value, node_data_field_ptype.field_ptype_value AS node_data_field_yr_acquired_field_ptype_value_1 FROM node node LEFT JOIN content_type_projects node_data_field_sprojman ON node.vid = node_data_field_sprojman.vid LEFT JOIN users users_node_data_field_sprojman ON node_data_field_sprojman.field_sprojman_uid = users_node_data_field_sprojman.uid INNER JOIN content_type_projects node_data_field_marketsegment ON node.vid = node_data_field_marketsegment.vid LEFT JOIN content_type_projects node_data_field_yr_acquired ON node.vid = node_data_field_yr_acquired.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 1 AND na.realm = 'term_access'))) AND ( node_data_field_marketsegment.field_marketsegment_value = 'Commercial / Residential' )) count_alias in /home/content/04/7088204/html/sites/default/modules/views/plugins/views_plugin_pager.inc on line 134.
  • user warning: Unknown column 'node_data_field_ptype.field_ptype_value' in 'field list' query: SELECT DISTINCT node_data_field_yr_acquired.field_yr_acquired_value AS node_data_field_yr_acquired_field_yr_acquired_value, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node_data_field_yr_acquired.field_job_no_value AS node_data_field_yr_acquired_field_job_no_value, node_data_field_yr_acquired.field_ptype_value AS node_data_field_yr_acquired_field_ptype_value, node.language AS node_language, node_data_field_marketsegment.field_marketsegment_value AS node_data_field_marketsegment_field_marketsegment_value, node_data_field_yr_acquired.field_bldgtype_value AS node_data_field_yr_acquired_field_bldgtype_value, node_data_field_ptype.field_ptype_value AS node_data_field_yr_acquired_field_ptype_value_1 FROM node node LEFT JOIN content_type_projects node_data_field_sprojman ON node.vid = node_data_field_sprojman.vid LEFT JOIN users users_node_data_field_sprojman ON node_data_field_sprojman.field_sprojman_uid = users_node_data_field_sprojman.uid INNER JOIN content_type_projects node_data_field_marketsegment ON node.vid = node_data_field_marketsegment.vid LEFT JOIN content_type_projects node_data_field_yr_acquired ON node.vid = node_data_field_yr_acquired.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 1 AND na.realm = 'term_access'))) AND ( node_data_field_marketsegment.field_marketsegment_value = 'Commercial / Residential' )ORDER BY node_data_field_yr_acquired_field_ptype_value_1 ASC LIMIT 0, 100 in /home/content/04/7088204/html/sites/default/modules/views/plugins/views_plugin_query_default.inc on line 1093.