array(1) {
[0]=>
string(29) "AND ae.speakers LIKE "%6812%""
}
CONDITIONS TO SQL
string(29) "AND ae.speakers LIKE "%6812%""
SQL
string(312) "SELECT *, DATE_FORMAT(date_event, '%W %D %M') AS date_event_text from wp_1061108_icc_new_agenda_event ae
INNER JOIN wp_1061108_icc_new_agenda_event_categories aec ON ae.id_category = aec.id_category
WHERE language_event = 'fr'
AND ae.speakers LIKE "%6812%"
ORDER BY time_start ASC"
EVENTS
array(2) {
[0]=>
object(stdClass)#5490 (15) {
["id_event"]=>
string(2) "95"
["id_category"]=>
string(1) "1"
["date_event"]=>
string(10) "2025-02-05"
["time_start"]=>
string(8) "09:00:00"
["time_end"]=>
string(8) "10:00:00"
["language_event"]=>
string(2) "fr"
["name_event"]=>
string(53) "Robots agricoles : Bilan économique des agriculteurs"
["description_event"]=>
string(332) "Des représentants d\'agriculteurs partageront leurs expériences en matière d\'intégration des technologies robotiques et autonomes dans les pratiques agricoles. Ils discuteront des améliorations de l\'efficacité obtenues grâce à ces innovations, y compris des exemples concrets de calculs de retour sur investissement (RSI)."
["speakers"]=>
string(19) "7257,6812,6505,5809"
["robots"]=>
string(0) ""
["localisation"]=>
string(6) "Hangar"
["id_sponsor"]=>
string(2) "15"
["id_post_event"]=>
string(4) "5833"
["name_category"]=>
string(16) "Panel discussion"
["date_event_text"]=>
string(22) "Wednesday 5th February"
}
[1]=>
object(stdClass)#5488 (15) {
["id_event"]=>
string(3) "161"
["id_category"]=>
string(1) "2"
["date_event"]=>
string(10) "2025-02-04"
["time_start"]=>
string(8) "15:30:00"
["time_end"]=>
string(8) "16:00:00"
["language_event"]=>
string(2) "fr"
["name_event"]=>
string(63) "Démo virtuelle : \"Élevage : IA et prédiction des maladies\""
["description_event"]=>
string(0) ""
["speakers"]=>
string(4) "6812"
["robots"]=>
string(4) "7753"
["localisation"]=>
string(20) "Zone Expo - Scène 2"
["id_sponsor"]=>
string(0) ""
["id_post_event"]=>
string(4) "7145"
["name_category"]=>
string(10) "Robot demo"
["date_event_text"]=>
string(20) "Tuesday 4th February"
}
}