{"id":987400,"date":"2015-07-17T08:27:47","date_gmt":"2015-07-17T15:27:47","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/"},"modified":"2015-08-03T07:05:03","modified_gmt":"2015-08-03T14:05:03","slug":"tribe_events-parts-added-to-regular-sql-query","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/","title":{"rendered":"tribe_events parts added to regular SQL query"},"content":{"rendered":"<p>Hi guys,<\/p>\n<p>we are investigating of The Events Calendar fits our needs. However, it seems that it terribly increases SQL queries in some cases.<\/p>\n<p>We have switched off the possibility to integrate events in the normal blog roll. So, the blog start page is fine.<\/p>\n<p>But when I want to see the posts for a category or tag the SQL query becomes something like:<\/p>\n<p>SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, IF (wp_posts.post_type = &#8216;tribe_events&#8217;, 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 = &#8216;_EventStartDate&#8217; WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (95) ) AND wp_posts.post_type IN (&#8216;post&#8217;, &#8216;tribe_events&#8217;) AND (wp_posts.post_status = &#8216;publish&#8217; OR wp_posts.post_status = &#8216;expired&#8217; OR wp_posts.post_author = 1 AND wp_posts.post_status = &#8216;private&#8217;) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 14 <\/p>\n<p>Why is it necessary to add all this tribe_events stuff to the query if I don&#8217;t care about events at all if I select posts? The calendar is kept separately!<\/p>\n<p>As far as I can see in the forum similar questions have been asked before. But it seems it is still an issue.<\/p>\n<p>IMO this prevents us from using the calender further and even buying the PRO version&#8230;<\/p>\n","protected":false},"template":"","class_list":["post-987400","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>tribe_events parts added to regular SQL query -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"tribe_events parts added to regular SQL query -\" \/>\n<meta property=\"og:description\" content=\"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 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/\" \/>\n<meta property=\"article:modified_time\" content=\"2015-08-03T14:05:03+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/\",\"name\":\"tribe_events parts added to regular SQL query -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2015-07-17T15:27:47+00:00\",\"dateModified\":\"2015-08-03T14:05:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Welcome!\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Pre-Sales Questions\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/pre-sales-questions\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"tribe_events parts added to regular SQL query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"tribe_events parts added to regular SQL query -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/","og_locale":"en_US","og_type":"article","og_title":"tribe_events parts added to regular SQL query -","og_description":"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 [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/","article_modified_time":"2015-08-03T14:05:03+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/","name":"tribe_events parts added to regular SQL query -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2015-07-17T15:27:47+00:00","dateModified":"2015-08-03T14:05:03+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/tribe_events-parts-added-to-regular-sql-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Welcome!","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/"},{"@type":"ListItem","position":4,"name":"Pre-Sales Questions","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/pre-sales-questions\/"},{"@type":"ListItem","position":5,"name":"tribe_events parts added to regular SQL query"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/987400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/987400\/revisions"}],"predecessor-version":[{"id":987656,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/987400\/revisions\/987656"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=987400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}