Used printing equipment at Pressdepo
Subscribe for News
Graphic Equipment finder 
Search By Category
 
More Criteria
 -
Camporese- macchine graphiche
 -
 
Search by Word:
seller
seller

Order by
Mach per page
 
 
Subscribe for this QuerySubscribe forWanted Machine
 

Your Search: Used Press - Sheetfed offset - Heidelberg - pressdepo Found 919 Machines

We recommend this machineRecommended machines
 
 
PD Ref: 40245 | Last updated: 22-05-2016 | Viewed: 467 times
 
 
 -  Age: 1969
 -  Size: 57 x 46 cm (22 x 18 inch)
 -  Colors: 1
 -  Impress.Count: 44 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 41548 | Last updated: 10-07-2016 | Viewed: 269 times
 
 
 -  Age: 2001
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 4
 -  Impress.Count: 13 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: 07-2016
 -
 
PD Ref: 40285 | Last updated: 24-05-2016 | Viewed: 946 times
 
 
 -  Age: 1997
 -  Size: 74 x 53 cm (29 x 20 inch)
 -  Colors: 5
 -  Impress.Count: 109 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: 07-2016
 -
 
PD Ref: 40766 | Last updated: 19-07-2016 | Viewed: 699 times
 
 
 -  Age: 2001
 -  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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: 08-2016
 -
 
PD Ref: 41547 | Last updated: 10-07-2016 | Viewed: 155 times
 
 
 -  Age: 1990
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 36 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: 07-2016
 -
 
PD Ref: 41654 | Last updated: 13-07-2016 | Viewed: 277 times
 
 
 -  Age: 1997
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 67 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: 09-2016
 -
 
PD Ref: 37277 | Last updated: 02-02-2016 | Viewed: 2811 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 40058 | Last updated: 14-05-2016 | Viewed: 504 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 41875 | Last updated: 24-07-2016 | Viewed: 214 times
 
 
 -  Age: 1991
 -  Size: 72 x 52 cm (28 x 20 inch)
 -  Colors: 2
 -  Impress.Count: 120 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
Dismantled - Available: 07-2016
 -
 
PD Ref: 38971 | Last updated: 05-04-2016 | Viewed: 1647 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 41361 | Last updated: 01-07-2016 | Viewed: 320 times
 
 
 -  Age: 2002
 -  Size: 74 x 53 cm (29 x 20 inch)
 -  Colors: 5
 -  Impress.Count: 134 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: 11-2016
 -
 
PD Ref: 41718 | Last updated: 17-07-2016 | Viewed: 245 times
 
 
 -  Age: 1994
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 1
 -  Impress.Count: 32 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: 07-2016
 -
 
PD Ref: 41596 | Last updated: 12-07-2016 | Viewed: 266 times
 
 
 -  Age: 2008
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 10
 -  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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: 07-2016
 -
 
PD Ref: 38549 | Last updated: 26-06-2016 | Viewed: 2147 times
 
 
 -  Age: 2006
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 5
 -  Impress.Count: 26 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 40060 | Last updated: 30-06-2016 | Viewed: 850 times
 
 
 -  Age: 2004
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 76 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '41874' OR a.id = '41562' OR a.id = '40285' OR a.id = '39576' OR a.id = '37656' OR a.id = '36835' OR a.id = '41872' OR a.id = '38175' OR a.id = '41718' OR a.id = '36836' OR a.id = '39389' OR a.id = '35417' OR a.id = '41548' OR a.id = '38749' OR a.id = '32564' OR a.id = '41870' OR a.id = '39573' OR a.id = '41865' OR a.id = '40748' OR a.id = '37196' OR a.id = '41873' OR a.id = '40245' OR a.id = '41547' OR a.id = '38930' OR a.id = '41869' OR a.id = '41378' OR a.id = '40060' OR a.id = '41361' OR a.id = '41711' OR a.id = '37195' OR a.id = '41375' OR a.id = '41227' OR a.id = '38971' OR a.id = '34286' OR a.id = '40766' OR a.id = '38551' OR a.id = '41654' OR a.id = '41422' OR a.id = '27715' OR a.id = '1418' OR a.id = '36837' OR a.id = '30264' OR a.id = '40058' OR a.id = '40635' OR a.id = '37197' OR a.id = '32365' OR a.id = '37277' OR a.id = '41719' OR a.id = '38552' OR a.id = '41875' OR a.id = '40632' OR a.id = '40633' OR a.id = '41596' OR a.id = '36832' OR a.id = '38549' OR a.id = '40800') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 41894 | Last updated: 25-07-2016 | Viewed: 7 times
 
 
 -  Age: 2003
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 5
 -  Impress.Count: 220 mio
 
