Used printing equipment at Pressdepo
Subscribe for News
Graphic Equipment finder 
Search By Category
 
 -
Gab Supplies - used machinery
 -
 
Search by Word:
seller
seller

Order by
Mach per page
 
 
Subscribe for this QuerySubscribe forWanted Machine
 

Your Search: Used Press pressdepo Found 1776 Machines

We recommend this machineRecommended machines
 
 
PD Ref: 40059 | Last updated: 14-05-2016 | Viewed: 745 times
 
 
 -  Age: 1995
 -  Size: 45 x 34 cm (17 x 13 inch)
 -  Colors: 2
 -  Impress.Count: 30 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 38283 | Last updated: 09-03-2016 | Viewed: 1091 times
 
 
 -  Age: 1994
 -  Size: 100 x 70 cm (39 x 27 inch)
 -  Colors: 5
 -  Impress.Count: 222 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In stock - Available: Immediately
 -
 
PD Ref: 40800 | Last updated: 12-06-2016 | Viewed: 1195 times
 
 
 -  Age: 1989
 -  Size: 66 x 46 cm (25 x 18 inch)
 -  Colors: 1
 -  Impress.Count: 33 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 42492 | Last updated: 22-08-2016 | Viewed: 276 times
 
 
 -  Age: 1992
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 6
 -  Impress.Count: 221 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
Under power - Available: 08-2016
 -
 
PD Ref: 39151 | Last updated: 09-04-2016 | Viewed: 1379 times
 
 
 -  Age: 1992
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 49 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 42356 | Last updated: 13-08-2016 | Viewed: 421 times
 
 
 -  Age: 1986
 -  Size: 46 x 32 cm (18 x 12 inch)
 -  Colors: 1
 -  Impress.Count: 41 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: 08-2016
 -
 
PD Ref: 37277 | Last updated: 02-02-2016 | Viewed: 3202 times
 
 
 -  Age: 1996
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 4
 -  Impress.Count: 157 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 40058 | Last updated: 14-05-2016 | Viewed: 1087 times
 
 
 -  Age: 1977
 -  Size: 46 x 32 cm (18 x 12 inch)
 -  Colors: 2
 -  Impress.Count: 51 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 41826 | Last updated: 21-07-2016 | Viewed: 262 times
 
 
 -  Age: 2004
 -  Size: 104 x 72 cm (40 x 28 inch)
 -  Colors: 5
 -  Impress.Count: 209 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 40438 | Last updated: 29-05-2016 | Viewed: 423 times
 
 
 -  Age: 1968
 -  Size: 72 x 52 cm (28 x 20 inch)
 -  Colors: 1
 -  Impress.Count: 51 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 36458 | Last updated: 30-12-2015 | Viewed: 1341 times
 
 
 -  Age: 2005
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 2
 -  Impress.Count: 105 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In stock - Available: Immediately
 -
 
PD Ref: 37656 | Last updated: 24-03-2016 | Viewed: 1628 times
 
 
 -  Age: 1994
 -  Size: 45 x 34 cm (17 x 13 inch)
 -  Colors: 1
 -  Impress.Count: 21 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 42214 | Last updated: 07-08-2016 | Viewed: 632 times
 
 
 -  Age: 2000
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 97 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: 08-2016
 -
 
PD Ref: 42596 | Last updated: 27-08-2016 | Viewed: 126 times
 
 
 -  Age: 1994
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 6
 -  Impress.Count: 173 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: 08-2016
 -
 
PD Ref: 38971 | Last updated: 05-04-2016 | Viewed: 2207 times
 
 
 -  Age: 1991
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 4
 -  Impress.Count: 57 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '42210' OR a.id = '25815' OR a.id = '38552' OR a.id = '37806' OR a.id = '36458' OR a.id = '38551' OR a.id = '38283' OR a.id = '41719' OR a.id = '42212' OR a.id = '42369' OR a.id = '36832' OR a.id = '38971' OR a.id = '38930' OR a.id = '42356' OR a.id = '42214' OR a.id = '42596' OR a.id = '42216' OR a.id = '40800' OR a.id = '39331' OR a.id = '41826' OR a.id = '33855' OR a.id = '40635' OR a.id = '39573' OR a.id = '28513' OR a.id = '39151' OR a.id = '39389' OR a.id = '37009' OR a.id = '40242' OR a.id = '42215' OR a.id = '41870' OR a.id = '42492' OR a.id = '36837' OR a.id = '41873' OR a.id = '42208' OR a.id = '32754' OR a.id = '41378' OR a.id = '38175' OR a.id = '37196' OR a.id = '40633' OR a.id = '39576' OR a.id = '1418' OR a.id = '40059' OR a.id = '37656' OR a.id = '40058' OR a.id = '32565' OR a.id = '37277' OR a.id = '40438' OR a.id = '29332') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 42596 | Last updated: 27-08-2016 | Viewed: 126 times
 
 
 -  Age: 1994
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 6
 -  Impress.Count: 173 mio
