SELECT t1.*, t2.img_med as img_banco FROM site_reservas t1 LEFT JOIN site_imagens t2 ON t1.img_destaque = t2.codigo WHERE (t1.ativo = 'S') AND (t1.data_entrada <= '2012-02-22' AND t1.data_saida > '2012-02-22')