In production - Available: 07-2016
 -
 
PD Ref: 41890 | Last updated: 25-07-2016 | Viewed: 6 times
 
 
 -  Age: 1982
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 1
 -  Impress.Count: No counter
In stock - Available: 07-2016
 -
 
PD Ref: 41888 | Last updated: 25-07-2016 | Viewed: 51 times
 
 
 -  Age: 1973
 -  Size: 65 x 48 cm (25 x 18 inch)
 -  Colors: 2
 -  Impress.Count: No counter
In stock - Available: 07-2016
 -
 
PD Ref: 41887 | Last updated: 25-07-2016 | Viewed: 21 times
 
 
 -  Age: 1978
 -  Size: 65 x 48 cm (25 x 18 inch)
 -  Colors: 2
 -  Impress.Count: No counter
In stock - Available: 07-2016
 -
 
PD Ref: 41883 | Last updated: 25-07-2016 | Viewed: 103 times
 
 
 -  Age: 1975
 -  Size: 65 x 48 cm (25 x 18 inch)
 -  Colors: 2
 -  Impress.Count: No counter
In stock - Available: 07-2016
 -
 
PD Ref: 41882 | Last updated: 25-07-2016 | Viewed: 67 times
 
 
 -  Age: 1975
 -  Size: 65 x 48 cm (25 x 18 inch)
 -  Colors: 2
 -  Impress.Count: No counter
In stock - Available: 07-2016
 -
 
PD Ref: 41875 | Last updated: 24-07-2016 | Viewed: 214 times
 
 
 -  Age: 1991
 -  Size: 72 x 52 cm (28 x 20 inch)
 -  Colors: 2
 -  Impress.Count: 120 mio
Recommended machine
Dismantled - Available: 07-2016
 -
 
PD Ref: 41871 | Last updated: 24-07-2016 | Viewed: 159 times
 
 
 -  Age: 1977
 -  Size: 46 x 32 cm (18 x 12 inch)
 -  Colors: 1
 -  Impress.Count: 44 mio
In production - Available: 07-2016
 -
 
PD Ref: 41864 | Last updated: 23-07-2016 | Viewed: 257 times
 
 
 -  Age: 2002
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 90 mio
Under power - Available: 07-2016
 -
 
PD Ref: 41862 | Last updated: 23-07-2016 | Viewed: 239 times
 
 
 -  Age: 2002
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 32 mio
In production - Available: 08-2016
 -
 
PD Ref: 41856 | Last updated: 23-07-2016 | Viewed: 73 times
 
 
 -  Age: 2001
 -  Size: 105 x 72 cm (41 x 28 inch)
 -  Colors: 6
 -  Impress.Count: 205 mio
In production - Available: 07-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
    Duplo System 5000..
    2010 Used Postpress
    Image1 Duplo System 5000..
  • vipoffer
    Muller Martini Ty..
    1989 Spare Parts
    Image2 Muller Martini Ty..
  • vipoffer
    Heidelberg SM 52 ..
    2001 Misc
    Image3 Heidelberg SM 52 ..
  • vipoffer
    Ryobi Itek 3980
    1994 Used Press
    Image4 Ryobi Itek 3980
  • vipoffer
    Heidelberg GTO 46..
    1977 Used Press
    Image5 Heidelberg GTO 46..
  • vipoffer
    Guk SAF 35 4-2
    1994 Used Postpress
    Image6 Guk SAF 35 4-2
  • vipoffer
    Heidelberg GTO 52..
    1991 Used Press
    Image7 Heidelberg GTO 52..
  • vipoffer
    Heidelberg CD 102..
    2001 Used Press
    Image8 Heidelberg CD 102..
 
advert bottom
why_this_website
 
We use cookies to help provide you with the best possible online experience. By using this site, you agree that we may store and access cookies on your device.