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

Order by
Mach per page
 
 
Subscribe for this Query
 

Your Search: Used Press - Sheetfed offset pressdepo Found 1592 Machines

We recommend this machineRecommended machines
 
 
PD Ref: 50978 | Last updated: 31-07-2017 | Viewed: 659 times
 
 
 -  Age: 2005
 -  Size: 72 x 52 cm (28 x 20 inch)
 -  Colors: 6
 -  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 USE INDEX (mpresdep_outshared) 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.id = '49774' OR a.id = '50611' OR a.id = '51406' OR a.id = '44942' OR a.id = '50612' OR a.id = '49613' OR a.id = '50978' OR a.id = '51535' OR a.id = '48650' OR a.id = '51438' OR a.id = '40086' OR a.id = '40153' OR a.id = '45117' OR a.id = '51470' OR a.id = '46554' OR a.id = '50753' OR a.id = '51560' OR a.id = '50709' OR a.id = '46553' OR a.id = '1418' OR a.id = '47712' OR a.id = '50736' OR a.id = '51365' OR a.id = '44943' OR a.id = '47139' OR a.id = '51264') ORDER by rand()
Recommended machine
Dismantled - Available: Immediately
 -
 
PD Ref: 47712 | Last updated: 18-08-2017 | Viewed: 3086 times
 
 
 -  Age: 1992
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 2
 -  Impress.Count: 116 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 USE INDEX (mpresdep_outshared) 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.id = '49774' OR a.id = '50611' OR a.id = '51406' OR a.id = '44942' OR a.id = '50612' OR a.id = '49613' OR a.id = '50978' OR a.id = '51535' OR a.id = '48650' OR a.id = '51438' OR a.id = '40086' OR a.id = '40153' OR a.id = '45117' OR a.id = '51470' OR a.id = '46554' OR a.id = '50753' OR a.id = '51560' OR a.id = '50709' OR a.id = '46553' OR a.id = '1418' OR a.id = '47712' OR a.id = '50736' OR a.id = '51365' OR a.id = '44943' OR a.id = '47139' OR a.id = '51264') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 51365 | Last updated: 10-08-2017 | Viewed: 103 times
 
 
 -  Age: 1994
 -  Size: 72 x 52 cm (28 x 20 inch)
 -  Colors: 2
 -  Impress.Count: 125 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 USE INDEX (mpresdep_outshared) 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.id = '49774' OR a.id = '50611' OR a.id = '51406' OR a.id = '44942' OR a.id = '50612' OR a.id = '49613' OR a.id = '50978' OR a.id = '51535' OR a.id = '48650' OR a.id = '51438' OR a.id = '40086' OR a.id = '40153' OR a.id = '45117' OR a.id = '51470' OR a.id = '46554' OR a.id = '50753' OR a.id = '51560' OR a.id = '50709' OR a.id = '46553' OR a.id = '1418' OR a.id = '47712' OR a.id = '50736' OR a.id = '51365' OR a.id = '44943' OR a.id = '47139' OR a.id = '51264') ORDER by rand()
Recommended machine
In production - Available: 08-2017
 -
 
PD Ref: 51438 | Last updated: 15-08-2017 | Viewed: 124 times
 
 
 -  Age: 2007
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 4
 -  Impress.Count: 71 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 USE INDEX (mpresdep_outshared) 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.id = '49774' OR a.id = '50611' OR a.id = '51406' OR a.id = '44942' OR a.id = '50612' OR a.id = '49613' OR a.id = '50978' OR a.id = '51535' OR a.id = '48650' OR a.id = '51438' OR a.id = '40086' OR a.id = '40153' OR a.id = '45117' OR a.id = '51470' OR a.id = '46554' OR a.id = '50753' OR a.id = '51560' OR a.id = '50709' OR a.id = '46553' OR a.id = '1418' OR a.id = '47712' OR a.id = '50736' OR a.id = '51365' OR a.id = '44943' OR a.id = '47139' OR a.id = '51264') ORDER by rand()
Recommended machine
In production - Available: 10-2017
 -
 
