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') = '20111027' and wpp.id = wtr.object_id and wtr.term_taxonomy_id = 10 order by wpp.post_excerpt ASC