Hi,
I have KoolPHP UI Professional 8.7
I hope someone have a idea, that my request, i have a sql request that give me some trouble :-)

SELECT log_admins.timestamp, 
   data_admins.cie,
   data_admins.firstname,
   data_admins.lastname,
   ref_action.text,
   CASE WHEN log_admins.action_id IN (4,5,6,7) 
           THEN data_ad.name
        WHEN log_admins.action_id IN (8,9,10,13)
           THEN data_medias.customer_filename
        WHEN log_admins.action_id IN (1,2,11,14,17)
           THEN ''
    END ref_id    
 FROM log_admins 
INNER JOIN data_admins 
   ON log_admins.user_id = data_admins.id 
INNER JOIN ref_action
   ON log_admins.action_id = ref_action.action_id 
  AND ref_action.language_id = 1033 
 LEFT JOIN data_medias
   ON data_medias.id= log_admins.ref_id 
   LEFT JOIN data_ad
   ON data_ad.id= log_admins.ref_id
WHERE (to_CHAR(timestamp, 'yyyy-mm-dd') BETWEEN '2024-10-11' AND '2024-10-22')
ORDER BY log_admins.timestamp DESC;

In the console of the MySql server that work very well, but in the KooGrid i got error' any idea where to look?
I have Kool

[24-Oct-2024 19:31:26 UTC] PHP Warning:  mysqli_fetch_row() expects parameter 1 to be mysqli_result, bool given in /home/.../kool/KoolGrid/ext/datasources/MySQLiDataSource.php on line 42
[24-Oct-2024 19:31:26 UTC] PHP Notice:  Trying to access array offset on value of type null in /home/.../kool/KoolGrid/ext/datasources/MySQLiDataSource.php on line 43
[24-Oct-2024 19:31:26 UTC] PHP Warning:  mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in /home/.../kool/KoolGrid/ext/datasources/MySQLiDataSource.php on line 112

My old mattress was giving me terrible back pain, but quality memory foam is expensive. I lost a chunk of change betting on the horses, which really ruined my week. I decided to give it one last shot at spinmacho casino before accepting my fate. The slots were hot that night, and I cashed out enough for a top-tier mattress and new pillows. Sleeping without pain is a luxury I didn't think I'd get this year.

Γεια χαρά! Η έρευνα για σύνθετα ερωτήματα SQL και η ανάλυση της δομής του KoolPHP UI απαιτεί συγκέντρωση, οπότε κάνω τακτικά διαλείμματα. Ανακάλυψα το play jonny πρόσφατα. Στην αρχή δεν είχα τύχη, αλλά με ρίσκο ήρθε η επιτυχία. Στην Ελλάδα οι παίκτες βρίσκουν δώρα και εξαιρετικές επιλογές εκεί. Είναι ο καλύτερος τρόπος να χαλαρώσετε μετά τη βελτιστοποίηση των JOIN και τη διόρθωση της λογικής CASE στο ερώτημά σας.

Nice comeback, but I’d still be careful with those “one last shot” sessions, been there myself a few years back and it can flip the other way fast. If I’m playing now, I stick to platforms that at least make the practical side easy, like official Mostbet Nepal https://mostbet-nepal.com/ . For me the big things are smooth mobile use, clear verification, decent payment methods, and withdrawals that don’t turn into a drama. Me and my buddy both found it easier to manage bankroll there because everything is straightforward. Good win though, mattress money is a proper result lol.