Array
(
[id_masterPrix] => 1230
[DATA] => Array
(
[PARENTS] => Array
(
[29] => Array
(
[ENFANTS] => Array
(
[176] => Array
(
[label] => 120 MM
[label_lang] => 120 MM
[image] =>
[color] =>
)
)
[ordre] => 2
[label] => Diamètre
[label_lang] => Diamètre
)
[26] => Array
(
[ENFANTS] => Array
(
[899] => Array
(
[label] => Non
[label_lang] => Non
[image] =>
[color] =>
)
)
[ordre] => 2
[label] => Multi-fonctions
[label_lang] => Multi-fonctions
)
[70] => Array
(
[ENFANTS] => Array
(
[899] => Array
(
[label] => Non
[label_lang] => Non
[image] =>
[color] =>
)
)
[ordre] => 3
[label] => Système pliant
[label_lang] => Système pliant
)
[35] => Array
(
[ENFANTS] => Array
(
[658] => Array
(
[label] => 19 MM
[label_lang] => 19 MM
[image] =>
[color] =>
)
)
[ordre] => 5
[label] => Alésage
[label_lang] => Alésage
)
[41] => Array
(
[ENFANTS] => Array
(
[899] => Array
(
[label] => Non
[label_lang] => Non
[image] =>
[color] =>
)
)
[ordre] => 11
[label] => Extension
[label_lang] => Extension
)
)
)
[sqlTrieur] => SELECT tC.*, MTP.label AS Parent, MTE.label AS Enfant, MTE.image, MTE.value, MTP.ordre FROM trieurCollection tC
INNER JOIN masterTrieurParent MTP USING(id_masterTrieurParent)
INNER JOIN masterTrieurEnfant MTE ON tC.id_masterTrieurEnfant = MTE.id_masterTrieurEnfant
WHERE tC.id_masterPrix = :id_masterPrix
ORDER BY MTP.ordre, MTE.ordre ASC
[nbTrieur] => 5
[sqlTrieurParent] => SELECT ParentLang.* FROM masterTrieurParent LEFT OUTER JOIN trieurParent_FR ParentLang USING(id_masterTrieurParent) WHERE id_masterTrieurParent = :id_masterTrieurParent
[sqlTrieurEnfant] => SELECT EnfantLang.* FROM masterTrieurEnfant LEFT OUTER JOIN trieurEnfant_FR EnfantLang USING(id_masterTrieurEnfant) WHERE id_masterTrieurEnfant = :id_masterTrieurEnfant
[id_masterProduit] => 1230
)