I'm trying to speed my site up with a few direct queries.


{exp:query sql="SELECT field_id_16 FROM exp_channel_data WHERE channel_id='4' "} {field_id_16}


What query will I need to restrict these entries to a certain category? I'll probably need to join exp_category_posts?

1 Answer 1


Off the top of my head I'm pretty sure this should work for you :

SELECT field_id_16 FROM exp_channel_data cd
LEFT JOIN exp_category_posts cp
ON cd.entry_id = cp.entry_id
WHERE cp.cat_id = 1

Change the cp.cat_id = 1 number to whichever category ID you need and I'm fairly certain you should be good to go.

  • No problem. Glad that helped. :-)
    – Mark Bowen
    Jul 3, 2013 at 8:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.