Array ( [url] => https://cargohonduras.com/php/BandWidth/SendFactura.php?factura=HNDTPA01190716-11389 [content_type] => text/html; charset=UTF-8 [http_code] => 200 [header_size] => 269 [request_size] => 150 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.26864 [namelookup_time] => 0.000183 [connect_time] => 0.000293 [pretransfer_time] => 0.008773 [size_upload] => 0 [size_download] => 584 [speed_download] => 2179 [speed_upload] => 0 [download_content_length] => 584 [upload_content_length] => -1 [starttransfer_time] => 0.268563 [redirect_time] => 0 [redirect_url] => [primary_ip] => 72.167.140.75 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 72.167.140.75 [local_port] => 38200 [http_version] => 2 [protocol] => 2 [ssl_verifyresult] => 0 [scheme] => HTTPS [appconnect_time_us] => 8752 [connect_time_us] => 293 [namelookup_time_us] => 183 [pretransfer_time_us] => 8773 [redirect_time_us] => 0 [starttransfer_time_us] => 268563 [total_time_us] => 268640 [errno] => 0 [errmsg] => [content] =>
select f.factura , replace( replace( replace( replace( replace( t.telefono, '(', ''), ')', ''), '-', ''), '+', ''), ' ', '') telefono , a.celular from factura f left join telefonos t on t.idlink = f.clientefromid and activo != 'n' and t.sms = 'YES' left join agencias a on a.agencia = f.agencia where f.factura = 'HNDTPA01190716-11389' and ( LENGTH( replace( replace( replace( replace( replace( t.telefono, '(', ''), ')', ''), '-', ''), '+', ''), ' ', '')) = 10 or a.celular is not null )[Array] [HNDTPA01190716-11389]