Channel Query



3rd Party (Free)

454 downloads (last 90 days)

MIT License Download v1.0

EE Version Support

  • ExpressionEngine 2


If an item is crossed out, it might be untested, not applicable or incompatible. Contact the developer to be sure.

  • Updater
  • Multi Site Manager
  • Stand Alone Entry Form
  • Low Variables
  • Content Elements
  • Better Workflow
  • Matrix
  • Grid
  • Webservice
  • Publisher


  • jQuery for the Control Panel

Add-On Type(s)



This plugin lets you display channel entries using a custom SQL query. It brings you the benefits of combining the {exp:query} tag with the {exp:channel:entries} tag, without having to worry about GROUP_CONCAT or parse order.


{exp:channel_query sql="SELECT entry_id FROM exp_channel_titles"}

The sql parameter specifies the custom SQL query. Only SELECT statements can be used,
INSERT, UPDATE and DELETE are not supported for security reasons.

All other parameters and variables are exactly the same as the standard EE
Channel Entries Tag.

If an orderby parameter is specified, that will take precendence. Otherwise, entries will be
displayed in the order returned by your SQL query.

Download Channel Query

EE Support Downloads Add-On Version Release Date
Not Specified Download 1.0 Apr 11, 2013

Channel Query Links

This entry was created April 11, 2013, 8:34 am.
This entry was last updated April 11, 2013, 8:40 am.

Disclaimer: Information about ExpressionEngine add-ons is provided as a service to you, the user, and every member of the ExpressionEngine community. devot:ee is not responsible if you hose, mangle, wreck, or otherwise destroy your EE website by installing an add-on that you found out about at this site, regardless of its rating, Favorites status, commercial or free status, or general popularity. Caveat EEmptor!

Returns: devot:ee has a 30-day return policy on all commercial add-ons sold through If you need to return an add-on, do not go to the developer or the developer's site, but rather visit our returns page at to initiate your return. If you have questions, email

1 Review:

Alex Kendrick 01.30.14

Alex Kendrick
Rating - {addon_rating_average}

Very useful for those times when you can’t get quite the right result set from channel:entries, but the query module would be too basic. You can get exactly the results you want, and in the just the right order—with all the benefits of the channel:entries tag.