[FogBugz #133] Recherche anciennes saisons trop longue #195
Loading…
Reference in New Issue
There is no content yet.
Delete Branch "%!s(<nil>)"
Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?
Assigned To: Frederik Benoist
Project: CAISSE
Area: awcaisse
Category: Bogue
Priority: A fixer impérativement
Event ID: 629
Date: 2013-07-31T05:24:41Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
Event ID: 628
Date: 2013-07-31T05:23:49Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
Fichiers VB Modifiés
Ajout d'une condition supplémentaire pour catalogue_ligne et tarif_structure.
La condition supplémentaire était prévu par DOTSOFT mais non testée (et donc buggué e) dans l'implémentation du moteur dynamique.
Event ID: 615
Date: 2013-07-16T09:51:18Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
Optimisation Sylvain
LEFT OUTER JOIN catalogue_ligne a1a91a1a0
ON (a0a1a0a0.id_produit = a1a91a1a0.id_produit)
and a1a91a1a0.id_catalogue in (select id_catalogue from catalogue_structure_promo where id_structure = XXXX)
Event ID: 614
Date: 2013-07-16T09:45:31Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
Optimisation Francois :
INNER JOIN tarif_structure a11a14a2a0
ON (a1a11a1a0.id_tarif = a11a14a2a0.id_tarif)
AND ( (a11a14a2a0.id_structure = '507')
AND a11a14a2a0.datefin > SYSDATE)) -- FMARGUIN ajout de date de validité du tarif
Event ID: 613
Date: 2013-07-16T09:43:48Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
SELECT a1a11a1a0.prix_vente,
a0a1a0a0.id_produit AS a0a1a0a0a1,
a0a1a0a0.id_famille AS a0a1a0a0a4,
a0a1a0a0.code_modele AS a0a1a0a0a3,
a0a1a0a0.id_type_produit AS a0a1a0a0a2,
a0a1a0a0.id_type_axe_valeur1 AS a0a1a0a0a6,
a0a1a0a0.id_type_axe_valeur2 AS a0a1a0a0a7,
a0a1a0a0.id_type_axe_valeur3 AS a0a1a0a0a8,
a0a1a0a0.id_type_axe_valeur4 AS a0a1a0a0a9,
a0a1a0a0.id_taxe AS a0a1a0a0a10,
a0a1a0a0.id_marque AS a0a1a0a0a21,
a0a1a0a0.id_structure AS a0a1a0a0a28,
a0a1a0a0.code_reference AS a0a1a0a0a11,
a0a1a0a0.nom AS a0a1a0a0a5,
a0a1a0a0.garantie_plantation AS a0a1a0a0a12,
a0a1a0a0.troc_axe1 AS a0a1a0a0a13,
a0a1a0a0.troc_axe2 AS a0a1a0a0a14,
a0a1a0a0.troc_axe3 AS a0a1a0a0a15,
a0a1a0a0.troc_axe4 AS a0a1a0a0a16,
a0a1a0a0.messagecentrale AS a0a1a0a0a17,
a0a1a0a0.ecotaxe AS a0a1a0a0a18,
a0a1a0a0.ecotaxe_tva AS a0a1a0a0a19,
a0a1a0a0.prix_vente AS a0a1a0a0a20,
a0a1a0a0.reference_constructeur AS a0a1a0a0a22,
a0a1a0a0.garantie_5_ans AS a0a1a0a0a26,
a0a1a0a0.garantieenpourcent AS a0a1a0a0a27,
a0a1a0a0.gestion_valeur AS a0a1a0a0a29,
a0a1a0a0.prochaine_reference AS a0a1a0a0a30,
a0a1a0a0.id_etat AS a0a1a0a0a31,
a0a1a0a0.annules AS a0a1a0a0a32,
a0a1a0a0.abandonnes AS a0a1a0a0a33,
a1a154a1a0.id_type_carte AS a1a154a1a0a6941,
a1a154a1a0.id_produit AS a1a154a1a0a6942,
a1a154a1a0.capoint AS a1a154a1a0a6943,
a1a154a1a0.capointremise AS a1a154a1a0a6944,
a1a134a1a0.id_marque AS a1a134a1a0a6141,
a1a134a1a0.nom AS a1a134a1a0a6142,
a1a20a1a0.produit_bipable AS a1a20a1a0a722,
a1a20a1a0.id_type_produit AS a1a20a1a0a721,
a20a21a2a0.id_type_produit AS a20a21a2a0a761,
a20a21a2a0.id_distrib AS a20a21a2a0a762,
a20a21a2a0.accept_repart_remis_pd_tick AS a20a21a2a0a782,
a20a21a2a0.afficher_dans_panneau_bouton AS a20a21a2a0a777,
a20a21a2a0.autoriser_retour AS a20a21a2a0a775,
a20a21a2a0.couleur AS a20a21a2a0a776,
a20a21a2a0.dispo_mode_deconnecte AS a20a21a2a0a781,
a20a21a2a0.exclure_calcul_fidelisation AS a20a21a2a0a784,
a20a21a2a0.exclure_calcul_op_commercial AS a20a21a2a0a785,
a20a21a2a0.forcer_selection_consommateur AS a20a21a2a0a763,
a20a21a2a0.forcer_selection_motif AS a20a21a2a0a765,
a20a21a2a0.print_comme_ligne_sur_ticket AS a20a21a2a0a766,
a20a21a2a0.imprimer_en_pied_ticket AS a20a21a2a0a768,
a20a21a2a0.montant_mini AS a20a21a2a0a770,
a20a21a2a0.montant_modifiable AS a20a21a2a0a773,
a20a21a2a0.pourcentage_mini_total_ticket AS a20a21a2a0a771,
a20a21a2a0.quantite_modifiable AS a20a21a2a0a774,
a20a21a2a0.remise_interdite AS a20a21a2a0a783,
a20a21a2a0.saisie_montant AS a20a21a2a0a764,
a20a21a2a0.sens_accepte AS a20a21a2a0a769,
a20a21a2a0.texte_remplacement_mt_null AS a20a21a2a0a772,
a20a21a2a0.total_en_pied_ticket AS a20a21a2a0a767,
a20a21a2a0.type_remise_maxi AS a20a21a2a0a778,
a20a21a2a0.un_seul_par_ticket AS a20a21a2a0a780,
a20a21a2a0.valeur_remise_maxi AS a20a21a2a0a779,
a20a21a2a0.prefix_code_barre AS a20a21a2a0a786,
a20a21a2a0.longueur_code_barre AS a20a21a2a0a787,
a20a21a2a0.type_code_barre AS a20a21a2a0a788,
a20a21a2a0.id_type_bon_achat AS a20a21a2a0a789,
a20a21a2a0.gestion_stock AS a20a21a2a0a792,
a20a21a2a0.impressionba AS a20a21a2a0a791,
a21a26a3a0.id_type_produit AS a21a26a3a0a1001,
a21a26a3a0.id_distrib AS a21a26a3a0a1002,
a21a26a3a0.code_motif AS a21a26a3a0a1003,
a21a26a3a0.date_deb AS a21a26a3a0a1004,
a21a26a3a0.date_fin AS a21a26a3a0a1005,
a21a26a3a0.id_pays AS a21a26a3a0a1006,
a26a27a4a0.code_motif AS a26a27a4a0a1041,
a26a27a4a0.forcer_selection_vendeur AS a26a27a4a0a1044,
a26a27a4a0.autoris_saisie_nouveau_prix AS a26a27a4a0a1050,
a26a27a4a0.deductible_du_total_ticket AS a26a27a4a0a1049,
a26a27a4a0.deduire_remise_pour_retour AS a26a27a4a0a1048,
a26a27a4a0.detail_par_ligne_article AS a26a27a4a0a1046,
a26a27a4a0.libelle AS a26a27a4a0a1042,
a26a27a4a0.libellecourt AS a26a27a4a0a1043,
a26a27a4a0.message_sur_ticket AS a26a27a4a0a1051,
a26a27a4a0.possible_pour_pied_ticket AS a26a27a4a0a1056,
a26a27a4a0.possible_pour_sous_total AS a26a27a4a0a1055,
a26a27a4a0.saisie_commentaire AS a26a27a4a0a1045,
a26a27a4a0.sens_valeur_accepte AS a26a27a4a0a1052,
a26a27a4a0.total_en_pied_de_ticket AS a26a27a4a0a1047,
a26a27a4a0.type_valeur AS a26a27a4a0a1053,
a26a27a4a0.valeur_defaut AS a26a27a4a0a1054,
a26a27a4a0.restockage_produit_retour AS a26a27a4a0a1057,
a26a27a4a0.alimenter_panier_litige AS a26a27a4a0a1058,
a26a27a4a0.valeur_maxi AS a26a27a4a0a1059,
a27a103a5a0.code_motif AS a27a103a5a0a4901,
a27a103a5a0.code AS a27a103a5a0a4902,
a27a103a5a0.libelle AS a27a103a5a0a4903,
a27a103a5a0.libellecourt AS a27a103a5a0a4904,
a21a57a3a0.id_type_bon_achat AS a21a57a3a0a2241,
a21a57a3a0.prefix_code_barre AS a21a57a3a0a2242,
a21a57a3a0.libelle AS a21a57a3a0a2243,
a21a57a3a0.longueur AS a21a57a3a0a2244,
a21a57a3a0.TYPE AS a21a57a3a0a2245,
a21a57a3a0.duree_validite_en_jours AS a21a57a3a0a2246,
a21a57a3a0.remonter_client AS a21a57a3a0a2247,
a57a120a4a0.id_type_bon_achat AS a57a120a4a0a5581,
a57a120a4a0.id_distrib AS a57a120a4a0a5582,
a57a120a4a0.duree_validite_en_jours AS a57a120a4a0a5583,
a57a120a4a0.secable AS a57a120a4a0a5584,
a1a99a1a0.id_produit AS a1a99a1a0a4741,
a1a99a1a0.code AS a1a99a1a0a4742,
a1a99a1a0.nom AS a1a99a1a0a4743,
a1a99a1a0.troc_axe1 AS a1a99a1a0a4744,
a1a99a1a0.troc_axe2 AS a1a99a1a0a4745,
a1a99a1a0.troc_axe3 AS a1a99a1a0a4746,
a1a99a1a0.troc_axe4 AS a1a99a1a0a4747,
a1a99a1a0.messagecentrale AS a1a99a1a0a4748,
a1a15a1a0.id_produit AS a1a15a1a0a562,
a1a15a1a0.code_barre AS a1a15a1a0a561,
a1a24a1a0.id_taxe AS a1a24a1a0a921,
a1a24a1a0.nom AS a1a24a1a0a922,
a24a25a2a0.id_pays AS a24a25a2a0a961,
a24a25a2a0.id_taxe AS a24a25a2a0a962,
a24a25a2a0.pourcentage AS a24a25a2a0a963,
a24a25a2a0.nom AS a24a25a2a0a964,
a25a161a3a0.id_pays AS a25a161a3a0a7122,
a25a161a3a0.id_taxe AS a25a161a3a0a7121,
a25a161a3a0.date_deb AS a25a161a3a0a7123,
a25a161a3a0.pourcentage AS a25a161a3a0a7125,
a25a161a3a0.date_fin AS a25a161a3a0a7124,
a1a119a1a0.id_pays AS a1a119a1a0a5541,
a1a119a1a0.id_produit AS a1a119a1a0a5542,
a1a119a1a0.id_taxe AS a1a119a1a0a5543,
a119a24a2a1.id_taxe AS a119a24a2a1a921,
a119a24a2a1.nom AS a119a24a2a1a922,
a24a25a3a1.id_pays AS a24a25a3a1a961,
a24a25a3a1.id_taxe AS a24a25a3a1a962,
a24a25a3a1.pourcentage AS a24a25a3a1a963,
a24a25a3a1.nom AS a24a25a3a1a964,
a25a161a4a1.id_pays AS a25a161a4a1a7122,
a25a161a4a1.id_taxe AS a25a161a4a1a7121,
a25a161a4a1.date_deb AS a25a161a4a1a7123,
a25a161a4a1.pourcentage AS a25a161a4a1a7125,
a25a161a4a1.date_fin AS a25a161a4a1a7124,
a1a126a1a0.id_distrib AS a1a126a1a0a5821,
a1a126a1a0.id_structure AS a1a126a1a0a5822,
a1a126a1a0.id_produit AS a1a126a1a0a5823,
a1a126a1a0.id_carte_fidelite_type AS a1a126a1a0a5825,
a1a126a1a0.garantie AS a1a126a1a0a5824,
a1a4a1a0.id_famille AS a1a4a1a0a81,
a1a4a1a0.id_famille_parent AS a1a4a1a0a82,
a1a4a1a0.id_type_axe1 AS a1a4a1a0a83,
a1a4a1a0.id_type_axe2 AS a1a4a1a0a84,
a1a4a1a0.id_type_axe3 AS a1a4a1a0a85,
a1a4a1a0.id_type_axe4 AS a1a4a1a0a86,
a1a4a1a0.niveau AS a1a4a1a0a87,
a1a4a1a0.id_couleur AS a1a4a1a0a89,
a1a4a1a0.nom AS a1a4a1a0a88,
a1a4a1a0.ecotaxe AS a1a4a1a0a90,
a1a4a1a0.garantie_par_defaut AS a1a4a1a0a91,
a1a4a1a0.saisie_serie AS a1a4a1a0a92,
a1a4a1a0.extension_garantie AS a1a4a1a0a93,
a1a4a1a0.code_externe AS a1a4a1a0a94,
a4a137a2a0.id_type_carte AS a4a137a2a0a6261,
a4a137a2a0.id_famille AS a4a137a2a0a6262,
a4a137a2a0.capoint AS a4a137a2a0a6263,
a4a137a2a0.capointremise AS a4a137a2a0a6264,
a1a4a1a1.id_famille AS a1a4a1a1a81,
a1a4a1a1.id_famille_parent AS a1a4a1a1a82,
a1a4a1a1.id_type_axe1 AS a1a4a1a1a83,
a1a4a1a1.id_type_axe2 AS a1a4a1a1a84,
a1a4a1a1.id_type_axe3 AS a1a4a1a1a85,
a1a4a1a1.id_type_axe4 AS a1a4a1a1a86,
a1a4a1a1.niveau AS a1a4a1a1a87,
a1a4a1a1.id_couleur AS a1a4a1a1a89,
a1a4a1a1.nom AS a1a4a1a1a88,
a1a4a1a1.ecotaxe AS a1a4a1a1a90,
a1a4a1a1.garantie_par_defaut AS a1a4a1a1a91,
a1a4a1a1.saisie_serie AS a1a4a1a1a92,
a1a4a1a1.extension_garantie AS a1a4a1a1a93,
a1a4a1a1.code_externe AS a1a4a1a1a94,
a1a4a1a2.id_famille AS a1a4a1a2a81,
a1a4a1a2.id_famille_parent AS a1a4a1a2a82,
a1a4a1a2.id_type_axe1 AS a1a4a1a2a83,
a1a4a1a2.id_type_axe2 AS a1a4a1a2a84,
a1a4a1a2.id_type_axe3 AS a1a4a1a2a85,
a1a4a1a2.id_type_axe4 AS a1a4a1a2a86,
a1a4a1a2.niveau AS a1a4a1a2a87,
a1a4a1a2.id_couleur AS a1a4a1a2a89,
a1a4a1a2.nom AS a1a4a1a2a88,
a1a4a1a2.ecotaxe AS a1a4a1a2a90,
a1a4a1a2.garantie_par_defaut AS a1a4a1a2a91,
a1a4a1a2.saisie_serie AS a1a4a1a2a92,
a1a4a1a2.extension_garantie AS a1a4a1a2a93,
a1a4a1a2.code_externe AS a1a4a1a2a94,
a1a4a1a3.id_famille AS a1a4a1a3a81,
a1a4a1a3.id_famille_parent AS a1a4a1a3a82,
a1a4a1a3.id_type_axe1 AS a1a4a1a3a83,
a1a4a1a3.id_type_axe2 AS a1a4a1a3a84,
a1a4a1a3.id_type_axe3 AS a1a4a1a3a85,
a1a4a1a3.id_type_axe4 AS a1a4a1a3a86,
a1a4a1a3.niveau AS a1a4a1a3a87,
a1a4a1a3.id_couleur AS a1a4a1a3a89,
a1a4a1a3.nom AS a1a4a1a3a88,
a1a4a1a3.ecotaxe AS a1a4a1a3a90,
a1a4a1a3.garantie_par_defaut AS a1a4a1a3a91,
a1a4a1a3.saisie_serie AS a1a4a1a3a92,
a1a4a1a3.extension_garantie AS a1a4a1a3a93,
a1a4a1a3.code_externe AS a1a4a1a3a94,
a1a17a1a0.id AS a1a17a1a0a641,
a1a17a1a0.id_type_axe AS a1a17a1a0a642,
a1a17a1a0.id_principal AS a1a17a1a0a643,
a1a17a1a0.valeur AS a1a17a1a0a644,
a1a17a1a0.code_externe AS a1a17a1a0a645,
a17a18a2a0.id AS a17a18a2a0a681,
a17a18a2a0.code AS a17a18a2a0a682,
a17a18a2a0.libelle AS a17a18a2a0a683,
a17a18a2a0.valeur AS a17a18a2a0a684,
a17a18a2a0.code_externe AS a17a18a2a0a685,
a1a17a1a1.id AS a1a17a1a1a641,
a1a17a1a1.id_type_axe AS a1a17a1a1a642,
a1a17a1a1.id_principal AS a1a17a1a1a643,
a1a17a1a1.valeur AS a1a17a1a1a644,
a1a17a1a1.code_externe AS a1a17a1a1a645,
a1a91a1a0.id_ligne AS a1a91a1a0a4381,
a1a91a1a0.id_catalogue AS a1a91a1a0a4382,
a1a91a1a0.id_produit AS a1a91a1a0a4383,
a1a95a1a0.id_produit AS a1a95a1a0a4581,
a1a95a1a0.id_pays AS a1a95a1a0a4582,
a1a95a1a0.ecotaxe AS a1a95a1a0a4583,
a1a11a1a0.id_tarif AS a1a11a1a0a401,
a1a11a1a0.id_produit AS a1a11a1a0a402,
a1a11a1a0.prix_vente AS a1a11a1a0a403,
a1a11a1a0.prix_vente_points AS a1a11a1a0a404,
a1a11a1a0.points_prix_vente AS a1a11a1a0a405,
a1a11a1a0.points AS a1a11a1a0a406,
a1a11a1a0.prix_minimal AS a1a11a1a0a407,
a11a14a2a0.id_tarif AS a11a14a2a0a521,
a11a14a2a0.id_structure AS a11a14a2a0a522,
a11a14a2a0.datedeb AS a11a14a2a0a523,
a11a14a2a0.datefin AS a11a14a2a0a524,
a11a14a2a0.datecreation AS a11a14a2a0a525,
a11a36a2a0.id_tarif AS a11a36a2a0a1441,
a11a36a2a0.code_motif AS a11a36a2a0a1444,
a11a36a2a0.code_saison AS a11a36a2a0a1443,
a11a36a2a0.id_devise AS a11a36a2a0a1445,
a11a36a2a0.solde AS a11a36a2a0a1442,
a11a36a2a0.type_tarif AS a11a36a2a0a1446,
a11a36a2a0.ht AS a11a36a2a0a1447,
a36a27a3a1.code_motif AS a36a27a3a1a1041,
a36a27a3a1.forcer_selection_vendeur AS a36a27a3a1a1044,
a36a27a3a1.autoris_saisie_nouveau_prix AS a36a27a3a1a1050,
a36a27a3a1.deductible_du_total_ticket AS a36a27a3a1a1049,
a36a27a3a1.deduire_remise_pour_retour AS a36a27a3a1a1048,
a36a27a3a1.detail_par_ligne_article AS a36a27a3a1a1046,
a36a27a3a1.libelle AS a36a27a3a1a1042,
a36a27a3a1.libellecourt AS a36a27a3a1a1043,
a36a27a3a1.message_sur_ticket AS a36a27a3a1a1051,
a36a27a3a1.possible_pour_pied_ticket AS a36a27a3a1a1056,
a36a27a3a1.possible_pour_sous_total AS a36a27a3a1a1055,
a36a27a3a1.saisie_commentaire AS a36a27a3a1a1045,
a36a27a3a1.sens_valeur_accepte AS a36a27a3a1a1052,
a36a27a3a1.total_en_pied_de_ticket AS a36a27a3a1a1047,
a36a27a3a1.type_valeur AS a36a27a3a1a1053,
a36a27a3a1.valeur_defaut AS a36a27a3a1a1054,
a36a27a3a1.restockage_produit_retour AS a36a27a3a1a1057,
a36a27a3a1.alimenter_panier_litige AS a36a27a3a1a1058,
a36a27a3a1.valeur_maxi AS a36a27a3a1a1059,
a27a103a4a1.code_motif AS a27a103a4a1a4901,
a27a103a4a1.code AS a27a103a4a1a4902,
a27a103a4a1.libelle AS a27a103a4a1a4903,
a27a103a4a1.libellecourt AS a27a103a4a1a4904,
a1a127a1a0.id_structure AS a1a127a1a0a5861,
a1a127a1a0.id_produit AS a1a127a1a0a5862,
a1a127a1a0.pvttc AS a1a127a1a0a5863,
a127a33a2a0.id_structure AS a127a33a2a0a1321,
a127a33a2a0.id_devise AS a127a33a2a0a1324,
a127a33a2a0.id_pays3 AS a127a33a2a0a1325,
a127a33a2a0.id_distrib AS a127a33a2a0a1326,
a127a33a2a0.id_cp3 AS a127a33a2a0a1330,
a127a33a2a0.id_taxe AS a127a33a2a0a1334,
a127a33a2a0.num_interne AS a127a33a2a0a1336,
a127a33a2a0.nom AS a127a33a2a0a1322,
a127a33a2a0.enseigne AS a127a33a2a0a1323,
a127a33a2a0.adresse1 AS a127a33a2a0a1327,
a127a33a2a0.adresse2 AS a127a33a2a0a1328,
a127a33a2a0.adresse3 AS a127a33a2a0a1329,
a127a33a2a0.tel3 AS a127a33a2a0a1331,
a127a33a2a0.fax3 AS a127a33a2a0a1332,
a127a33a2a0.mail AS a127a33a2a0a1333,
a127a33a2a0.droits_speciaux AS a127a33a2a0a1335,
a127a33a2a0.cp_sur_ticket AS a127a33a2a0a1337,
a127a33a2a0.campagne_chalandise_debut AS a127a33a2a0a1338,
a127a33a2a0.campagne_chalandise_fin AS a127a33a2a0a1339,
a127a33a2a0.decalage_horaire_ete AS a127a33a2a0a1340,
a127a33a2a0.decalage_horaire_hiver AS a127a33a2a0a1341,
a127a33a2a0.langue AS a127a33a2a0a1342,
a127a33a2a0.tel_sav AS a127a33a2a0a1343,
a127a33a2a0.capital_social AS a127a33a2a0a1344,
a127a33a2a0.type_societe AS a127a33a2a0a1345,
a127a33a2a0.num_siret AS a127a33a2a0a1346,
a127a33a2a0.numero_rc AS a127a33a2a0a1347,
a127a33a2a0.num_tva AS a127a33a2a0a1348,
a127a33a2a0.numero_id_fiscale AS a127a33a2a0a1349,
a127a33a2a0.id_niveau AS a127a33a2a0a1350,
a127a33a2a0.id_structure_parent AS a127a33a2a0a1351,
a127a33a2a0.structures_parents AS a127a33a2a0a1352,
a127a33a2a0.prefix_ip AS a127a33a2a0a1353,
a127a33a2a0.nb_factures AS a127a33a2a0a1354,
a127a33a2a0.nbre_jour_validite_pwd AS a127a33a2a0a1355,
a127a33a2a0.denominationsociale AS a127a33a2a0a1356,
a127a33a2a0.mentionlegale AS a127a33a2a0a1357,
a127a33a2a0.gpslatitude AS a127a33a2a0a1358,
a127a33a2a0.gpslongitude AS a127a33a2a0a1359,
a127a33a2a0.horaires_jours_ouverture AS a127a33a2a0a1360,
a127a33a2a0.ecommerce AS a127a33a2a0a1361
FROM ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( produit a0a1a0a0
LEFT OUTER JOIN
carte_fidelite_type_produit a1a154a1a0
ON (a0a1a0a0.id_produit =
a1a154a1a0.id_produit))
LEFT OUTER JOIN
marque a1a134a1a0
ON (a0a1a0a0.id_marque =
a1a134a1a0.id_marque))
INNER JOIN
produit_type a1a20a1a0
ON (a0a1a0a0.id_type_produit =
a1a20a1a0.id_type_produit))
LEFT OUTER JOIN
produit_type_distrib a20a21a2a0
ON (a1a20a1a0.id_type_produit =
a20a21a2a0.id_type_produit)
AND ( (a20a21a2a0.id_distrib =
'3')))
LEFT OUTER JOIN
produit_type_distrib_motif a21a26a3a0
ON ( a20a21a2a0.id_type_produit =
a21a26a3a0.id_type_produit
AND a20a21a2a0.id_distrib =
a21a26a3a0.id_distrib)
AND ( (a21a26a3a0.id_distrib =
'3')))
LEFT OUTER JOIN
motif a26a27a4a0
ON (a21a26a3a0.code_motif =
a26a27a4a0.code_motif))
LEFT OUTER JOIN
language_motif a27a103a5a0
ON (a26a27a4a0.code_motif =
a27a103a5a0.code_motif)
AND ( (a27a103a5a0.code =
'4')))
LEFT OUTER JOIN
param_type_bon_achat a21a57a3a0
ON (a20a21a2a0.id_type_bon_achat =
a21a57a3a0.id_type_bon_achat))
LEFT OUTER JOIN
param_type_bon_achat_distrib a57a120a4a0
ON (a21a57a3a0.id_type_bon_achat =
a57a120a4a0.id_type_bon_achat)
AND ( (a57a120a4a0.id_distrib =
'3')))
LEFT OUTER JOIN
language_produit a1a99a1a0
ON (a0a1a0a0.id_produit =
a1a99a1a0.id_produit)
AND ( (a1a99a1a0.id_produit =
'1896359')
AND (a1a99a1a0.code =
'4')))
LEFT OUTER JOIN
produit_code_barre a1a15a1a0
ON (a0a1a0a0.id_produit =
a1a15a1a0.id_produit))
LEFT OUTER JOIN
param_taxes a1a24a1a0
ON (a0a1a0a0.id_taxe =
a1a24a1a0.id_taxe))
LEFT OUTER JOIN
param_taxes_valeur a24a25a2a0
ON (a1a24a1a0.id_taxe =
a24a25a2a0.id_taxe)
AND ( (a24a25a2a0.id_pays =
'87')))
LEFT OUTER JOIN
param_taxes_valeur_histo a25a161a3a0
ON ( a24a25a2a0.id_pays =
a25a161a3a0.id_pays
AND a24a25a2a0.id_taxe =
a25a161a3a0.id_taxe))
LEFT OUTER JOIN
param_taxes_produit_pays a1a119a1a0
ON (a0a1a0a0.id_produit =
a1a119a1a0.id_produit)
AND ( (a1a119a1a0.id_pays =
'87')))
LEFT OUTER JOIN
param_taxes a119a24a2a1
ON (a1a119a1a0.id_taxe =
a119a24a2a1.id_taxe))
LEFT OUTER JOIN
param_taxes_valeur a24a25a3a1
ON (a119a24a2a1.id_taxe =
a24a25a3a1.id_taxe)
AND ( (a24a25a3a1.id_pays =
'87')))
LEFT OUTER JOIN
param_taxes_valeur_histo a25a161a4a1
ON ( a24a25a3a1.id_pays =
a25a161a4a1.id_pays
AND a24a25a3a1.id_taxe =
a25a161a4a1.id_taxe))
LEFT OUTER JOIN
produit_structure_garantie a1a126a1a0
ON (a0a1a0a0.id_produit =
a1a126a1a0.id_produit)
AND ( (a1a126a1a0.id_distrib =
'3')))
LEFT OUTER JOIN
produit_famille a1a4a1a0
ON (a0a1a0a0.id_famille =
a1a4a1a0.id_famille))
LEFT OUTER JOIN
carte_fidelite_type_famille a4a137a2a0
ON (a1a4a1a0.id_famille =
a4a137a2a0.id_famille))
LEFT OUTER JOIN
produit_famille a1a4a1a1
ON (a0a1a0a0.id_famille =
a1a4a1a1.id_famille))
LEFT OUTER JOIN
produit_famille a1a4a1a2
ON (a0a1a0a0.id_famille =
a1a4a1a2.id_famille))
LEFT OUTER JOIN
produit_famille a1a4a1a3
ON (a0a1a0a0.id_famille =
a1a4a1a3.id_famille))
LEFT OUTER JOIN
param_axe_valeur a1a17a1a0
ON (a0a1a0a0.id_type_axe_valeur1 =
a1a17a1a0.id))
LEFT OUTER JOIN
language_param_axe_valeur a17a18a2a0
ON (a1a17a1a0.id =
a17a18a2a0.id))
LEFT OUTER JOIN
param_axe_valeur a1a17a1a1
ON (a0a1a0a0.id_type_axe_valeur2 =
a1a17a1a1.id))
LEFT OUTER JOIN
catalogue_ligne a1a91a1a0
ON (a0a1a0a0.id_produit =
a1a91a1a0.id_produit))
LEFT OUTER JOIN
produit_ecopart_pays a1a95a1a0
ON (a0a1a0a0.id_produit =
a1a95a1a0.id_produit)
AND ( (a1a95a1a0.id_produit =
'1896359')
AND (a1a95a1a0.id_pays = '87')))
INNER JOIN
tarif_ligne a1a11a1a0
ON (a0a1a0a0.id_produit =
a1a11a1a0.id_produit))
INNER JOIN
tarif_structure a11a14a2a0
ON (a1a11a1a0.id_tarif = a11a14a2a0.id_tarif)
AND ( (a11a14a2a0.id_structure = '507')
-- AND a11a14a2a0.datefin > SYSDATE))
-- FMARGUIN ajout de date de validité du tarif
INNER JOIN
tarif a11a36a2a0
ON (a1a11a1a0.id_tarif = a11a36a2a0.id_tarif))
LEFT OUTER JOIN
motif a36a27a3a1
ON (a11a36a2a0.code_motif = a36a27a3a1.code_motif))
LEFT OUTER JOIN
language_motif a27a103a4a1
ON (a36a27a3a1.code_motif = a27a103a4a1.code_motif)
AND ( (a27a103a4a1.code = '4')))
LEFT OUTER JOIN
produit_structure_visu a1a127a1a0
ON (a0a1a0a0.id_produit = a1a127a1a0.id_produit)
AND ( (a1a127a1a0.id_structure = '507')))
LEFT OUTER JOIN
structure a127a33a2a0
ON (a1a127a1a0.id_structure = a127a33a2a0.id_structure))
WHERE (a0a1a0a0.id_produit = '1896359')
Event ID: 612
Date: 2013-07-16T09:40:05Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist
Event ID: 611
Date: 2013-07-16T09:40:04Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist