Statistics:Posted by hlussa — 06 Jun 2012 21:27
Amazing stuff.SELECT
a.endpoints_entity_id AS source,
b.endpoints_entity_id AS target,
a.entity_id,
c.label AS label
FROM
field_data_endpoints a
INNER JOIN
field_data_endpoints b
ON
a.entity_id=b.entity_id
INNER JOIN
relation_type c
ON
a.bundle=c.relation_type
WHERE
a.endpoints_entity_id<>b.endpoints_entity_id
AND
a.endpoints_r_index<>1
ORDER BY
entity_id;
Statistics:Posted by hlussa — 05 Jun 2012 16:18
CODE:
SELECT a.endpoints_entity_id AS source, b.endpoints_entity_id AS target, a.bundle AS label, a.entity_id FROM field_data_endpoints a, field_data_endpoints b WHERE a.entity_id=b.entity_id AND a.endpoints_entity_id<>b.endpoints_entity_id AND a.endpoints_r_index<>1 ORDER BY entity_id
Statistics:Posted by hlussa — 05 Jun 2012 10:40
CODE:
rid - relation_type 6 - works_for
CODE:
entity_id - endpoints_entity_id - endpoints_r_index 6 14 0 6 7 1
Statistics:Posted by hlussa — 02 Jun 2012 23:06