Symfony Profiler

[
  "route" => "app_tresorerie_bordereau_list"
  "route_parameters" => [
    "_route" => "app_tresorerie_bordereau_list"
    "_controller" => "App\Controller\Tresorerie\BordereauController::app_tresorerie_bordereau_list"
    "periode" => "2025-03"
  ]
  "request_uri" => "http://drh-fcz.ma/tresorerie/bordereau/app_tresorerie_bordereau_list/2025-03?_=1742206733808&columns%5B0%5D%5Bdata%5D=id&columns%5B0%5D%5Bname%5D=b.id&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=code&columns%5B1%5D%5Bname%5D=b.code&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=dossier_designation&columns%5B2%5D%5Bname%5D=d.designation&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=periode&columns%5B3%5D%5Bname%5D=p.abreviation&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=type&columns%5B4%5D%5Bname%5D=b.type&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=designation&columns%5B5%5D%5Bname%5D=natureContract.designation&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=montant&columns%5B6%5D%5Bname%5D=montant&columns%5B6%5D%5Bsearchable%5D=false&columns%5B6%5D%5Borderable%5D=false&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B7%5D%5Bdata%5D=devise&columns%5B7%5D%5Bname%5D=deviseEntity.designation&columns%5B7%5D%5Bsearchable%5D=true&columns%5B7%5D%5Borderable%5D=true&columns%5B7%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B7%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B8%5D%5Bdata%5D=paiement&columns%5B8%5D%5Bname%5D=paiementEntity.designation&columns%5B8%5D%5Bsearchable%5D=true&columns%5B8%5D%5Borderable%5D=true&columns%5B8%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B8%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B9%5D%5Bdata%5D=created&columns%5B9%5D%5Bname%5D=b.created&columns%5B9%5D%5Bsearchable%5D=true&columns%5B9%5D%5Borderable%5D=true&columns%5B9%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B9%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B10%5D%5Bdata%5D=icon&columns%5B10%5D%5Bname%5D=s.icon&columns%5B10%5D%5Bsearchable%5D=true&columns%5B10%5D%5Borderable%5D=true&columns%5B10%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B10%5D%5Bsearch%5D%5Bregex%5D=false&draw=1&length=10&order%5B0%5D%5Bcolumn%5D=7&order%5B0%5D%5Bdir%5D=desc&search%5Bvalue%5D=&search%5Bregex%5D=false&start=0"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\SecurityAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\SecurityAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "sirh-db.chlyq6uxnmog.eu-west-1.rds.amazonaws.com"
    "port" => 3306
    "user" => "Dev"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "sirh"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.enable AS enable_7, t0.created AS created_8, t0.email AS email_9, t0.updated AS updated_10, t0.user_updated_id AS user_updated_id_11, t0.dossier_responsable_id AS dossier_responsable_id_12 FROM users t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "g.safouane"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.abreviation AS abreviation_3, t0.date AS date_4, t0.is_valider AS is_valider_5, t0.is_integrer AS is_integrer_6 FROM periode t0 WHERE t0.code = ? LIMIT 1"
  "params" => [
    1 => "032025"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p1_.designation AS designation_1, p2_.designation AS designation_2, p3_.designation AS designation_3, p4_.abreviation AS abreviation_4, p0_.code AS code_5, p0_.created AS created_6, p0_.type AS type_7, p5_.designation AS designation_8, p6_.designation AS designation_9, p6_.icon AS icon_10 FROM pbordereau p0_ INNER JOIN pstatut p6_ ON p0_.statut_id = p6_.id INNER JOIN periode p4_ ON p0_.periode_id = p4_.id INNER JOIN pdossier p1_ ON p0_.dossier_id = p1_.id INNER JOIN pdevise p3_ ON p0_.devise_id = p3_.id INNER JOIN ppaiement p2_ ON p0_.paiement_id = p2_.id LEFT JOIN pnature_contract p5_ ON p0_.nature_contract_id = p5_.id WHERE p0_.active = 1 AND p0_.periode_id = ? AND p1_.id = ? ORDER BY p3_.designation DESC"
  "params" => [
    1 => 46
    2 => 3
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p1_.designation AS designation_1, p2_.designation AS designation_2, p3_.designation AS designation_3, p4_.abreviation AS abreviation_4, p0_.code AS code_5, p0_.created AS created_6, p0_.type AS type_7, p5_.designation AS designation_8, p6_.designation AS designation_9, p6_.icon AS icon_10 FROM pbordereau p0_ INNER JOIN pstatut p6_ ON p0_.statut_id = p6_.id INNER JOIN periode p4_ ON p0_.periode_id = p4_.id INNER JOIN pdossier p1_ ON p0_.dossier_id = p1_.id INNER JOIN pdevise p3_ ON p0_.devise_id = p3_.id INNER JOIN ppaiement p2_ ON p0_.paiement_id = p2_.id LEFT JOIN pnature_contract p5_ ON p0_.nature_contract_id = p5_.id WHERE p0_.active = 1 AND p0_.periode_id = ? AND p1_.id = ? ORDER BY p0_.id DESC LIMIT 10"
  "params" => [
    1 => 46
    2 => 3
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.type AS type_3, t0.code AS code_4, t0.nature AS nature_5, t0.observation AS observation_6, t0.active AS active_7, t0.date_integration AS date_integration_8, t0.unique_id AS unique_id_9, t0.motif_annulation AS motif_annulation_10, t0.periode_id AS periode_id_11, t0.user_created_id AS user_created_id_12, t0.dossier_id AS dossier_id_13, t0.paiement_id AS paiement_id_14, t0.piece_id AS piece_id_15, t0.nature_contract_id AS nature_contract_id_16, t0.statut_id AS statut_id_17, t0.devise_id AS devise_id_18, t0.user_integration_id AS user_integration_id_19, t0.user_annulation_id AS user_annulation_id_20, t0.rubrique_indiminite_id AS rubrique_indiminite_id_21 FROM pbordereau t0 WHERE t0.id = ?"
  "params" => [
    1 => 7293
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.annee AS annee_2, t0.code AS code_3, t0.observation AS observation_4, t0.active AS active_5, t0.motif_annulation AS motif_annulation_6, t0.taux_cotis_cimr AS taux_cotis_cimr_7, t0.categorie_cimr AS categorie_cimr_8, t0.periode_id AS periode_id_9, t0.contract_id AS contract_id_10, t0.dossier_id AS dossier_id_11, t0.devise_id AS devise_id_12, t0.paiement_id AS paiement_id_13, t0.bordereau_id AS bordereau_id_14, t0.piece_id AS piece_id_15, t0.user_annulation_id AS user_annulation_id_16 FROM tbulletin t0 WHERE t0.bordereau_id = ?"
  "params" => [
    1 => 7293
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 107095
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 107096
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 107097
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 107098
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 107099
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.type AS type_3, t0.code AS code_4, t0.nature AS nature_5, t0.observation AS observation_6, t0.active AS active_7, t0.date_integration AS date_integration_8, t0.unique_id AS unique_id_9, t0.motif_annulation AS motif_annulation_10, t0.periode_id AS periode_id_11, t0.user_created_id AS user_created_id_12, t0.dossier_id AS dossier_id_13, t0.paiement_id AS paiement_id_14, t0.piece_id AS piece_id_15, t0.nature_contract_id AS nature_contract_id_16, t0.statut_id AS statut_id_17, t0.devise_id AS devise_id_18, t0.user_integration_id AS user_integration_id_19, t0.user_annulation_id AS user_annulation_id_20, t0.rubrique_indiminite_id AS rubrique_indiminite_id_21 FROM pbordereau t0 WHERE t0.id = ?"
  "params" => [
    1 => 7292
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.annee AS annee_2, t0.code AS code_3, t0.observation AS observation_4, t0.active AS active_5, t0.motif_annulation AS motif_annulation_6, t0.taux_cotis_cimr AS taux_cotis_cimr_7, t0.categorie_cimr AS categorie_cimr_8, t0.periode_id AS periode_id_9, t0.contract_id AS contract_id_10, t0.dossier_id AS dossier_id_11, t0.devise_id AS devise_id_12, t0.paiement_id AS paiement_id_13, t0.bordereau_id AS bordereau_id_14, t0.piece_id AS piece_id_15, t0.user_annulation_id AS user_annulation_id_16 FROM tbulletin t0 WHERE t0.bordereau_id = ?"
  "params" => [
    1 => 7292
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 107094
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.type AS type_3, t0.code AS code_4, t0.nature AS nature_5, t0.observation AS observation_6, t0.active AS active_7, t0.date_integration AS date_integration_8, t0.unique_id AS unique_id_9, t0.motif_annulation AS motif_annulation_10, t0.periode_id AS periode_id_11, t0.user_created_id AS user_created_id_12, t0.dossier_id AS dossier_id_13, t0.paiement_id AS paiement_id_14, t0.piece_id AS piece_id_15, t0.nature_contract_id AS nature_contract_id_16, t0.statut_id AS statut_id_17, t0.devise_id AS devise_id_18, t0.user_integration_id AS user_integration_id_19, t0.user_annulation_id AS user_annulation_id_20, t0.rubrique_indiminite_id AS rubrique_indiminite_id_21 FROM pbordereau t0 WHERE t0.id = ?"
  "params" => [
    1 => 7088
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.annee AS annee_2, t0.code AS code_3, t0.observation AS observation_4, t0.active AS active_5, t0.motif_annulation AS motif_annulation_6, t0.taux_cotis_cimr AS taux_cotis_cimr_7, t0.categorie_cimr AS categorie_cimr_8, t0.periode_id AS periode_id_9, t0.contract_id AS contract_id_10, t0.dossier_id AS dossier_id_11, t0.devise_id AS devise_id_12, t0.paiement_id AS paiement_id_13, t0.bordereau_id AS bordereau_id_14, t0.piece_id AS piece_id_15, t0.user_annulation_id AS user_annulation_id_16 FROM tbulletin t0 WHERE t0.bordereau_id = ?"
  "params" => [
    1 => 7088
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103881
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103882
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103883
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103884
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103885
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103886
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.type AS type_3, t0.code AS code_4, t0.nature AS nature_5, t0.observation AS observation_6, t0.active AS active_7, t0.date_integration AS date_integration_8, t0.unique_id AS unique_id_9, t0.motif_annulation AS motif_annulation_10, t0.periode_id AS periode_id_11, t0.user_created_id AS user_created_id_12, t0.dossier_id AS dossier_id_13, t0.paiement_id AS paiement_id_14, t0.piece_id AS piece_id_15, t0.nature_contract_id AS nature_contract_id_16, t0.statut_id AS statut_id_17, t0.devise_id AS devise_id_18, t0.user_integration_id AS user_integration_id_19, t0.user_annulation_id AS user_annulation_id_20, t0.rubrique_indiminite_id AS rubrique_indiminite_id_21 FROM pbordereau t0 WHERE t0.id = ?"
  "params" => [
    1 => 7087
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.annee AS annee_2, t0.code AS code_3, t0.observation AS observation_4, t0.active AS active_5, t0.motif_annulation AS motif_annulation_6, t0.taux_cotis_cimr AS taux_cotis_cimr_7, t0.categorie_cimr AS categorie_cimr_8, t0.periode_id AS periode_id_9, t0.contract_id AS contract_id_10, t0.dossier_id AS dossier_id_11, t0.devise_id AS devise_id_12, t0.paiement_id AS paiement_id_13, t0.bordereau_id AS bordereau_id_14, t0.piece_id AS piece_id_15, t0.user_annulation_id AS user_annulation_id_16 FROM tbulletin t0 WHERE t0.bordereau_id = ?"
  "params" => [
    1 => 7087
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103469
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103470
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103472
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103473
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103474
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103475
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103476
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103477
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103478
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103479
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103480
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103481
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103482
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103483
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.type AS type_3, t0.code AS code_4, t0.nature AS nature_5, t0.observation AS observation_6, t0.active AS active_7, t0.date_integration AS date_integration_8, t0.unique_id AS unique_id_9, t0.motif_annulation AS motif_annulation_10, t0.periode_id AS periode_id_11, t0.user_created_id AS user_created_id_12, t0.dossier_id AS dossier_id_13, t0.paiement_id AS paiement_id_14, t0.piece_id AS piece_id_15, t0.nature_contract_id AS nature_contract_id_16, t0.statut_id AS statut_id_17, t0.devise_id AS devise_id_18, t0.user_integration_id AS user_integration_id_19, t0.user_annulation_id AS user_annulation_id_20, t0.rubrique_indiminite_id AS rubrique_indiminite_id_21 FROM pbordereau t0 WHERE t0.id = ?"
  "params" => [
    1 => 7086
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.annee AS annee_2, t0.code AS code_3, t0.observation AS observation_4, t0.active AS active_5, t0.motif_annulation AS motif_annulation_6, t0.taux_cotis_cimr AS taux_cotis_cimr_7, t0.categorie_cimr AS categorie_cimr_8, t0.periode_id AS periode_id_9, t0.contract_id AS contract_id_10, t0.dossier_id AS dossier_id_11, t0.devise_id AS devise_id_12, t0.paiement_id AS paiement_id_13, t0.bordereau_id AS bordereau_id_14, t0.piece_id AS piece_id_15, t0.user_annulation_id AS user_annulation_id_16 FROM tbulletin t0 WHERE t0.bordereau_id = ?"
  "params" => [
    1 => 7086
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103466
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103467
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103468
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103471
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103484
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103485
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103486
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103487
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103488
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103489
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103490
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103491
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103492
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103493
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103494
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103495
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103496
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103497
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103498
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103499
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103500
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103501
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103502
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103503
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103504
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103505
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103506
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103507
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103508
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103509
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103510
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103511
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103512
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103513
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103514
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103515
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103516
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103517
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103518
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103519
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103520
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103521
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103522
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103523
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103525
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103526
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103527
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103528
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103529
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103530
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103531
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103532
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103533
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103534
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103535
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103536
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103537
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103538
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103539
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103540
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103541
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103542
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103543
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103544
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103545
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103546
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103547
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103548
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103549
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103550
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103551
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103552
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103553
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103554
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103555
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103556
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103557
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103558
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103559
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103560
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103561
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103562
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103563
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103564
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103565
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103566
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103567
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103568
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103569
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103570
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103571
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103572
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103573
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103574
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103575
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103576
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103577
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103578
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103579
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103580
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103581
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103582
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103583
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103584
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103585
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103586
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103587
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103588
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103589
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103590
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103591
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103592
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103593
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103594
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103595
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103596
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103597
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103598
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103599
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103600
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103601
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103602
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103603
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103604
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103605
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103606
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103607
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103608
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103609
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103610
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103611
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103612
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103613
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103614
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103615
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103616
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103617
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103618
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103619
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103620
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103621
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103622
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103623
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103624
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103625
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103626
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103627
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103628
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103629
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103630
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103631
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103632
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103633
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103634
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103635
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103636
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103637
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103638
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103639
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103640
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103641
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103642
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103643
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103644
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103645
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103646
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103647
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103648
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103649
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103650
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103651
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103652
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103653
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1"
  "params" => [
    1 => 103654
  ]
  "types" => [
    1 => 1
  ]
]