Skip to content

Instantly share code, notes, and snippets.

@unruthless
Created May 3, 2011 20:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save unruthless/954118 to your computer and use it in GitHub Desktop.
Save unruthless/954118 to your computer and use it in GitHub Desktop.
bit of SQL for @benbrunt
SELECT
exp_channel_data.entry_id,
exp_channel_data.field_id_5 'largest'
FROM
exp_channel_data
JOIN
exp_channel_titles
ON exp_channel_data.entry_id = exp_channel_titles.entry_id
ORDER BY
exp_channel_data.field_id_5 DESC
LIMIT
0, 1
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment