Used printing equipment at Pressdepo
Subscribe for News
Graphic Equipment finder 
Search By Category
 
More Criteria
 -
Gab Supplies - used machinery
 -
 
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 886 Machines

We recommend this machineRecommended machines
 
 
PD Ref: 42596 | Last updated: 27-08-2016 | Viewed: 736 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '38971' OR a.id = '40725' OR a.id = '43133' OR a.id = '42867' OR a.id = '42866' OR a.id = '43136' OR a.id = '43135' OR a.id = '42241' OR a.id = '42464' OR a.id = '42791' OR a.id = '38551' OR a.id = '37344' OR a.id = '1418' OR a.id = '43140' OR a.id = '43138' OR a.id = '42792' OR a.id = '43142' OR a.id = '42216' OR a.id = '43139' OR a.id = '42596' OR a.id = '37009' OR a.id = '42463' OR a.id = '41339' OR a.id = '42154') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 42463 | Last updated: 20-08-2016 | Viewed: 644 times
 
 
 -  Age: 2001
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 11 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 = '38971' OR a.id = '40725' OR a.id = '43133' OR a.id = '42867' OR a.id = '42866' OR a.id = '43136' OR a.id = '43135' OR a.id = '42241' OR a.id = '42464' OR a.id = '42791' OR a.id = '38551' OR a.id = '37344' OR a.id = '1418' OR a.id = '43140' OR a.id = '43138' OR a.id = '42792' OR a.id = '43142' OR a.id = '42216' OR a.id = '43139' OR a.id = '42596' OR a.id = '37009' OR a.id = '42463' OR a.id = '41339' OR a.id = '42154') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 42154 | Last updated: 12-09-2016 | Viewed: 523 times
 
 
 -  Age: 1998
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 4
 -  Impress.Count: 150 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 = '38971' OR a.id = '40725' OR a.id = '43133' OR a.id = '42867' OR a.id = '42866' OR a.id = '43136' OR a.id = '43135' OR a.id = '42241' OR a.id = '42464' OR a.id = '42791' OR a.id = '38551' OR a.id = '37344' OR a.id = '1418' OR a.id = '43140' OR a.id = '43138' OR a.id = '42792' OR a.id = '43142' OR a.id = '42216' OR a.id = '43139' OR a.id = '42596' OR a.id = '37009' OR a.id = '42463' OR a.id = '41339' OR a.id = '42154') ORDER by rand()
Recommended machine
In production - Available: 09-2016
 -
 
PD Ref: 38971 | Last updated: 05-04-2016 | Viewed: 2477 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 = '38971' OR a.id = '40725' OR a.id = '43133' OR a.id = '42867' OR a.id = '42866' OR a.id = '43136' OR a.id = '43135' OR a.id = '42241' OR a.id = '42464' OR a.id = '42791' OR a.id = '38551' OR a.id = '37344' OR a.id = '1418' OR a.id = '43140' OR a.id = '43138' OR a.id = '42792' OR a.id = '43142' OR a.id = '42216' OR a.id = '43139' OR a.id = '42596' OR a.id = '37009' OR a.id = '42463' OR a.id = '41339' OR a.id = '42154') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 42866 | Last updated: 07-09-2016 | Viewed: 225 times
 
 
 -  Age: 2011
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 5
 -  Impress.Count: 60 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 = '38971' OR a.id = '40725' OR a.id = '43133' OR a.id = '42867' OR a.id = '42866' OR a.id = '43136' OR a.id = '43135' OR a.id = '42241' OR a.id = '42464' OR a.id = '42791' OR a.id = '38551' OR a.id = '37344' OR a.id = '1418' OR a.id = '43140' OR a.id = '43138' OR a.id = '42792' OR a.id = '43142' OR a.id = '42216' OR a.id = '43139' OR a.id = '42596' OR a.id = '37009' OR a.id = '42463' OR a.id = '41339' OR a.id = '42154') ORDER by rand()
Recommended machine
In production - Available: 09-2016
 -
 
PD Ref: 41339 | Last updated: 01-07-2016 | Viewed: 506 times
 
 
 -  Age: 2005
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 10
 -  Impress.Count: No counter
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 = '38971' OR a.id = '40725' OR a.id = '43133' OR a.id = '42867' OR a.id = '42866' OR a.id = '43136' OR a.id = '43135' OR a.id = '42241' OR a.id = '42464' OR a.id = '42791' OR a.id = '38551' OR a.id = '37344' OR a.id = '1418' OR a.id = '43140' OR a.id = '43138' OR a.id = '42792' OR a.id = '43142' OR a.id = '42216' OR a.id = '43139' OR a.id = '42596' OR a.id = '37009' OR a.id = '42463' OR a.id = '41339' OR a.id = '42154') ORDER by rand()
Recommended machine
In production - Available: 09-2016
 -
 
PD Ref: 43140 | Last updated: 18-09-2016 | Viewed: 297 times
 
 
 -  Age: 1999
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 2
 -  Impress.Count: 63 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 = '38971' OR a.id = '40725' OR a.id = '43133' OR a.id = '42867' OR a.id = '42866' OR a.id = '43136' OR a.id = '43135' OR a.id = '42241' OR a.id = '42464' OR a.id = '42791' OR a.id = '38551' OR a.id = '37344' OR a.id = '1418' OR a.id = '43140' OR a.id = '43138' OR a.id = '42792' OR a.id = '43142' OR a.id = '42216' OR a.id = '43139' OR a.id = '42596' OR a.id = '37009' OR a.id = '42463' OR a.id = '41339' OR a.id = '42154') ORDER by rand()
Recommended machine
In production - Available: 09-2016
 -
 
PD Ref: 42464 | Last updated: 20-08-2016 | Viewed: 826 times
 
 
 -  Age: 1974
 -  Size: 64 x 48 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.subcat_id='51') AND (a.man_id='63') AND (a.id = '38971' OR a.id = '40725' OR a.id = '43133' OR a.id = '42867' OR a.id = '42866' OR a.id = '43136' OR a.id = '43135' OR a.id = '42241' OR a.id = '42464' OR a.id = '42791' OR a.id = '38551' OR a.id = '37344' OR a.id = '1418' OR a.id = '43140' OR a.id = '43138' OR a.id = '42792' OR a.id = '43142' OR a.id = '42216' OR a.id = '43139' OR a.id = '42596' OR a.id = '37009' OR a.id = '42463' OR a.id = '41339' OR a.id = '42154') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 42792 | Last updated: 04-09-2016 | Viewed: 627 times
 
 
 -  Age: 1980
 -  Size: 46 x 32 cm (18 x 12 inch)
 -  Colors: 4
 -  Impress.Count: 58 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 = '38971' OR a.id = '40725' OR a.id = '43133' OR a.id = '42867' OR a.id = '42866' OR a.id = '43136' OR a.id = '43135' OR a.id = '42241' OR a.id = '42464' OR a.id = '42791' OR a.id = '38551' OR a.id = '37344' OR a.id = '1418' OR a.id = '43140' OR a.id = '43138' OR a.id = '42792' OR a.id = '43142' OR a.id = '42216' OR a.id = '43139' OR a.id = '42596' OR a.id = '37009' OR a.id = '42463' OR a.id = '41339' OR a.id = '42154') ORDER by rand()
Recommended machine
In production - Available: 09-2016
 -
 
PD Ref: 43136 | Last updated: 18-09-2016 | Viewed: 128 times
 
 
 -  Age: 1991
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 1
 -  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 = '38971' OR a.id = '40725' OR a.id = '43133' OR a.id = '42867' OR a.id = '42866' OR a.id = '43136' OR a.id = '43135' OR a.id = '42241' OR a.id = '42464' OR a.id = '42791' OR a.id = '38551' OR a.id = '37344' OR a.id = '1418' OR a.id = '43140' OR a.id = '43138' OR a.id = '42792' OR a.id = '43142' OR a.id = '42216' OR a.id = '43139' OR a.id = '42596' OR a.id = '37009' OR a.id = '42463' OR a.id = '41339' OR a.id = '42154') ORDER by rand()
Recommended machine
In production - Available: 09-2016
 -
 
PD Ref: 43297 | Last updated: 25-09-2016 | Viewed: 83 times
 
 
 -  Age: 1998
 -  Size: 102 x 74 cm (40 x 29 inch)
 -  Colors: 5
 -  Impress.Count: 100 mio
In production - Available: 10-2016
 -
 
PD Ref: 43289 | Last updated: 24-09-2016 | Viewed: 135 times
 
 
 -  Age: 2001
 -  Size: 52 x 35 cm (20 x 13 inch)
 -  Colors: 2
 -  Impress.Count: 39 mio
In production - Available: 09-2016
 -
 
PD Ref: 43288 | Last updated: 24-09-2016 | Viewed: 34 times
 
 
 -  Age: 1998
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 6
 -  Impress.Count: 250 mio
In production - Available: 12-2016
 -
 
PD Ref: 43285 | Last updated: 24-09-2016 | Viewed: 94 times
 
 
 -  Age: 2011
 -  Size: 52 x 35 cm (20 x 13 inch)
 -  Colors: 5
 -  Impress.Count: 60 mio
In production - Available: 09-2016
 -
 
PD Ref: 43259 | Last updated: 23-09-2016 | Viewed: 203 times
 
 
 -  Age: 1988
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 1
In production - Available: 10-2016
 -
 
PD Ref: 43258 | Last updated: 23-09-2016 | Viewed: 311 times
 
 
 -  Age: 1991
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 2
In production - Available: 10-2016
 -
 
PD Ref: 43254 | Last updated: 23-09-2016 | Viewed: 120 times
 
 
 -  Age: 2013
 -  Size: 106 x 75 cm (41 x 29 inch)
 -  Colors: 4
In production - Available: 09-2016
 -
 
PD Ref: 43229 | Last updated: 22-09-2016 | Viewed: 31 times
 
 
 -  Age: 2001
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 8
 -  Impress.Count: 255 mio
In production - Available: 12-2016
 -
 
PD Ref: 43225 | Last updated: 21-09-2016 | Viewed: 73 times
 
 
 -  Age: 1999
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 22 mio
 
In production - Available: 12-2016
 -
 
PD Ref: 43222 | Last updated: 21-09-2016 | Viewed: 215 times
 
 
 -  Age: 2006
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 42 mio
In production - Available: 09-2016
 -
 
PD Ref: 43221 | Last updated: 21-09-2016 | Viewed: 314 times
 
 
 -  Age: 1988
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 2
 -  Impress.Count: 18 mio
In production - Available: 09-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
    NEW !!! Hot foil ..
    New Used Postpress
    Image1 NEW !!! Hot foil ..
  • vipoffer
    Heidelberg SM 102..
    2005 Used Press
    Image2 Heidelberg SM 102..
  • vipoffer
    KBA Rapida 105U-6..
    2004 Used Press
    Image3 KBA Rapida 105U-6..
  • vipoffer
    Boston No 7
    1986 Used Postpress
    Image4 Boston No 7
  • vipoffer
    GBC B2 Thermal La..
    1995 Used Packaging
    Image5 GBC B2 Thermal La..
  • vipoffer
    Heidelberg KORD 6..
    1974 Used Press
    Image6 Heidelberg KORD 6..
  • vipoffer
    Man-Roland 905-7B..
    2006 Used Press
    Image7 Man-Roland 905-7B..
  • vipoffer
    Heidelberg GTO 46..
    1980 Used Press
    Image8 Heidelberg GTO 46..
 
advert bottom
why_this_website