Home

Fix for Fix for views sql for node reference/relationship reference

January 25, 2009 - 8:48pm — Anonymous
  1. SELECT node.nid AS nid, node.title AS node_title, node_node_data_field_location_node__location.latitude AS node_node_data_field_location_node__location_latitude, node_node_data_field_location_node__location.longitude AS node_node_data_field_location_node__location_longitude FROM node node  LEFT JOIN content_field_location_node node_data_field_location_node ON node.vid = node_data_field_location_node.vid LEFT JOIN node node_node_data_field_location_node ON node_data_field_location_node.field_location_node_nid = node_node_data_field_location_node.nid LEFT JOIN location_instance node_node_data_field_location_node__location_instance ON node_node_data_field_location_node.vid = node_node_data_field_location_node__location_instance.vid LEFT JOIN location node_node_data_field_location_node__location ON node_node_data_field_location_node__location_instance.lid = node_node_data_field_location_node__location.lid WHERE node.type IN ('resource')

Submit Fix

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Select the syntax highlighting mode to use.