Hi,
Can any one help me to design a custom view for this query
"SELECT node_data_field_townuser_town.field_townuser_town_nid AS nid,
node_data_field_townuser_town.field_townuser_town_nid AS node_data_field_townuser_town_field_townuser_town_nid,
node.type AS node_type,
node.vid AS node_vid
FROM node node
LEFT JOIN content_type_relations node_data_field_townuser_user ON node.vid = node_data_field_townuser_user.vid
LEFT JOIN users users_node_data_field_townuser_user ON node_data_field_townuser_user.field_townuser_user_uid = users_node_data_field_townuser_user.uid
LEFT JOIN content_type_relations node_data_field_townuser_town ON node.vid = node_data_field_townuser_town.vid
WHERE (node.type in ('relations')) AND (users_node_data_field_townuser_user.uid = CURRENT_USER)"
Thanks
Ajmal