HtmlToText
service client au 06 30 08 12 32 09h à 12h - 13h à 16h livraison gratuite à partir de 35€ d'achat mon compte se connecter mon panier 0 article - 0,00€ toggle navigation les traditionnelles cousu machine cousu main les classiques femme les fantaisies homme femme pantoufles homme femme noël les bios homme femme les sacs sac previous next ` inte18-3560 marron 28,00 € inte18-443 argent 35,00 € inte18-324 rustic léopard 25,00 € inte18-1051 taupe 89,00 € infos livraison colissimo 48h paiement sécurisé achetez sur notre site en toute confiance echange et retour 20 jours pour changer d'avis contactez-nous 06 30 08 12 32 du lundi au jeudi : 09h à 12h - 13h à 16h le vendredi : 09h à 12h nos magasins la | nos magasins | nous contacter conditions générales de vente | mentions légales '0') group by si.no_modele limit 1 + la requête s'est éxécutée en 4,34 ms. + 1 éléments trouvés en 6,98 ms requête sql : select si.no_modele as id, si.libelle as libelle, si.code_modele as codemodele, si.summary as summary, si.description as description, si.home_rating as homerating, si.user_rating as userrating, si.no_sous_famille as id_rfs, si.no_marque as id_marque, (si.prix_diff)::integer as prixdiff, si.encombrement as encombrement, si.ecotaxeht as ecotaxe, case when si.no_categorie1 = 16384 and si.no_categorie2 = 16384 and si.no_categorie3 = 16384 and si.no_categorie4 = 16384 then 0 else 1 end as havecategories, si.no_categorie1 as id_categorie1, si.no_categorie2 as id_categorie2, si.no_categorie3 as id_categorie3, si.no_categorie4 as id_categorie4, case when case when (si.cflags & 1) = 1 then 999 else si.stock_imm - si.stock_resa - si.stock_en_cde end = current_date)::integer as nouveau from ipsmodele as si left join ipscritmod as sc on (sc.no_modele = si.no_modele) left join ipscollection as col on (col.no_collection = sc.no_collection) where (si.no_modele in ('44384257')) group by si.no_modele, si.libelle, si.code_modele, si.summary, si.description, si.home_rating, si.user_rating, si.no_sous_famille, si.no_marque, (si.prix_diff)::integer, si.encombrement, si.ecotaxeht, case when si.no_categorie1 = 16384 and si.no_categorie2 = 16384 and si.no_categorie3 = 16384 and si.no_categorie4 = 16384 then 0 else 1 end, si.no_categorie1, si.no_categorie2, si.no_categorie3, si.no_categorie4, case when case when (si.cflags & 1) = 1 then 999 else si.stock_imm - si.stock_resa - si.stock_en_cde end '0') order by random(), si.no_critmod asc limit 4 + la requête s'est éxécutée en 2,57 ms. + 4 éléments trouvés en 2,68 ms requête sql : select si.no_critmod as id, si.flags as flags, si.libelle as libelle, si.description as description, si.summary as summary, si.date_first_publish as datepublished, case when (si.flags&1) = 1 then 1 else 0 end as alwaysinstock, si.new_until as datefinnouveau, (si.new_until = current_date)::integer as nouveau, (si.prix_diff)::integer as prixdiff, si.no_modele as id_modele, si.no_collection as id_collection, si.no_niveau1 as id_niveau1, si.no_niveau2 as id_niveau2, si.no_niveau3 as id_niveau3, si.no_niveau4 as id_niveau4, si.no_articles as id_articles, case when case when (si.cflags & 1) = 1 then 999 else si.stock_imm - si.stock_resa - si.stock_en_cde end = current_date)::integer as nouveau from ipsmodele as si left join ipscritmod as sc on (sc.no_modele = si.no_modele) left join ipscollection as col on (col.no_collection = sc.no_collection) where (si.no_modele in ('107495425', '45826049', '107888641', '108232705')) group by si.no_modele, si.libelle, si.code_modele, si.summary, si.description, si.home_rating, si.user_rating, si.no_sous_famille, si.no_marque, (si.prix_diff)::integer, si.encombrement, si.ecotaxeht, case when si.no_categorie1 = 16384 and si.no_categorie2 = 16384 and si.no_categorie3 = 16384 and si.no_categorie4 = 16384 then 0 else 1 end, si.no_categorie1, si.no_categorie2, si.no_categorie3, si.no_categorie4, case when case when (si.cflags & 1) = 1 then 999 else si.stock_imm - si.stock_resa - si.stock_en_cde end --