General
Start Topic
default userpic

MTSQLEntries - limit to a category

By orm_jen on Sep 11, 2009 at 6:15 PM 1 Vote 0 Votes

I'm using the MTSQL plugin and need to know - How do you limit a query in the MTSQLEntries tag to a category? Apparently ( and maybe this is just our database ) there are no category_id's in the entry_category_id field, so adding "where entry_category_id=nnn" has no effect even though there are in fact categories being used.

Thanks!

Reported on Movable Type 4.2

1 Reply

| Add a Reply
  • user-pic
    Author Profile Page Brad Choate | September 12, 2009 2:40 PM | Reply

    The entry_category_id column is vestigial. It's a column that isn't currently used by MT. All category relationships are in the mt_placement table. So you want a query like this:

    select placement_entry_id as entry_id
  from mt_placement
 where placement_category_id=1

    And just join against mt_entry if you need to further limit the selection based on other entry fields or if you want to sort by the publish date, etc.

Add a Reply

If you need to share template code, replace all the "<" signs with "&lt;" or use this utility.

Forum Groups

1773 6162

Last Topic: Excluding categories from blog by kholechek on Feb 9, 2012

86 302

Last Topic: website entries by masoud on Oct 26, 2011

1429 5077

Last Topic: What apocalypse hit this community in the middle of 2011? by 75th on Feb 10, 2012

695 2910

Last Topic: Insert Image / File Fails by Russ Miller on Feb 10, 2012

84 291

Last Topic: How to have some other characters in entry basename automatically written by Afshin Haghighatnia on Dec 22, 2011

173 737

Last Topic: About the MT version stated in HTML source by Alex E. Schneider on Feb 7, 2012

190 567

Last Topic: Analytics Reporting by michael webster on Feb 5, 2012

26 95

Last Topic: How do ProNet Licensees Get Current Versions of Movable Type? by Bill on Aug 28, 2011

48 210

Last Topic: An idea and also a request by Afshin Haghighatnia on Jun 29, 2011

64 246

Last Topic: jQuery in MT 5.1 still at 1.4 - why? by perlmonkey on May 25, 2011

code.sixapart.com

137 478

Last Topic: Getting a thumbnail with xpath by Peter on Mar 13, 2011

222 720

Last Topic: Custom Field for Asset Not Appearing by android on Feb 9, 2012