DrupalBin
Submit Code
About
Recent Posts
Code
Fix for Fix for Code
Fix for Code
Code
Node type whitelist
an axe coach accessories
coach purses married
Fix for de las ghd alturas
de las ghd alturas
Code
more
User login
Log in using OpenID:
What is OpenID?
Username:
*
Password:
*
Log in using OpenID
Cancel OpenID login
Create new account
Request new password
Tags
CCK
drupal
fapi
jquery
menu
module
php
simpletest
taxonomy
test
theme
views
more tags
Home
›
views sql for node reference/relationship reference
Fix for views sql for node reference/relationship reference
View
Fix
Fixes are not saved to the database until you submit.
Summary:
Tags:
Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Show summary in full view
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')
Syntax highlighting mode:
ActionScript
ColdFusion
Diff
Drupal 5
Drupal 6
HTML
INI
Javascript
MySQL
PHP
Python
robots.txt
SQL
Text
Select the syntax highlighting mode to use.
See Also:
Order
Title:
URL:
-1
0
1
Title:
URL:
-1
0
1
Any links you'd like to have associated with the post (Drupal.org issue, Wikipedia article, etc).
File attachments
Changes made to the attachments are not permanent until you save this post. The first "listed" file will be included in RSS feeds.
Attach new file:
The maximum upload size is
1 MB
. Only files with the following extensions may be uploaded:
jpg jpeg gif png txt doc xls pdf ppt pps odt ods odp phps
.
