UID:--061840--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--061840--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--062621--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--062621--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--065949--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--065949--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--065949--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--070001--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--070001--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--070148--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--070148--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--070307--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--070307--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--071013--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--071013--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--071050--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--071050--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--071124--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--071124--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--071153--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--071153--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--071239--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:--071239--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--071324--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--071324--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--071351--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--071351--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--071414--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--071414--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--071436--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--071436--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--071507--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--071507--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--071541--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--071541--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--080022--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--080022--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--081930--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--081930--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--081952--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--081952--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--083139--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--083139--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--083246--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--083246--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--083603--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--083603--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--085301--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--085301--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--085301--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--090628--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--090628--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--090900--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--090900--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--091027--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--091027--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--091504--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--091504--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--091802--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--091802--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--092726--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--092726--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--093118--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:--093118--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--093248--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--093248--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--093319--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--093319--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--093414--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--093414--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--093504--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:--093504--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:3--093514--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:3--093514--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--093518--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--093518--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:3--093521--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:3--093521--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:3--093532--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:3--093532--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:3--093601--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:3--093601--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--093612--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--093612--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--094206--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--094206--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--094235--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--094235--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--094334--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--094334--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--095024--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--095024--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--095044--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--095044--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--095044--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--095307--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--095307--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--095309--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--095309--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:8--095426--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:8--095426--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--095434--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--095434--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--095555--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--095555--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--095821--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--095821--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:13--095911--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:13--095911--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--095948--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--095948--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--100129--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--100129--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--100347--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--100347--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--100347--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--100508--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--100508--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--100527--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--100527--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--100532--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--100532--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--100756--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--100756--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--101122--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--101122--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--101517--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--101517--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--101541--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--101541--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--101747--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--101747--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--101913--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--101913--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--102254--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:10--102254--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--102308--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:10--102308--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--102903--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--102903--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--102948--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--102948--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--103120--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--103120--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--103212--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--103212--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--103218--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:10--103218--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--103226--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--103226--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--103255--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--103255--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--103334--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--103334--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--103620--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:10--103620--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--103748--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--103748--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--103748--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--103842--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--103842--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--104044--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--104044--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--104100--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--104100--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--104109--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--104109--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--104534--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--104534--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--104733--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--104733--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--104740--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--104740--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--104801--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--104801--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--104806--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--104806--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--104806--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--104811--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--104811--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--104917--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--104917--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--104943--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--104943--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--104949--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--104949--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--105139--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--105139-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202504251051' )
UID:--105139-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='zerzerzerzer',`att90`='4abh4z405y9-670r',`attf100`='20250425',`att5`='2800',`att8`='12',`att9`='480',`att10`='48',`att11`='528',`att13`='chèque ou virement',`att14`='68',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco TooSmart</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>33 rue Paul Duvivier<br>\n                    69007 Lyon</p>\n                    <',`att16`='  33 rue Paul Duvivier 69003 Lyon',`att18`='0',`att24`='528',`att25`='33 rue Paul Duvivier',`att26`='',`att27`='69003',`att28`='Lyon',`attdatmod`='202504251051',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '69')  AND (id_type = '168')  LIMIT 1 
UID:--105139-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '69')  LIMIT 1 
UID:--105139-- UPDATE  `tier_lig`  SET `lig2`='2',`ligdatmod`='202504251051',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '7')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '32')  LIMIT 1 
UID:--105139-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-TOO-2',`att3`='',`att2`='zerzerzerzer',`att90`='4abh4z405y9-670r',`attf100`='20250425',`att5`='2800',`att8`='12',`att9`='480',`att10`='48',`att11`='528',`att13`='chèque ou virement',`att14`='68',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco TooSmart</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>33 rue Paul Duvivier<br>\n                    69007 Lyon</p>\n                    <',`att16`='  33 rue Paul Duvivier 69003 Lyon',`att18`='0',`att24`='528',`att25`='33 rue Paul Duvivier',`att26`='',`att27`='69003',`att28`='Lyon',`attdatmod`='202504251051',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '69')  AND (id_type = '168')  LIMIT 1 
UID:--105139-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','69','202504251051','202504251051' )
UID:--105139-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='164',`lig7`='48.00',`lig9`='164',`lig3`='1',`lig2`='480.00',`lig5`='10',`lig4`='480.00',`lig8`='528.00',`lig10`='euro',`lig6`='528.00',`lig90`='&lt;p&gt;&lt;br&gt;&lt;/p&gt;',`ligdatmod`='202504251051',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '69')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '83')  LIMIT 1 
UID:--105139-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('14','1','2','Devis_DV-TOO-4_25_04_2025_10h_50m_signe.pdf','20250425','26','devis_signe','168','69','-2','-1','' )
UID:--105139-- UPDATE  `file`  SET `size`='136865'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '34')  LIMIT 1 
UID:--105139-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','tete_de_reseau@toosmart.fr','Exteco','morganetest@toosmart.fr','','','Merci pour votre commande : Devis N°DV-TOO-4','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouveau Devis EXTECO</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Merci pour votre commande (Devis N° DV-TOO-4)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour madame TEST,<br><br>Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.<br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nous prendrons contact avec vous rapidement pour programmer l\'intervention. En attendant, n\'hésitez pas à nous contacter si vous avez la moindre question ou besoin de clarification sur certains points.<br><br>\r\n                                Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.<br><br>\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe nooa</p>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\"><br></div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>\r\n','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/34-14-26-1§Devis_DV-TOO-4_25_04_2025_10h_50m_signe.pdf','0','v2017b' )
UID:--105139-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '36')  LIMIT 1 
UID:--105140-- UPDATE  `vent_lig`  SET `lig1`='164',`lig7`='48.00',`lig9`='164',`lig3`='1',`lig2`='480.00',`lig5`='10',`lig4`='480.00',`lig8`='528.00',`lig10`='euro',`lig6`='528.00',`lig90`='&lt;p&gt;&lt;br&gt;&lt;/p&gt;',`ligdatmod`='202504251051',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '69')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '83')  LIMIT 1 
UID:--105140-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-TOO-2',`att3`='',`att2`='zerzerzerzer',`att90`='4abh4z405y9-670r',`attf100`='20250425',`att5`='2800',`att8`='12',`att9`='480',`att10`='48',`att11`='528',`att13`='chèque ou virement',`att14`='68',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco TooSmart</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>33 rue Paul Duvivier<br>\n                    69007 Lyon</p>\n                    <',`att16`='  33 rue Paul Duvivier 69003 Lyon',`att18`='0',`att24`='528',`att25`='33 rue Paul Duvivier',`att26`='',`att27`='69003',`att28`='Lyon',`att31`='48',`att29`='480',`attdatmod`='202504251051',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '69')  AND (id_type = '168')  LIMIT 1 
UID:--105140-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='0',`attdatmod`='202504251051',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '67')  AND (id_type = '148')  LIMIT 1 
UID:--105140-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202504251051',`attdatmod`='202504251051',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '68')  AND (id_type = '165')  LIMIT 1 
UID:--105154--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--105154--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--105235--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--105235--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--105235--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--105651--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--105651--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:12--105816--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:12--105816--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--105956--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--105956--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--111520--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--111520--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--111753--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--111753--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--112155--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--112155--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--112155--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--112202--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--112202--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--112253--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--112253--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--112635--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--112635--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--112635--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--112655--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--112655--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--112714--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--112714--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--112807--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--112807--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--112943--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--112943--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--112953--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--112953--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--113032--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--113032--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--113052--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--113052--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--113107--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--113107--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--113123--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--113123--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--113123--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--113133--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--113133--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--113143--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--113143--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--113151--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--113151--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--113237--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--113237--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--113312--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--113312--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--113347--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--113347--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--113545--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--113545--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--113545--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--113559-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202504251135' )
UID:--113559-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`attdatmod`='202504251135',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2824')  AND (id_type = '80')  LIMIT 1 
UID:--113601-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','2824','202504251136','202504251136' )
UID:--113601-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='66 rue coste',`lig4`='69300',`lig5`='Caluire et cuire',`lig6`='France',`ligdatmod`='202504251136',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '2824')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1447')  LIMIT 1 
UID:--113601-- UPDATE  `tier_lig`  SET `lig2`='6',`ligdatmod`='202504251136',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '7')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '30')  LIMIT 1 
UID:--113601-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att22`='CL-TOO-6',`attf100`='1',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2824')  AND (id_type = '80')  LIMIT 1 
UID:--113601-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att22`='-1',`attf100`='1',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2824')  AND (id_type = '80')  LIMIT 1 
UID:--113601-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att22`='-1',`attf100`='1',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2824')  AND (id_type = '80')  LIMIT 1 
UID:--113601-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202504251136' )
UID:--113601-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Boudilmi',`att5`='0909090909',`att6`='boudilmitest@toosmart.fr',`att8`='2824',`att10`='[IDMYUSER]',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2825')  AND (id_type = '149')  LIMIT 1 
UID:--113601-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202504251136' )
UID:--113601-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-',`att2`='2824',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1447',`att6`='[IDMYUSER]',`att9`='2825',`att3`='§toiture§',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '148')  LIMIT 1 
UID:--113601-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2824',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1447',`att6`='[IDMYUSER]',`att9`='2825',`att3`='§toiture§',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '148')  LIMIT 1 
UID:--113601-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2824',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1447',`att6`='[IDMYUSER]',`att9`='2825',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '148')  LIMIT 1 
UID:--113601-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2824',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1447',`att6`='0',`att9`='2825',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '148')  LIMIT 1 
UID:--113601-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Test</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)<br><br>\r\n                                Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://prod.egiteko.net/toosmart_exteco/soft/www/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--113601-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '37')  LIMIT 1 
UID:--113601--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--113601-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','','Exteco','franchise@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Test</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Franchisé , (mail envoyé à la personne qui gère le client si le client existe déjà et qu\'il a déjà été affecté)<br><br>\r\n                                Une nouvelle opportunité vous a été affectée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://prod.egiteko.net/toosmart_exteco/soft/www/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--113601-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '38')  LIMIT 1 
UID:--113601-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2824',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1447',`att6`='12',`att9`='2825',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '148')  LIMIT 1 
UID:--113601-- UPDATE  `tier_lig`  SET `lig2`='7',`ligdatmod`='202504251136',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '7')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '30')  LIMIT 1 
UID:--113601-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Boudilmi',`att5`='0909090909',`att6`='boudilmitest@toosmart.fr',`att8`='2824',`att10`='[IDMYUSER]',`att4`='0909090909',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2825')  AND (id_type = '149')  LIMIT 1 
UID:--113601-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att22`='CL-TOO-7',`attf100`='1',`att19`='45.786944',`att20`='4.834154',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2824')  AND (id_type = '80')  LIMIT 1 
UID:--113601-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att22`='CL-EPI-2546',`attf100`='1',`att19`='45.786944',`att20`='4.834154',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2824')  AND (id_type = '80')  LIMIT 1 
UID:--113601-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att22`='CL-EPI-2546',`attf100`='1',`att19`='45.786944',`att20`='4.834154',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2824')  AND (id_type = '80')  LIMIT 1 
UID:--113601-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att22`='CL-EPI-2546',`attf100`='1',`att19`='45.786944',`att20`='4.834154',`att6`='0909090909',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2824')  AND (id_type = '80')  LIMIT 1 
UID:--113601-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2824',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1447',`att6`='12',`att9`='2825',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251136',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '148')  LIMIT 1 
UID:--113741--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--113741--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--114307-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202504251143' )
UID:--114307-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2826')  AND (id_type = '80')  LIMIT 1 
UID:--114307-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','2826','202504251143','202504251143' )
UID:--114307-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='66 rue coste',`lig4`='69300',`lig5`='Caluire et cuire',`lig6`='France',`ligdatmod`='202504251143',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '2826')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1448')  LIMIT 1 
UID:--114307-- UPDATE  `tier_lig`  SET `lig2`='8',`ligdatmod`='202504251143',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '7')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '30')  LIMIT 1 
UID:--114307-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='CL-TOO-8',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2826')  AND (id_type = '80')  LIMIT 1 
UID:--114307-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='-1',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2826')  AND (id_type = '80')  LIMIT 1 
UID:--114307-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='-1',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2826')  AND (id_type = '80')  LIMIT 1 
UID:--114307-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202504251143' )
UID:--114307-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Toosmart',`att5`='0909090909',`att6`='testtoosmart@toosmart.fr',`att8`='2826',`att10`='[IDMYUSER]',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2827')  AND (id_type = '149')  LIMIT 1 
UID:--114307-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202504251143' )
UID:--114307-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-',`att2`='2826',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1448',`att6`='[IDMYUSER]',`att9`='2827',`att3`='§toiture§',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '73')  AND (id_type = '148')  LIMIT 1 
UID:--114307-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2826',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1448',`att6`='[IDMYUSER]',`att9`='2827',`att3`='§toiture§',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '73')  AND (id_type = '148')  LIMIT 1 
UID:--114307-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2826',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1448',`att6`='[IDMYUSER]',`att9`='2827',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '73')  AND (id_type = '148')  LIMIT 1 
UID:--114307-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2826',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1448',`att6`='0',`att9`='2827',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '73')  AND (id_type = '148')  LIMIT 1 
UID:--114307-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Test</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)<br><br>\r\n                                Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://prod.egiteko.net/toosmart_exteco/soft/www/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--114307-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '39')  LIMIT 1 
UID:--114307--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--114307-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','','Exteco','franchise@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Test</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Franchisé , (mail envoyé à la personne qui gère le client si le client existe déjà et qu\'il a déjà été affecté)<br><br>\r\n                                Une nouvelle opportunité vous a été affectée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://prod.egiteko.net/toosmart_exteco/soft/www/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--114307-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '40')  LIMIT 1 
UID:--114307-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2826',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1448',`att6`='12',`att9`='2827',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '73')  AND (id_type = '148')  LIMIT 1 
UID:--114307-- UPDATE  `tier_lig`  SET `lig2`='9',`ligdatmod`='202504251143',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '7')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '30')  LIMIT 1 
UID:--114307-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Toosmart',`att5`='0909090909',`att6`='testtoosmart@toosmart.fr',`att8`='2826',`att10`='[IDMYUSER]',`att4`='0909090909',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2827')  AND (id_type = '149')  LIMIT 1 
UID:--114307-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='CL-TOO-9',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2826')  AND (id_type = '80')  LIMIT 1 
UID:--114307-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2826')  AND (id_type = '80')  LIMIT 1 
UID:--114307-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2826')  AND (id_type = '80')  LIMIT 1 
UID:--114307-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`att6`='0909090909',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2826')  AND (id_type = '80')  LIMIT 1 
UID:--114307-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2826',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1448',`att6`='12',`att9`='2827',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '73')  AND (id_type = '148')  LIMIT 1 
UID:--114357-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202504251143' )
UID:--114357-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='4',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='3',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2828')  AND (id_type = '80')  LIMIT 1 
UID:--114358-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','2828','202504251143','202504251143' )
UID:--114358-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='66 rue coste',`lig4`='69300',`lig5`='Caluire et cuire',`lig6`='France',`ligdatmod`='202504251143',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '2828')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1449')  LIMIT 1 
UID:--114358-- UPDATE  `tier_lig`  SET `lig2`='250',`ligdatmod`='202504251143',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '6')  LIMIT 1 
UID:--114358-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='4',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='3',`att19`='45.786944',`att20`='4.834154',`att22`='CL-METZ-250',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2828')  AND (id_type = '80')  LIMIT 1 
UID:--114358-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='4',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='3',`att19`='45.786944',`att20`='4.834154',`att22`='-1',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2828')  AND (id_type = '80')  LIMIT 1 
UID:--114358-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='4',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='3',`att19`='45.786944',`att20`='4.834154',`att22`='-1',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2828')  AND (id_type = '80')  LIMIT 1 
UID:--114358-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202504251143' )
UID:--114358-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Toosmart',`att5`='0909090909',`att6`='testtoosmart@toosmart.fr',`att8`='2828',`att10`='[IDMYUSER]',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2829')  AND (id_type = '149')  LIMIT 1 
UID:--114358-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202504251143' )
UID:--114358-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-',`att2`='2828',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1449',`att6`='[IDMYUSER]',`att9`='2829',`att3`='§toiture§',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '74')  AND (id_type = '148')  LIMIT 1 
UID:--114358-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2828',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1449',`att6`='[IDMYUSER]',`att9`='2829',`att3`='§toiture§',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '74')  AND (id_type = '148')  LIMIT 1 
UID:--114358-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2828',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1449',`att6`='[IDMYUSER]',`att9`='2829',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '74')  AND (id_type = '148')  LIMIT 1 
UID:--114358-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2828',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1449',`att6`='0',`att9`='2829',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '74')  AND (id_type = '148')  LIMIT 1 
UID:--114358-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Test</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)<br><br>\r\n                                Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://prod.egiteko.net/toosmart_exteco/soft/www/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--114358-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '41')  LIMIT 1 
UID:--114358--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--114358-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','','Exteco','agence-metz@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Test</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour AYAD, (mail envoyé à la personne qui gère le client si le client existe déjà et qu\'il a déjà été affecté)<br><br>\r\n                                Une nouvelle opportunité vous a été affectée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://prod.egiteko.net/toosmart_exteco/soft/www/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--114358-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '42')  LIMIT 1 
UID:--114358-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2828',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1449',`att6`='4',`att9`='2829',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '74')  AND (id_type = '148')  LIMIT 1 
UID:--114358-- UPDATE  `tier_lig`  SET `lig2`='251',`ligdatmod`='202504251143',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '6')  LIMIT 1 
UID:--114358-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Toosmart',`att5`='0909090909',`att6`='testtoosmart@toosmart.fr',`att8`='2828',`att10`='[IDMYUSER]',`att4`='0909090909',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2829')  AND (id_type = '149')  LIMIT 1 
UID:--114358-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='4',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='3',`att19`='45.786944',`att20`='4.834154',`att22`='CL-METZ-251',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2828')  AND (id_type = '80')  LIMIT 1 
UID:--114358-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='4',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='3',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2828')  AND (id_type = '80')  LIMIT 1 
UID:--114358-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='4',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='3',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2828')  AND (id_type = '80')  LIMIT 1 
UID:--114358-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='4',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='3',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`att6`='0909090909',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2828')  AND (id_type = '80')  LIMIT 1 
UID:--114358-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2828',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1449',`att6`='4',`att9`='2829',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251143',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '74')  AND (id_type = '148')  LIMIT 1 
UID:--114437-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202504251144' )
UID:--114437-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='10',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='4',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2830')  AND (id_type = '80')  LIMIT 1 
UID:--114437-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','2830','202504251144','202504251144' )
UID:--114437-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='66 rue coste',`lig4`='69300',`lig5`='Caluire et cuire',`lig6`='France',`ligdatmod`='202504251144',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '2830')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1450')  LIMIT 1 
UID:--114438-- UPDATE  `tier_lig`  SET `lig2`='22',`ligdatmod`='202504251144',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '4')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '11')  LIMIT 1 
UID:--114438-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='10',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='4',`att19`='45.786944',`att20`='4.834154',`att22`='CL-LSDO-22',`attf100`='1',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2830')  AND (id_type = '80')  LIMIT 1 
UID:--114438-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='10',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='4',`att19`='45.786944',`att20`='4.834154',`att22`='-1',`attf100`='1',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2830')  AND (id_type = '80')  LIMIT 1 
UID:--114438-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='10',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='4',`att19`='45.786944',`att20`='4.834154',`att22`='-1',`attf100`='1',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2830')  AND (id_type = '80')  LIMIT 1 
UID:--114438-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202504251144' )
UID:--114438-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Toosmart',`att5`='0909090909',`att6`='testtoosmart@toosmart.fr',`att8`='2830',`att10`='[IDMYUSER]',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2831')  AND (id_type = '149')  LIMIT 1 
UID:--114438-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202504251144' )
UID:--114438-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-',`att2`='2830',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1450',`att6`='[IDMYUSER]',`att9`='2831',`att3`='§toiture§',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '75')  AND (id_type = '148')  LIMIT 1 
UID:--114438-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2830',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1450',`att6`='[IDMYUSER]',`att9`='2831',`att3`='§toiture§',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '75')  AND (id_type = '148')  LIMIT 1 
UID:--114438-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2830',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1450',`att6`='[IDMYUSER]',`att9`='2831',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '75')  AND (id_type = '148')  LIMIT 1 
UID:--114438-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2830',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1450',`att6`='0',`att9`='2831',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '75')  AND (id_type = '148')  LIMIT 1 
UID:--114438-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Test</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)<br><br>\r\n                                Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://prod.egiteko.net/toosmart_exteco/soft/www/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--114438-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '43')  LIMIT 1 
UID:--114438--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--114438-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','','Exteco','mathieutheo@yahoo.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Test</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour MATHIEU, (mail envoyé à la personne qui gère le client si le client existe déjà et qu\'il a déjà été affecté)<br><br>\r\n                                Une nouvelle opportunité vous a été affectée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://prod.egiteko.net/toosmart_exteco/soft/www/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--114438-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '44')  LIMIT 1 
UID:--114438-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2830',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1450',`att6`='10',`att9`='2831',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '75')  AND (id_type = '148')  LIMIT 1 
UID:--114438-- UPDATE  `tier_lig`  SET `lig2`='23',`ligdatmod`='202504251144',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '4')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '11')  LIMIT 1 
UID:--114438-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Toosmart',`att5`='0909090909',`att6`='testtoosmart@toosmart.fr',`att8`='2830',`att10`='[IDMYUSER]',`att4`='0909090909',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2831')  AND (id_type = '149')  LIMIT 1 
UID:--114438-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='10',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='4',`att19`='45.786944',`att20`='4.834154',`att22`='CL-LSDO-23',`attf100`='1',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2830')  AND (id_type = '80')  LIMIT 1 
UID:--114438-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='10',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='4',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2830')  AND (id_type = '80')  LIMIT 1 
UID:--114438-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='10',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='4',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2830')  AND (id_type = '80')  LIMIT 1 
UID:--114438-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='10',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='4',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`att6`='0909090909',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2830')  AND (id_type = '80')  LIMIT 1 
UID:--114438-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2830',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1450',`att6`='10',`att9`='2831',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251144',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '75')  AND (id_type = '148')  LIMIT 1 
UID:--114756-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202504251147' )
UID:--114756-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2832')  AND (id_type = '80')  LIMIT 1 
UID:--114756-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','2832','202504251147','202504251147' )
UID:--114756-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='66 rue coste',`lig4`='69300',`lig5`='Caluire et cuire',`lig6`='France',`ligdatmod`='202504251147',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '2832')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1451')  LIMIT 1 
UID:--114756-- UPDATE  `tier_lig`  SET `lig2`='10',`ligdatmod`='202504251147',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '7')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '30')  LIMIT 1 
UID:--114756-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='CL-TOO-10',`attf100`='1',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2832')  AND (id_type = '80')  LIMIT 1 
UID:--114756-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='-1',`attf100`='1',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2832')  AND (id_type = '80')  LIMIT 1 
UID:--114756-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='-1',`attf100`='1',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2832')  AND (id_type = '80')  LIMIT 1 
UID:--114756-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202504251147' )
UID:--114756-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Toosmart',`att5`='0909090909',`att6`='testtoosmart@toosmart.fr',`att8`='2832',`att10`='[IDMYUSER]',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2833')  AND (id_type = '149')  LIMIT 1 
UID:--114756-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202504251147' )
UID:--114756-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-',`att2`='2832',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1451',`att6`='[IDMYUSER]',`att9`='2833',`att3`='§toiture§',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '76')  AND (id_type = '148')  LIMIT 1 
UID:--114756-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2832',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1451',`att6`='[IDMYUSER]',`att9`='2833',`att3`='§toiture§',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '76')  AND (id_type = '148')  LIMIT 1 
UID:--114756-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2832',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1451',`att6`='[IDMYUSER]',`att9`='2833',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '76')  AND (id_type = '148')  LIMIT 1 
UID:--114756-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2832',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1451',`att6`='0',`att9`='2833',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '76')  AND (id_type = '148')  LIMIT 1 
UID:--114756-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Test</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)<br><br>\r\n                                Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://prod.egiteko.net/toosmart_exteco/soft/www/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--114756-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '45')  LIMIT 1 
UID:--114756--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--114756-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','','Exteco','franchise@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Test</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Franchisé , (mail envoyé à la personne qui gère le client si le client existe déjà et qu\'il a déjà été affecté)<br><br>\r\n                                Une nouvelle opportunité vous a été affectée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://prod.egiteko.net/toosmart_exteco/soft/www/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--114756-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '46')  LIMIT 1 
UID:--114756-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2832',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1451',`att6`='12',`att9`='2833',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '76')  AND (id_type = '148')  LIMIT 1 
UID:--114756-- UPDATE  `tier_lig`  SET `lig2`='11',`ligdatmod`='202504251147',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '7')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '30')  LIMIT 1 
UID:--114756-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Toosmart',`att5`='0909090909',`att6`='testtoosmart@toosmart.fr',`att8`='2832',`att10`='[IDMYUSER]',`att4`='0909090909',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2833')  AND (id_type = '149')  LIMIT 1 
UID:--114756-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='CL-TOO-11',`attf100`='1',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2832')  AND (id_type = '80')  LIMIT 1 
UID:--114756-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2832')  AND (id_type = '80')  LIMIT 1 
UID:--114756-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2832')  AND (id_type = '80')  LIMIT 1 
UID:--114756-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='testtoosmart@toosmart.fr',`att21`='12',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att24`='7',`att19`='45.786944',`att20`='4.834154',`att22`='CL-EPI-2546',`attf100`='1',`att6`='0909090909',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2832')  AND (id_type = '80')  LIMIT 1 
UID:--114756-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2832',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1451',`att6`='12',`att9`='2833',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251147',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '76')  AND (id_type = '148')  LIMIT 1 
UID:--114918--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--114918--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--115219--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--115219--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--115643--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--115643--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--115646--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--115646--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--115649--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--115649--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--115939--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--115939--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--120309--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:--120309--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--120323-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202504251203' )
UID:--120323-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='morganetestapi@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2835')  AND (id_type = '80')  LIMIT 1 
UID:--120323-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','2835','202504251203','202504251203' )
UID:--120323-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='66 rue coste',`lig4`='69300',`lig5`='Caluire et cuire',`lig6`='France',`ligdatmod`='202504251203',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '2835')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1452')  LIMIT 1 
UID:--120323-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='morganetestapi@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2835')  AND (id_type = '80')  LIMIT 1 
UID:--120323-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='morganetestapi@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2835')  AND (id_type = '80')  LIMIT 1 
UID:--120323-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202504251203' )
UID:--120323-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Toosmart',`att5`='0909090909',`att6`='morganetestapi@toosmart.fr',`att8`='2835',`att10`='[IDMYUSER]',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2836')  AND (id_type = '149')  LIMIT 1 
UID:--120323-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202504251203' )
UID:--120323-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-',`att2`='2835',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1452',`att6`='[IDMYUSER]',`att9`='2836',`att3`='§toiture§',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '77')  AND (id_type = '148')  LIMIT 1 
UID:--120323-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2835',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1452',`att6`='[IDMYUSER]',`att9`='2836',`att3`='§toiture§',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '77')  AND (id_type = '148')  LIMIT 1 
UID:--120323-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2835',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1452',`att6`='[IDMYUSER]',`att9`='2836',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '77')  AND (id_type = '148')  LIMIT 1 
UID:--120323-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2835',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1452',`att6`='0',`att9`='2836',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '77')  AND (id_type = '148')  LIMIT 1 
UID:--120323-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250425','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Test</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)<br><br>\r\n                                Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://prod.egiteko.net/toosmart_exteco/soft/www/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--120323-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '47')  LIMIT 1 
UID:--120323--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--120323-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Toosmart',`att5`='0909090909',`att6`='morganetestapi@toosmart.fr',`att8`='2835',`att10`='[IDMYUSER]',`att4`='0909090909',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2836')  AND (id_type = '149')  LIMIT 1 
UID:--120323-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='morganetestapi@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2835')  AND (id_type = '80')  LIMIT 1 
UID:--120323-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='morganetestapi@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2835')  AND (id_type = '80')  LIMIT 1 
UID:--120323-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Toosmart',`att1`='Test',`att8`='professionnel',`att12`='morganetestapi@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250425',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250425',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`att6`='0909090909',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2835')  AND (id_type = '80')  LIMIT 1 
UID:--120323-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='2835',`att90`='devis pour démoussage toiture',`attf100`='20250425',`att8`='1452',`att6`='0',`att9`='2836',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504251203',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '77')  AND (id_type = '148')  LIMIT 1 
UID:--120703--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--120703--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--120902--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--120902--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--122114--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--122114--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--122114--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:1--122137--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--122137--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--122353--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--122353--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--124324--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--124324--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--124849--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--124849--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--133144--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--133144--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--141349--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:--141349--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--141412--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--141412--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--143232--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--143232--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--143644--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--143644--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--143822--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--143822--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--145239--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--145239--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--150154--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--150154--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--150548--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--150548--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--160828--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--160828--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--161617--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--161617--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--162041--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--162041--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--162120--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--162120--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--162245--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--162245--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--162553--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--162553--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--163801--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--163801--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--163810--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--163810--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--164407--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--164407--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--165736--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--165736--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--165815--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--165815--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:12--165823--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:12--165823--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:12--165825--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:12--165825--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--170512--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--170512--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--170533--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--170533--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:9--170940--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:9--170940--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:9--170946--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:9--170946--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:12--171803--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:12--171803--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--171815--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--171815--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:9--172556--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:9--172556--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--173457--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--173457--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--173731--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--173731--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--175244--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:10--175244--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--175251--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:10--175251--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--175408--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:10--175408--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:12--180048--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:12--180048--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:12--180510--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('30','1','2','Logo Exteco (1).png','20250425','333','12','-3','-2')
UID:12--180510--UPDATE `file` SET `last`='1' , `size`='9153' , `fol_id`='2' , `esp_id`='1' WHERE file_id=47
UID:12--180510--UPDATE `file` SET `id_type`='168' , `id_obje`='88' , `specif`='devis_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=47
UID:12--180510--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=47
UID:12--180510--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1
UID:12--180510--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','12','2','47','30','Logo Exteco (1).png','1','20250425','18:05:10','upload')
UID:12--180513--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:12--180513--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--181630--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--181630--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--181644--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--181644--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:12--181817--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:12--181817--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--181829--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--181829--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--182014--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--182014--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--182025--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--182025--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:12--182105--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:12--182105--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--184800--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--184800--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre