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,2649,2692,2700,2733,2754,2782,2786,2833,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,4457,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,3985,3986,3987,3992,3994,3995,3997,4001,4015,4021,4022,4023,4025,4029,4031,4032,4033,4035,4036,4037,4042,4044,4045,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,4122,4125,4127,4131,4133,4136,4138,4140,4142,4143,4145,4146,4148,4149,4162,4165,4168,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,4258,4260,4262,4264,4265,4266,4269,4275,4279,4281,4284,4285,4287,4288,4289,4290,4292,4293,4294,4298,4903,4301,4302,4305,4311,4312,4313,4315,4316,4319,4322,4326,4329,4333,4335,4336,4338,4340,4342,4344,4347,4348,4349,4350,4356,4357,4358,4360,4365,4368,4371,4372,4373,4376,4381,4383,4384,4385,4389,4395,4404,4408,4411,4414,4416,4421,4427,4433,4437,4440,4442,4445,4449,4450,4451,4455,4457,4458,4459,4460,4464,4466,4468,4469,4477,4478,4480,4485,4486,4491,4493,4494,4495,4496,4497,4498,4505,4509,4510,4511,4513,4514,4515,4516,4518,4520,4526,4527,4534,4538,4539,4541,4542,4544,4545,4546,4547,4549,4550,4551,4553,4560,4565,4566,4572,4584,4586,4587,4588,4590,4591,4592,4601,4602,4604,4611,4619,4621,4623,4624,4625,4626,4629,4630,4631,4635,4636,4639,4641,4642,4644,4648,4654,4658,4662,4664,4665,4666,4670,4671,4674,4677,4678,4679,4684,4686,4687,4689,4690,4692,4693,4695,4696,4698,4700,4701,4702,4704,4706,4709,4712,4713,4717,4718,4724,4731,4732,4733,4735,4737,4739,4745,4746,4751,4755,4757,4761,4771,4772,4773,4774,4779,4781,4784,4785,4787,4788,4790,4798,4800,4803,4804,4805,4806,4812,4815,4824,4828,4829,4831,4832,4833,4835,4839,4840,4842,4843,4844,4845,4848,4850,4851,4852,4854,4855,4863,4857,4865,4866,4868,4869,4873,4879,4883,4885,4886,4891,4892,4897,4898,4904,4906,4909,4910,4911,4918,4920,4921,4922,4923,4924,4926,4927,4935,4936,4940,4946,4950,4963,4964,4965,4967,4968,4969,4970,4971,4976,4979,4983,4985,4988,4990,4991,4993,4994,4997,4998,5001,5004,5008,5009,5012,5014,5016,5023,5024,5030,5034,5037,5038,5039,5040,5041,5049,5050,5051,5053,5057,5060,5064,5065,5067,5068,5070,5071,5073,5074,5075,5078,5079,5091,5094,5096,5098,5103,5114,5120,5122,5124,5126,5130,5139,5154,5160,5161,5176,5187,5189,5190,5191,5194,5195,5199,5200,5201,5202,5209,5211,5212,5216,5220,5221,5226,5227,5233,5236,5239,5241,5242,5245,5252,5254,5263,5269,5271,5281,5285,5288,5294,5297,5298,5299,5311,5313,5319,5320,5321,5323,5324,5325,5327,5334,5335,5338,0,5352,5355,5369,5377,5381,5382,5388,5394,5405,5421,5422,5433,5434,5441,5449,5455,5464,5467,5468,5470,5493,5503,5504,5506,5508,5509,5510,5512,5514,5524,5532,5544,5561,5564,5565,5566,5567,5578,5580,5582,5585,5586,5592,5594,5597,5602,5609,5612,5613,5625,5628,5632,5639,5640,5642,5648,5655,5657,5658,5661,5665,5666,5673,5680,5691,5692,5693,5695,5704,5710,5711,5717,5718,5741,5757) 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,48570,46510,48569,48567,48566,48564,48563,48562,48560,49335,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,49334,49333,49211,48585,48584,48583,48582,48581,48580,48579,46437,48578,48577,49210,46443,49209,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,49208,49207,48576,49002,49001,49000,48999,48998,48997,48996,48995,48994,48980,48979,48978,48977,48976,48975,48974,48973,48972,48971,48963,48962,48961,48960,48959,46168,46169,46170,46171,46172,46173,46175,46176,48958,48957,48956,48955,48954,48858,48857,48856,49336,49337,49338,49339,49340,49341,49528,48572,48571,46344,46345,46346,46347,46348,46350,46351,46352,46354,46448,46449,46450,46451,46527,46528,46529,46530,46534,46535,46536,46538,46539,46540,46541,46542,46543,46544,46545,46822,46823,46824,46825,46826,46827,46828,46829,46901,46902,46903,46904,46905,46909,46910,46911,46914,46915,46916,46917,46918,46919,46920,46921,46922,46923,47193,47194,47195,47196,47197,47198,47199,47200,49332,47252,47253,47254,47255,47256,47257,47258,47259,47260,47261,47371,47372,47373,47374,47375,47376,47377,47378,47379,47380,47467,47468,47469,47470,47471,47472,47473,47537,47538,47539,47540,47541,47560,47561,47562,47563,47564,47716,47717,47718,47719,47720,47721,47722,47723,47724,47725,47742,47743,48023,48025,48026,48027,48028,48029,48030,48031,48033,48034,48035,48037,48038,48039,48308,48309,48310,48311,48312,48313,48314,48315,48316,48317,48362,48363,48364,48365,48366,48367,48368,48369,48370,48371,48380,48381,48382,48383,48384,48385,48386,48387,49529,49530,49531,49532,49533,49534,49535,49536,49537,49538,49539,49540,49541,49542,49543,49544,49545,49547,49555,49556,49557,49558,49559,49560,49561,49562,49563,49564,49565,49566,49567,49568,49569,49570,49571,49572,49573,49574,49575,49576,49577,49578,49579,49580,49812,49814,49816,49818,49819,49931,49932,49933,49934,50005,50004,50003,50000,49999,49998,49997,49996,50001,50002,50008,50009,50010,50011,50012,50013,50014,50015,50016,50018,50019,50049,50050,50051,50052,50053,50054,50055,50056,50598,50599,50600,50601,50602,50603,50604,50605,50606,50607,50727,50728,50729,50730,50731,50732,50733,50734,50735,50736,50737,50738,50739,50742,50743,50744,50745,50746,50747,50748,50749,50750,50751,50752,50876,50877,50878,50879,50880,50881,50882,50883,50884,50885,50886,50887,50888,50889,50890,50891,50892,50893,50894,50895,50896,50897,50898,50899,50910,50911,50912,50913,50914,50915,50916,50917,50918,50919,50920,50921,50922,50935,50936,50938,50939,50940,50941,50942,50943,50944,50945,51043,51044,51045,51046,51047,51048,51049,51050,51051,51052,51075,51076,51077,51078,51079,51080,51081,51082,51083,51084,51085,51086,51118,51119,51120,51121,51122,51123,51124,51125,51126,51127,51128,51129,51130,51131,51132,51133,51134,51135,51136,51137,51138,51139,51163,51164,51165,51166,51167,51168,51169,51170,51171,51172,51249,51250,51251,51252,51253,51254,51255,51256,51257,51258,51259,51260,51261,51262,51263,51264,51265,51266,51267,51268,51269,51270,51271,51272,51273,51274,51275,51276,51277,51278,51279,51280,51371,51372,51373,51378,51379,51380,51381,51382,51383,51384,51386,51387,51388,51389,51390,51391,51392,51393,51394,51398,51401,51402,51404,51405,51407,51409,51410,51524,51525,51533,51534,51536,51537,51538,51539,51540,51542,51545,51546,51555,51556,51559,51560,51561,51562,51563,51564,51565,51566,51567,51568,51569,51570,51571,51577,51578,51579,51580,51581,51582,51583,51584,51585,51586,51593,51594,51595,51596,51597,51598,51599,51600,51601,51602,51626,51647,51648,51649,51650,51651,51652,51653,51654,51655,51656,51677,51678,51679,51680,51681,51682,51683,51684,51685,51686,51687,51688,51689,51690,51691,51692,51693,51694,51695,51696,51866,51867,51868,51869,51870,51871,51872,51873,51874,51876,51877,51878,51956,51957,51959,51965,51966,51967,51968,51969,51970,51971,51977,51978,51979,51980,51981,51982,51983,51984,51985,51986,51987,51988,51989,52017,52018,52019,52020,52021,52027,52060,52061,52062,52063,52064,52065,52066,52067,52068,52069,52070,52071,52072,52073,52074,52075,52076,52077,52078,52079,52083,52084,52256,52259,52261,52262,52264,52266,52267,52268,52270,52272,52273,52274,52275,52276,52277,52279,52280,52281,52283,52284,52285,52287,52288,52290,52291,52292,52346,52347,52348,52349,52350,52351,52352,52353,52354,52355,52356,52406,52407,52408,52409,52410,52411,52412,52413,52415,52416,52417,52418,52419,52420,52421,52422,52423,52424,52425,52500,52502,52503,52828,52830,52831,52832,52833,52834,52835,52836,52837,52838,52839,52840,52841,52842,52843,52844,52845,52846,52847,52848,52867,52868,52869,52870,52871,52872,52873,52874,52875,52877,52878,52879,52880,52881,52882,52883,52884,52885,52886,52887) AND view_prodotto.IDLiquidazioneCollegata NOT IN (31208,31891,34302,35480,36952,39244,39965,40176,40674,41059,41088,41090,41098,41092,41095,41096,41099,41100,41101,41102,41103,41104,41106,41107,41109) 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)