chrisathook

hi, I Don’t have access yet to their account for the PRO plugin since I am currently volunteering consulting services for them. Once I do I will move into that area. as requested here are some of the queries

SELECT SQL_CALC_FOUND_ROWS (npfo_tec_occurrences.occurrence_id + 10000000) as occurrence_id
FROM npfo_posts INNER JOIN npfo_postmeta ON ( npfo_posts.ID = npfo_postmeta.post_id )
JOIN npfo_tec_occurrences ON npfo_posts.ID = npfo_tec_occurrences.post_id
WHERE 1=1 AND (
CAST(npfo_tec_occurrences.end_date_utc AS DATETIME) < '2025-02-28 13:35:13'
AND
( npfo_postmeta.meta_key = '_EventVenueID' AND npfo_postmeta.meta_value IN ('15137') )
) AND npfo_posts.post_type = 'tribe_events' AND ((npfo_posts.post_status = 'publish')) AND (npfo_posts.ID NOT IN (901,2314,18356,44753,45064,46621,47301,48353,48354,48355,48356,48357,48358,48360,48361,48362,48365,48465,48473,48559,48655,48994,49369,49414,49562,50880,51364,51563,51940,52823,53238,53630,53988,54526,54547,54718,54867,55023,55480,55553,55676,55917,56015,56138,69691,69744,69800,69863,69898,69940,69980,70911,71014,71059,71106,71171))
GROUP BY npfo_tec_occurrences.occurrence_id
ORDER BY npfo_tec_occurrences.start_date_utc DESC, npfo_tec_occurrences.duration DESC, npfo_posts.post_date DESC
LIMIT 0, 51




SELECT SQL_CALC_FOUND_ROWS (npfo_tec_occurrences.occurrence_id + 10000000) as occurrence_id
FROM npfo_posts INNER JOIN npfo_postmeta ON ( npfo_posts.ID = npfo_postmeta.post_id )
JOIN npfo_tec_occurrences ON npfo_posts.ID = npfo_tec_occurrences.post_id
WHERE 1=1 AND (
CAST(npfo_tec_occurrences.end_date_utc AS DATETIME) < '2025-02-28 13:35:33'
AND
( npfo_postmeta.meta_key = '_EventVenueID' AND npfo_postmeta.meta_value IN ('1627') )
) AND npfo_posts.post_type = 'tribe_events' AND ((npfo_posts.post_status = 'publish')) AND (npfo_posts.ID NOT IN (901,2314,18356,44753,45064,46621,47301,48353,48354,48355,48356,48357,48358,48360,48361,48362,48365,48465,48473,48559,48655,48994,49369,49414,49562,50880,51364,51563,51940,52823,53238,53630,53988,54526,54547,54718,54867,55023,55480,55553,55676,55917,56015,56138,69691,69744,69800,69863,69898,69940,69980,70911,71014,71059,71106,71171))
GROUP BY npfo_tec_occurrences.occurrence_id
ORDER BY npfo_tec_occurrences.start_date_utc DESC, npfo_tec_occurrences.duration DESC, npfo_posts.post_date DESC
LIMIT 0, 51

SELECT SQL_CALC_FOUND_ROWS  (npfo_tec_occurrences.occurrence_id + 10000000) as occurrence_id
					 FROM npfo_posts INNER JOIN npfo_postmeta ON ( npfo_posts.ID = npfo_postmeta.post_id )
JOIN npfo_tec_occurrences ON npfo_posts.ID = npfo_tec_occurrences.post_id 
					 WHERE 1=1  AND ( 
  CAST(npfo_tec_occurrences.end_date_utc AS DATETIME) < '2025-02-28 13:37:43' 
  AND 
  ( npfo_postmeta.meta_key = '_EventVenueID' AND npfo_postmeta.meta_value IN ('15637') )
) AND npfo_posts.post_type = 'tribe_events' AND ((npfo_posts.post_status = 'publish')) AND (npfo_posts.ID NOT IN (901,2314,18356,44753,45064,46621,47301,48353,48354,48355,48356,48357,48358,48360,48361,48362,48365,48465,48473,48559,48655,48994,49369,49414,49562,50880,51364,51563,51940,52823,53238,53630,53988,54526,54547,54718,54867,55023,55480,55553,55676,55917,56015,56138,69691,69744,69800,69863,69898,69940,69980,70911,71014,71059,71106,71171))
					 GROUP BY npfo_tec_occurrences.occurrence_id
					 ORDER BY npfo_tec_occurrences.start_date_utc DESC, npfo_tec_occurrences.duration DESC, npfo_posts.post_date DESC
					 LIMIT 0, 51


SELECT SQL_CALC_FOUND_ROWS  (npfo_tec_occurrences.occurrence_id + 10000000) as occurrence_id
					 FROM npfo_posts LEFT JOIN npfo_postmeta ON ( npfo_posts.ID = npfo_postmeta.post_id AND npfo_postmeta.meta_key = '_EventHideFromUpcoming' )
JOIN npfo_tec_occurrences ON npfo_posts.ID = npfo_tec_occurrences.post_id 
					 WHERE 1=1  AND ( 
  CAST(npfo_tec_occurrences.start_date AS DATETIME) > '2021-11-26 11:00:00' 
  AND 
  npfo_postmeta.post_id IS NULL
) AND npfo_posts.post_type = 'tribe_events' AND ((npfo_posts.post_status = 'publish')) AND (npfo_tec_occurrences.occurrence_id NOT IN (89969))
					 GROUP BY npfo_tec_occurrences.occurrence_id
					 ORDER BY npfo_tec_occurrences.start_date_utc ASC, npfo_posts.post_date ASC
					 LIMIT 0, 1

Hi,

but here is the info i was able to gather so far and some screenshots from the AWS tenant. I am not sure how to retrieve the entire SQL query from the amazon RDS UI it seems to truncate it.

I don’t have access to make admin changes yet so i can’t test your hypothesis WP Memory Limit: 52.71 of 256MB (21%) | PHP Memory Limit: 52.71 of 256MB (21%) | IP-Address (www.foodgatherers.org): 172.31.15.27 | PHP: 8.3.14Version 6.7.2

events calender Version 6.10.1.1

Pro version

Version 7.4.1?

https://app.screencast.com/HnJHvGoje4Sjz

https://app.screencast.com/8qecDlUlrah6O

https://app.screencast.com/uCO93B0xejkoB