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 1855 Machines

We recommend this machineRecommended machines
 
 
PD Ref: 52620 | Last updated: 29-09-2017 | Viewed: 165 times
 
 
 -  Age: 1986
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 1
 -  Impress.Count: 43 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 = '52497' OR a.id = '52788' OR a.id = '52109' OR a.id = '52784' OR a.id = '51275' OR a.id = '50296' OR a.id = '50299' OR a.id = '49600' OR a.id = '52305' OR a.id = '50611' OR a.id = '52008' OR a.id = '53196' OR a.id = '47315' OR a.id = '51696' OR a.id = '50446' OR a.id = '1418' OR a.id = '52620' OR a.id = '47712' OR a.id = '52619' OR a.id = '50300' OR a.id = '49599' OR a.id = '52888' OR a.id = '52835' OR a.id = '53237' OR a.id = '50612' OR a.id = '52303' OR a.id = '46473' OR a.id = '49677') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 50446 | Last updated: 08-07-2017 | Viewed: 474 times
 
 
 -  Age: 1986
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 79 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 = '52497' OR a.id = '52788' OR a.id = '52109' OR a.id = '52784' OR a.id = '51275' OR a.id = '50296' OR a.id = '50299' OR a.id = '49600' OR a.id = '52305' OR a.id = '50611' OR a.id = '52008' OR a.id = '53196' OR a.id = '47315' OR a.id = '51696' OR a.id = '50446' OR a.id = '1418' OR a.id = '52620' OR a.id = '47712' OR a.id = '52619' OR a.id = '50300' OR a.id = '49599' OR a.id = '52888' OR a.id = '52835' OR a.id = '53237' OR a.id = '50612' OR a.id = '52303' OR a.id = '46473' OR a.id = '49677') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 51696 | Last updated: 25-08-2017 | Viewed: 608 times
 
 
 -  Age: 2001
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 42 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 = '52497' OR a.id = '52788' OR a.id = '52109' OR a.id = '52784' OR a.id = '51275' OR a.id = '50296' OR a.id = '50299' OR a.id = '49600' OR a.id = '52305' OR a.id = '50611' OR a.id = '52008' OR a.id = '53196' OR a.id = '47315' OR a.id = '51696' OR a.id = '50446' OR a.id = '1418' OR a.id = '52620' OR a.id = '47712' OR a.id = '52619' OR a.id = '50300' OR a.id = '49599' OR a.id = '52888' OR a.id = '52835' OR a.id = '53237' OR a.id = '50612' OR a.id = '52303' OR a.id = '46473' OR a.id = '49677') ORDER by rand()
Recommended machine
Under power - Available: Immediately
 -
 
PD Ref: 52305 | Last updated: 20-09-2017 | Viewed: 383 times
 
 
 -  Age: 2005
 -  Size: 72 x 52 cm (28 x 20 inch)
 -  Colors: 5
 -  Impress.Count: 95 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 = '52497' OR a.id = '52788' OR a.id = '52109' OR a.id = '52784' OR a.id = '51275' OR a.id = '50296' OR a.id = '50299' OR a.id = '49600' OR a.id = '52305' OR a.id = '50611' OR a.id = '52008' OR a.id = '53196' OR a.id = '47315' OR a.id = '51696' OR a.id = '50446' OR a.id = '1418' OR a.id = '52620' OR a.id = '47712' OR a.id = '52619' OR a.id = '50300' OR a.id = '49599' OR a.id = '52888' OR a.id = '52835' OR a.id = '53237' OR a.id = '50612' OR a.id = '52303' OR a.id = '46473' OR a.id = '49677') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 52497 | Last updated: 25-09-2017 | Viewed: 171 times
 
 
 -  Age: 2001
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 5
 -  Impress.Count: 204 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 = '52497' OR a.id = '52788' OR a.id = '52109' OR a.id = '52784' OR a.id = '51275' OR a.id = '50296' OR a.id = '50299' OR a.id = '49600' OR a.id = '52305' OR a.id = '50611' OR a.id = '52008' OR a.id = '53196' OR a.id = '47315' OR a.id = '51696' OR a.id = '50446' OR a.id = '1418' OR a.id = '52620' OR a.id = '47712' OR a.id = '52619' OR a.id = '50300' OR a.id = '49599' OR a.id = '52888' OR a.id = '52835' OR a.id = '53237' OR a.id = '50612' OR a.id = '52303' OR a.id = '46473' OR a.id = '49677') ORDER by rand()
Recommended machine
In production - Available: 10-2017
 -
 
PD Ref: 52835 | Last updated: 13-10-2017 | Viewed: 231 times
 
 
 -  Age: 2006
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 5
 -  Impress.Count: 80 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 = '52497' OR a.id = '52788' OR a.id = '52109' OR a.id = '52784' OR a.id = '51275' OR a.id = '50296' OR a.id = '50299' OR a.id = '49600' OR a.id = '52305' OR a.id = '50611' OR a.id = '52008' OR a.id = '53196' OR a.id = '47315' OR a.id = '51696' OR a.id = '50446' OR a.id = '1418' OR a.id = '52620' OR a.id = '47712' OR a.id = '52619' OR a.id = '50300' OR a.id = '49599' OR a.id = '52888' OR a.id = '52835' OR a.id = '53237' OR a.id = '50612' OR a.id = '52303' OR a.id = '46473' OR a.id = '49677') ORDER by rand()
Recommended machine
In production - Available: 10-2017
 -
 
PD Ref: 50299 | Last updated: 30-06-2017 | Viewed: 852 times
 
 
 -  Age: 1990
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 4
 -  Impress.Count: 53 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 = '52497' OR a.id = '52788' OR a.id = '52109' OR a.id = '52784' OR a.id = '51275' OR a.id = '50296' OR a.id = '50299' OR a.id = '49600' OR a.id = '52305' OR a.id = '50611' OR a.id = '52008' OR a.id = '53196' OR a.id = '47315' OR a.id = '51696' OR a.id = '50446' OR a.id = '1418' OR a.id = '52620' OR a.id = '47712' OR a.id = '52619' OR a.id = '50300' OR a.id = '49599' OR a.id = '52888' OR a.id = '52835' OR a.id = '53237' OR a.id = '50612' OR a.id = '52303' OR a.id = '46473' OR a.id = '49677') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 49600 | Last updated: 03-06-2017 | Viewed: 454 times
 
 
 -  Age: 1987
 -  Size: 45 x 34 cm (17 x 13 inch)
 -  Colors: 2
 -  Impress.Count: 22 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 = '52497' OR a.id = '52788' OR a.id = '52109' OR a.id = '52784' OR a.id = '51275' OR a.id = '50296' OR a.id = '50299' OR a.id = '49600' OR a.id = '52305' OR a.id = '50611' OR a.id = '52008' OR a.id = '53196' OR a.id = '47315' OR a.id = '51696' OR a.id = '50446' OR a.id = '1418' OR a.id = '52620' OR a.id = '47712' OR a.id = '52619' OR a.id = '50300' OR a.id = '49599' OR a.id = '52888' OR a.id = '52835' OR a.id = '53237' OR a.id = '50612' OR a.id = '52303' OR a.id = '46473' OR a.id = '49677') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 47712 | Last updated: 19-10-2017 | Viewed: 4252 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 = '52497' OR a.id = '52788' OR a.id = '52109' OR a.id = '52784' OR a.id = '51275' OR a.id = '50296' OR a.id = '50299' OR a.id = '49600' OR a.id = '52305' OR a.id = '50611' OR a.id = '52008' OR a.id = '53196' OR a.id = '47315' OR a.id = '51696' OR a.id = '50446' OR a.id = '1418' OR a.id = '52620' OR a.id = '47712' OR a.id = '52619' OR a.id = '50300' OR a.id = '49599' OR a.id = '52888' OR a.id = '52835' OR a.id = '53237' OR a.id = '50612' OR a.id = '52303' OR a.id = '46473' OR a.id = '49677') ORDER by rand()
Recommended machine
In stock - Available: Immediately
 -
 
PD Ref: 52109 | Last updated: 13-09-2017 | Viewed: 494 times
 
 
 -  Age: 2003
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 5
 -  Impress.Count: 85 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 = '52497' OR a.id = '52788' OR a.id = '52109' OR a.id = '52784' OR a.id = '51275' OR a.id = '50296' OR a.id = '50299' OR a.id = '49600' OR a.id = '52305' OR a.id = '50611' OR a.id = '52008' OR a.id = '53196' OR a.id = '47315' OR a.id = '51696' OR a.id = '50446' OR a.id = '1418' OR a.id = '52620' OR a.id = '47712' OR a.id = '52619' OR a.id = '50300' OR a.id = '49599' OR a.id = '52888' OR a.id = '52835' OR a.id = '53237' OR a.id = '50612' OR a.id = '52303' OR a.id = '46473' OR a.id = '49677') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 53254 | Last updated: 23-10-2017 | Viewed: 3 times
 
 
 -  Age: 1987
 -  Size: 52 x 35 cm (20 x 13 inch)
 -  Colors: 2
 -  Impress.Count: 30 mio
In stock - Available: 02-2018
 -
 
PD Ref: 53242 | Last updated: 23-10-2017 | Viewed: 4 times
 
 
 -  Age: 2009
 -  Size: 102 x 75 cm (40 x 29 inch)
 -  Colors: 8
 -  Impress.Count: 245 mio
 
In production - Available: 10-2017
 -
 
PD Ref: 53240 | Last updated: 23-10-2017 | Viewed: 18 times
 
 
 -  Age: 2005
 -  Size: 66 x 48 cm (25 x 18 inch)
 -  Colors: 5
 -  Impress.Count: 38 mio
In production - Available: 10-2017
 -
 
PD Ref: 53239 | Last updated: 23-10-2017 | Viewed: 9 times
 
 
 -  Age: 2001
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 21 mio
In production - Available: 10-2017
 -
 
PD Ref: 53236 | Last updated: 23-10-2017 | Viewed: 18 times
 
 
 -  Age: 1992
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 5
 -  Impress.Count: No counter
In production - Available: 10-2017
 -
 
PD Ref: 53235 | Last updated: 23-10-2017 | Viewed: 8 times
 
 
 -  Age: 2003
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 8
 -  Impress.Count: No counter
In production - Available: 10-2017
 -
 
PD Ref: 53234 | Last updated: 23-10-2017 | Viewed: 8 times
 
 
 -  Age: 2007
 -  Size: 162 x 142 cm (63 x 55 inch)
 -  Colors: 6
 -  Impress.Count: 250 mio
In production - Available: 10-2017
 -
 
PD Ref: 53233 | Last updated: 23-10-2017 | Viewed: 5 times
 
 
 -  Age: 2001
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 38 mio
In production - Available: 10-2017
 -
 
PD Ref: 53230 | Last updated: 23-10-2017 | Viewed: 10 times
 
 
 -  Age: 1992
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 5
 -  Impress.Count: 88 mio
In production - Available: 10-2017
 -
 
PD Ref: 53216 | Last updated: 23-10-2017 | Viewed: 4 times
 
 
 -  Age: 1997
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 83 mio
In production - Available: 10-2017
 -
 
PD Ref: 53215 | Last updated: 23-10-2017 | Viewed: 11 times
 
 
 -  Age: 1992
 -  Size: 72 x 52 cm (28 x 20 inch)
 -  Colors: 6
In production - Available: 10-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
    Duplo System 2000
    2008
    Image1 Duplo System 2000
  • vipoffer
    Komori Lithrone N..
    2005
    Image2 Komori Lithrone N..
  • vipoffer
    Bobst SP 102 E II..
    1998
    Image3 Bobst SP 102 E II..
  • vipoffer
    Fuji Luxel V-6
    2006
    Image4 Fuji Luxel V-6
  • vipoffer
    NEW !!! Hot foil ..
    New
    Image5 NEW !!! Hot foil ..
  • vipoffer
    Heidelberg SM 74 ..
    2003
    Image6 Heidelberg SM 74 ..
  • vipoffer
    Heidelberg SM 52-..
    2001
    Image7 Heidelberg SM 52-..
  • vipoffer
    Heidelberg GTO 52..
    1990
    Image8 Heidelberg GTO 52..
  • vipoffer
    Heidelberg CD 102..
    1992
    Image9 Heidelberg CD 102..
  • vipoffer
    Heidelberg GTO 52..
    1986
    Image10 Heidelberg GTO 52..
  • vipoffer
    Esko
    2006
    Image11 Esko
  • vipoffer
    Brehmer Col
    1980
    Image12 Brehmer Col
 
advert bottom
why_this_website