All brushes with 120 mm diameter
Array ( [id_masterBoutikB] => 1704 [id_masterBoutikA] => 1700 [label] => Brushes for REX120/200/200H [ordre] => 2 [code_import] => 1704 [date_updated] => 2025-01-23 03:00:02 [date_created] => 2024-09-28 03:00:02 [id_boutikB] => 98 [content] =>All brushes with 120 mm diameter
[color] => [back] => [image] => medias/photos-sousfamille/1704.jpg [colorOn] => [backOn] => [imageOn] => [rewrite_url] => brushes-for-rex120-200-200h [actif] => 1 [SEO] => Array ( ) [OG] => Array ( ) [income] => Array ( [lang] => en [rewrite_url_surboutik] => [rewrite_url_boutikA] => stripping-scouring [rewrite_url_boutikB] => brushes-for-rex120-200-200h [rewrite_url_boutikC] => [arborescence] => BOUTIKB [rewrite_url_trieur] => [shop] => [secondevie] => [promotions] => [id_masterBoutikA] => 1700 [id_masterBoutikB] => 1704 ) [type] => BOUTIKB [URLs] => Array ( [url_link] => en/stripping-scouring/brushes-for-rex120-200-200h/ [breadcrumbs] => STRIPPING / SCOURING Brushes for REX120/200/200H ) [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 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 colProd.id_masterBoutikA = :id_masterBoutikA AND colProd.id_masterBoutikB = :id_masterBoutikB GROUP BY mPrix.id_masterProduit ORDER BY mPrix.reference ASC, 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 )