force mysql to use an index


SELECT * 
FROM Y
LEFT JOIN Z FORCE INDEX(image_id)```