DrupalBin

user warning: You have an error IN your SQL syntax; CHECK the manual that corresponds TO your MySQL server version FOR the RIGHT syntax TO USE near '= node_node_data_field_client.nid WHERE node.type in ('project') ORDER BY no' at line 8 query:

 

SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node_node_data_field_supportstatus.title AS node_node_data_field_supportstatus_title, node_node_data_field_supportstatus.nid AS node_node_data_field_supportstatus_nid

 

FROM node node

LEFT JOIN content_type_project node_data_field_supportstatus ON node.vid = node_data_field_supportstatus.vid

INNER JOIN node node_node_data_field_supportstatus ON node_data_field_supportstatus.field_supportstatus_nid = node_node_data_field_supportstatus.nid

LEFT JOIN node node_node_data_field_client ON .field_client_nid = node_node_data_field_client.nid

WHERE node.type IN ('project')

ORDER BY node_title ASC, node_node_data_field_supportstatus_title ASC