verbier
WHERE ( descr LIKE _utf8"%verbier%" collate utf8_general_ci ) | | WHERE ( match (descr,nomweb,nomserie) against ('verbier*' in BOOLEAN MODE) OR match (descr,nomweb,nomserie) against ('verbier') ) > 0 | SELECT MAX(`search`.`idserie`) idserie, `search`.`cod04`, MAX(`search`.`id_tm`) id_tm, MAX(`search`.`codprecio`) codprecio, MAX(`search`.`tipomaterial_es`) tipomaterial_es, MAX(`search`.`tipomaterial_en`) tipomaterial_en, MAX(`search`.`tipomaterial_fr`) tipomaterial_fr, MAX(`search`.`tipomaterial_de`) tipomaterial_de, MAX(`search`.`id_stm`) id_stm, MAX(`search`.`subtipo_es`) subtipo_es, MAX(`search`.`subtipo_en`) subtipo_en, MAX(`search`.`subtipo_fr`) subtipo_fr, MAX(`search`.`subtipo_de`) subtipo_de, MAX(`search`.`nomserie`) nomserie, MAX(`search`.`nomweb`) nomweb, MAX(`search`.`fmtpieza`) fmtpieza, MAX(`search`.`fmtserie`) fmtserie, MAX(`search`.`fmtserie_in`) fmtserie_in, MAX(`search`.`id_tp`) id_tp, MAX(`search`.`orden`) orden, MAX(`search`.`tp_orden`) tp_orden, MAX(`search`.`visualizacion`) visualizacion, MAX(`search`.`serie_w`) serie_w, MAX(`search`.`serie_h`) serie_h, MAX(`search`.`fmt_h`) fmt_h, MAX(`search`.`fmt_w`) fmt_w, MAX(`search`.`descr`) descr, MAX(match (descr,nomweb,nomserie) against ('verbier*' in BOOLEAN MODE) + match (descr,nomweb,nomserie) against ('verbier') ) AS priority FROM `vives_db`.`search` WHERE ( match (descr,nomweb,nomserie) against ('verbier*' in BOOLEAN MODE) OR match (descr,nomweb,nomserie) against ('verbier') ) > 0 GROUP BY cod04 ORDER BY priority DESC , id_tp ASC , idserie DESC , fmtserie DESC , nomserie ASC , tp_orden , nomweb , id_tm ASC;
Searched: “verbier”
Products found: 9
Verbier-R Pulido
59,3x119,3 cm.
G.169
selling unit pieces/ box m²/ box ml/ box kg/ box box/ pallet m²/ pallet linear m/ pallet kg/ pallet 59,3x119,3 Box 2 1.42 - 36.50 24 33.96 - 876.00
Verbier-R Pulido
119,3x119,3 cm.
G.206
selling unit pieces/ box m²/ box ml/ box kg/ box box/ pallet m²/ pallet linear m/ pallet kg/ pallet 119,3x119,3 Piece 1 1.42 - 36.50 38 54.07 - 1 387.00
Verbier-R Pulido
79,3x179,3 cm.
G.176
selling unit pieces/ box m²/ box ml/ box kg/ box box/ pallet m²/ pallet linear m/ pallet kg/ pallet 79,3x179,3 Piece 1 1.42 - 36.50 38 54.04 - 1 387.00
Liston Verbier-R
10x59,3 cm.
G.161
selling unit pieces/ box m²/ box ml/ box kg/ box box/ pallet m²/ pallet linear m/ pallet kg/ pallet 10x59,3 Box 20 1.19 - 20.60 56 66.42 - 1 153.60
Verbier-R
19,4x120 cm.
G.161
selling unit pieces/ box m²/ box ml/ box kg/ box box/ pallet m²/ pallet linear m/ pallet kg/ pallet 19,4x120 Box 4 0.93 - 23.68 45 41.90 - 1 065.69
Verbier-R
60x120 cm.
G.200
selling unit pieces/ box m²/ box ml/ box kg/ box box/ pallet m²/ pallet linear m/ pallet kg/ pallet 60x120 Box 2 1.44 - 36.13 24 34.56 - 867.00
Verbier-R
120x120 cm.
G.171
selling unit pieces/ box m²/ box ml/ box kg/ box box/ pallet m²/ pallet linear m/ pallet kg/ pallet 120x120 Piece 1 1.44 - 36.13 38 54.72 - 1 372.75
Hexágono Verbier
51,9x59,9 cm.
G.186
selling unit pieces/ box m²/ box ml/ box kg/ box box/ pallet m²/ pallet linear m/ pallet kg/ pallet 51,9x59,9 Box 4 0.93 - 18.89 30 27.90 - 566.76
Tulum Verbier
36,4x33,7 cm.
G.58
selling unit pieces/ box m²/ box ml/ box kg/ box box/ pallet m²/ pallet linear m/ pallet kg/ pallet 36,4x33,7 Piece 10 0.62 - 15.89 - - - -
3 Results found for "verbier "
Result pages:
hola ambientes
Where to buy? Your inquiry has been sent successfully
There has been an error while processing your request, please try again later