INSERT INTO molinapp_autotest.tbl_next_service (id_car, id_order, ultima_fecha, kms_actuales, fecha_proximo_servicio) 
                        SELECT 
                            o1.id_car, 
                            o1.id_order, 
                            o1.strDate AS ultima_fecha, 
                            o1.iKms AS kms_actuales, 
                            DATE_ADD(o1.strDate, INTERVAL 180 DAY) AS fecha_proximo_servicio 
                        FROM molinapp_autotest.tbl_order o1 
                        INNER JOIN (
                            SELECT id_car, MAX(strDate) AS ultima_fecha 
                            FROM molinapp_autotest.tbl_order 
                            WHERE (id_order_service_type = 2 OR id_order_service_type = 1) 
                              AND strDate >= CURDATE() - INTERVAL 365 DAY 
                            GROUP BY id_car 
                        ) o2 ON o1.id_car = o2.id_car AND o1.strDate = o2.ultima_fecha 
                        WHERE (o1.id_order_service_type = 2 OR o1.id_order_service_type = 1) 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) <= CURDATE() + INTERVAL 3 DAY 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) >= CURDATE() 
                        ORDER BY o1.strDate DESC;
                         <br />=================================<br />
                        INSERT INTO molinapp_hb21.tbl_next_service (id_car, id_order, ultima_fecha, kms_actuales, fecha_proximo_servicio) 
                        SELECT 
                            o1.id_car, 
                            o1.id_order, 
                            o1.strDate AS ultima_fecha, 
                            o1.iKms AS kms_actuales, 
                            DATE_ADD(o1.strDate, INTERVAL 180 DAY) AS fecha_proximo_servicio 
                        FROM molinapp_hb21.tbl_order o1 
                        INNER JOIN (
                            SELECT id_car, MAX(strDate) AS ultima_fecha 
                            FROM molinapp_hb21.tbl_order 
                            WHERE (id_order_service_type = 2 OR id_order_service_type = 24 OR id_order_service_type = 22) 
                              AND strDate >= CURDATE() - INTERVAL 365 DAY 
                            GROUP BY id_car 
                        ) o2 ON o1.id_car = o2.id_car AND o1.strDate = o2.ultima_fecha 
                        WHERE (o1.id_order_service_type = 2 OR o1.id_order_service_type = 24 OR o1.id_order_service_type = 22) 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) <= CURDATE() + INTERVAL 3 DAY 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) >= CURDATE() 
                        ORDER BY o1.strDate DESC;
                         <br />=================================<br />
                        INSERT INTO molinapp_maudaz2.tbl_next_service (id_car, id_order, ultima_fecha, kms_actuales, fecha_proximo_servicio) 
                        SELECT 
                            o1.id_car, 
                            o1.id_order, 
                            o1.strDate AS ultima_fecha, 
                            o1.iKms AS kms_actuales, 
                            DATE_ADD(o1.strDate, INTERVAL 180 DAY) AS fecha_proximo_servicio 
                        FROM molinapp_maudaz2.tbl_order o1 
                        INNER JOIN (
                            SELECT id_car, MAX(strDate) AS ultima_fecha 
                            FROM molinapp_maudaz2.tbl_order 
                            WHERE (id_order_service_type = 2 OR id_order_service_type = 6 OR id_order_service_type = 4 OR id_order_service_type = 7 OR id_order_service_type = 3 OR id_order_service_type = 11 OR id_order_service_type = 5 OR id_order_service_type = 10 OR id_order_service_type = 9) 
                              AND strDate >= CURDATE() - INTERVAL 365 DAY 
                            GROUP BY id_car 
                        ) o2 ON o1.id_car = o2.id_car AND o1.strDate = o2.ultima_fecha 
                        WHERE (o1.id_order_service_type = 2 OR o1.id_order_service_type = 6 OR o1.id_order_service_type = 4 OR o1.id_order_service_type = 7 OR o1.id_order_service_type = 3 OR o1.id_order_service_type = 11 OR o1.id_order_service_type = 5 OR o1.id_order_service_type = 10 OR o1.id_order_service_type = 9) 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) <= CURDATE() + INTERVAL 3 DAY 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) >= CURDATE() 
                        ORDER BY o1.strDate DESC;
                         <br />=================================<br />
                        INSERT INTO molinapp_mtechnik.tbl_next_service (id_car, id_order, ultima_fecha, kms_actuales, fecha_proximo_servicio) 
                        SELECT 
                            o1.id_car, 
                            o1.id_order, 
                            o1.strDate AS ultima_fecha, 
                            o1.iKms AS kms_actuales, 
                            DATE_ADD(o1.strDate, INTERVAL 180 DAY) AS fecha_proximo_servicio 
                        FROM molinapp_mtechnik.tbl_order o1 
                        INNER JOIN (
                            SELECT id_car, MAX(strDate) AS ultima_fecha 
                            FROM molinapp_mtechnik.tbl_order 
                            WHERE (id_order_service_type = 13 OR id_order_service_type = 1) 
                              AND strDate >= CURDATE() - INTERVAL 365 DAY 
                            GROUP BY id_car 
                        ) o2 ON o1.id_car = o2.id_car AND o1.strDate = o2.ultima_fecha 
                        WHERE (o1.id_order_service_type = 13 OR o1.id_order_service_type = 1) 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) <= CURDATE() + INTERVAL 3 DAY 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) >= CURDATE() 
                        ORDER BY o1.strDate DESC;
                         <br />=================================<br />
                        INSERT INTO molinapp_silver.tbl_next_service (id_car, id_order, ultima_fecha, kms_actuales, fecha_proximo_servicio) 
                        SELECT 
                            o1.id_car, 
                            o1.id_order, 
                            o1.strDate AS ultima_fecha, 
                            o1.iKms AS kms_actuales, 
                            DATE_ADD(o1.strDate, INTERVAL 180 DAY) AS fecha_proximo_servicio 
                        FROM molinapp_silver.tbl_order o1 
                        INNER JOIN (
                            SELECT id_car, MAX(strDate) AS ultima_fecha 
                            FROM molinapp_silver.tbl_order 
                            WHERE (id_order_service_type = 2 OR id_order_service_type = 6 OR id_order_service_type = 4 OR id_order_service_type = 3 OR id_order_service_type = 5 OR id_order_service_type = 1 OR id_order_service_type = 10 OR id_order_service_type = 9) 
                              AND strDate >= CURDATE() - INTERVAL 365 DAY 
                            GROUP BY id_car 
                        ) o2 ON o1.id_car = o2.id_car AND o1.strDate = o2.ultima_fecha 
                        WHERE (o1.id_order_service_type = 2 OR o1.id_order_service_type = 6 OR o1.id_order_service_type = 4 OR o1.id_order_service_type = 3 OR o1.id_order_service_type = 5 OR o1.id_order_service_type = 1 OR o1.id_order_service_type = 10 OR o1.id_order_service_type = 9) 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) <= CURDATE() + INTERVAL 3 DAY 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) >= CURDATE() 
                        ORDER BY o1.strDate DESC;
                         <br />=================================<br />
                        INSERT INTO molinapp_totalcs.tbl_next_service (id_car, id_order, ultima_fecha, kms_actuales, fecha_proximo_servicio) 
                        SELECT 
                            o1.id_car, 
                            o1.id_order, 
                            o1.strDate AS ultima_fecha, 
                            o1.iKms AS kms_actuales, 
                            DATE_ADD(o1.strDate, INTERVAL 180 DAY) AS fecha_proximo_servicio 
                        FROM molinapp_totalcs.tbl_order o1 
                        INNER JOIN (
                            SELECT id_car, MAX(strDate) AS ultima_fecha 
                            FROM molinapp_totalcs.tbl_order 
                            WHERE (id_order_service_type = 2 OR id_order_service_type = 1) 
                              AND strDate >= CURDATE() - INTERVAL 365 DAY 
                            GROUP BY id_car 
                        ) o2 ON o1.id_car = o2.id_car AND o1.strDate = o2.ultima_fecha 
                        WHERE (o1.id_order_service_type = 2 OR o1.id_order_service_type = 1) 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) <= CURDATE() + INTERVAL 3 DAY 
                          AND DATE_ADD(o1.strDate, INTERVAL 180 DAY) >= CURDATE() 
                        ORDER BY o1.strDate DESC;
                         <br />=================================<br />