Help with some SQL

This is another one with the longstanding safari websites. I have a request to export a simple .csv for my client, but unfortunately because of the data structure its anything but a simple .csv.

Its to do with the keyword profile thing with the checkboxes to display lists of activities, accommodation type etc on an agent's page.

I have attached some stuff below for reference....

I could help you with this in a premier support ticket pretty easily. Not easy enough to pull off without direct access to the pages and direct communication to capture what they need in the csv.

Thanks Ray - I've my client know. When I've done this before I've had cash to get it sorted ad worry about being reimbursed later. But I've just moved and been haemorrhaging money recently due to that and Covid not helping. So I'll need to get the $99 from him first this time, which might take a couple of days. Or I can see if you can send he invoice directly to him maybe.

Hi Ray - I'm good to go with that. Let me know when you have a bit of time and we can look at it. Thanks again.

Just call me using the number at the bottom of the web site and we can take a look together.

Hi Ray - really sorry, change of plan.

Simply adding indexes on the tables where you have joins will speed up the database. That is probably all he is doing.

Let me know if you need help at a later date, but I'm sure they can handle it... creating a .csv from database tables isn't too difficult.

Thanks Ray - I will do. I have appreciated all your help with this stuff over the years more than you know. And Jason too, which is going back quite a long time.

I thought the same with database optimisation - that that was mostly about Primary Keys and indexes. We went through it ages ago and added loads of indexes, maybe about three years ago.

I'm not sure what else he could do to optimize... maybe update caching settings... anyway I guess that isn't important as long as it gets done. Let me know if you need any more help.

Sorry, just tired and a bit maudlin. Going to call a night tonight with this.