Wtorek, 16 kwietnia 202416/04/2024

Tag: wejherowska

SELECT count(ID) FROM wp_posts p LEFT JOIN wp_term_relationships tr ON tr.object_id = p.ID INNER JOIN wp_term_taxonomy tt ON tt.term_id = tr.term_taxonomy_id INNER JOIN wp_postmeta pm ON pm.post_id = p.ID where p.post_status = 'publish' AND (p.post_type = 'post' OR p.post_type = 'event') AND (tr.term_taxonomy_id = 16 OR tt.taxonomy = 'event-category') AND pm.meta_key AND pm.meta_value >= '2024-04-16'