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='2012-07-19' ORDER BY a.id LIMIT 100 OFFSET 4700 29th week of 2012 patent applcation highlights part 48