Array
(
    [id_masterSurBoutik] => 3
    [label] => Construction
    [ordre] => 2
    [date_updated] => 2024-05-15 09:42:16
    [date_created] => 2022-09-07 16:03:44
    [id_surboutik] => 2
    [content] => 
Une gamme complète pour la construction, la démolition, la découpe, le ponçage du béton
    [color] => 
    [back] => 
    [image] => https://www.fartools.com/medias/FAMILLE/beton.jpg
    [colorOn] => 
    [backOn] => 
    [imageOn] => 
    [code_import] => 
    [rewrite_url] => construction
    [actif] => 1
    [TRIEUR] => Array
        (
        )

    [SEO] => Array
        (
        )

    [OG] => Array
        (
        )

    [income] => Array
        (
            [lang] => fr
            [rewrite_url_surboutik] => construction
            [rewrite_url_boutikA] => 
            [rewrite_url_boutikB] => 
            [rewrite_url_boutikC] => 
            [arborescence] => SURBOUTIK
            [rewrite_url_trieur] => 
            [shop] => 
            [secondevie] => 
            [id_masterSurBoutik] => 3
        )

    [type] => SURBOUTIK
    [URLs] => Array
        (
            [url_link] => 
            [breadcrumbs] => 
        )

    [SQLBoutique] => SELECT SQL_CALC_FOUND_ROWS mPrix.* FROM masterPrix mPrix 
						INNER JOIN prix_FR mPrixLang USING(id_masterPrix) 
						LEFT OUTER JOIN prixExceptions prixExc ON mPrix.id_masterPrix = prixExc.id_masterPrix
						LEFT OUTER JOIN prixSecondevie prixSec ON mPrix.id_masterPrix = prixSec.id_masterPrix
						LEFT OUTER JOIN masterProduit mProd USING(id_masterProduit) 
						LEFT OUTER JOIN collectionProduits colProd ON mProd.id_masterProduit = colProd.id_masterProduit
						LEFT OUTER JOIN masterSurBoutik_Navision_Collection MSBNC ON MSBNC.id_masterBoutikA = colProd.id_masterBoutikA AND ( MSBNC.id_masterBoutikB = colProd.id_masterBoutikB OR MSBNC.id_masterBoutikB = 0) AND ( MSBNC.id_masterBoutikC = colProd.id_masterBoutikC OR MSBNC.id_masterBoutikC = 0 )
						WHERE  ( ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) OR ( mPrix.support = 1 ))   AND ( prixSec.seconde_vie_actif IS NULL || prixSec.seconde_vie_actif = 0 )  AND MSBNC.value = 1 AND MSBNC.id_masterSurBoutik = :id_masterSurBoutik GROUP BY mPrix.id_masterProduit ORDER BY mPrix.ordre_BoutikA, IF( FIELD( prixExc.code_marque, 20, 11, 40, 90 ) = 0, 1, 0 ) , FIELD( prixExc.code_marque, 20, 11, 40, 90 ), mPrix.reference, mPrix.reference_fournisseur ASC
    [REWRITE_TRIEUR_SQL] => 
)