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

CMigrator: Path from Drupal 6 to J5?
(Category s/b CMigrator, but didn't see it on the list) I'm interested in usi...
0 Replies
Posted on Monday, 28 April 2025
  • New
  • Dowload all Hotspots entries
    Hi there, I'm looking for a way to dowload all the Hotspots entries. I've got t...
    0 Replies
    Posted on Sunday, 06 April 2025
    • #kml
    • #download
    Set number of hotspots / user groups
    Hi, I'm working with Hotspots for my new website and I love it! After trying ...
    0 Replies
    Posted on Monday, 31 March 2025
    J5 compatibility for Hotspots
    Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
    1 Replies
    Posted on Monday, 24 February 2025
    • #Hotspots
    • #hotspots Joomla 5
    Text size in the comment input form
    Hello. How can I increase the font size in the comment input field? For examp...
    0 Replies
    Posted on Wednesday, 26 February 2025
    • #CComment 6