Patient Study Results
user warning: Unknown column 'node_data_field_original_diagnosis.field_original_diagnosis_valu' in 'field list'
query: SELECT DISTINCT(node.nid), node.type AS node_type, users.name AS users_name, users.uid AS users_uid, profile_gender.value AS profile_gender_value, node_data_field_original_diagnosis.field_original_diagnosis_value AS node_data_field_original_diagnosis_field_original_diagnosis_value, node_data_field_currentdiagnosis.field_currentdiagnosis_value AS node_data_field_currentdiagnosis_field_currentdiagnosis_value, node_data_field_other_side_effect.field_other_side_effect_value AS node_data_field_other_side_effect_field_other_side_effect_value, node_data_field_diagnosis_status.field_diagnosis_status_value AS node_data_field_diagnosis_status_field_diagnosis_status_value, node.uid AS node_uid FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN profile_values profile_gender ON users.uid = profile_gender.uid AND profile_gender.fid = '2' 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 = 1 AND na.realm = 'content_access_rid') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( (node.type IN ('content_patient_study_curcumin')) ) ORDER BY users_name ASC LIMIT 0, 10 in /home/.watson/rbtvance/beating-myeloma.org/includes/database.mysql.inc on line 172.
|