¿Cómo saber el total de los cobros del día, mes o año?

Error en la base de datos de WordPress: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND p.post_type = 'docs' AND tt.taxonomy = 'doc_category' AND tt.term_id I...' at line 1]
SELECT p.ID FROM wpu2_posts AS p INNER JOIN wpu2_term_relationships AS tr ON p.ID = tr.object_id INNER JOIN wpu2_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE p.ID = '183689' AND p.ID < 183691)) AND p.post_type = 'docs' AND tt.taxonomy = 'doc_category' AND tt.term_id IN (232) AND p.ID NOT IN ( SELECT tr.object_id FROM wpu2_term_relationships tr LEFT JOIN wpu2_term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id) WHERE tt.term_id IN (0) ) AND p.post_status = 'publish' ORDER BY p.post_date DESC, p.ID DESC LIMIT 1

Error en la base de datos de WordPress: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND p.post_type = 'docs' AND tt.taxonomy = 'doc_category' AND tt.term_id I...' at line 1]
SELECT p.ID FROM wpu2_posts AS p INNER JOIN wpu2_term_relationships AS tr ON p.ID = tr.object_id INNER JOIN wpu2_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE p.ID = '183695' AND p.ID > 183691)) AND p.post_type = 'docs' AND tt.taxonomy = 'doc_category' AND tt.term_id IN (232) AND p.ID NOT IN ( SELECT tr.object_id FROM wpu2_term_relationships tr LEFT JOIN wpu2_term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id) WHERE tt.term_id IN (0) ) AND p.post_status = 'publish' ORDER BY p.post_date ASC, p.ID ASC LIMIT 1