Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #10964, comment 104


Ignore:
Timestamp:
12/22/2011 01:27:54 PM (13 years ago)
Author:
bear_beavis
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #10964, comment 104

    initial v1  
    44The query is :
    55{{{
    6 SELECT SQL_CALC_FOUND_ROWS  posts.* FROM posts  INNER JOIN term_relationships ON (lme_posts.ID = term_relationships.object_id) WHERE 1=1  AND ( term_relationships.term_taxonomy_id IN (9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55) ) AND psots_post_type = 'post' AND (posts.post_status = 'publish') GROUP BY lme_posts.ID ORDER BY lme_posts.post_date DESC LIMIT 0, 10;
     6SELECT SQL_CALC_FOUND_ROWS  posts.* FROM posts  INNER JOIN term_relationships ON (posts.ID = term_relationships.object_id) WHERE 1=1  AND ( term_relationships.term_taxonomy_id IN (9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55) ) AND posts.post_type = 'post' AND (posts.post_status = 'publish') GROUP BY posts.ID ORDER BY posts.post_date DESC LIMIT 0, 10;
    77}}}
    88