A complete range for construction, demolition, cutting, concrete sanding
Array ( [id_masterSurBoutik] => 3 [label] => Building [ordre] => 2 [date_updated] => 2024-12-03 15:28:36 [date_created] => 2022-09-07 16:03:44 [id_surboutik] => 2 [content] =>A complete range for construction, demolition, cutting, concrete sanding
[color] => [back] => [image] => [colorOn] => [backOn] => [imageOn] => [code_import] => [rewrite_url] => building [actif] => 1 [TRIEUR] => Array ( ) [SEO] => Array ( ) [OG] => Array ( ) [income] => Array ( [lang] => en [rewrite_url_surboutik] => building [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_EN 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] => )