Agenda

SELECT p.*,e.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS r ON ( p.ID = r.object_id ) INNER JOIN wp_term_taxonomy AS t ON ( r.term_taxonomy_id = t.term_taxonomy_id ) INNER JOIN wp_ec3_schedule AS e ON ( e.post_id = p.ID ) WHERE 1 =1 AND t.taxonomy = 'category' AND t.term_id IN ('1','5', '6', '7', '10', '11') AND p.post_type = 'post' AND (p.post_status = 'publish' OR p.post_status = 'private') AND e.end > CURDATE() GROUP BY p.ID ORDER BY e.start ASC LIMIT 4 OFFSET 20

Barkatu eragozpenak; ez dago ekitaldirik hurbileko datetan.