Recommended machine
In production - Available: 08-2016
 -
 
PD Ref: 42593 | Last updated: 27-08-2016 | Viewed: 122 times
 
 
 -  Age: 1987
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 2
 -  Impress.Count: 73 mio
In production - Available: 08-2016
 -
 
PD Ref: 42583 | Last updated: 26-08-2016 | Viewed: 132 times
 
 
 -  Age: 1975
 -  Size: 46 x 32 cm (18 x 12 inch)
 -  Colors: 1
 -  Impress.Count: No counter
In stock - Available: 08-2016
 -
 
PD Ref: 42575 | Last updated: 25-08-2016 | Viewed: 29 times
 
 
 -  Age: 1997
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 40 mio
In stock - Available: 08-2016
 -
 
PD Ref: 42572 | Last updated: 25-08-2016 | Viewed: 43 times
 
 
 -  Age: 2000
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 5
 -  Impress.Count: 96 mio
In production - Available: 12-2016
 -
 
PD Ref: 42571 | Last updated: 25-08-2016 | Viewed: 35 times
 
 
 -  Age: 2002
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 5
 -  Impress.Count: 163 mio
In production - Available: 08-2016
 -
 
PD Ref: 42570 | Last updated: 25-08-2016 | Viewed: 40 times
 
 
 -  Age: 2005
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 10
 -  Impress.Count: 233 mio
In production - Available: 08-2016
 -
 
PD Ref: 42569 | Last updated: 25-08-2016 | Viewed: 50 times
 
 
 -  Age: 1975
 -  Size: 64 x 46 cm (25 x 18 inch)
 -  Colors: 1
 -  Impress.Count: No counter
In stock - Available: 08-2016
 -
 
PD Ref: 42568 | Last updated: 25-08-2016 | Viewed: 36 times
 
 
 -  Age: 1987
 -  Size: 65 x 48 cm (25 x 18 inch)
 -  Colors: 2
 -  Impress.Count: 27 mio
In stock - Available: 08-2016
 -
 
PD Ref: 42567 | Last updated: 25-08-2016 | Viewed: 31 times
 
 
 -  Age: 1982
 -  Size: 65 x 48 cm (25 x 18 inch)
 -  Colors: 1
 -  Impress.Count: 56 mio
In stock - Available: 08-2016
 -
 
PD Ref: 42566 | Last updated: 25-08-2016 | Viewed: 29 times
 
 
 -  Age: 1987
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 1
 -  Impress.Count: 13 mio
In stock - Available: 08-2016
 -
 
Subscribe for News
Subscribe for latest Sheetfed Press Machines
Subscribe for latest Prepress Machines
Subscribe for latest Packaging Machines
Subscribe for latest Guillotines
  • vipoffer
    Muller Martini Lo..
    2016 Spare Parts
    Image1 Muller Martini Lo..
  • vipoffer
    Ryobi Itek 3980
    1994 Used Press
    Image2 Ryobi Itek 3980
  • vipoffer
    Billows SM 102 Pu..
    1990 Used Prepress
    Image3 Billows SM 102 Pu..
  • vipoffer
    Parker A1
    1980 Used Prepress
    Image4 Parker A1
  • vipoffer
    Heidelberg 10 x 1..
    1955 Used Packaging
    Image5 Heidelberg 10 x 1..
  • vipoffer
    Horizon AFC 564 A..
    2008 Used Postpress
    Image6 Horizon AFC 564 A..
  • vipoffer
    Heidelberg GTO 52..
    1992 Used Press
    Image7 Heidelberg GTO 52..
  • vipoffer
    Heidelberg GTO 46
    1986 Used Press
    Image8 Heidelberg GTO 46
 
advert bottom
why_this_website