01/19/11 10:17:38,435 [1232] DEBUG root - Début fonction ProcessTable 01/19/11 10:17:38,437 [1232] DEBUG root - data['rapport']=7 01/19/11 10:17:38,440 [1232] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 10:17:38,462 [1232] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 10:17:38,480 [1232] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 10:17:38,498 [1232] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 10:17:38,516 [1232] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 10:17:38,534 [1232] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 10:18:26,467 [1232] DEBUG root - Début fonction ProcessTable 01/19/11 10:18:26,468 [1232] DEBUG root - data['rapport']=0 01/19/11 10:18:26,471 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , prestataires , unite_maintenance um , societes s WHERE i.id_prestataire=s.id_societes AND s.id_societes=1 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:18:26,480 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , prestataires , unite_maintenance um , societes s WHERE i.id_prestataire=s.id_societes AND s.id_societes=152 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:06,326 [1232] DEBUG root - Début fonction ProcessTable 01/19/11 10:19:06,327 [1232] DEBUG root - data['rapport']=1 01/19/11 10:19:06,330 [1232] DEBUG root - pre_requete=SELECT TO_CHAR(AVG(date_debut_intervention - d.date_enregistrement),'DD|HH24:mi') as value FROM interventions i , demandes d , prestataires , items type_panne , demandes_natures dn , societes s WHERE i.id_prestataire=s.id_societes AND s.id_societes=1 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.id_demandes=d.id_demandes AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention = 104 AND i.date_debut_intervention IS NOT NULL AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND prestataires.id_societes = 152 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 10:19:06,369 [1232] DEBUG root - pre_requete=SELECT TO_CHAR(AVG(date_debut_intervention - d.date_enregistrement),'DD|HH24:mi') as value FROM interventions i , demandes d , prestataires , items type_panne , demandes_natures dn , societes s WHERE i.id_prestataire=s.id_societes AND s.id_societes=152 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.id_demandes=d.id_demandes AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention = 104 AND i.date_debut_intervention IS NOT NULL AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND prestataires.id_societes = 152 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 10:19:49,654 [1232] DEBUG root - Début fonction ProcessTable 01/19/11 10:19:49,655 [1232] DEBUG root - data['rapport']=0 01/19/11 10:19:49,659 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=682 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,668 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=683 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,673 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=674 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,678 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=677 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,683 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=646 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,687 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=667 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,692 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=641 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,697 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=756 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,702 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=763 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,707 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=761 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,712 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=730 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,716 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=708 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,721 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=736 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,726 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=735 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,731 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=663 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,736 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=661 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,741 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=654 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,745 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=755 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,750 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=738 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,755 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=737 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,760 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=653 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,765 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=656 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,769 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=652 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,774 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=651 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,779 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=657 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,784 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=670 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,789 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=705 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,794 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=687 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,798 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=699 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,803 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=701 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,808 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=716 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,813 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=703 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,818 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=702 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,823 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=711 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,827 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=712 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,832 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=666 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,837 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=731 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,842 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=757 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,847 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=709 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,851 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=713 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,856 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=725 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,861 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=714 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,866 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=715 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,871 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=717 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,875 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=704 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,880 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=680 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,885 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=718 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,890 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=719 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,895 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=720 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,899 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=726 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,904 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=655 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,909 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=722 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,914 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=723 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,919 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=724 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,923 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=733 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,928 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=758 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,933 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=765 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,938 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=727 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,942 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=739 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,947 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=728 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,952 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=729 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,957 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=740 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,962 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=766 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,966 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=732 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,971 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=741 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,976 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=742 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,981 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=764 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,986 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=759 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,991 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=743 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:49,995 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=745 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,000 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=747 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,005 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=748 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,010 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=665 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,015 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=749 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,019 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=750 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,024 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=751 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,029 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=752 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,034 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=753 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,038 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=754 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,043 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=684 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,048 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=668 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,053 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=643 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,058 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=678 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,103 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=642 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,108 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=662 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,113 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=644 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,118 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=664 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,123 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=695 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,128 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=767 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,133 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=744 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,138 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=746 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,142 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=693 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,147 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=689 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,152 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=762 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,157 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=698 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,161 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=760 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,166 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=679 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,171 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=658 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,176 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=688 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,180 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=694 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,185 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=691 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,190 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=686 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,195 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=681 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,200 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=685 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,204 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=697 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,209 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=671 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,214 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=770 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,219 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=769 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:19:50,223 [1232] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , prestataires , unite_maintenance um , demandes d , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=771 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 10:20:43,014 [1232] DEBUG root - Début fonction ProcessTable 01/19/11 10:20:43,015 [1232] DEBUG root - data['rapport']=5 01/19/11 13:38:40,748 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 13:38:40,749 [7364] DEBUG root - data['rapport']=7 01/19/11 13:38:40,809 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651) 01/19/11 14:26:23,310 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 14:26:23,312 [7364] DEBUG root - data['rapport']=7 01/19/11 14:26:23,314 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (651) 01/19/11 14:26:50,576 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 14:26:50,577 [7364] DEBUG root - data['rapport']=7 01/19/11 14:26:50,580 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651) 01/19/11 14:26:50,602 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651) 01/19/11 14:27:30,904 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 14:27:30,905 [7364] DEBUG root - data['rapport']=7 01/19/11 14:27:30,908 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651) 01/19/11 14:27:30,930 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 1 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651) 01/19/11 14:28:43,764 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 14:28:43,765 [7364] DEBUG root - data['rapport']=3 01/19/11 14:28:43,768 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=682 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,778 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=683 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,784 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=674 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,789 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=677 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,795 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=646 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,800 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=667 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,806 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=641 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,811 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=756 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,817 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=763 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,822 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=761 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,828 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=730 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,833 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=708 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,839 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=736 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,845 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=735 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,850 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=663 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,856 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=661 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,861 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=654 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,867 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=755 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,872 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=738 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,878 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=737 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,884 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=653 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,889 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=656 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,895 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=652 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,900 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=651 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,906 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=657 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,911 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=670 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,917 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=705 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,922 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=687 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,928 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=699 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,933 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=701 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,939 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=716 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,944 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=703 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,950 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=702 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,955 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=711 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,961 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=712 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,966 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=666 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,972 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=731 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,977 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=757 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,983 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=709 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,988 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=713 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,994 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=725 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:43,999 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=714 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,005 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=715 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,010 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=717 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,016 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=704 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,021 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=680 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,027 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=718 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,033 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=719 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,038 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=720 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,044 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=726 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,049 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=655 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,055 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=722 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,060 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=723 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,066 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=724 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,071 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=733 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,077 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=758 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,082 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=765 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,088 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=727 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,093 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=739 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,099 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=728 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,104 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=729 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,110 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=740 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,115 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=766 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,121 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=732 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,126 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=741 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,132 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=742 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,137 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=764 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,143 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=759 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,148 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=743 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,154 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=745 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,159 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=747 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,165 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=748 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,170 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=665 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,176 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=749 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,181 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=750 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,187 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=751 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,193 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=752 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,198 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=753 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,204 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=754 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,209 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=684 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,215 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=668 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,220 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=643 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,226 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=678 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,232 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=642 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,237 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=662 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,243 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=644 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,248 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=664 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,254 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=695 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,260 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=767 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,265 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=744 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,271 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=746 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,276 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=693 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,282 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=689 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,287 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=762 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,293 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=698 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,298 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=760 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,304 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=679 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,309 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=658 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,315 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=688 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,321 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=694 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,326 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=691 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,332 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=686 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,337 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=681 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,343 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=685 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,348 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=697 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,354 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=671 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,359 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=770 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,365 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=769 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:28:44,370 [7364] DEBUG root - pre_requete=SELECT AVG(i.temps_passe) as value FROM interventions i , unite_maintenance um , demandes d , items type_panne , demandes_natures dn , contrats c WHERE d.id_contrats=c.id_contrats AND i.id_demandes=d.id_demandes AND c.id_contrats=771 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.date_debut_intervention IS NOT NULL AND i.date_fin_intervention IS NOT NULL AND i.type_intervention = 104 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND d.id_demandes=dn.id_demandes AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210) 01/19/11 14:30:57,154 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 14:30:57,155 [7364] DEBUG root - data['rapport']=7 01/19/11 14:30:57,158 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 151 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651) 01/19/11 14:30:57,194 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 151 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651) 01/19/11 14:31:22,982 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 14:31:22,984 [7364] DEBUG root - data['rapport']=0 01/19/11 14:31:23,020 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=919 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,029 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=5128 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,037 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=10102 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,045 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=11961 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,053 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=16292 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,061 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=22890 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,069 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=25362 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,078 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=26244 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,086 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=27768 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,094 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=28305 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,102 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=34622 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,110 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=37993 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,118 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=40269 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:31:23,126 [7364] DEBUG root - pre_requete=SELECT COUNT(DISTINCT i.id_interventions) as value FROM interventions i , demandes d , unite_maintenance um , items ville WHERE um.id_villes=ville.id_items AND (i.id_prestataire = 1 OR i.id_destinataire = 1 ) AND i.id_demandes=d.id_demandes AND d.id_unite_maintenance=um.id_unite_maintenance AND ville.id_items=40271 AND date_fin_intervention >= '2011-01-01 00:00:00' AND date_fin_intervention <= '2011-01-31 23:59:59' AND i.etat_intervention in(94,109,110,111,112) AND i.type_intervention=104 AND d.id_contrats = 641 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:34:47,607 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 14:34:47,609 [7364] DEBUG root - data['rapport']=7 01/19/11 14:34:47,611 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes 01/19/11 14:35:20,154 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 14:35:20,155 [7364] DEBUG root - data['rapport']=7 01/19/11 14:35:20,158 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:21,881 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:23,598 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:25,349 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:27,373 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:29,530 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:31,246 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:33,389 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:35,530 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:37,246 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:39,420 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:41,134 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:43,264 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:45,389 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:47,389 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:49,514 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:51,229 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:53,357 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:55,482 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:57,198 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:35:59,326 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2011-01-01 00:00:00' AND d.date_enregistrement <= '2011-01-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:37:41,826 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 14:37:41,827 [7364] DEBUG root - data['rapport']=7 01/19/11 14:37:41,830 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:38:34,156 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:39:26,355 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:41:40,076 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 14:41:40,077 [7364] DEBUG root - data['rapport']=7 01/19/11 14:41:40,080 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:42:32,387 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:43:24,594 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 01/19/11 14:44:42,998 [7364] DEBUG root - Début fonction ProcessTable 01/19/11 14:44:42,999 [7364] DEBUG root - data['rapport']=7 01/19/11 14:44:43,002 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,032 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,058 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,083 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,108 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,134 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,159 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,184 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,209 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,234 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,259 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,285 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,310 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,353 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,379 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,404 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,429 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,454 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,480 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,505 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131) 01/19/11 14:44:43,530 [7364] DEBUG root - pre_requete=SELECT DISTINCT(d.id_demandes), (r.lib_reference_court || ': ' || t.lib_item) as nom FROM interventions i , demandes d , demandes_natures dn , items t , liste_references r , items ville , prestataires , unite_maintenance um , items type_panne WHERE 1=1 AND d.date_enregistrement >= '2010-01-01 00:00:00' AND d.date_enregistrement <= '2010-12-31 23:59:59' AND d.id_demandes=dn.id_demandes AND i.id_demandes=d.id_demandes AND dn.id_natures=t.id_items AND t.id_reference=r.id_reference AND r.id_reference=90 AND ville.id_items=um.id_villes AND d.id_contrats = 641 AND d.id_societes = 151 AND prestataires.id_prestataires = d.id_prestataires AND prestataires.id_societes = 152 AND d.id_unite_maintenance = um.id_unite_maintenance AND um.id_type_unite_maintenance = 64 AND dn.id_natures=type_panne.id_items AND type_panne.id_items in (653,651,650,40208,40209,40210,648,654,40213,40212,649,40216,40211,40215,40214,135,130,132,134,133,131)