66SELECT post_status,post_date,post_date_gmt,guid, concat( 'http://www.gfranciscodeassis.org.br/', post_name,'/?provem=d') as link ,gsfrancisco_postmeta.meta_value as previa FROM gsfrancisco_posts inner join gsfrancisco_postmeta on gsfrancisco_posts.id = gsfrancisco_postmeta.post_id inner join gsfrancisco_postmeta as a on gsfrancisco_posts.id = a.post_id and a.meta_key = '_yoast_wpseo_primary_category' WHERE a.meta_key = '_yoast_wpseo_primary_category' and gsfrancisco_postmeta.meta_key = '_yoast_wpseo_metadesc' and post_type = 'post' and post_status = 'publish' and datediff('2024-07-27',post_date) >= 0 and datediff('2024-07-27',post_date) < 2
miolo: