WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #23383


Ignore:
Timestamp:
02/04/13 20:37:27 (2 years ago)
Author:
Viper007Bond
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #23383 – Description

    initial v1  
    11Visiting `http://www.viper007bond.com/category/videos/page/6805063692754011230` on my site generates the following database query: 
    22 
    3 {{{ 
    4 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (21) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 6.805063692754E+19, 10 
    5 }}} 
     3`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (21) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 6.805063692754E+19, 10` 
    64 
    75Note the scientific notation `LIMIT` value. 
    86 
    97 
    10 PHP: 5.3.15-pl0-gentoo 
    11 MySQL: 5.2.12 
     8PHP: 5.3.15-pl0-gentoo[[BR]] 
     9MySQL: 5.2.12[[BR]] 
    1210WordPress: r23386