gistfile1.txt

SELECT `people`.* FROM `people` WHERE `people`.`deleted_at` IS NULL AND (`people`.`country_id` = 16777217) AND (id IN (SELECT DISTINCT person_id FROM people_sections WHERE people_sections.deleted_at IS NULL AND section_id IN (SELECT DISTINCT section_id FROM event_types WHERE event_types.deleted_at IS NULL AND event_types.id IN (SELECT DISTINCT event_type_id FROM events WHERE events.deleted_at IS NULL AND competition_id = 16777237)))) AND ((people.lastname LIKE '%gabriella%' or people.firstname LIKE '%gabriella%')) AND ((people.lastname LIKE '%szabo%' or people.firstname LIKE '%szabo%')) LIMIT 100