id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,focuses 23383,High archive page numbers cause invalid database queries,Viper007Bond,,"Visiting `http://www.viper007bond.com/category/videos/page/6805063692754011230` on my site generates the following database query: {{{ 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 }}} Note the scientific notation `LIMIT` value. PHP: 5.3.15-pl0-gentoo MySQL: 5.2.12 WordPress: r23386 ",defect (bug),new,normal,Awaiting Review,Database,3.6,normal,,,,