PD Ref: 47139 | Last updated: 25-02-2017 | Viewed: 613 times
 
 
 -  Age: 2013
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 4
 -  Impress.Count: 15 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 USE INDEX (mpresdep_outshared) 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.id = '49774' OR a.id = '50611' OR a.id = '51406' OR a.id = '44942' OR a.id = '50612' OR a.id = '49613' OR a.id = '50978' OR a.id = '51535' OR a.id = '48650' OR a.id = '51438' OR a.id = '40086' OR a.id = '40153' OR a.id = '45117' OR a.id = '51470' OR a.id = '46554' OR a.id = '50753' OR a.id = '51560' OR a.id = '50709' OR a.id = '46553' OR a.id = '1418' OR a.id = '47712' OR a.id = '50736' OR a.id = '51365' OR a.id = '44943' OR a.id = '47139' OR a.id = '51264') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 50736 | Last updated: 24-07-2017 | Viewed: 274 times
 
 
 -  Age: 2002
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 2
 -  Impress.Count: 55 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 USE INDEX (mpresdep_outshared) 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.id = '49774' OR a.id = '50611' OR a.id = '51406' OR a.id = '44942' OR a.id = '50612' OR a.id = '49613' OR a.id = '50978' OR a.id = '51535' OR a.id = '48650' OR a.id = '51438' OR a.id = '40086' OR a.id = '40153' OR a.id = '45117' OR a.id = '51470' OR a.id = '46554' OR a.id = '50753' OR a.id = '51560' OR a.id = '50709' OR a.id = '46553' OR a.id = '1418' OR a.id = '47712' OR a.id = '50736' OR a.id = '51365' OR a.id = '44943' OR a.id = '47139' OR a.id = '51264') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 51406 | Last updated: 15-08-2017 | Viewed: 116 times
 
 
 -  Age: 1988
 -  Size: 72 x 52 cm (28 x 20 inch)
 -  Colors: 6
 -  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 USE INDEX (mpresdep_outshared) 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.id = '49774' OR a.id = '50611' OR a.id = '51406' OR a.id = '44942' OR a.id = '50612' OR a.id = '49613' OR a.id = '50978' OR a.id = '51535' OR a.id = '48650' OR a.id = '51438' OR a.id = '40086' OR a.id = '40153' OR a.id = '45117' OR a.id = '51470' OR a.id = '46554' OR a.id = '50753' OR a.id = '51560' OR a.id = '50709' OR a.id = '46553' OR a.id = '1418' OR a.id = '47712' OR a.id = '50736' OR a.id = '51365' OR a.id = '44943' OR a.id = '47139' OR a.id = '51264') ORDER by rand()
Recommended machine
In production - Available: 08-2017
 -
 
PD Ref: 51560 | Last updated: 20-08-2017 | Viewed: 40 times
 
 
 -  Age: 2003
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 8
 -  Impress.Count: 190 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 USE INDEX (mpresdep_outshared) 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.id = '49774' OR a.id = '50611' OR a.id = '51406' OR a.id = '44942' OR a.id = '50612' OR a.id = '49613' OR a.id = '50978' OR a.id = '51535' OR a.id = '48650' OR a.id = '51438' OR a.id = '40086' OR a.id = '40153' OR a.id = '45117' OR a.id = '51470' OR a.id = '46554' OR a.id = '50753' OR a.id = '51560' OR a.id = '50709' OR a.id = '46553' OR a.id = '1418' OR a.id = '47712' OR a.id = '50736' OR a.id = '51365' OR a.id = '44943' OR a.id = '47139' OR a.id = '51264') ORDER by rand()
Recommended machine
In production - Available: 08-2017
 -
 
PD Ref: 51470 | Last updated: 16-08-2017 | Viewed: 102 times
 
 
 -  Age: 2013
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 4
 -  Impress.Count: 15 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 USE INDEX (mpresdep_outshared) 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.id = '49774' OR a.id = '50611' OR a.id = '51406' OR a.id = '44942' OR a.id = '50612' OR a.id = '49613' OR a.id = '50978' OR a.id = '51535' OR a.id = '48650' OR a.id = '51438' OR a.id = '40086' OR a.id = '40153' OR a.id = '45117' OR a.id = '51470' OR a.id = '46554' OR a.id = '50753' OR a.id = '51560' OR a.id = '50709' OR a.id = '46553' OR a.id = '1418' OR a.id = '47712' OR a.id = '50736' OR a.id = '51365' OR a.id = '44943' OR a.id = '47139' OR a.id = '51264') ORDER by rand()
Recommended machine
In production - Available: 09-2017
 -
 
PD Ref: 51264 | Last updated: 05-08-2017 | Viewed: 230 times
 
 
 -  Age: 2000
 -  Size: 103 x 72 cm (40 x 28 inch)
 -  Colors: 5
 -  Impress.Count: 186 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 USE INDEX (mpresdep_outshared) 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.id = '49774' OR a.id = '50611' OR a.id = '51406' OR a.id = '44942' OR a.id = '50612' OR a.id = '49613' OR a.id = '50978' OR a.id = '51535' OR a.id = '48650' OR a.id = '51438' OR a.id = '40086' OR a.id = '40153' OR a.id = '45117' OR a.id = '51470' OR a.id = '46554' OR a.id = '50753' OR a.id = '51560' OR a.id = '50709' OR a.id = '46553' OR a.id = '1418' OR a.id = '47712' OR a.id = '50736' OR a.id = '51365' OR a.id = '44943' OR a.id = '47139' OR a.id = '51264') ORDER by rand()
Recommended machine
Under power - Available: 08-2017
 -
 
PD Ref: 51561 | Last updated: 20-08-2017 | Viewed: 4 times
 
 
 -  Age: 1990
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 4
 -  Impress.Count: 45 mio
In production - Available: 08-2017
 -
 
PD Ref: 51560 | Last updated: 20-08-2017 | Viewed: 40 times
 
 
 -  Age: 2003
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 8
 -  Impress.Count: 190 mio
Recommended machine
In production - Available: 08-2017
 -
 
PD Ref: 51559 | Last updated: 19-08-2017 | Viewed: 41 times
 
 
 -  Age: 1998
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: No counter
In stock - Available: 08-2017
 -
 
PD Ref: 51558 | Last updated: 19-08-2017 | Viewed: 51 times
 
 
 -  Age: 1984
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 1
 -  Impress.Count: 59 mio
In stock - Available: 09-2017
 -
 
PD Ref: 51557 | Last updated: 19-08-2017 | Viewed: 42 times
 
 
 -  Age: Unkn.
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: No counter
In production - Available: 08-2017
 -
 
PD Ref: 51556 | Last updated: 19-08-2017 | Viewed: 58 times
 
 
 -  Age: 1989
 -  Size: 72 x 52 cm (28 x 20 inch)
 -  Colors: 4
 -  Impress.Count: No counter
In production - Available: 08-2017
 -
 
PD Ref: 51555 | Last updated: 18-08-2017 | Viewed: 80 times
 
 
 -  Age: 2002
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 5
 -  Impress.Count: 188 mio
In production - Available: 08-2017
 -
 
PD Ref: 51553 | Last updated: 18-08-2017 | Viewed: 64 times
 
 
 -  Age: 2004
 -  Size: 104 x 74 cm (40 x 29 inch)
 -  Colors: 6
 -  Impress.Count: 172 mio
In production - Available: 08-2017
 -
 
PD Ref: 51552 | Last updated: 18-08-2017 | Viewed: 57 times
 
 
 -  Age: 1999
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 4
 -  Impress.Count: 61 mio
In production - Available: 08-2017
 -
 
PD Ref: 51550 | Last updated: 18-08-2017 | Viewed: 96 times
 
 
 -  Age: 2007
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 6
 -  Impress.Count: 110 mio
Under power - Available: 08-2017
 -
 
PD Ref: 51549 | Last updated: 18-08-2017 | Viewed: 76 times
 
 
 -  Age: 2008
 -  Size: 103 x 72 cm (40 x 28 inch)
 -  Colors: 10
 -  Impress.Count: 66 mio
In production - Available: 08-2017
 -
 
Subscribe for News
Subscribe for latest Sheetfed Press Machines
Subscribe for latest Prepress Machines
Subscribe for latest Packaging Machines
Subscribe for latest Guillotines
 
Ads
 
GAB Supplies UK
 
  • vipoffer
    Komori L 628 UV
    2005
    Image1 Komori L 628 UV
  • vipoffer
    Heidelberg CD 102..
    2002
    Image2 Heidelberg CD 102..
  • vipoffer
    Man-Roland RSF 0B..
    1988
    Image3 Man-Roland RSF 0B..
  • vipoffer
    Setmasters A4P
    2000
    Image4 Setmasters A4P
  • vipoffer
    NEW !!! Hot foil ..
    New
    Image5 NEW !!! Hot foil ..
  • vipoffer
    Duplo FKS KB-4000..
    2013
    Image6 Duplo FKS KB-4000..
  • vipoffer
    Bobst SP126 BMA H..
    1980
    Image7 Bobst SP126 BMA H..
  • vipoffer
    Bobst SP 102 E II..
    1998
    Image8 Bobst SP 102 E II..
  • vipoffer
    Theisen Bonitz
    Unkn.
    Image9 Theisen Bonitz
  • vipoffer
    Bobst Domino 110 ..
    1996
    Image10 Bobst Domino 110 ..
  • vipoffer
    Newbind Adventure..
    2009
    Image11 Newbind Adventure..
  • vipoffer
    Heidelberg SM 74-..
    2007
    Image12 Heidelberg SM 74-..
 
advert bottom
why_this_website