SELECT a.docnumber,a.title,a.longtitle,a.id,a.pdate,ai.abstract FROM tbl_application a LEFT JOIN tbl_app_info ai on a.docnumber=ai.docnumber WHERE a.disabled=false AND a.pdate='2011-09-01' ORDER BY a.id LIMIT 100 OFFSET 3000 35th week of 2011 patent applcation highlights part 31