Query SELECT DISTINCT a.*
FROM #__zoo_item AS a LEFT JOIN #__zoo_category_item AS c0 ON a.id = c0.item_id LEFT JOIN #__zoo_search_index AS b0 ON a.id = b0.item_id
AND b0.element_id='a94bef72-d989-45b3-bcdb-be5a9eb0de7f' LEFT JOIN #__zoo_search_index AS b1 ON a.id = b1.item_id
AND b1.element_id='793a8b98-af52-4d00-97af-e8229deecc46' LEFT JOIN #__zoo_search_index AS b2 ON a.id = b2.item_id
AND b2.element_id='8761558d-d039-4a07-81d6-7a11759ef8e1'
WHERE a.searchable = 1
AND a.state = 1
AND a.access IN (1)
AND (a.publish_up = '0000-00-00 00:00:00'
OR a.publish_up <= '2025-06-14 15:35:10')
AND (a.publish_down = '0000-00-00 00:00:00'
OR a.publish_down >= '2025-06-14 15:35:10')
AND ((a.application_id = 21
AND (a.type LIKE 'mass-times'
AND (c0.category_id IN (197))
AND (( b0.element_id = 'a94bef72-d989-45b3-bcdb-be5a9eb0de7f'
AND ((TRIM(b0.value) LIKE 'Mass'
OR TRIM(b0.value) LIKE 'Mass\n%'
OR TRIM(b0.value) LIKE '%\nMass'
OR TRIM(b0.value) LIKE '%\nMass\n%')))
AND ( b1.element_id = '793a8b98-af52-4d00-97af-e8229deecc46'
AND ((TRIM(b1.value) LIKE '7:00 AM'
OR TRIM(b1.value) LIKE '7:00 AM\n%'
OR TRIM(b1.value) LIKE '%\n7:00 AM'
OR TRIM(b1.value) LIKE '%\n7:00 AM\n%')
OR (TRIM(b1.value) LIKE '7:30 AM'
OR TRIM(b1.value) LIKE '7:30 AM\n%'
OR TRIM(b1.value) LIKE '%\n7:30 AM'
OR TRIM(b1.value) LIKE '%\n7:30 AM\n%')
OR (TRIM(b1.value) LIKE '8:00 AM'
OR TRIM(b1.value) LIKE '8:00 AM\n%'
OR TRIM(b1.value) LIKE '%\n8:00 AM'
OR TRIM(b1.value) LIKE '%\n8:00 AM\n%')
OR (TRIM(b1.value) LIKE '8:30 AM'
OR TRIM(b1.value) LIKE '8:30 AM\n%'
OR TRIM(b1.value) LIKE '%\n8:30 AM'
OR TRIM(b1.value) LIKE '%\n8:30 AM\n%')
OR (TRIM(b1.value) LIKE '8:45 AM'
OR TRIM(b1.value) LIKE '8:45 AM\n%'
OR TRIM(b1.value) LIKE '%\n8:45 AM'
OR TRIM(b1.value) LIKE '%\n8:45 AM\n%')
OR (TRIM(b1.value) LIKE '9:00 AM'
OR TRIM(b1.value) LIKE '9:00 AM\n%'
OR TRIM(b1.value) LIKE '%\n9:00 AM'
OR TRIM(b1.value) LIKE '%\n9:00 AM\n%')
OR (TRIM(b1.value) LIKE '9:15 AM'
OR TRIM(b1.value) LIKE '9:15 AM\n%'
OR TRIM(b1.value) LIKE '%\n9:15 AM'
OR TRIM(b1.value) LIKE '%\n9:15 AM\n%')
OR (TRIM(b1.value) LIKE '9:30 AM'
OR TRIM(b1.value) LIKE '9:30 AM\n%'
OR TRIM(b1.value) LIKE '%\n9:30 AM'
OR TRIM(b1.value) LIKE '%\n9:30 AM\n%')
OR (TRIM(b1.value) LIKE '10:00 AM'
OR TRIM(b1.value) LIKE '10:00 AM\n%'
OR TRIM(b1.value) LIKE '%\n10:00 AM'
OR TRIM(b1.value) LIKE '%\n10:00 AM\n%')
OR (TRIM(b1.value) LIKE '10:15 AM'
OR TRIM(b1.value) LIKE '10:15 AM\n%'
OR TRIM(b1.value) LIKE '%\n10:15 AM'
OR TRIM(b1.value) LIKE '%\n10:15 AM\n%')
OR (TRIM(b1.value) LIKE '10:30 AM'
OR TRIM(b1.value) LIKE '10:30 AM\n%'
OR TRIM(b1.value) LIKE '%\n10:30 AM'
OR TRIM(b1.value) LIKE '%\n10:30 AM\n%')
OR (TRIM(b1.value) LIKE '11:00 AM'
OR TRIM(b1.value) LIKE '11:00 AM\n%'
OR TRIM(b1.value) LIKE '%\n11:00 AM'
OR TRIM(b1.value) LIKE '%\n11:00 AM\n%')
OR (TRIM(b1.value) LIKE '11:15 AM'
OR TRIM(b1.value) LIKE '11:15 AM\n%'
OR TRIM(b1.value) LIKE '%\n11:15 AM'
OR TRIM(b1.value) LIKE '%\n11:15 AM\n%')
OR (TRIM(b1.value) LIKE '11:20 AM'
OR TRIM(b1.value) LIKE '11:20 AM\n%'
OR TRIM(b1.value) LIKE '%\n11:20 AM'
OR TRIM(b1.value) LIKE '%\n11:20 AM\n%')
OR (TRIM(b1.value) LIKE '11:30 AM'
OR TRIM(b1.value) LIKE '11:30 AM\n%'
OR TRIM(b1.value) LIKE '%\n11:30 AM'
OR TRIM(b1.value) LIKE '%\n11:30 AM\n%')
OR (TRIM(b1.value) LIKE '12:00 PM'
OR TRIM(b1.value) LIKE '12:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n12:00 PM'
OR TRIM(b1.value) LIKE '%\n12:00 PM\n%')
OR (TRIM(b1.value) LIKE '12:15 PM'
OR TRIM(b1.value) LIKE '12:15 PM\n%'
OR TRIM(b1.value) LIKE '%\n12:15 PM'
OR TRIM(b1.value) LIKE '%\n12:15 PM\n%')
OR (TRIM(b1.value) LIKE '12:30 PM'
OR TRIM(b1.value) LIKE '12:30 PM\n%'
OR TRIM(b1.value) LIKE '%\n12:30 PM'
OR TRIM(b1.value) LIKE '%\n12:30 PM\n%')
OR (TRIM(b1.value) LIKE '12:45 PM'
OR TRIM(b1.value) LIKE '12:45 PM\n%'
OR TRIM(b1.value) LIKE '%\n12:45 PM'
OR TRIM(b1.value) LIKE '%\n12:45 PM\n%')
OR (TRIM(b1.value) LIKE '1:00 PM'
OR TRIM(b1.value) LIKE '1:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n1:00 PM'
OR TRIM(b1.value) LIKE '%\n1:00 PM\n%')
OR (TRIM(b1.value) LIKE '1:30 PM'
OR TRIM(b1.value) LIKE '1:30 PM\n%'
OR TRIM(b1.value) LIKE '%\n1:30 PM'
OR TRIM(b1.value) LIKE '%\n1:30 PM\n%')
OR (TRIM(b1.value) LIKE '2:00 PM'
OR TRIM(b1.value) LIKE '2:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n2:00 PM'
OR TRIM(b1.value) LIKE '%\n2:00 PM\n%')
OR (TRIM(b1.value) LIKE '3:00 PM'
OR TRIM(b1.value) LIKE '3:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n3:00 PM'
OR TRIM(b1.value) LIKE '%\n3:00 PM\n%')
OR (TRIM(b1.value) LIKE '4:00 PM'
OR TRIM(b1.value) LIKE '4:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n4:00 PM'
OR TRIM(b1.value) LIKE '%\n4:00 PM\n%')
OR (TRIM(b1.value) LIKE '4:30 PM'
OR TRIM(b1.value) LIKE '4:30 PM\n%'
OR TRIM(b1.value) LIKE '%\n4:30 PM'
OR TRIM(b1.value) LIKE '%\n4:30 PM\n%')
OR (TRIM(b1.value) LIKE '5:00 PM'
OR TRIM(b1.value) LIKE '5:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n5:00 PM'
OR TRIM(b1.value) LIKE '%\n5:00 PM\n%')
OR (TRIM(b1.value) LIKE '5:15 PM'
OR TRIM(b1.value) LIKE '5:15 PM\n%'
OR TRIM(b1.value) LIKE '%\n5:15 PM'
OR TRIM(b1.value) LIKE '%\n5:15 PM\n%')
OR (TRIM(b1.value) LIKE '5:30 PM'
OR TRIM(b1.value) LIKE '5:30 PM\n%'
OR TRIM(b1.value) LIKE '%\n5:30 PM'
OR TRIM(b1.value) LIKE '%\n5:30 PM\n%')
OR (TRIM(b1.value) LIKE '6:00 PM'
OR TRIM(b1.value) LIKE '6:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n6:00 PM'
OR TRIM(b1.value) LIKE '%\n6:00 PM\n%')
OR (TRIM(b1.value) LIKE '6:15 PM'
OR TRIM(b1.value) LIKE '6:15 PM\n%'
OR TRIM(b1.value) LIKE '%\n6:15 PM'
OR TRIM(b1.value) LIKE '%\n6:15 PM\n%')
OR (TRIM(b1.value) LIKE '6:30 PM'
OR TRIM(b1.value) LIKE '6:30 PM\n%'
OR TRIM(b1.value) LIKE '%\n6:30 PM'
OR TRIM(b1.value) LIKE '%\n6:30 PM\n%')
OR (TRIM(b1.value) LIKE '6:45 PM'
OR TRIM(b1.value) LIKE '6:45 PM\n%'
OR TRIM(b1.value) LIKE '%\n6:45 PM'
OR TRIM(b1.value) LIKE '%\n6:45 PM\n%')
OR (TRIM(b1.value) LIKE '7:00 PM'
OR TRIM(b1.value) LIKE '7:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n7:00 PM'
OR TRIM(b1.value) LIKE '%\n7:00 PM\n%')
OR (TRIM(b1.value) LIKE '7:15 PM'
OR TRIM(b1.value) LIKE '7:15 PM\n%'
OR TRIM(b1.value) LIKE '%\n7:15 PM'
OR TRIM(b1.value) LIKE '%\n7:15 PM\n%')))
AND ( b2.element_id = '8761558d-d039-4a07-81d6-7a11759ef8e1'
AND ((TRIM(b2.value) LIKE 'English'
OR TRIM(b2.value) LIKE 'English\n%'
OR TRIM(b2.value) LIKE '%\nEnglish'
OR TRIM(b2.value) LIKE '%\nEnglish\n%')))))))
ORDER BY a.name
LIMIT 10
Result Query SELECT COUNT( DISTINCT a.id )
FROM #__zoo_item AS a LEFT JOIN #__zoo_category_item AS c0 ON a.id = c0.item_id LEFT JOIN #__zoo_search_index AS b0 ON a.id = b0.item_id
AND b0.element_id='a94bef72-d989-45b3-bcdb-be5a9eb0de7f' LEFT JOIN #__zoo_search_index AS b1 ON a.id = b1.item_id
AND b1.element_id='793a8b98-af52-4d00-97af-e8229deecc46' LEFT JOIN #__zoo_search_index AS b2 ON a.id = b2.item_id
AND b2.element_id='8761558d-d039-4a07-81d6-7a11759ef8e1'
WHERE a.searchable = 1
AND a.state = 1
AND a.access IN (1)
AND (a.publish_up = '0000-00-00 00:00:00'
OR a.publish_up <= '2025-06-14 15:35:10')
AND (a.publish_down = '0000-00-00 00:00:00'
OR a.publish_down >= '2025-06-14 15:35:10')
AND ((a.application_id = 21
AND (a.type LIKE 'mass-times'
AND (c0.category_id IN (197))
AND (( b0.element_id = 'a94bef72-d989-45b3-bcdb-be5a9eb0de7f'
AND ((TRIM(b0.value) LIKE 'Mass'
OR TRIM(b0.value) LIKE 'Mass\n%'
OR TRIM(b0.value) LIKE '%\nMass'
OR TRIM(b0.value) LIKE '%\nMass\n%')))
AND ( b1.element_id = '793a8b98-af52-4d00-97af-e8229deecc46'
AND ((TRIM(b1.value) LIKE '7:00 AM'
OR TRIM(b1.value) LIKE '7:00 AM\n%'
OR TRIM(b1.value) LIKE '%\n7:00 AM'
OR TRIM(b1.value) LIKE '%\n7:00 AM\n%')
OR (TRIM(b1.value) LIKE '7:30 AM'
OR TRIM(b1.value) LIKE '7:30 AM\n%'
OR TRIM(b1.value) LIKE '%\n7:30 AM'
OR TRIM(b1.value) LIKE '%\n7:30 AM\n%')
OR (TRIM(b1.value) LIKE '8:00 AM'
OR TRIM(b1.value) LIKE '8:00 AM\n%'
OR TRIM(b1.value) LIKE '%\n8:00 AM'
OR TRIM(b1.value) LIKE '%\n8:00 AM\n%')
OR (TRIM(b1.value) LIKE '8:30 AM'
OR TRIM(b1.value) LIKE '8:30 AM\n%'
OR TRIM(b1.value) LIKE '%\n8:30 AM'
OR TRIM(b1.value) LIKE '%\n8:30 AM\n%')
OR (TRIM(b1.value) LIKE '8:45 AM'
OR TRIM(b1.value) LIKE '8:45 AM\n%'
OR TRIM(b1.value) LIKE '%\n8:45 AM'
OR TRIM(b1.value) LIKE '%\n8:45 AM\n%')
OR (TRIM(b1.value) LIKE '9:00 AM'
OR TRIM(b1.value) LIKE '9:00 AM\n%'
OR TRIM(b1.value) LIKE '%\n9:00 AM'
OR TRIM(b1.value) LIKE '%\n9:00 AM\n%')
OR (TRIM(b1.value) LIKE '9:15 AM'
OR TRIM(b1.value) LIKE '9:15 AM\n%'
OR TRIM(b1.value) LIKE '%\n9:15 AM'
OR TRIM(b1.value) LIKE '%\n9:15 AM\n%')
OR (TRIM(b1.value) LIKE '9:30 AM'
OR TRIM(b1.value) LIKE '9:30 AM\n%'
OR TRIM(b1.value) LIKE '%\n9:30 AM'
OR TRIM(b1.value) LIKE '%\n9:30 AM\n%')
OR (TRIM(b1.value) LIKE '10:00 AM'
OR TRIM(b1.value) LIKE '10:00 AM\n%'
OR TRIM(b1.value) LIKE '%\n10:00 AM'
OR TRIM(b1.value) LIKE '%\n10:00 AM\n%')
OR (TRIM(b1.value) LIKE '10:15 AM'
OR TRIM(b1.value) LIKE '10:15 AM\n%'
OR TRIM(b1.value) LIKE '%\n10:15 AM'
OR TRIM(b1.value) LIKE '%\n10:15 AM\n%')
OR (TRIM(b1.value) LIKE '10:30 AM'
OR TRIM(b1.value) LIKE '10:30 AM\n%'
OR TRIM(b1.value) LIKE '%\n10:30 AM'
OR TRIM(b1.value) LIKE '%\n10:30 AM\n%')
OR (TRIM(b1.value) LIKE '11:00 AM'
OR TRIM(b1.value) LIKE '11:00 AM\n%'
OR TRIM(b1.value) LIKE '%\n11:00 AM'
OR TRIM(b1.value) LIKE '%\n11:00 AM\n%')
OR (TRIM(b1.value) LIKE '11:15 AM'
OR TRIM(b1.value) LIKE '11:15 AM\n%'
OR TRIM(b1.value) LIKE '%\n11:15 AM'
OR TRIM(b1.value) LIKE '%\n11:15 AM\n%')
OR (TRIM(b1.value) LIKE '11:20 AM'
OR TRIM(b1.value) LIKE '11:20 AM\n%'
OR TRIM(b1.value) LIKE '%\n11:20 AM'
OR TRIM(b1.value) LIKE '%\n11:20 AM\n%')
OR (TRIM(b1.value) LIKE '11:30 AM'
OR TRIM(b1.value) LIKE '11:30 AM\n%'
OR TRIM(b1.value) LIKE '%\n11:30 AM'
OR TRIM(b1.value) LIKE '%\n11:30 AM\n%')
OR (TRIM(b1.value) LIKE '12:00 PM'
OR TRIM(b1.value) LIKE '12:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n12:00 PM'
OR TRIM(b1.value) LIKE '%\n12:00 PM\n%')
OR (TRIM(b1.value) LIKE '12:15 PM'
OR TRIM(b1.value) LIKE '12:15 PM\n%'
OR TRIM(b1.value) LIKE '%\n12:15 PM'
OR TRIM(b1.value) LIKE '%\n12:15 PM\n%')
OR (TRIM(b1.value) LIKE '12:30 PM'
OR TRIM(b1.value) LIKE '12:30 PM\n%'
OR TRIM(b1.value) LIKE '%\n12:30 PM'
OR TRIM(b1.value) LIKE '%\n12:30 PM\n%')
OR (TRIM(b1.value) LIKE '12:45 PM'
OR TRIM(b1.value) LIKE '12:45 PM\n%'
OR TRIM(b1.value) LIKE '%\n12:45 PM'
OR TRIM(b1.value) LIKE '%\n12:45 PM\n%')
OR (TRIM(b1.value) LIKE '1:00 PM'
OR TRIM(b1.value) LIKE '1:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n1:00 PM'
OR TRIM(b1.value) LIKE '%\n1:00 PM\n%')
OR (TRIM(b1.value) LIKE '1:30 PM'
OR TRIM(b1.value) LIKE '1:30 PM\n%'
OR TRIM(b1.value) LIKE '%\n1:30 PM'
OR TRIM(b1.value) LIKE '%\n1:30 PM\n%')
OR (TRIM(b1.value) LIKE '2:00 PM'
OR TRIM(b1.value) LIKE '2:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n2:00 PM'
OR TRIM(b1.value) LIKE '%\n2:00 PM\n%')
OR (TRIM(b1.value) LIKE '3:00 PM'
OR TRIM(b1.value) LIKE '3:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n3:00 PM'
OR TRIM(b1.value) LIKE '%\n3:00 PM\n%')
OR (TRIM(b1.value) LIKE '4:00 PM'
OR TRIM(b1.value) LIKE '4:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n4:00 PM'
OR TRIM(b1.value) LIKE '%\n4:00 PM\n%')
OR (TRIM(b1.value) LIKE '4:30 PM'
OR TRIM(b1.value) LIKE '4:30 PM\n%'
OR TRIM(b1.value) LIKE '%\n4:30 PM'
OR TRIM(b1.value) LIKE '%\n4:30 PM\n%')
OR (TRIM(b1.value) LIKE '5:00 PM'
OR TRIM(b1.value) LIKE '5:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n5:00 PM'
OR TRIM(b1.value) LIKE '%\n5:00 PM\n%')
OR (TRIM(b1.value) LIKE '5:15 PM'
OR TRIM(b1.value) LIKE '5:15 PM\n%'
OR TRIM(b1.value) LIKE '%\n5:15 PM'
OR TRIM(b1.value) LIKE '%\n5:15 PM\n%')
OR (TRIM(b1.value) LIKE '5:30 PM'
OR TRIM(b1.value) LIKE '5:30 PM\n%'
OR TRIM(b1.value) LIKE '%\n5:30 PM'
OR TRIM(b1.value) LIKE '%\n5:30 PM\n%')
OR (TRIM(b1.value) LIKE '6:00 PM'
OR TRIM(b1.value) LIKE '6:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n6:00 PM'
OR TRIM(b1.value) LIKE '%\n6:00 PM\n%')
OR (TRIM(b1.value) LIKE '6:15 PM'
OR TRIM(b1.value) LIKE '6:15 PM\n%'
OR TRIM(b1.value) LIKE '%\n6:15 PM'
OR TRIM(b1.value) LIKE '%\n6:15 PM\n%')
OR (TRIM(b1.value) LIKE '6:30 PM'
OR TRIM(b1.value) LIKE '6:30 PM\n%'
OR TRIM(b1.value) LIKE '%\n6:30 PM'
OR TRIM(b1.value) LIKE '%\n6:30 PM\n%')
OR (TRIM(b1.value) LIKE '6:45 PM'
OR TRIM(b1.value) LIKE '6:45 PM\n%'
OR TRIM(b1.value) LIKE '%\n6:45 PM'
OR TRIM(b1.value) LIKE '%\n6:45 PM\n%')
OR (TRIM(b1.value) LIKE '7:00 PM'
OR TRIM(b1.value) LIKE '7:00 PM\n%'
OR TRIM(b1.value) LIKE '%\n7:00 PM'
OR TRIM(b1.value) LIKE '%\n7:00 PM\n%')
OR (TRIM(b1.value) LIKE '7:15 PM'
OR TRIM(b1.value) LIKE '7:15 PM\n%'
OR TRIM(b1.value) LIKE '%\n7:15 PM'
OR TRIM(b1.value) LIKE '%\n7:15 PM\n%')))
AND ( b2.element_id = '8761558d-d039-4a07-81d6-7a11759ef8e1'
AND ((TRIM(b2.value) LIKE 'English'
OR TRIM(b2.value) LIKE 'English\n%'
OR TRIM(b2.value) LIKE '%\nEnglish'
OR TRIM(b2.value) LIKE '%\nEnglish\n%')))))))
