1select a.issue_id,b.page_name,a.pubdate,a.iconname from pdf_issues As a LEFT JOIN pdf_pages As b ON a.issue_id=b.issue_id where a.issue_title='20170429' and a.class_id='1' and a.status='1' order by a.issue_title desc limit 1 **
Array ( [pubdate] => 1395158400 [iconname] => 20140319_CAk43zyIcBox.jpg [page_name] => 2014031912_lQSqMS.pdf [issue_id] => 4151 ) ./cover/20140319_CAk43zyIcBox.jpg ### 2014-03-19 China Daily PDF Edition

 
China Daily PDF Edition


Page 01 (Top News)
Page 02 (Nation & Digest)
Page 03 (Nation)
Page 04 (Nation)
Page 05 (Nation)
Page 06 (Cover Story)
Page 07 (Nation)
Page 08 (Comment)
Page 09 (Comment)
Page 10 (World)
Page 11 (World)
Page 12 (World)
Page 13 (Business)
Page 14 (Business Digest)
Page 15 (Business Companies)
Page 16 (Business)
Page 17 (IP Special)
Page 18 (Business)
Page 19 (Life)
Page 20 (Life Pulse)
Page 21 (Life Fun)
Page 22 (Lfe Health)
Page 23 (Sports)
Page 24 (Sports)