Sunny times for Searching used printing machines
Subscribe for News
 
Search By Category
 
Gab Supplies - used machinery
 
or Refine by Word:

Order by
Mach per page
 
 
Subscribe for this Query
 
Your Search: Used Press Found 1477 Machines
Recommended machines
 
 
PD Ref: 32508 | Last updated: 01-07-2015 | Viewed: 388 times
 
 
 Age: 2009
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 5
 Impress.Count: 45 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '32038' OR a.id = '31946' OR a.id = '32877' OR a.id = '26059' OR a.id = '32432' OR a.id = '1418' OR a.id = '32508' OR a.id = '32254' OR a.id = '32436' OR a.id = '32191' OR a.id = '32557' OR a.id = '32665' OR a.id = '30479' OR a.id = '32595' OR a.id = '32563') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 32595 | Last updated: 08-07-2015 | Viewed: 203 times
 
 
 Age: 2008
 Size: 52 x 37 cm (20 x 14 inch)
 Colors: 4
 Impress.Count: 29 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '32038' OR a.id = '31946' OR a.id = '32877' OR a.id = '26059' OR a.id = '32432' OR a.id = '1418' OR a.id = '32508' OR a.id = '32254' OR a.id = '32436' OR a.id = '32191' OR a.id = '32557' OR a.id = '32665' OR a.id = '30479' OR a.id = '32595' OR a.id = '32563') ORDER by rand()
Recommended machine
In production - Available: 08-2015
logo
 
PD Ref: 32038 | Last updated: 10-06-2015 | Viewed: 653 times
 
 
 Age: 2008
 Size: 75 x 53 cm (29 x 20 inch)
 Colors: 10
 Impress.Count: 175 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '32038' OR a.id = '31946' OR a.id = '32877' OR a.id = '26059' OR a.id = '32432' OR a.id = '1418' OR a.id = '32508' OR a.id = '32254' OR a.id = '32436' OR a.id = '32191' OR a.id = '32557' OR a.id = '32665' OR a.id = '30479' OR a.id = '32595' OR a.id = '32563') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 32432 | Last updated: 10-07-2015 | Viewed: 342 times
 
 
 Age: 2006
 Size: 52 x 37 cm (20 x 14 inch)
 Colors: 4
 Impress.Count: 27 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '32038' OR a.id = '31946' OR a.id = '32877' OR a.id = '26059' OR a.id = '32432' OR a.id = '1418' OR a.id = '32508' OR a.id = '32254' OR a.id = '32436' OR a.id = '32191' OR a.id = '32557' OR a.id = '32665' OR a.id = '30479' OR a.id = '32595' OR a.id = '32563') ORDER by rand()
Recommended machine
In production - Available: 08-2015
logo
 
PD Ref: 26059 | Last updated: 12-09-2014 | Viewed: 949 times
 
 
 Age: 2004
 Size: 51 x 35 cm (20 x 13 inch)
 Colors: 4
 Impress.Count: 16 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '32038' OR a.id = '31946' OR a.id = '32877' OR a.id = '26059' OR a.id = '32432' OR a.id = '1418' OR a.id = '32508' OR a.id = '32254' OR a.id = '32436' OR a.id = '32191' OR a.id = '32557' OR a.id = '32665' OR a.id = '30479' OR a.id = '32595' OR a.id = '32563') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 32254 | Last updated: 19-06-2015 | Viewed: 520 times
 
 
 Age: 2002
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 65 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '32038' OR a.id = '31946' OR a.id = '32877' OR a.id = '26059' OR a.id = '32432' OR a.id = '1418' OR a.id = '32508' OR a.id = '32254' OR a.id = '32436' OR a.id = '32191' OR a.id = '32557' OR a.id = '32665' OR a.id = '30479' OR a.id = '32595' OR a.id = '32563') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 32563 | Last updated: 05-07-2015 | Viewed: 531 times
 
 
 Age: 2008
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 16 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '32038' OR a.id = '31946' OR a.id = '32877' OR a.id = '26059' OR a.id = '32432' OR a.id = '1418' OR a.id = '32508' OR a.id = '32254' OR a.id = '32436' OR a.id = '32191' OR a.id = '32557' OR a.id = '32665' OR a.id = '30479' OR a.id = '32595' OR a.id = '32563') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 32665 | Last updated: 14-07-2015 | Viewed: 128 times
 
 
 Age: 2006
 Size: 74 x 53 cm (29 x 20 inch)
 Colors: 5
 Impress.Count: 250 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '32038' OR a.id = '31946' OR a.id = '32877' OR a.id = '26059' OR a.id = '32432' OR a.id = '1418' OR a.id = '32508' OR a.id = '32254' OR a.id = '32436' OR a.id = '32191' OR a.id = '32557' OR a.id = '32665' OR a.id = '30479' OR a.id = '32595' OR a.id = '32563') ORDER by rand()
Recommended machine
In production - Available: 12-2015
logo
 
PD Ref: 32877 | Last updated: 23-07-2015 | Viewed: 170 times
 
 
 Age: 1996
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 5
 Impress.Count: 103 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '32038' OR a.id = '31946' OR a.id = '32877' OR a.id = '26059' OR a.id = '32432' OR a.id = '1418' OR a.id = '32508' OR a.id = '32254' OR a.id = '32436' OR a.id = '32191' OR a.id = '32557' OR a.id = '32665' OR a.id = '30479' OR a.id = '32595' OR a.id = '32563') ORDER by rand()
Recommended machine
In production - Available: 08-2015
logo
 
PD Ref: 32557 | Last updated: 03-07-2015 | Viewed: 633 times
 
 
 Age: 2007
 Size: 104 x 74 cm (40 x 29 inch)
 Colors: 4
 Impress.Count: 89 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '32038' OR a.id = '31946' OR a.id = '32877' OR a.id = '26059' OR a.id = '32432' OR a.id = '1418' OR a.id = '32508' OR a.id = '32254' OR a.id = '32436' OR a.id = '32191' OR a.id = '32557' OR a.id = '32665' OR a.id = '30479' OR a.id = '32595' OR a.id = '32563') ORDER by rand()
Recommended machine
In production - Available: 09-2015
logo
 
PD Ref: 30479 | Last updated: 21-07-2015 | Viewed: 680 times
 
 
 Age: 1977
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 2
 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.id = '32038' OR a.id = '31946' OR a.id = '32877' OR a.id = '26059' OR a.id = '32432' OR a.id = '1418' OR a.id = '32508' OR a.id = '32254' OR a.id = '32436' OR a.id = '32191' OR a.id = '32557' OR a.id = '32665' OR a.id = '30479' OR a.id = '32595' OR a.id = '32563') ORDER by rand()
Recommended machine
Under power - Available: Immediately
logo
Used Press 12 colors
 
 
PD Ref: 29527 | Last updated: 24-02-2015 | Viewed: 557 times
 
 
 Age: 2004
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 12
 Impress.Count: 352 mio
 
In production - Available: Immediately
logo
 
PD Ref: 11222 | Last updated: 23-05-2013 | Viewed: 2605 times
 
 
 Age: 2004
 Size: 300 x 50 cm (118 x 19 inch)
 Colors: 12
 Impress.Count: No counter
 
In production - Available: Immediately
logo
 
PD Ref: 25530 | Last updated: 03-03-2015 | Viewed: 1100 times
 
 
 Age: 2005
 Size: 15000 x 50 cm (5905 x 19 inch)
 Colors: 12
 Impress.Count: 3.5 mio
 
In production - Available: Immediately
logo
Used Press 10 colors
 
 
PD Ref: 27039 | Last updated: 23-10-2014 | Viewed: 959 times
 
 
 Age: 2005
 Size: 62 x 42 cm (24 x 16 inch)
 Colors: 10
 Impress.Count: 190 mio
 
In production - Available: Immediately
logo
 
PD Ref: 20674 | Last updated: 15-12-2013 | Viewed: 1710 times
 
 
 Age: 2004
 Size: 102 x 71 cm (40 x 27 inch)
 Colors: 10
 Impress.Count: 79 mio
 
In production - Available: Immediately
logo
 
PD Ref: 28195 | Last updated: 18-12-2014 | Viewed: 1335 times
 
 
 Age: 2005
 Size: 74 x 53 cm (29 x 20 inch)
 Colors: 10
 Impress.Count: 148 mio
 
In stock - Available: Immediately
logo
 
PD Ref: 28802 | Last updated: 24-01-2015 | Viewed: 564 times
 
 
 Age: 2001
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 10
 Impress.Count: 220 mio
 
In production - Available: Immediately
logo
 
PD Ref: 30402 | Last updated: 27-03-2015 | Viewed: 391 times
 
 
 Age: 2006
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 10
 Impress.Count: 242 mio
 
In production - Available: Immediately
logo
 
PD Ref: 21515 | Last updated: 27-01-2014 | Viewed: 1729 times
 
 
 Age: 2006
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 10
 Impress.Count: 51 mio
 
In production - Available: Immediately
logo
 
PD Ref: 29052 | Last updated: 04-02-2015 | Viewed: 472 times
 
 
 Age: 2006
 Size: 52 x 37 cm (20 x 14 inch)
 Colors: 10
 Impress.Count: 53 mio
 
In stock - Available: Immediately
logo
 
PD Ref: 29466 | Last updated: 20-02-2015 | Viewed: 485 times
 
 
 Age: 2004
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 10
 Impress.Count: 92 mio
 
In production - Available: Immediately
logo
 
Subscribe for News
  • vipoffer
    Heidelberg XL 75-..
    2008 Used Press
    Image1 Heidelberg XL 75-..
  • vipoffer
    Muller Martini Va..
    2004 Used Postpress
    Image2 Muller Martini Va..
  • vipoffer
    Man-Roland Rekord..
    1977 Used Press
    Image3 Man-Roland Rekord..
  • vipoffer
    NEW !!! Hot foil ..
    2015 Used Postpress
    Image4 NEW !!! Hot foil ..
  • vipoffer
    Heidelberg SM 52-..
    2002 Used Press
    Image5 Heidelberg SM 52-..
  • vipoffer
    Heidelberg SM 52-..
    2008 Used Press
    Image6 Heidelberg SM 52-..
  • vipoffer
    Hamada B452-A
    2004 Used Press
    Image7 Hamada B452-A
  • vipoffer
    Bobst SP-102 E Fu..
    1993 Used Packaging
    Image8 Bobst SP-102 E Fu..
 
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.