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='2008-08-28' ORDER BY a.id LIMIT 100 OFFSET 5300 35th week of 2008 patent applcation highlights part 54