1. Chris Paschen
  2. Sherlock Holmes
  3. General
  4. Monday, 10 October 2016
  5.  Subscribe via email
 I'm trying to generate a custom report via SQL (and jDBReports) and I'm trying to link (JOIN) 'bookings' with the 'event', but I can't tell how the bookings table (_matuko_bookings) is 'related' to the main '_matuko' table?
I can't find which field in _matukio_bookings should be JOINED to what field in _matukio.

Am I missing something?

I just need to create an SQL join between the event data and the bookings data.

Can you tell me what tables/fields would do that?

Thanks.
Responses (3)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Is Ccomment still alive?
Is Ccomment still being supported? It's time for my Pro renewal but I haven't se...
0 Replies
Posted on Thursday, 14 August 2025
  • New
  • Anzeige von mehrtägigen Events auf Buchungsseite
    We have been using Matukio for quite some time now. Unfortunately, we have been ...
    3 Replies
    Posted on Sunday, 03 August 2025
    Assistance Needed – Error When Posting Comments
    Hello, I’m experiencing an issue when trying to submit a comment on my site u...
    0 Replies
    Posted on Sunday, 10 August 2025
  • New
  • Hotspots Pro 6.0.13 compatability with Joomla 5.3.
    Running Hotspots Pro 6.0.13 on Joomla 4.4.13 and want to upgrade to Joomla 5.3.1...
    2 Replies
    Posted on Friday, 04 July 2025
    some questions on Hotspots
    Hi, On Hotspots extension : 1) is it possible to add our own map layer / v...
    0 Replies
    Posted on Thursday, 03 July 2025