A mal-understanding of inner joins

[John Allsopp]

Hi

This is supposed to show me this month's events where the event title contains %market%, or either of its category descriptions do

SELECT * FROM event as e
inner join event_category as ec1 on e.event_category_1 = ec1.id
inner join event_category as ec2 on e.event_category_2 = ec2.id
where (e.title LIKE '%market%' || ec1.category_name LIKE '%market%' || ec2.category_name LIKE '%market%')
AND MONTH(date_from) = '7'
AND YEAR(date_from) = '2017'
ORDER BY date_from ASC

It doesn't show me any current matches, it comes up with something from 1995.

What am I missing?

All help appreciated.

Cheers
J