Is there any SQL documentation available?

[Carole Langman]

Hi,

I have been tasked with putting together some SQL statements that can be called on-demand to display information from the database such as:

• List of customers who have not bought a ticket for 3 months
• Top 15 customers with most bookings the last 3 months
• etc etc

I figured if I could see any of the SQL used by The Event Calendar or ticket plugins when displaying lists on the backend of WordPress then it would save me loads of time working out the relationship between wp_posts, postmeta for customer and event data etc. I’ve had a look but I can’t see any documentation anywhere – is this kind of information available anywhere?

Many thanks.

[Andras]

Hi Carole,

Thanks for reaching out!

No, we do not have any documentation on SQL scripts and we are not running queries like you mentioned on the back-end.

I see that you are using WooCommerce. The ticket products are handled through that, so you might be able to find some WooCommerce extensions that could help you out.

Also this reply might give you some insight in what data is saved where, when an order is made:

• https://theeventscalendar.com/support/forums/topic/export-sql-statement-for-managing-your-orders-and-attendees/#post-1478664

I hope this helps you get started. Let me know if you have any further questions.

Cheers,
Andras

[Carole Langman]

Hi Andras,

Ok thank you for the assistance, the information in that link looks like it will be useful in this.

Cheers/

[Andras]

You’re welcome!

I’ll keep my fingers crossed for you!

I will keep this open in case you need some more assistance down the road. Note, that if there are no new posts here for 3 weeks it will be automatically closed. In this case feel free to open a new thread, and copy the url of this thread there for reference.

Also I would be happy to hear back on your results. Might be useful for other community members as well.

Cheers,
Andras

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts