This is an SQL question - but anyway. The subselect should be in parenthesis like this:

destination =
        (SELECT destination
        FROM checkin
        ...
        )/
[download]

I don't know why there is that qq/ perhaps it was pasted from some kind of reference but it should not be there.

Beside that I'm not sure if in the current MySQL there are subselect supported.