SELECT `post_title`, `tr`.`name` AS category, `pm`.`meta_value` AS fecha, `post_content` FROM `wpadk_posts` AS tp INNER JOIN `wpadk_postmeta` AS pm ON pm.post_id = tp.ID INNER JOIN `wpadk_term_relationships` AS trs ON trs.object_id = tp.ID INNER JOIN `wpadk_terms` AS tr ON tr.term_id = trs.term_taxonomy_id WHERE `post_type` = 'post' AND `post_status` = 'publish' AND pm.meta_key = 'fecha_evento' AND( trs.term_taxonomy_id = ) AND meta_value > '2023-10-01' ORDER BY `pm`.`meta_value` ASC
Lunes
23
Martes
24
Miércoles
25
Jueves
26
Viernes
27
Sábado
28
Domingo
29