Ayuda consulta sql

[jawir]

Gracias por contestar
Me da el siguiente error en la consulta

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT t1.id_parcela

Código MySQL:

SELECT tp.* FROM TParcela tp LEFT JOIN  TReserva tr ON (tp.id_parc = tr.id_parcela AND 
                                                tp.id_parc NOT IN 
                                                (SELECT t1.id_parcela 
                                                 FROM TReserva t1)
                                                 WHERE t1.dia_reserva NOT BETWEEN '2010-04-15' AND '2010-05-09' AND t1.dia_salida NOT  BETWEEN '2010-04-15' AND '2010-05-09')) 
WHERE  tp.libre='si' OR tp.libre='res'