Memory limit 40000000M
Maximum execution time 3000000
2021/02/01 - 2021/02/31SELECT * FROM datosimpoint where referencia like '%%' and referencia<>'' and bl_master like '%' and linea_naviera like '%' and buque like '%' and puerto_origen like '%' and puerto_destino like '%' and agente_aduanal like '%' and agente_aduanal_atencion like '%' and agente_en_origen like '%' and numero_de_contenedores like '%' and desconsolidacion like '%' and rebate like '%' and otros like '%' and profit_fee like '%' and tipo_de_carga like '%%' and nombre_del_contenedor like '%' and sello_del_contenedor like '%' and dimension_del_contenedor like '%' and bl_house like '%%' and notificar_a like '%' and notificar_a_persona_de_contacto like '%' and consignatario like '%' and notify_consignatario like '%' and shipper like '%' and destino_final like '%' and instrucciones_especiales like '%' and liberar_contra_hbl like '%' and flete_maritimo_pagado like '%' and liberar_el_bl_contra_presentacion like '%' and endosado_al_a_a like '%' and factura_emitida_en like '%' and if(tipo_de_carga='AEREO/AIR',eta,atraco_puerto) BETWEEN '2021/02/01' AND '2021/02/31' and fecha_desconsolidacion like '%' and almacen like '%' and inicio_de_revalidacion like '%' and hora_de_inicio_de_revalidacion like '%' and pcs_missing like '%' and cargo_broken like '%' and other_details like '%' and fecha_aviso_llegada_manzanillo like '%' and fecha_aviso_llegada_veracruz like '%' and fecha_aviso_llegada_altamira like '%' and iddatosimpoint>359000 order by iddatosimpoint limit 10000 0