aquarius : SQL snippets

See all stored values for a node

SELECT lg, cf.name, cfv.name, value
FROM content c
JOIN content_field cf ON cf.content_id = c.id
JOIN content_field_value cfv ON cfv.content_field_id = cf.id
WHERE node_id = 1278
ORDER BY cf.weight, cf.name, cfv.name

See all values for fields of a certain type

SELECT lg, cf.name, cfv.name, value
FROM node n
JOIN form ON n.form_id = form.id
JOIN form_field ON form.id = form_field.form_id
JOIN content c ON n.id = c.node_id
JOIN content_field cf ON cf.content_id = c.id
JOIN content_field_value cfv ON cfv.content_field_id = cf.id
WHERE form_field.name = cf.name
  AND form_field.type = 'rte'
ORDER BY n.id, cf.weight, cf.name, cfv.name
LIMIT 100