{"id":1327003,"date":"2017-07-27T09:45:18","date_gmt":"2017-07-27T16:45:18","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/"},"modified":"2017-07-27T09:45:18","modified_gmt":"2017-07-27T16:45:18","slug":"plugin-refund","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/","title":{"rendered":"Plugin Refund"},"content":{"rendered":"<p>I would like to have a refund of your plugins. We are just getting started with them and have server load issues and all sorts of server issue related to your tables&#8230; is one example. Out of the box your software does not appear to be handling well our data we need something scalable with room to grow. Already changed main calendar to week view and don&#8217;t even have any traffic yet to these pages so it is crawler traffic only and it can&#8217;t handle it.<\/p>\n<p>SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts  LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )  LEFT JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id AND mt2.meta_key = &#8216;_EventHideFromUpcoming&#8217; ) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = &#8216;_EventEndDateUTC&#8217; )  WHERE 1=1  AND wp_posts.ID NOT IN (16113) AND (<br \/>\nwp_postmeta.meta_key = &#8216;_EventStartDateUTC&#8217;<br \/>\n  AND<br \/>\n   (<br \/>\n                                        ( mt1.meta_key = &#8216;_EventStartDate&#8217; AND CAST(mt1.meta_value AS DATETIME) &gt; &#8216;2016-05-30 19:00:00&#8217; )<br \/>\n                                        OR (<br \/>\n                                                ( mt1.meta_key = &#8216;_EventStartDate&#8217; AND CAST(mt1.meta_value AS DATETIME) = &#8216;2016-05-30 19:00:00&#8217; )<br \/>\n                                                AND mt1.post_id &gt; 14541<br \/>\n                                        )<br \/>\n                                )<br \/>\n  AND<br \/>\n  mt2.post_id IS NULL<br \/>\n) AND wp_posts.post_type = &#8216;tribe_events&#8217; AND (wp_posts.post_status = &#8216;publish&#8217; OR wp_posts.post_status = &#8216;tribe-ea-success&#8217; OR wp_posts.post_status = &#8216;tribe-ea-failed&#8217; OR wp_posts.post_status = &#8216;tribe-ea-schedule&#8217; OR wp_posts.post_status = &#8216;tribe-ea-pending&#8217; OR wp_posts.post_status = &#8216;tribe-ea-draft&#8217;)  GROUP BY wp_posts.ID ORDER BY EventStartDate ASC, wp_posts.ID ASC LIMIT 0, 1<\/p>\n","protected":false},"template":"","class_list":["post-1327003","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>Plugin Refund -<\/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\/plugin-refund\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Plugin Refund -\" \/>\n<meta property=\"og:description\" content=\"I would like to have a refund of your plugins. We are just getting started with them and have server load issues and all sorts of server issue related to your tables&#8230; is one example. Out of the box your software does not appear to be handling well our data we need something scalable with [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/\",\"name\":\"Plugin Refund -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2017-07-27T16:45:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/#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\":\"Plugin Refund\"}]},{\"@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":"Plugin Refund -","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\/plugin-refund\/","og_locale":"en_US","og_type":"article","og_title":"Plugin Refund -","og_description":"I would like to have a refund of your plugins. We are just getting started with them and have server load issues and all sorts of server issue related to your tables&#8230; is one example. Out of the box your software does not appear to be handling well our data we need something scalable with [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/","name":"Plugin Refund -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2017-07-27T16:45:18+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/plugin-refund\/#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":"Plugin Refund"}]},{"@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\/1327003","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":0,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1327003\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1327003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}