Array
(
[id_masterPrix] => 49
[DATA] => Array
(
[PARENTS] => Array
(
[14] => Array
(
[ENFANTS] => Array
(
[899] => Array
(
[label] => Non
[label_lang] => Non
[image] =>
[color] =>
)
)
[ordre] => 4
[label] => Fonction eau et poussières
[label_lang] => wet and dry function
)
[11] => Array
(
[ENFANTS] => Array
(
[899] => Array
(
[label] => Non
[label_lang] => Non
[image] =>
[color] =>
)
)
[ordre] => 8
[label] => Filtre cartouche
[label_lang] => cartridge filter
)
[12] => Array
(
[ENFANTS] => Array
(
[899] => Array
(
[label] => Non
[label_lang] => Non
[image] =>
[color] =>
)
)
[ordre] => 9
[label] => Sac de récupération
[label_lang] => waste bag
)
[22] => Array
(
[ENFANTS] => Array
(
[899] => Array
(
[label] => Non
[label_lang] => Non
[image] =>
[color] =>
)
)
[ordre] => 11
[label] => Equipé de roulettes
[label_lang] => with wheels
)
[5] => Array
(
[ENFANTS] => Array
(
[899] => Array
(
[label] => Non
[label_lang] => Non
[image] =>
[color] =>
)
)
[ordre] => 13
[label] => Vidange de cuve
[label_lang] => tank draining
)
)
)
[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_EN ParentLang USING(id_masterTrieurParent) WHERE id_masterTrieurParent = :id_masterTrieurParent
[sqlTrieurEnfant] => SELECT EnfantLang.* FROM masterTrieurEnfant LEFT OUTER JOIN trieurEnfant_EN EnfantLang USING(id_masterTrieurEnfant) WHERE id_masterTrieurEnfant = :id_masterTrieurEnfant
[id_masterProduit] => 49
)