select cltrschedu0_.Cltr_Schedule_ID as cltr_sch1_352_0_, cltrschedu0_.AD_Client_ID as ad_clien2_352_0_, cltrschedu0_.AD_Org_ID as ad_org_i3_352_0_, ( select rrmm.temp_ambiente_extrem from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula2_0_, ( select rrmm.expo_sustancias_quimi from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula3_0_, ( select rrmm.agentes_anestesicos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula4_0_, ( select rrmm.agentes_biologicos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula5_0_, ( select rrmm.agentes_citosaticos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula6_0_, ( select rrmm.alturas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula7_0_, ( select rrmm.alveolitis_alergica_extrinseca from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula8_0_, ( select rrmm.amianto from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula9_0_, ( select rrmm.apto_con_restricc from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula10_0_, ( select rrmm.apto_sin_restricc from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula11_0_, ( select rrmm.asma_laboral from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula12_0_, ( select rrmm.cloruro_vinilo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula13_0_, ( select rrmm.colinesterasa_plasmatica from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula14_0_, ( select rrmm.conduccion from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula15_0_, ( select rrmm.dermatosis_laboral from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula16_0_, ( select rrmm.diabetes from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula17_0_, ( SELECT historias.edad FROM opxhcli_rrmm AS rrmm LEFT JOIN Opxhcli_Historias AS historias ON rrmm.opxhcli_historias_id = historias.opxhcli_historias_id where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula18_0_, ( select rrmm.en_observacion from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula19_0_, ( select rrmm.espacios_confinados from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula20_0_, ( select rrmm.explosivos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula21_0_, ( select rrmm.hipercolesterolemia from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula22_0_, ( select rrmm.hipertension from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula23_0_, ( select rrmm.hipertrigliceridemia from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula24_0_, ( select rrmm.manipulacion_cargas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula25_0_, ( select rrmm.molestias_relac_pvd from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula26_0_, ( select rrmm.movimientos_miembro_superior from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula27_0_, ( select rrmm.neuropatias from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula28_0_, ( select rrmm.no_apto from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula29_0_, ( select rrmm.obesidad from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula30_0_, ( select rrmm.observaciones_apt_medica from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula31_0_, ( select rrmm.oxido_etileno from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula32_0_, ( select rrmm.plaguicidas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula33_0_, ( select rrmm.plomo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula34_0_, ( select rrmm.posturas_forzadas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula35_0_, ( select pu.puesto_trabajo from opxhcli_anam_laboral as an join opxhcli_puesto_trabajo as pu on an.opxhcli_puesto_trabajo_id = pu.opxhcli_puesto_trabajo_id join opxhcli_historias as h on h.opxhcli_historias_id = an.opxhcli_historias_id join opxhcli_rrmm as rrmm on rrmm.opxhcli_historias_id = h.opxhcli_historias_id where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id order by an.fecha_fin desc limit 1) as formula36_0_, ( select rrmm.pvd from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula37_0_, ( select rrmm.radiaciones_ionizantes from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula38_0_, ( select rrmm.ruido from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula39_0_, ( select rrmm.sedentarismo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula40_0_, ( select rrmm.se_objetiva_dato_patolo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula41_0_, ( SELECT historias.sexo FROM opxhcli_rrmm AS rrmm LEFT JOIN Opxhcli_Historias AS historias ON rrmm.opxhcli_historias_id = historias.opxhcli_historias_id where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula42_0_, ( select rrmm.signos_phanel_tinel from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula43_0_, ( select rrmm.silicosis_neumoconiosis from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula44_0_, ( select rrmm.sin_alteraciones from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula45_0_, ( select rrmm.sordera from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula46_0_, ( select rrmm.sospecha_epicondilitis from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula47_0_, ( select rrmm.tabaquismo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula48_0_, ( select rrmm.tipo_reconocimiento from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula49_0_, ( select rrmm.trauma_sonoro_pro from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula50_0_, ( select rrmm.vibraciones from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula51_0_ from cltr_schedule cltrschedu0_ where cltrschedu0_.Cltr_Schedule_ID in ('8FB4AC7F6518490BA2CABF10ABD7226F', 'A7633216950E4D0CAD4CF4C753983647', 'D60C77842F7F4B06AF806964DD270618', '1AC27D657585462CA4FFFE0F1FC3718C', '1AFF401947C9474B9718F35995E16F15', '2B9478D53D0243FCABBDDB3E752F30C1', '3A6370A55860421296FCEB7E2F4CA364', '63DD1C181BD542E0A2443223A2DC2EB1', 'AEF400D421F3457A829785EA73E4D692', 'FDD483CFE1A64C279DFC1810F6C9C795', '00231C6A28654E39A59072F039EC34B7', '07FCD75E8C534D9DBF834495073439D6', '158CC1ACC08E417FA25896D4F0FFF56B', '1826937A4281499DB8FC016F789169F9', '200463708B154F1A8A82A4697F159017', '390F400EF263431A9B1305DD3FB46025', '4130AA42B03044F08B00C1BCFF982120', '629F1464178E47B388530D08A0941D82', '6A526CC26508407184BFA9EF0A275780', '6DBD1A3AD20E4CB68ED2D5A47553E870', 'ACCA25E889EC4849BBF630D87B4DD71C', 'F7A7E68037254FADB47B9749200ADC93', '0314D2BF35F944A4A26645B036C22340', '42BABF715FC4428B853D5C6E0B74D5BF', '82FB89429E7C460BA6EF1B90CD525017', '935848C5A7A545E2BCEF14FCC2218B18', '95644DF01C4F499F90F892CF1572A6A5', '967E0F1543C04A6A9204C0D45A22EE80', 'A00C61DA6C844AEEACA13CDE0501A174', 'AC845A5A2567478CAED7B790CEF259D4', 'E0B4E99303904486AA9A024C2A61C71B', 'E16CE3DB9E624D9EBCC847FEB874C6F7', 'E3CB2150C09846A0914DF73A7DF316B7', 'E57E9B354796405FB6071D0033F389A9', 'EC2047D7C85046F3835B61391825B0BD', '07240A00D9FD44A8A4FB6E3A537C969B', '3E85EB32CB7844979E9D00C2C5D8DB5C', '5F1D512A7A6E465C89A4667CE4EFD185', '795A8D62890943F3830B1BEEC1A4C3B7', '8E473C44447842749DC4E289BB55A1FD', '9ECB168166074890A533C5D893F05036', 'BD7F7D1EA1794C29BBFB2862A3692EBA', 'C7F36562A54E4FCB9658F3177C7D8430', 'E749B323553C4D8DA0A01D81FF9A83B0', 'FCD17739DC2041208E73222E9C9EDDB5', '0D11300A1C4148528449D6FC187AAB3B', '1907AC1962BC47ABA9D6444C237B9DF1', '269C870187FC415BAADD97DE4E73B477', '400732A0967A4062BA5F3B5F9AE47E0A', '4465570728ED435F896B539655863356');

Date: 2026-07-15 11:49:09
Duration: 2s630ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select cltrschedu0_.Cltr_Schedule_ID as cltr_sch1_352_0_, cltrschedu0_.AD_Client_ID as ad_clien2_352_0_, cltrschedu0_.AD_Org_ID as ad_org_i3_352_0_, ( select rrmm.temp_ambiente_extrem from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula2_0_, ( select rrmm.expo_sustancias_quimi from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula3_0_, ( select rrmm.agentes_anestesicos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula4_0_, ( select rrmm.agentes_biologicos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula5_0_, ( select rrmm.agentes_citosaticos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula6_0_, ( select rrmm.alturas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula7_0_, ( select rrmm.alveolitis_alergica_extrinseca from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula8_0_, ( select rrmm.amianto from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula9_0_, ( select rrmm.apto_con_restricc from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula10_0_, ( select rrmm.apto_sin_restricc from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula11_0_, ( select rrmm.asma_laboral from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula12_0_, ( select rrmm.cloruro_vinilo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula13_0_, ( select rrmm.colinesterasa_plasmatica from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula14_0_, ( select rrmm.conduccion from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula15_0_, ( select rrmm.dermatosis_laboral from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula16_0_, ( select rrmm.diabetes from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula17_0_, ( SELECT historias.edad FROM opxhcli_rrmm AS rrmm LEFT JOIN Opxhcli_Historias AS historias ON rrmm.opxhcli_historias_id = historias.opxhcli_historias_id where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula18_0_, ( select rrmm.en_observacion from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula19_0_, ( select rrmm.espacios_confinados from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula20_0_, ( select rrmm.explosivos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula21_0_, ( select rrmm.hipercolesterolemia from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula22_0_, ( select rrmm.hipertension from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula23_0_, ( select rrmm.hipertrigliceridemia from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula24_0_, ( select rrmm.manipulacion_cargas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula25_0_, ( select rrmm.molestias_relac_pvd from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula26_0_, ( select rrmm.movimientos_miembro_superior from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula27_0_, ( select rrmm.neuropatias from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula28_0_, ( select rrmm.no_apto from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula29_0_, ( select rrmm.obesidad from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula30_0_, ( select rrmm.observaciones_apt_medica from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula31_0_, ( select rrmm.oxido_etileno from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula32_0_, ( select rrmm.plaguicidas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula33_0_, ( select rrmm.plomo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula34_0_, ( select rrmm.posturas_forzadas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula35_0_, ( select pu.puesto_trabajo from opxhcli_anam_laboral as an join opxhcli_puesto_trabajo as pu on an.opxhcli_puesto_trabajo_id = pu.opxhcli_puesto_trabajo_id join opxhcli_historias as h on h.opxhcli_historias_id = an.opxhcli_historias_id join opxhcli_rrmm as rrmm on rrmm.opxhcli_historias_id = h.opxhcli_historias_id where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id order by an.fecha_fin desc limit 1) as formula36_0_, ( select rrmm.pvd from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula37_0_, ( select rrmm.radiaciones_ionizantes from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula38_0_, ( select rrmm.ruido from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula39_0_, ( select rrmm.sedentarismo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula40_0_, ( select rrmm.se_objetiva_dato_patolo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula41_0_, ( SELECT historias.sexo FROM opxhcli_rrmm AS rrmm LEFT JOIN Opxhcli_Historias AS historias ON rrmm.opxhcli_historias_id = historias.opxhcli_historias_id where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula42_0_, ( select rrmm.signos_phanel_tinel from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula43_0_, ( select rrmm.silicosis_neumoconiosis from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula44_0_, ( select rrmm.sin_alteraciones from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula45_0_, ( select rrmm.sordera from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula46_0_, ( select rrmm.sospecha_epicondilitis from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula47_0_, ( select rrmm.tabaquismo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula48_0_, ( select rrmm.tipo_reconocimiento from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula49_0_, ( select rrmm.trauma_sonoro_pro from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula50_0_, ( select rrmm.vibraciones from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula51_0_ from cltr_schedule cltrschedu0_ where cltrschedu0_.Cltr_Schedule_ID in ('074BBAF087DB42EDB7A343848B914ED8', '3B779729128E430C82AFE2E3E02332C4', '58155205588D49BEAC2B20A748C31A86', '6715D2B05BF840A9839989BAF7D6C067', 'FA701D17EC8B47A9B696A57BA30ABC8B', 'FDDCDC900B944CAD886055931E38D660', '09D2B78CD4314452B07612FFA432C2B2', '1A05748128244F85917036964D3DCEBD', '272394A6B92E462EA54820FF58BB36E2', '6EB9108CF57C4139982799D41FA256D4', '8E769CABF887473AA36BCF7B60818694', 'B2883F69E1034B0D83D92CE0157F8294', 'B4539FBC9FC84354B1E53F6E63323BFF', 'D3BD4B1E7A10448F899D9F6632C29ACE', 'D577497E5D9A467F80F846FE78ADA03C', 'DA64BA042A0B476FA47BA9CEFD305FD1', 'E833729DBE604CC68B5A65811338A312', '12CE92A6697E459784AFFAF6008566AE', '1D05CB8B06AE4A97809832291C586A13', '25B4800B4AF442FF805ED6052CC269C1', '8DCE2E7ACED743EE9AF845CFAFBB6776', 'BA34566FB20743F597BD09AD22C57D73', 'CA4EE6B2F1274EC78CA0064BA568B91D', 'CC29FDC364F24773942D9DDACD407ADF', 'CE433C58FFEB44938E8A6940A9923D50', 'EF17FE8F84564649BCF8A3E0E2BBACA8', 'F6BDBF97835749CEA75273A533CDEA86', 'FC7232FAC19742EDBC0DB557960F888E', '2087B0F37FFA4A6281BDDE37E0499BC6', '38F7EAFCFCC945169A48FF2BB8063751', '5298192B17AE42F29106218D8F10AC1E', '57A879E509A0458783769A2BCB109EC6', '5FDED5AEFCD1449794979CA2DC51CA0F', 'C248AF83319D48929A981D9535BC7AF5', 'C2E51D1E142F43DAA64AC6CFF5203FE2', 'C8A2F7935D2647359D8C9394ABA5A96C', 'E8BB27E4E2E14DAE91947E9313394374', '1D31227D285F4525BD331B2DE803F2D9', '3F600EDE89244D21978A2983D63D2D0A', '44481DDCA6ED46EFAFACA0226C413A50', '71EED0F27E3946F2B921B0B3D6BC7130', '7E3562B80E394ABC94BAB7BF63B3BE28', '85816E010B054A56BDE136687583A30D', '98421016E11645468C816A74A1207DE9', 'B22BC582E49A40E899FFEA247953F50C', 'ED1DF1BA6A504F36BE8F8D4B6A2784DA', '0C44C6117CDB49689662ACF2DADC0031', '10565229EA1341378C36A66CA91B0AD6', '35349DDEFD6B4EAB910247F4D66FA6F0', '53D89777F3D44483BA76EE5104CB5855');

Date: 2026-07-15 12:31:49
Duration: 2s100ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select cltrschedu0_.Cltr_Schedule_ID as cltr_sch1_352_0_, cltrschedu0_.AD_Client_ID as ad_clien2_352_0_, cltrschedu0_.AD_Org_ID as ad_org_i3_352_0_, ( select rrmm.temp_ambiente_extrem from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula2_0_, ( select rrmm.expo_sustancias_quimi from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula3_0_, ( select rrmm.agentes_anestesicos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula4_0_, ( select rrmm.agentes_biologicos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula5_0_, ( select rrmm.agentes_citosaticos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula6_0_, ( select rrmm.alturas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula7_0_, ( select rrmm.alveolitis_alergica_extrinseca from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula8_0_, ( select rrmm.amianto from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula9_0_, ( select rrmm.apto_con_restricc from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula10_0_, ( select rrmm.apto_sin_restricc from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula11_0_, ( select rrmm.asma_laboral from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula12_0_, ( select rrmm.cloruro_vinilo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula13_0_, ( select rrmm.colinesterasa_plasmatica from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula14_0_, ( select rrmm.conduccion from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula15_0_, ( select rrmm.dermatosis_laboral from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula16_0_, ( select rrmm.diabetes from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula17_0_, ( SELECT historias.edad FROM opxhcli_rrmm AS rrmm LEFT JOIN Opxhcli_Historias AS historias ON rrmm.opxhcli_historias_id = historias.opxhcli_historias_id where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula18_0_, ( select rrmm.en_observacion from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula19_0_, ( select rrmm.espacios_confinados from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula20_0_, ( select rrmm.explosivos from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula21_0_, ( select rrmm.hipercolesterolemia from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula22_0_, ( select rrmm.hipertension from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula23_0_, ( select rrmm.hipertrigliceridemia from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula24_0_, ( select rrmm.manipulacion_cargas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula25_0_, ( select rrmm.molestias_relac_pvd from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula26_0_, ( select rrmm.movimientos_miembro_superior from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula27_0_, ( select rrmm.neuropatias from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula28_0_, ( select rrmm.no_apto from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula29_0_, ( select rrmm.obesidad from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula30_0_, ( select rrmm.observaciones_apt_medica from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula31_0_, ( select rrmm.oxido_etileno from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula32_0_, ( select rrmm.plaguicidas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula33_0_, ( select rrmm.plomo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula34_0_, ( select rrmm.posturas_forzadas from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula35_0_, ( select pu.puesto_trabajo from opxhcli_anam_laboral as an join opxhcli_puesto_trabajo as pu on an.opxhcli_puesto_trabajo_id = pu.opxhcli_puesto_trabajo_id join opxhcli_historias as h on h.opxhcli_historias_id = an.opxhcli_historias_id join opxhcli_rrmm as rrmm on rrmm.opxhcli_historias_id = h.opxhcli_historias_id where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id order by an.fecha_fin desc limit 1) as formula36_0_, ( select rrmm.pvd from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula37_0_, ( select rrmm.radiaciones_ionizantes from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula38_0_, ( select rrmm.ruido from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula39_0_, ( select rrmm.sedentarismo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula40_0_, ( select rrmm.se_objetiva_dato_patolo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula41_0_, ( SELECT historias.sexo FROM opxhcli_rrmm AS rrmm LEFT JOIN Opxhcli_Historias AS historias ON rrmm.opxhcli_historias_id = historias.opxhcli_historias_id where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula42_0_, ( select rrmm.signos_phanel_tinel from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula43_0_, ( select rrmm.silicosis_neumoconiosis from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula44_0_, ( select rrmm.sin_alteraciones from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula45_0_, ( select rrmm.sordera from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula46_0_, ( select rrmm.sospecha_epicondilitis from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula47_0_, ( select rrmm.tabaquismo from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula48_0_, ( select rrmm.tipo_reconocimiento from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula49_0_, ( select rrmm.trauma_sonoro_pro from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula50_0_, ( select rrmm.vibraciones from opxhcli_rrmm as rrmm where rrmm.opxhcli_rrmm_id = cltrschedu0_.em_opxhcli_rrmm_id) as formula51_0_ from cltr_schedule cltrschedu0_ where cltrschedu0_.Cltr_Schedule_ID in ('2D7A747D7960435C81D21D14AE9A2E90', '50E747E7DC644C3C8C7D0E5161FFE1D7', '64FA2865931746EF937FE93669B3778C', '732808D8FE704BCEB9E476DD401D3BB5', '8F2A31B7AE5A4B4EA6B9DA32F5A371E3', 'AA44331221A74927A746998D839E665D', 'B78A1FEF4B85401B987406D6C39370D6', 'BE103B4D72A240478E3EB0F277A8EE52', 'CF3B82F31829474CB56A1A90BE40E916', 'DFCC283B41B14B49A57FB71D87728460', '025176C203AE4BC7B78E10EA80193409', '2A151FD31E7049A2A7542047916624D3', '346AAEDDB30A4F088497445AF8D8C8F0', '39816BAB39CB4809AC7D05D0175526DE', '6A7F23AB3C70450C8B4621C339460FEA', '6C49D6A5E1A04D07A57C8D4836D1449F', '7ED9FBAEB24A40878F7C2BA00EC7D8BC', 'B3EDF19CE0174F34AB5F5AFDDD4869E0', 'BE2D217B923A409190558E4E4475469C', 'CD137CE184C54C4884135AA790132B6F', '3B57196F556A41C9B60ACE22D72CDAB1', '55FE210430AA446B89CD037CA283143D', '7EECAD3F648441D097925481C158BD69', '7FEEE07B02474EB0B9689652874AF28F', 'B34DC25EA11644209D14028F1ED3C66A', 'C6E1542EC2BD481D963BACDC7B2038EC', 'EC5793BCB308462FA6197AA6A081BC6D', 'F044D4AC9D7442299787F5979170F570', '0667BF9D567A42B39821284BAFF0B304', '27BC83098D4A4432893E613BBD76C17B', '3D0C6AB532084B119803A8DFA9AA66F0', '499F03E722624EFBAF97FC12D9199CD5', '4E88AD912B274E1E84958FB0DECAEEFD', '4FE96ADD915743ACB15821EC42895852', '51A866AF6A4C4B00B6C22FF45F004441', '589E6883188D45FB9D7257A1D501EC78', '91559F5310C24F1D8D72B826EEBF586F', '9FD829A0D0DE4F44B36465A3CFCC327A', 'A11121942BCC4332AB64F80C521DA2F0', 'A7813A3E6FB94168A1E3F01DC030E059', 'AB6F325B48044D219E5E5117E86B56B5', 'BE61D694544942C7AE273F1B5AD1E588', 'C8FB3112F2DD4785AEF1F03BEFF29912', 'DC881F32D6844150A3D3A22A11EF2675', 'E033E9AA2CD44B8F9A7CAD2170BC6871', 'FB63ADDB4EFA42C182DBBAD58B13F465', 'FEA8AE3CA3744028A03943CFF605FE26', '1672752181E2453591A188E5462D41A2', '1F04FC4FFBC84AE2A08317718D518112', '44DFB3A987734DBEB06FDBD986AC0106');

Date: 2026-07-15 11:49:06
Duration: 2s85ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select cltr_sched0_.Cltr_Schedule_ID as cltr_sch1_352_, cltr_sched0_.AD_Client_ID as ad_clien2_352_, cltr_sched0_.AD_Org_ID as ad_org_i3_352_, cltr_sched0_.Isactive as isactive4_352_, cltr_sched0_.Created as created5_352_, cltr_sched0_.Createdby as createdb6_352_, cltr_sched0_.Updated as updated7_352_, cltr_sched0_.Updatedby as updatedb8_352_, cltr_sched0_.Remarks as remarks9_352_, cltr_sched0_.Clmd_Medicalfield_ID as clmd_me10_352_, cltr_sched0_.Consultday as consult11_352_, cltr_sched0_.Consulthour as consult12_352_, cltr_sched0_.Totalamt as totalam13_352_, cltr_sched0_.FIN_Paymentmethod_ID as fin_pay14_352_, cltr_sched0_.Pending as pending15_352_, cltr_sched0_.Payed as payed16_352_, cltr_sched0_.Totalpayed as totalpa17_352_, cltr_sched0_.Clmd_Doctors as clmd_do18_352_, cltr_sched0_.Clmd_Patients as clmd_pa19_352_, cltr_sched0_.DAY_Hour as day_hou20_352_, cltr_sched0_.Clmd_Consulttype_ID as clmd_co21_352_, cltr_sched0_.Status as status22_352_, cltr_sched0_.Weekday as weekday23_352_, cltr_sched0_.Phone as phone24_352_, cltr_sched0_.Istaken as istaken25_352_, cltr_sched0_.Btninvoice as btninvo26_352_, cltr_sched0_.Invoiced as invoice27_352_, cltr_sched0_.C_Invoice_ID as c_invoi28_352_, cltr_sched0_.Tarjeta_Citaprevia as tarjeta29_352_, cltr_sched0_.EM_Opxhcli_Lineas_Hc_ID as em_opxh30_352_, cltr_sched0_.EM_Opxhcli_C_Bpartner_ID as em_opxh31_352_, cltr_sched0_.EM_Opxhcli_Rrmm_ID as em_opxh32_352_, cltr_sched0_.EM_Opxhcli_Proceso_Citas as em_opxh33_352_, cltr_sched0_.EM_Opxhcli_Btn_Certificado as em_opxh34_352_, cltr_sched0_.EM_Clmd_Consultation as em_clmd35_352_, cltr_sched0_.EM_Opxhcli_Prot_Aplicados as em_opxh36_352_ from cltr_schedule cltr_sched0_ cross join C_BPartner businesspa1_ where cltr_sched0_.Clmd_Patients = businesspa1_.C_BPartner_ID and (upper(businesspa1_.TaxID) like upper('%X9%') escape '|') and cltr_sched0_.Clmd_Medicalfield_ID = 'CF51DD3E7BFD47F7831AF3674A67F76F' and (cltr_sched0_.AD_Org_ID in ('E71E99D977C34EB8B2B2BE2FE1F5D81E', '01FC4F43C9AC4A2B81D1BC5AF3286428', 'FE5FB16EB45A440F8A40CDA05C33345D', '58528B35ABF0464F8B15C4791EB5DA2A', 'BF2402CDA819493B87AD24A3C87AD885', '96C2971E69BC4A6FAF6DBE7E3558ED33', 'EA64FBE3DA9B456D9458015D08821793', '0', '4719EC141AF0400D99A6417915FCC2F6', 'DBDC39875B8B4F23A94E6CD2B6FD7510', 'AE7761AC3D56449885017C3DBA14BB2A', 'FF808081318B15B301318B3A2DFE2EA3', 'D03A965CB1C44BE38BD25255FFC3720B')) and (cltr_sched0_.AD_Client_ID in ('FF808081318B15B301318B27D6370001', '0')) order by cltr_sched0_.Consulthour, cltr_sched0_.Cltr_Schedule_ID limit '101';

Date: 2026-07-15 11:29:55
Duration: 1s223ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select cltr_sched0_.Cltr_Schedule_ID as cltr_sch1_352_, cltr_sched0_.AD_Client_ID as ad_clien2_352_, cltr_sched0_.AD_Org_ID as ad_org_i3_352_, cltr_sched0_.Isactive as isactive4_352_, cltr_sched0_.Created as created5_352_, cltr_sched0_.Createdby as createdb6_352_, cltr_sched0_.Updated as updated7_352_, cltr_sched0_.Updatedby as updatedb8_352_, cltr_sched0_.Remarks as remarks9_352_, cltr_sched0_.Clmd_Medicalfield_ID as clmd_me10_352_, cltr_sched0_.Consultday as consult11_352_, cltr_sched0_.Consulthour as consult12_352_, cltr_sched0_.Totalamt as totalam13_352_, cltr_sched0_.FIN_Paymentmethod_ID as fin_pay14_352_, cltr_sched0_.Pending as pending15_352_, cltr_sched0_.Payed as payed16_352_, cltr_sched0_.Totalpayed as totalpa17_352_, cltr_sched0_.Clmd_Doctors as clmd_do18_352_, cltr_sched0_.Clmd_Patients as clmd_pa19_352_, cltr_sched0_.DAY_Hour as day_hou20_352_, cltr_sched0_.Clmd_Consulttype_ID as clmd_co21_352_, cltr_sched0_.Status as status22_352_, cltr_sched0_.Weekday as weekday23_352_, cltr_sched0_.Phone as phone24_352_, cltr_sched0_.Istaken as istaken25_352_, cltr_sched0_.Btninvoice as btninvo26_352_, cltr_sched0_.Invoiced as invoice27_352_, cltr_sched0_.C_Invoice_ID as c_invoi28_352_, cltr_sched0_.Tarjeta_Citaprevia as tarjeta29_352_, cltr_sched0_.EM_Opxhcli_Lineas_Hc_ID as em_opxh30_352_, cltr_sched0_.EM_Opxhcli_C_Bpartner_ID as em_opxh31_352_, cltr_sched0_.EM_Opxhcli_Rrmm_ID as em_opxh32_352_, cltr_sched0_.EM_Opxhcli_Proceso_Citas as em_opxh33_352_, cltr_sched0_.EM_Opxhcli_Btn_Certificado as em_opxh34_352_, cltr_sched0_.EM_Clmd_Consultation as em_clmd35_352_, cltr_sched0_.EM_Opxhcli_Prot_Aplicados as em_opxh36_352_ from cltr_schedule cltr_sched0_ cross join C_BPartner businesspa1_ where cltr_sched0_.Clmd_Patients = businesspa1_.C_BPartner_ID and (upper(businesspa1_.TaxID) like upper('%X98%') escape '|') and cltr_sched0_.Clmd_Medicalfield_ID = 'CF51DD3E7BFD47F7831AF3674A67F76F' and (cltr_sched0_.AD_Org_ID in ('E71E99D977C34EB8B2B2BE2FE1F5D81E', '01FC4F43C9AC4A2B81D1BC5AF3286428', 'FE5FB16EB45A440F8A40CDA05C33345D', '58528B35ABF0464F8B15C4791EB5DA2A', 'BF2402CDA819493B87AD24A3C87AD885', '96C2971E69BC4A6FAF6DBE7E3558ED33', 'EA64FBE3DA9B456D9458015D08821793', '0', '4719EC141AF0400D99A6417915FCC2F6', 'DBDC39875B8B4F23A94E6CD2B6FD7510', 'AE7761AC3D56449885017C3DBA14BB2A', 'FF808081318B15B301318B3A2DFE2EA3', 'D03A965CB1C44BE38BD25255FFC3720B')) and (cltr_sched0_.AD_Client_ID in ('FF808081318B15B301318B27D6370001', '0')) order by cltr_sched0_.Consulthour, cltr_sched0_.Cltr_Schedule_ID limit '101';

Date: 2026-07-15 11:29:56
Duration: 1s31ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

insert into cltr_scheduleline (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, M_Product_ID, Pricelist, Priceactual, Remarks, Qty, Cltr_Scheduleline_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13);

Date: 2026-07-15 11:29:54
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select businesspa0_.C_BPartner_ID as c_bpartn1_187_, businesspa0_.AD_Client_ID as ad_clien2_187_, businesspa0_.AD_Org_ID as ad_org_i3_187_, businesspa0_.IsActive as isactive4_187_, businesspa0_.Created as created5_187_, businesspa0_.CreatedBy as createdb6_187_, businesspa0_.Updated as updated7_187_, businesspa0_.UpdatedBy as updatedb8_187_, businesspa0_.Value as value9_187_, businesspa0_.Name as name10_187_, businesspa0_.Name2 as name11_187_, businesspa0_.Description as descrip12_187_, businesspa0_.IsSummary as issumma13_187_, businesspa0_.C_BP_Group_ID as c_bp_gr14_187_, businesspa0_.IsOneTime as isoneti15_187_, businesspa0_.IsProspect as isprosp16_187_, businesspa0_.IsVendor as isvendo17_187_, businesspa0_.IsCustomer as iscusto18_187_, businesspa0_.IsEmployee as isemplo19_187_, businesspa0_.IsSalesRep as issales20_187_, businesspa0_.ReferenceNo as referen21_187_, businesspa0_.DUNS as duns22_187_, businesspa0_.URL as url23_187_, businesspa0_.AD_Language as ad_lang24_187_, businesspa0_.TaxID as taxid25_187_, businesspa0_.IsTaxExempt as istaxex26_187_, businesspa0_.C_InvoiceSchedule_ID as c_invoi27_187_, businesspa0_.Rating as rating28_187_, businesspa0_.SalesVolume as salesvo29_187_, businesspa0_.NumberEmployees as numbere30_187_, businesspa0_.NAICS as naics31_187_, businesspa0_.FirstSale as firstsa32_187_, businesspa0_.AcqusitionCost as acqusit33_187_, businesspa0_.PotentialLifeTimeValue as potenti34_187_, businesspa0_.ActualLifeTimeValue as actuall35_187_, businesspa0_.ShareOfCustomer as shareof36_187_, businesspa0_.PaymentRule as payment37_187_, businesspa0_.SO_CreditLimit as so_cred38_187_, businesspa0_.SO_CreditUsed as so_cred39_187_, businesspa0_.C_PaymentTerm_ID as c_payme40_187_, businesspa0_.M_PriceList_ID as m_price41_187_, businesspa0_.IsDiscountPrinted as isdisco42_187_, businesspa0_.SO_Description as so_desc43_187_, businesspa0_.POReference as porefer44_187_, businesspa0_.PaymentRulePO as payment45_187_, businesspa0_.PO_PriceList_ID as po_pric46_187_, businesspa0_.PO_PaymentTerm_ID as po_paym47_187_, businesspa0_.DocumentCopies as documen48_187_, businesspa0_.C_Greeting_ID as c_greet49_187_, businesspa0_.InvoiceRule as invoice50_187_, businesspa0_.DeliveryRule as deliver51_187_, businesspa0_.DeliveryViaRule as deliver52_187_, businesspa0_.SalesRep_ID as salesre53_187_, businesspa0_.BPartner_Parent_ID as bpartne54_187_, businesspa0_.SOCreditStatus as socredi55_187_, businesspa0_.AD_Forced_Org_ID as ad_forc56_187_, businesspa0_.ShowPriceInOrder as showpri57_187_, businesspa0_.Invoicegrouping as invoice58_187_, businesspa0_.FixMonthDay as fixmont59_187_, businesspa0_.FixMonthDay2 as fixmont60_187_, businesspa0_.Fixmonthday3 as fixmont61_187_, businesspa0_.Isworker as isworke62_187_, businesspa0_.UPC as upc63_187_, businesspa0_.C_Salary_Category_ID as c_salar64_187_, businesspa0_.Invoice_Printformat as invoice65_187_, businesspa0_.Last_Days as last_da66_187_, businesspa0_.PO_Bankaccount_ID as po_bank67_187_, businesspa0_.PO_BP_TaxCategory_ID as po_bp_t68_187_, businesspa0_.PO_Fixmonthday as po_fixm69_187_, businesspa0_.PO_Fixmonthday2 as po_fixm70_187_, businesspa0_.PO_Fixmonthday3 as po_fixm71_187_, businesspa0_.SO_Bankaccount_ID as so_bank72_187_, businesspa0_.SO_Bp_Taxcategory_ID as so_bp_t73_187_, businesspa0_.Fiscalcode as fiscalc74_187_, businesspa0_.Isofiscalcode as isofisc75_187_, businesspa0_.EM_Einv_Einvoice as em_einv76_187_, businesspa0_.PO_C_Incoterms_ID as po_c_in77_187_, businesspa0_.EM_Einv_Format_Id as em_einv78_187_, businesspa0_.SO_C_Incoterms_ID as so_c_in79_187_, businesspa0_.EM_Einv_Platform_Id as em_einv80_187_, businesspa0_.FIN_Paymentmethod_ID as fin_pay81_187_, businesspa0_.EM_Einv_Email as em_einv82_187_, businesspa0_.PO_Paymentmethod_ID as po_paym83_187_, businesspa0_.FIN_Financial_Account_ID as fin_fin84_187_, businesspa0_.EM_Einv_Deliverymode as em_einv85_187_, businesspa0_.PO_Financial_Account_ID as po_fina86_187_, businesspa0_.Customer_Blocking as custome87_187_, businesspa0_.Vendor_Blocking as vendor_88_187_, businesspa0_.SO_Payment_Blocking as so_paym89_187_, businesspa0_.PO_Payment_Blocking as po_paym90_187_, businesspa0_.SO_Invoice_Blocking as so_invo91_187_, businesspa0_.PO_Invoice_Blocking as po_invo92_187_, businesspa0_.EM_Clmd_Custtype as em_clmd93_187_, businesspa0_.SO_Order_Blocking as so_orde94_187_, businesspa0_.EM_Clmd_Patients_ID as em_clmd95_187_, businesspa0_.PO_Order_Blocking as po_orde96_187_, businesspa0_.EM_Clmd_Ispatient as em_clmd97_187_, businesspa0_.SO_Goods_Blocking as so_good98_187_, businesspa0_.EM_Clmd_Company_ID as em_clmd99_187_, businesspa0_.PO_Goods_Blocking as po_goo100_187_, businesspa0_.Iscashvat as iscash101_187_, businesspa0_.EM_Clmd_Laboratory_ID as em_clm102_187_, businesspa0_.EM_Clmd_Insurance_Co_ID as em_clm103_187_, businesspa0_.Update_Currency as update104_187_, businesspa0_.BP_Currency_ID as bp_cur105_187_, businesspa0_.EM_Clmd_Mutual_Ins_Co_ID as em_clm106_187_, businesspa0_.Birthplace as birthp107_187_, businesspa0_.EM_Clmd_Nurse_ID as em_clm108_187_, businesspa0_.Birthday as birthd109_187_, businesspa0_.EM_Clmd_Assistant_ID as em_clm110_187_, businesspa0_.EM_Clmd_Doctors_ID as em_clm111_187_, businesspa0_.Is_Customer_Consent as is_cus112_187_, businesspa0_.EM_Clmd_Empltype as em_clm113_187_, businesspa0_.EM_Clmd_Phone as em_clm114_187_, businesspa0_.EM_Obsepad_Mandate_Identifier as em_obs115_187_, businesspa0_.EM_Clmd_Invoicepatient as em_clm116_187_, businesspa0_.EM_Obsepad_Mandate_Date as em_obs117_187_, businesspa0_.EM_Aeatsii_Rep_Taxid as em_aea118_187_, businesspa0_.EM_Aeatsii_Menor as em_aea119_187_, businesspa0_.EM_Pdp_Stamp_ID as em_pdp120_187_, businesspa0_.EM_Aeatsii_Defaultsiikey as em_aea121_187_, businesspa0_.EM_Aeatsii_Siikeylist as em_aea122_187_, businesspa0_.EM_Tbai_Issimplifiedinv as em_tba123_187_, businesspa0_.EM_OBTIK_Tax_ID_Key as em_obt124_187_ from C_BPartner businesspa0_ where (upper(businesspa0_.TaxID) like upper('%FELIX%OCTAVIO%LIZANO%MARTINEZ%') escape '|' or upper(businesspa0_.Name) like upper('%FELIX%OCTAVIO%LIZANO%MARTINEZ%') escape '|' or upper(businesspa0_.Name) like upper('%FELIX%OCTAVIO%LIZANO%MARTINEZ%') escape '|') and (businesspa0_.AD_Org_ID in ('0', '4719EC141AF0400D99A6417915FCC2F6', 'FE5FB16EB45A440F8A40CDA05C33345D', 'FF808081318B15B301318B3A2DFE2EA3')) and isCustomer = 'Y' and (c_bp_group_id in ( select businesspa1_.C_BP_Group_ID from C_BP_Group businesspa1_ where em_clmd_ispatient = 'Y')) and (businesspa0_.AD_Client_ID in ('FF808081318B15B301318B27D6370001', '0')) and businesspa0_.IsActive = 'Y' order by businesspa0_.Name, businesspa0_.C_BPartner_ID limit '76';

Date: 2026-07-15 13:33:57
Duration: 1s122ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select businesspa0_.C_BPartner_ID as c_bpartn1_187_, businesspa0_.AD_Client_ID as ad_clien2_187_, businesspa0_.AD_Org_ID as ad_org_i3_187_, businesspa0_.IsActive as isactive4_187_, businesspa0_.Created as created5_187_, businesspa0_.CreatedBy as createdb6_187_, businesspa0_.Updated as updated7_187_, businesspa0_.UpdatedBy as updatedb8_187_, businesspa0_.Value as value9_187_, businesspa0_.Name as name10_187_, businesspa0_.Name2 as name11_187_, businesspa0_.Description as descrip12_187_, businesspa0_.IsSummary as issumma13_187_, businesspa0_.C_BP_Group_ID as c_bp_gr14_187_, businesspa0_.IsOneTime as isoneti15_187_, businesspa0_.IsProspect as isprosp16_187_, businesspa0_.IsVendor as isvendo17_187_, businesspa0_.IsCustomer as iscusto18_187_, businesspa0_.IsEmployee as isemplo19_187_, businesspa0_.IsSalesRep as issales20_187_, businesspa0_.ReferenceNo as referen21_187_, businesspa0_.DUNS as duns22_187_, businesspa0_.URL as url23_187_, businesspa0_.AD_Language as ad_lang24_187_, businesspa0_.TaxID as taxid25_187_, businesspa0_.IsTaxExempt as istaxex26_187_, businesspa0_.C_InvoiceSchedule_ID as c_invoi27_187_, businesspa0_.Rating as rating28_187_, businesspa0_.SalesVolume as salesvo29_187_, businesspa0_.NumberEmployees as numbere30_187_, businesspa0_.NAICS as naics31_187_, businesspa0_.FirstSale as firstsa32_187_, businesspa0_.AcqusitionCost as acqusit33_187_, businesspa0_.PotentialLifeTimeValue as potenti34_187_, businesspa0_.ActualLifeTimeValue as actuall35_187_, businesspa0_.ShareOfCustomer as shareof36_187_, businesspa0_.PaymentRule as payment37_187_, businesspa0_.SO_CreditLimit as so_cred38_187_, businesspa0_.SO_CreditUsed as so_cred39_187_, businesspa0_.C_PaymentTerm_ID as c_payme40_187_, businesspa0_.M_PriceList_ID as m_price41_187_, businesspa0_.IsDiscountPrinted as isdisco42_187_, businesspa0_.SO_Description as so_desc43_187_, businesspa0_.POReference as porefer44_187_, businesspa0_.PaymentRulePO as payment45_187_, businesspa0_.PO_PriceList_ID as po_pric46_187_, businesspa0_.PO_PaymentTerm_ID as po_paym47_187_, businesspa0_.DocumentCopies as documen48_187_, businesspa0_.C_Greeting_ID as c_greet49_187_, businesspa0_.InvoiceRule as invoice50_187_, businesspa0_.DeliveryRule as deliver51_187_, businesspa0_.DeliveryViaRule as deliver52_187_, businesspa0_.SalesRep_ID as salesre53_187_, businesspa0_.BPartner_Parent_ID as bpartne54_187_, businesspa0_.SOCreditStatus as socredi55_187_, businesspa0_.AD_Forced_Org_ID as ad_forc56_187_, businesspa0_.ShowPriceInOrder as showpri57_187_, businesspa0_.Invoicegrouping as invoice58_187_, businesspa0_.FixMonthDay as fixmont59_187_, businesspa0_.FixMonthDay2 as fixmont60_187_, businesspa0_.Fixmonthday3 as fixmont61_187_, businesspa0_.Isworker as isworke62_187_, businesspa0_.UPC as upc63_187_, businesspa0_.C_Salary_Category_ID as c_salar64_187_, businesspa0_.Invoice_Printformat as invoice65_187_, businesspa0_.Last_Days as last_da66_187_, businesspa0_.PO_Bankaccount_ID as po_bank67_187_, businesspa0_.PO_BP_TaxCategory_ID as po_bp_t68_187_, businesspa0_.PO_Fixmonthday as po_fixm69_187_, businesspa0_.PO_Fixmonthday2 as po_fixm70_187_, businesspa0_.PO_Fixmonthday3 as po_fixm71_187_, businesspa0_.SO_Bankaccount_ID as so_bank72_187_, businesspa0_.SO_Bp_Taxcategory_ID as so_bp_t73_187_, businesspa0_.Fiscalcode as fiscalc74_187_, businesspa0_.Isofiscalcode as isofisc75_187_, businesspa0_.EM_Einv_Einvoice as em_einv76_187_, businesspa0_.PO_C_Incoterms_ID as po_c_in77_187_, businesspa0_.EM_Einv_Format_Id as em_einv78_187_, businesspa0_.SO_C_Incoterms_ID as so_c_in79_187_, businesspa0_.EM_Einv_Platform_Id as em_einv80_187_, businesspa0_.FIN_Paymentmethod_ID as fin_pay81_187_, businesspa0_.EM_Einv_Email as em_einv82_187_, businesspa0_.PO_Paymentmethod_ID as po_paym83_187_, businesspa0_.FIN_Financial_Account_ID as fin_fin84_187_, businesspa0_.EM_Einv_Deliverymode as em_einv85_187_, businesspa0_.PO_Financial_Account_ID as po_fina86_187_, businesspa0_.Customer_Blocking as custome87_187_, businesspa0_.Vendor_Blocking as vendor_88_187_, businesspa0_.SO_Payment_Blocking as so_paym89_187_, businesspa0_.PO_Payment_Blocking as po_paym90_187_, businesspa0_.SO_Invoice_Blocking as so_invo91_187_, businesspa0_.PO_Invoice_Blocking as po_invo92_187_, businesspa0_.EM_Clmd_Custtype as em_clmd93_187_, businesspa0_.SO_Order_Blocking as so_orde94_187_, businesspa0_.EM_Clmd_Patients_ID as em_clmd95_187_, businesspa0_.PO_Order_Blocking as po_orde96_187_, businesspa0_.EM_Clmd_Ispatient as em_clmd97_187_, businesspa0_.SO_Goods_Blocking as so_good98_187_, businesspa0_.EM_Clmd_Company_ID as em_clmd99_187_, businesspa0_.PO_Goods_Blocking as po_goo100_187_, businesspa0_.Iscashvat as iscash101_187_, businesspa0_.EM_Clmd_Laboratory_ID as em_clm102_187_, businesspa0_.EM_Clmd_Insurance_Co_ID as em_clm103_187_, businesspa0_.Update_Currency as update104_187_, businesspa0_.BP_Currency_ID as bp_cur105_187_, businesspa0_.EM_Clmd_Mutual_Ins_Co_ID as em_clm106_187_, businesspa0_.Birthplace as birthp107_187_, businesspa0_.EM_Clmd_Nurse_ID as em_clm108_187_, businesspa0_.Birthday as birthd109_187_, businesspa0_.EM_Clmd_Assistant_ID as em_clm110_187_, businesspa0_.EM_Clmd_Doctors_ID as em_clm111_187_, businesspa0_.Is_Customer_Consent as is_cus112_187_, businesspa0_.EM_Clmd_Empltype as em_clm113_187_, businesspa0_.EM_Clmd_Phone as em_clm114_187_, businesspa0_.EM_Obsepad_Mandate_Identifier as em_obs115_187_, businesspa0_.EM_Clmd_Invoicepatient as em_clm116_187_, businesspa0_.EM_Obsepad_Mandate_Date as em_obs117_187_, businesspa0_.EM_Aeatsii_Rep_Taxid as em_aea118_187_, businesspa0_.EM_Aeatsii_Menor as em_aea119_187_, businesspa0_.EM_Pdp_Stamp_ID as em_pdp120_187_, businesspa0_.EM_Aeatsii_Defaultsiikey as em_aea121_187_, businesspa0_.EM_Aeatsii_Siikeylist as em_aea122_187_, businesspa0_.EM_Tbai_Issimplifiedinv as em_tba123_187_, businesspa0_.EM_OBTIK_Tax_ID_Key as em_obt124_187_ from C_BPartner businesspa0_ where (upper(businesspa0_.TaxID) like upper('%FELIX%OCTAVIO%LIZANO%MARTINE%') escape '|' or upper(businesspa0_.Name) like upper('%FELIX%OCTAVIO%LIZANO%MARTINE%') escape '|' or upper(businesspa0_.Name) like upper('%FELIX%OCTAVIO%LIZANO%MARTINE%') escape '|') and (businesspa0_.AD_Org_ID in ('0', '4719EC141AF0400D99A6417915FCC2F6', 'FE5FB16EB45A440F8A40CDA05C33345D', 'FF808081318B15B301318B3A2DFE2EA3')) and isCustomer = 'Y' and (c_bp_group_id in ( select businesspa1_.C_BP_Group_ID from C_BP_Group businesspa1_ where em_clmd_ispatient = 'Y')) and (businesspa0_.AD_Client_ID in ('FF808081318B15B301318B27D6370001', '0')) and businesspa0_.IsActive = 'Y' order by businesspa0_.Name, businesspa0_.C_BPartner_ID limit '76';

Date: 2026-07-15 13:33:54
Duration: 1s107ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select businesspa0_.C_BPartner_ID as c_bpartn1_187_, businesspa0_.AD_Client_ID as ad_clien2_187_, businesspa0_.AD_Org_ID as ad_org_i3_187_, businesspa0_.IsActive as isactive4_187_, businesspa0_.Created as created5_187_, businesspa0_.CreatedBy as createdb6_187_, businesspa0_.Updated as updated7_187_, businesspa0_.UpdatedBy as updatedb8_187_, businesspa0_.Value as value9_187_, businesspa0_.Name as name10_187_, businesspa0_.Name2 as name11_187_, businesspa0_.Description as descrip12_187_, businesspa0_.IsSummary as issumma13_187_, businesspa0_.C_BP_Group_ID as c_bp_gr14_187_, businesspa0_.IsOneTime as isoneti15_187_, businesspa0_.IsProspect as isprosp16_187_, businesspa0_.IsVendor as isvendo17_187_, businesspa0_.IsCustomer as iscusto18_187_, businesspa0_.IsEmployee as isemplo19_187_, businesspa0_.IsSalesRep as issales20_187_, businesspa0_.ReferenceNo as referen21_187_, businesspa0_.DUNS as duns22_187_, businesspa0_.URL as url23_187_, businesspa0_.AD_Language as ad_lang24_187_, businesspa0_.TaxID as taxid25_187_, businesspa0_.IsTaxExempt as istaxex26_187_, businesspa0_.C_InvoiceSchedule_ID as c_invoi27_187_, businesspa0_.Rating as rating28_187_, businesspa0_.SalesVolume as salesvo29_187_, businesspa0_.NumberEmployees as numbere30_187_, businesspa0_.NAICS as naics31_187_, businesspa0_.FirstSale as firstsa32_187_, businesspa0_.AcqusitionCost as acqusit33_187_, businesspa0_.PotentialLifeTimeValue as potenti34_187_, businesspa0_.ActualLifeTimeValue as actuall35_187_, businesspa0_.ShareOfCustomer as shareof36_187_, businesspa0_.PaymentRule as payment37_187_, businesspa0_.SO_CreditLimit as so_cred38_187_, businesspa0_.SO_CreditUsed as so_cred39_187_, businesspa0_.C_PaymentTerm_ID as c_payme40_187_, businesspa0_.M_PriceList_ID as m_price41_187_, businesspa0_.IsDiscountPrinted as isdisco42_187_, businesspa0_.SO_Description as so_desc43_187_, businesspa0_.POReference as porefer44_187_, businesspa0_.PaymentRulePO as payment45_187_, businesspa0_.PO_PriceList_ID as po_pric46_187_, businesspa0_.PO_PaymentTerm_ID as po_paym47_187_, businesspa0_.DocumentCopies as documen48_187_, businesspa0_.C_Greeting_ID as c_greet49_187_, businesspa0_.InvoiceRule as invoice50_187_, businesspa0_.DeliveryRule as deliver51_187_, businesspa0_.DeliveryViaRule as deliver52_187_, businesspa0_.SalesRep_ID as salesre53_187_, businesspa0_.BPartner_Parent_ID as bpartne54_187_, businesspa0_.SOCreditStatus as socredi55_187_, businesspa0_.AD_Forced_Org_ID as ad_forc56_187_, businesspa0_.ShowPriceInOrder as showpri57_187_, businesspa0_.Invoicegrouping as invoice58_187_, businesspa0_.FixMonthDay as fixmont59_187_, businesspa0_.FixMonthDay2 as fixmont60_187_, businesspa0_.Fixmonthday3 as fixmont61_187_, businesspa0_.Isworker as isworke62_187_, businesspa0_.UPC as upc63_187_, businesspa0_.C_Salary_Category_ID as c_salar64_187_, businesspa0_.Invoice_Printformat as invoice65_187_, businesspa0_.Last_Days as last_da66_187_, businesspa0_.PO_Bankaccount_ID as po_bank67_187_, businesspa0_.PO_BP_TaxCategory_ID as po_bp_t68_187_, businesspa0_.PO_Fixmonthday as po_fixm69_187_, businesspa0_.PO_Fixmonthday2 as po_fixm70_187_, businesspa0_.PO_Fixmonthday3 as po_fixm71_187_, businesspa0_.SO_Bankaccount_ID as so_bank72_187_, businesspa0_.SO_Bp_Taxcategory_ID as so_bp_t73_187_, businesspa0_.Fiscalcode as fiscalc74_187_, businesspa0_.Isofiscalcode as isofisc75_187_, businesspa0_.EM_Einv_Einvoice as em_einv76_187_, businesspa0_.PO_C_Incoterms_ID as po_c_in77_187_, businesspa0_.EM_Einv_Format_Id as em_einv78_187_, businesspa0_.SO_C_Incoterms_ID as so_c_in79_187_, businesspa0_.EM_Einv_Platform_Id as em_einv80_187_, businesspa0_.FIN_Paymentmethod_ID as fin_pay81_187_, businesspa0_.EM_Einv_Email as em_einv82_187_, businesspa0_.PO_Paymentmethod_ID as po_paym83_187_, businesspa0_.FIN_Financial_Account_ID as fin_fin84_187_, businesspa0_.EM_Einv_Deliverymode as em_einv85_187_, businesspa0_.PO_Financial_Account_ID as po_fina86_187_, businesspa0_.Customer_Blocking as custome87_187_, businesspa0_.Vendor_Blocking as vendor_88_187_, businesspa0_.SO_Payment_Blocking as so_paym89_187_, businesspa0_.PO_Payment_Blocking as po_paym90_187_, businesspa0_.SO_Invoice_Blocking as so_invo91_187_, businesspa0_.PO_Invoice_Blocking as po_invo92_187_, businesspa0_.EM_Clmd_Custtype as em_clmd93_187_, businesspa0_.SO_Order_Blocking as so_orde94_187_, businesspa0_.EM_Clmd_Patients_ID as em_clmd95_187_, businesspa0_.PO_Order_Blocking as po_orde96_187_, businesspa0_.EM_Clmd_Ispatient as em_clmd97_187_, businesspa0_.SO_Goods_Blocking as so_good98_187_, businesspa0_.EM_Clmd_Company_ID as em_clmd99_187_, businesspa0_.PO_Goods_Blocking as po_goo100_187_, businesspa0_.Iscashvat as iscash101_187_, businesspa0_.EM_Clmd_Laboratory_ID as em_clm102_187_, businesspa0_.EM_Clmd_Insurance_Co_ID as em_clm103_187_, businesspa0_.Update_Currency as update104_187_, businesspa0_.BP_Currency_ID as bp_cur105_187_, businesspa0_.EM_Clmd_Mutual_Ins_Co_ID as em_clm106_187_, businesspa0_.Birthplace as birthp107_187_, businesspa0_.EM_Clmd_Nurse_ID as em_clm108_187_, businesspa0_.Birthday as birthd109_187_, businesspa0_.EM_Clmd_Assistant_ID as em_clm110_187_, businesspa0_.EM_Clmd_Doctors_ID as em_clm111_187_, businesspa0_.Is_Customer_Consent as is_cus112_187_, businesspa0_.EM_Clmd_Empltype as em_clm113_187_, businesspa0_.EM_Clmd_Phone as em_clm114_187_, businesspa0_.EM_Obsepad_Mandate_Identifier as em_obs115_187_, businesspa0_.EM_Clmd_Invoicepatient as em_clm116_187_, businesspa0_.EM_Obsepad_Mandate_Date as em_obs117_187_, businesspa0_.EM_Aeatsii_Rep_Taxid as em_aea118_187_, businesspa0_.EM_Aeatsii_Menor as em_aea119_187_, businesspa0_.EM_Pdp_Stamp_ID as em_pdp120_187_, businesspa0_.EM_Aeatsii_Defaultsiikey as em_aea121_187_, businesspa0_.EM_Aeatsii_Siikeylist as em_aea122_187_, businesspa0_.EM_Tbai_Issimplifiedinv as em_tba123_187_, businesspa0_.EM_OBTIK_Tax_ID_Key as em_obt124_187_ from C_BPartner businesspa0_ where (upper(businesspa0_.TaxID) like upper('%JONAS%ARIEL%SUTIL%THIST%') escape '|' or upper(businesspa0_.Name) like upper('%JONAS%ARIEL%SUTIL%THIST%') escape '|' or upper(businesspa0_.Name) like upper('%JONAS%ARIEL%SUTIL%THIST%') escape '|') and (businesspa0_.AD_Org_ID in ('0', '4719EC141AF0400D99A6417915FCC2F6', 'FE5FB16EB45A440F8A40CDA05C33345D', 'FF808081318B15B301318B3A2DFE2EA3')) and isCustomer = 'Y' and (c_bp_group_id in ( select businesspa1_.C_BP_Group_ID from C_BP_Group businesspa1_ where em_clmd_ispatient = 'Y')) and (businesspa0_.AD_Client_ID in ('FF808081318B15B301318B27D6370001', '0')) and businesspa0_.IsActive = 'Y' order by businesspa0_.Name, businesspa0_.C_BPartner_ID limit '76';

Date: 2026-07-15 12:57:12
Duration: 1s93ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo