array(1) {
[0]=>
string(29) "AND ae.speakers LIKE "%4177%""
}
CONDITIONS TO SQL
string(29) "AND ae.speakers LIKE "%4177%""
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 = 'en'
AND ae.speakers LIKE "%4177%"
ORDER BY time_start ASC"
EVENTS
array(1) {
[0]=>
object(stdClass)#5527 (15) {
["id_event"]=>
string(2) "65"
["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) "en"
["name_event"]=>
string(49) "ROI of agricultural robots: farmers share results"
["description_event"]=>
string(288) "Farmers and growers representatives will share their experiences integrating robotic and autonomous technologies into agricultural practices. They will discuss the efficiency gains achieved through these innovations, including concrete examples of return on investment (ROI) calculations."
["speakers"]=>
string(9) "6502,4177"
["robots"]=>
string(0) ""
["localisation"]=>
string(6) "Hangar"
["id_sponsor"]=>
string(2) "15"
["id_post_event"]=>
string(4) "5382"
["name_category"]=>
string(16) "Panel discussion"
["date_event_text"]=>
string(22) "Wednesday 5th February"
}
}