gistfile1.sql

SELECT node.nid AS nid, COUNT(node_node_data_field_tourist_attraction.nid) AS node_node_data_field_tourist_attraction_nid, node_node_data_field_tourist_attraction.type AS node_node_data_field_tourist_attraction_type FROM node node LEFT JOIN content_field_day_plan node_data_field_day_plan ON node.vid = node_data_field_day_plan.vid LEFT JOIN flexifield_items flexifield_items_node_data_field_day_plan ON node_data_field_day_plan.field_day_plan_item_id = flexifield_items_node_data_field_day_plan.item_id LEFT JOIN content_field_tourist_attraction flexifield_items_node_data_field_day_plan_node_data_field_tourist_attraction ON flexifield_items_node_data_field_day_plan.item_id = flexifield_items_node_data_field_day_plan_node_data_field_tourist_attraction.vid LEFT JOIN node node_node_data_field_tourist_attraction ON flexifield_items_node_data_field_day_plan_node_data_field_tourist_attraction.field_tourist_attraction_nid = node_node_data_field_tourist_attraction.nid WHERE node.type in ('travel_log') GROUP BY node_node_data_field_tourist_attraction_nid, nid, node_node_data_field_tourist_attraction_type ORDER BY node_node_data_field_tourist_attraction_nid ASC