mysql inner join limit 1 or grab the last (within one inner join)

I know this is not possible but this is what I want to do…
inner join tabbble ON concat ( B.`planted`,'-',`withshovel`.`color`)=( tabbble.`entireshvoelcolor` AND tabbble.`Date` >= […]

See original post by invalid@example.com (xbat)