Skip to content

Instantly share code, notes, and snippets.

@brettp
Created April 25, 2011 16:28
Show Gist options
  • Save brettp/940753 to your computer and use it in GitHub Desktop.
Save brettp/940753 to your computer and use it in GitHub Desktop.
Elgg List Metadata on Entity
SELECT elgg_metadata.id, elgg_metadata.owner_guid, elgg_metadata.access_id, name.*, value.*, entity_guid
FROM elgg_metadata, elgg_metastrings name, elgg_metastrings value
WHERE name_id = name.id
AND value_id = value.id
AND entity_guid =
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment