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='2010-05-27' ORDER BY a.id LIMIT 100 OFFSET 1100 21st week of 2010 patent applcation highlights part 12