tribe_events parts added to regular SQL query

[Daniel]

Hi guys,

we are investigating of The Events Calendar fits our needs. However, it seems that it terribly increases SQL queries in some cases.

We have switched off the possibility to integrate events in the normal blog roll. So, the blog start page is fine.

But when I want to see the posts for a category or tag the SQL query becomes something like:

SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, IF (wp_posts.post_type = ‘tribe_events’, wp_postmeta.meta_value, wp_posts.post_date) AS post_date FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta as wp_postmeta on wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (95) ) AND wp_posts.post_type IN (‘post’, ‘tribe_events’) AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘expired’ OR wp_posts.post_author = 1 AND wp_posts.post_status = ‘private’) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 14

Why is it necessary to add all this tribe_events stuff to the query if I don’t care about events at all if I select posts? The calendar is kept separately!

As far as I can see in the forum similar questions have been asked before. But it seems it is still an issue.

IMO this prevents us from using the calender further and even buying the PRO version…

[George]

Hey Daniel,

First of all, thanks for even considering our plugins to begin with! As for your query issues, can you specify the exact locations on your site where you see this SQL? Are you finding it on specific tag or category archives, where some tags or cats do not produce this but some do?

Further, are these categories and tags the generic WordPress “Category” and “Tag” taxonomy? If so, are you tagging Events with these default tags and/or default categories in any way?

Finally, what versions of The Events Calendar and of WordPress itself are active on your site?

Thank you!
George

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts