select wpp.id,wpp.post_excerpt as glosa,wpp.guid as url from wp_posts wpp, wp_term_relationships wtr
where wpp.post_mime_type = 'application/pdf'
and DATE_FORMAT(wpp.post_date,'%Y%m%d') = '20150417'
and wpp.id = wtr.object_id
and wtr.term_taxonomy_id = 12 order by wpp.post_excerpt ASC
