Making WordPress.org

Changes between Initial Version and Version 1 of Ticket #2532, comment 3


Ignore:
Timestamp:
02/28/2017 10:45:24 PM (8 years ago)
Author:
SergeyBiryukov
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #2532, comment 3

    initial v1  
    44Currently:
    55{{{
    6 SELECT SQL_CALC_FOUND_ROWS support_posts.ID FROM support_posts INNER JOIN support_postmeta ON ( support_posts.ID = support_postmeta.post_id ) WHERE 1=1 AND support_posts.post_parent NOT IN (21261,21262,21272) AND (
    7 support_postmeta.meta_key = '_bbp_reply_count'
    8 ) AND support_posts.post_type = 'topic' AND (support_posts.post_status = 'publish' OR support_posts.post_status = 'closed' OR support_posts.post_status = 'private' OR support_posts.post_status = 'hidden') AND ( support_posts.ID >= 1 ) GROUP BY support_posts.ID ORDER BY support_posts.ID DESC LIMIT 0, 15
     6SELECT SQL_CALC_FOUND_ROWS wporg_419_posts.ID FROM wporg_419_posts INNER JOIN wporg_419_postmeta ON ( wporg_419_posts.ID = wporg_419_postmeta.post_id ) WHERE 1=1 AND wporg_419_posts.post_parent NOT IN (21261,21262,21272) AND (
     7wporg_419_postmeta.meta_key = '_bbp_reply_count'
     8) AND wporg_419_posts.post_type = 'topic' AND (wporg_419_posts.post_status = 'publish' OR wporg_419_posts.post_status = 'closed' OR wporg_419_posts.post_status = 'private' OR wporg_419_posts.post_status = 'hidden') AND ( wporg_419_posts.ID >= 1 ) GROUP BY wporg_419_posts.ID ORDER BY wporg_419_posts.ID DESC LIMIT 0, 15
    99}}}
    1010With those lines removed:
    1111{{{
    12 SELECT SQL_CALC_FOUND_ROWS support_posts.ID FROM support_posts INNER JOIN support_postmeta ON ( support_posts.ID = support_postmeta.post_id ) WHERE 1=1 AND support_posts.post_parent NOT IN (21261,21262,21272) AND (
    13 support_postmeta.meta_key = '_bbp_reply_count'
    14 ) AND support_posts.post_type = 'topic' AND (support_posts.post_status = 'publish' OR support_posts.post_status = 'closed' OR support_posts.post_status = 'private' OR support_posts.post_status = 'hidden') GROUP BY support_posts.ID ORDER BY support_postmeta.meta_value+0 DESC LIMIT 0, 15
     12SELECT SQL_CALC_FOUND_ROWS wporg_419_posts.ID FROM wporg_419_posts INNER JOIN wporg_419_postmeta ON ( wporg_419_posts.ID = wporg_419_postmeta.post_id ) WHERE 1=1 AND wporg_419_posts.post_parent NOT IN (21261,21262,21272) AND (
     13wporg_419_postmeta.meta_key = '_bbp_reply_count'
     14) AND wporg_419_posts.post_type = 'topic' AND (wporg_419_posts.post_status = 'publish' OR wporg_419_posts.post_status = 'closed' OR wporg_419_posts.post_status = 'private' OR wporg_419_posts.post_status = 'hidden') GROUP BY wporg_419_posts.ID ORDER BY wporg_419_postmeta.meta_value+0 DESC LIMIT 0, 15
    1515}}}
    1616