SELECT  tur_numero 		 AS tnumero
								,tur_token 			 AS token
								,cli_email 			 AS cli_email
								,cli_nombre 		 AS cli_nombre
								,CONCAT(CONVERT(VARCHAR(10),tur_fecha,103),' ',STUFF(RIGHT('0000' + CAST(tur_hora AS VARCHAR(4)), 4), 3, 0, ':')) as fecha
						   FROM turnos AS t
					 INNER JOIN clientes AS c ON c.cli_codigo = t.cli_codigo
						  WHERE LEFT(CONVERT(VARCHAR,tur_fecha, 120), 10) >= LEFT(CONVERT(VARCHAR, GETDATE(), 120), 10)
						    AND tur_telemed = 1
						    AND tur_telemedicina_sendemail = 0
Array
(
)