Paul J Heidema
user warning: Unknown column 'node_data_field_csmcost.field_csmcost_value' in 'field list'
query: SELECT node_data_field_seminar_date.field_seminar_date_value AS node_data_field_seminar_date_field_seminar_date_value,
node.nid AS nid,
node.language AS node_language,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_seminar_date.field_seminar_location_value AS node_data_field_seminar_date_field_seminar_location_value,
node_data_field_seminar_date.field_seminar_type_value AS node_data_field_seminar_date_field_seminar_type_value,
node_data_field_seminar_date.field_original_price_value AS node_data_field_seminar_date_field_original_price_value,
node_data_field_seminar_date.field_original_price_format AS node_data_field_seminar_date_field_original_price_format,
node_data_field_seminar_date.field_csmcost_value AS node_data_field_seminar_date_field_csmcost_value,
node_data_field_csmcost.field_csmcost_value AS node_data_field_seminar_date_field_csmcost_value_1
FROM node node
INNER JOIN content_field_upcomingcsm node_data_field_upcomingcsm ON node.vid = node_data_field_upcomingcsm.vid
LEFT JOIN content_type_csm3d node_data_field_seminar_date ON node.vid = node_data_field_seminar_date.vid
WHERE (node.type in ('csm3d')) AND (node.status <> 0) AND (node_data_field_upcomingcsm.field_upcomingcsm_value IN ('Upcoming & FULL', 'Upcoming & OPEN'))
ORDER BY node_data_field_seminar_date_field_csmcost_value_1 ASC
LIMIT 0, 50 in /home/bci_admin/berteigconsulting.com/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1093.
