Sheathed jewellery gift boxes

Extensive collections of jewellery presentation boxes

Discover our collections of gift boxes for jewellery:

Learn more

Home Jewellery gift boxes Luxury Sheathed

Product lines

Luxury

Array ( [lang] => en [id_masterGamme_LAVAL] => 15 [id_masterFamille_LAVAL] => 135 [id_masterSSFamille_LAVAL] => 469 [id_masterBoutikB] => [arborescence] => TRIEUR [search] => [id_masterNiveau] => [id_masterTrieurEnfant] => Array ( [0] => ) ) Array ( [arborescence] => TRIEUR [SQL] => SELECT * FROM trieurCollection tC WHERE tC.actif = 1 AND tC.EN = 1 AND tC.id_masterTrieurParent NOT IN (9,15) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL AND tC.reference IN ( SELECT mPrix.reference FROM masterPrix mPrix INNER JOIN prix_EN mPrixLang USING(id_masterPrix) INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix WHERE ( tC.actif = 1 AND EN = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL GROUP BY tC.id_masterPrix ) GROUP BY tC.id_masterPrix [NUMBER] => 41 [texte] => (41 products) [received] => Array ( [lang] => en [id_masterGamme_LAVAL] => 15 [id_masterFamille_LAVAL] => 135 [id_masterSSFamille_LAVAL] => 469 [id_masterBoutikB] => [arborescence] => TRIEUR [search] => [id_masterNiveau] => [id_masterTrieurEnfant] => Array ( [0] => ) ) )

Sort (41 products)

ARBORESCENCE => SSFAMILLE
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS mPrix.* FROM masterPrix mPrix INNER JOIN prix_EN mPrixLang USING(id_masterPrix) LEFT OUTER JOIN masterProduit mProd USING(id_masterProduit) LEFT OUTER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND mPrix.CategorieProduit = '' AND tC.id_masterTrieurParent IN (1) AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND mProd.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL GROUP BY mPrix.id_masterProduit, tC.id_masterTrieurEnfant ORDER BY mPrix.date_online DESC, mPrix.ordre_SSFamille_LAVAL ASC, mPrix.reference ASC
SQL BOUTIQUE => SELECT SQL_CALC_FOUND_ROWS mPrix.* FROM masterPrix mPrix INNER JOIN prix_EN mPrixLang USING(id_masterPrix) LEFT OUTER JOIN masterProduit mProd USING(id_masterProduit) LEFT OUTER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND mPrix.CategorieProduit = '' AND tC.id_masterTrieurParent IN (1) AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND mProd.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL GROUP BY mPrix.id_masterProduit, tC.id_masterTrieurEnfant ORDER BY mPrix.date_online DESC, mPrix.ordre_SSFamille_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 15
:id_masterFamille_LAVAL 135
:id_masterSSFamille_LAVAL 469
:eclatement
:id_masterTrieurEnfant
:price_asked
:id_masterBoutikB =>
:search
NB PRODUIT => 26
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => ""AUTORISATION => {"type":"SSFAMILLE","array_received":{"arborescence":"SSFAMILLE","id_masterGamme_LAVAL":"15","id_masterFamille_LAVAL":"135","id_masterSSFamille_LAVAL":"469","id_masterTrieurEnfant":null,"price_asked":null,"id_masterBoutikB":null,"lang":"en"},"id_client_received":"","client":{"id_client":null,"email_client":null,"num_client":null,"statut_client":null,"id_masterNiveau":null,"label_niveau":null,"adresse":null,"ville":null,"id_pays":null,"pays":null,"id_masterCondition":null,"id_masterDelais":null,"condition_paiement":null,"delais_paiement":null,"tva":1,"ecotaxe":0,"compte_or":0,"langue":"fr","pbx_nom":null,"pbx_prenom":null,"pbx_adresse":null,"pbx_adresse2":null,"pbx_zipcode":null,"pbx_city":null,"pbx_countrycode":null},"autorisation":true}

Add to favorites