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='2009-01-08' ORDER BY a.id LIMIT 100 OFFSET 1100 02nd week of 2009 patent applcation highlights part 12