RIVISTA L'INDUSTRIALE l'industriale presenta, quindicinalmente, l'offerta di macchine utensili nuove ed usate disponibili presso i migliori rivenditori specializzati; ed inoltre interviste, news, economia, fiere, novità dalle industrie...

SCOPRI DI PIÙ»
MACCHINE IN VENDITA

Ricerca tra migliaia di macchine utensili in vendita, nuove, usate, da aste, liquidazioni e fallimenti.

ANNUNCI DI RICERCA

Annunci di ricerca di macchine utensili.

VENDI LA TUA MACCHINA

Registrati e metti in vendita on line le tue macchine utensili usate e nuove.

RIVISTA L'INDUSTRIALE
l'industriale presenta, quindicinalmente, l'offerta di macchine utensili nuove ed usate disponibili presso i migliori rivenditori specializzati; ed inoltre interviste, news, economia, fiere, novità dalle industrie...
SFOGLIA
l'ultimo numero
ABBONATI A
L'INDUSTRIALE
SCOPRI DI PIÙ»
RICERCA
RIVENDITORE
rivenditore
nazione
provincia
LE FIERE
Le principali FIERE ITALIANE ED ESTERE inerenti il mondo della lavorazione dei metalli
ELENCO FIERE
SELECT * FROM `catalogo_prodotto_categoria` LEFT JOIN `view_prodotto` ON ( catalogo_prodotto_categoria.IDProdotto = view_prodotto.IDProdotto ) WHERE catalogo_prodotto_categoria.Annullato = 0 AND Stato = 1 AND (view_prodotto.created <= UNIX_TIMESTAMP(DATE_ADD(NOW(), INTERVAL -7 DAY)) OR view_prodotto.IDUtente NOT IN (429,430,431,577,626,639,714,721,784,912,932,994,1114,1130,1180,1362,1538,1601,1703,2116,2284,2328,2340,2374,2393,2417,2440,2513,2572,2579,2610,2621,2649,2692,2700,2733,2754,2782,2786,2833,2918,2994,3000,3041,3055,3097,3176,3198,3220,3268,3285,3300,3302,3312,3347,3351,3392,3401,3428,3459,3466,3511,3519,3572,3577,3594,3627,3660,3677,3685,3709,3729,3771,3776,3790,3794,3795,3797,3799,3805,3807,3810,3812,3814,3817,3818,3830,3831,3834,3837,3839,3840,3843,3844,3848,3853,3854,3856,3857,3864,3867,3868,3869,3876,3877,3879,3881,3895,3897,3903,3910,3913,0,3920,3927,3928,3930,3931,3935,3937,3940,3942,3943,3945,3947,3951,3954,3957,3958,3959,3965,3966,3967,3969,3973,3974,3975,3976,3978,3981,3983,3986,3987,3992,3994,3995,3997,4001,4015,4021,4022,4023,4025,4029,4031,4032,4033,4035,4036,4037,4042,4044,4048,4049,4051,4054,4056,4059,4061,4062,4068,4069,4070,4071,4080,4083,4096,4097,4098,4100,4102,4103,4104,4107,4108,4109,4110,4111,4114,4119,4120,4125,4127,4131,4133,4136,4138,4140,4142,4143,4145,4146,4148,4149,4162,4165,4169,4171,4172,4173,4174,4178,4181,4187,4189,4192,4194,4200,4202,4209,4214,4218,4219,4220,4225,4228,4230,4231,4234,4235,4238,4239,4244,4246,4247,4252,4254,4255,4257,4260,4262,4264,4265,4266,4269,4275,4279,4281,4284,4285,4287,4288,4289,4290,4292,4293,4294,4298,4301,4302,4305,4311,4312,4313,4315,4316,4319,4322,4326,4329,4333,4335,4336,4338,4340,4342,4343,4344,4347,4348,4349,4350,4356,4357,4358,4360,4365,4368,4371,4372,4373,4376,4381,4383,4384,4385,4395,4404,4408,4411,4414,4416,4421,4427,4433,4440,4442,4445,4449,4450,4451,4455,4457) OR view_prodotto.PrezzoFlash > 0) AND view_prodotto.IDProdotto NOT IN (32521,35367,35368,35369,35370,35371,35372,35373,35374,36669,36670,36671,36672,36673,36674,36675,36676,38215,38216,38217,38218,38219,38220,38221,38222,38298,38299,38300,38301,38302,38303,38304,38305,38306,38685,38686,38687,38688,38689,38690,38691,38692,38693,39552,39553,39554,39652,39653,39654,39655,39656,39657,39658,39659,39660,39661,39669,39670,39671,39672,39673,39674,39675,39676,39954,39955,39956,39957,39958,39959,39960,39961,39962,40008,40009,40010,40088,40089,40090,40091,40092,40093,40094,40095,40096,40097,40184,40185,40187,40188,40189,40190,40191,40192,40193,40194,40489,40490,40491,40492,40493,40494,40495,40496,40497,40498,40569,40570,40571,40572,40573,40574,40575,40576,40577,40578,40677,40678,40679,40680,40681,40682,40683,40684,40685,40686,40793,40794,40795,40796,40797,40798,40799,40800,40801,40802,41047,41048,41049,41050,41051,41052,41053,41054,41055,41056,41101,41102,41103,41104,41105,41106,41107,41108,41109,41110,41296,41297,41298,41299,41300,41301,41302,41304,41415,41416,41417,41418,41419,41420,41421,41422,41423,41424,41641,41642,41643,41644,41645,41646,41647,41648,41649,41650,41871,41872,41873,41874,41875,41876,41877,41878,42037,42038,42039,42040,42041,42042,42043,42044,42045,42046,42047,42105,42106,42107,42108,42109,42110,42112,42113,42114,42115,42116,42117,42118,42119,42120,42423,42425,42426,42427,42428,42429,42430,42431,42432,42448,42449,42450,42451,42452,42453,42454,42455,42456,42457,42475,42476,42477,42478,42479,42480,42481,42482,42483,42484,42686,42697,42699,42704,42707,42712,42715,42717,42721,42809,42810,42811,42812,42813,42814,42815,42816,42817,42818,42839,42840,42841,42842,42843,42844,42845,42846,42847,42849,42850,42874,42875,42876,42877,42878,42879,42880,42881,42882,42883,43458,43459,43460,43461,43462,43463,43464,43465,43466,43467,43472,43473,43474,43475,43476,43477,43478,43479,43480,43481,43644,43645,43646,43647,43648,43649,43650,43651,43652,43653,43714,43715,43955,43956,43957,43958,43959,43960,43961,43962,43963,43964,43965,43967,44087,44088,44089,44090,44091,44092,44093,44094,44095,44096,44097,44098,44099,44100,44101,44102,44146,44147,44148,44149,44150,44151,44152,44153,44154,44261,44262,44265,44266,44268,44269,44270,44271,44275,44276,44278,44280,44281,44283,44285,44287,44330,46510,44332,44333,44334,44335,44336,44337,44338,44339,44459,44460,44461,44462,44463,44464,44465,44466,44467,44468,44537,44538,44539,44540,44541,44542,44543,44544,44545,44546,44964,44786,44787,44788,44789,44790,44791,44793,44808,44809,44810,44811,44812,44813,44815,44817,44819,44965,45448,45449,45450,45451,45452,45453,45454,45455,45456,45507,45508,45510,45511,45513,45514,45515,45516,45518,45533,45534,45535,45536,45537,45538,45539,45540,45541,45545,45546,45547,45548,45549,45550,45551,45552,45553,45722,45723,45724,45725,45726,45727,45728,45729,45730,45791,45792,45793,45794,45795,45796,45797,45798,45799,45800,45831,45832,45833,45834,45835,45837,45838,45839,45840,45841,45915,45916,45917,45918,45919,45920,45921,45922,45923,45924,46437,46443,46438,46442,46441,46440,45959,45960,45961,45962,45963,45964,45965,45966,45967,45968,45969,45970,45971,45972,45973,45974,45975,45992,45993,45994,45995,45996,45997,45998,45999,46433,46434,46436,46439,46431,46432,46078,46079,46080,46081,46082,46083,46084,46445,46086,46444,46446,46089,46090,46447,46093,46096,46097,46099,46100,46101,46102,46103,46113,46114,46115,46116,46140,46141,46142,46143,46144,46145,46146,46168,46169,46170,46171,46172,46173,46175,46176,46187,46189,46190,46191,46192,46193,46194,46208,46209,46211,46213,46214,46215,46216,46217,46218,46219,46448,46449,46450,46451,46527,46528,46529,46530,46534,46535,46536,46538,46539,46540,46541,46542,46543,46544,46545) AND view_prodotto.IDLiquidazioneCollegata NOT IN (31208,31891,34302,35480,36952,39244,39965,40176,40674,41059,41088,41090,41098,41092,41095,41096) AND catalogo_prodotto_categoria.IDCategoria IN (contatto,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,316,317,318,319,320,321,322,323,324,326,327,328,329,340,342,343,344,345,346,347,348,349,350,352,353,354,355,4827,4828,4829,17391,17510,17511,351)