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

Order by
Mach per page
 
 
Subscribe for this QuerySubscribe forWanted Machine
 
Your Search: Used Press pressdepo Found 1728 Machines
We recommend this machineRecommended machines
 
 
PD Ref: 37650 | Last updated: 14-02-2016 | Viewed: 1000 times
 
 
 -  Age: 1989
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 47 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 37195 | Last updated: 30-01-2016 | Viewed: 1668 times
 
 
 -  Age: 2003
 -  Size: 66 x 50 cm (25 x 19 inch)
 -  Colors: 5
 -  Impress.Count: 101 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 32564 | Last updated: 05-07-2015 | Viewed: 3973 times
 
 
 -  Age: 1995
 -  Size: 47 x 36 cm (18 x 14 inch)
 -  Colors: 1
 -  Impress.Count: 13 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 38343 | Last updated: 11-03-2016 | Viewed: 1219 times
 
 
 -  Age: 2006
 -  Size: 162 x 122 cm (63 x 48 inch)
 -  Colors: 5
 -  Impress.Count: 120 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 38818 | Last updated: 30-03-2016 | Viewed: 405 times
 
 
 -  Age: 2002
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 4
 -  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 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
Under power - Available: Immediately
 -
 
PD Ref: 21499 | Last updated: 28-04-2016 | Viewed: 4463 times
 
 
 -  Age: 2002
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 6
 -  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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 37669 | Last updated: 20-04-2016 | Viewed: 1041 times
 
 
 -  Age: 1996
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 5
 -  Impress.Count: 24 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 38971 | Last updated: 05-04-2016 | Viewed: 594 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.id = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 32365 | Last updated: 24-06-2015 | Viewed: 3534 times
 
 
 -  Age: 1990
 -  Size: 72 x 52 cm (28 x 20 inch)
 -  Colors: 6
 -  Impress.Count: 165 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 37092 | Last updated: 27-01-2016 | Viewed: 952 times
 
 
 -  Age: 2007
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 5
 -  Impress.Count: 156 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: 06-2016
 -
 
PD Ref: 38528 | Last updated: 18-03-2016 | Viewed: 411 times
 
 
 -  Age: 2004
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 5
 -  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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
Under power - Available: Immediately
 -
 
PD Ref: 38929 | Last updated: 03-04-2016 | Viewed: 444 times
 
 
 -  Age: 1976
 -  Size: 64 x 48 cm (25 x 18 inch)
 -  Colors: 1
 -  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 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 38749 | Last updated: 25-03-2016 | Viewed: 299 times
 
 
 -  Age: 2004
 -  Size: 104 x 74 cm (40 x 29 inch)
 -  Colors: 4
 -  Impress.Count: 81 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
Under power - Available: Immediately
 -
 
PD Ref: 37277 | Last updated: 02-02-2016 | Viewed: 1779 times
 
 
 -  Age: 1996
 -  Size: 74 x 52 cm (29 x 20 inch)
 -  Colors: 4
 -  Impress.Count: 157 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 38810 | Last updated: 29-03-2016 | Viewed: 793 times
 
 
 -  Age: 2011
 -  Size: 91 x 35 cm (35 x 13 inch)
 -  Colors: 5
 -  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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 37668 | Last updated: 06-04-2016 | Viewed: 932 times
 
 
 -  Age: 1996
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 5
 -  Impress.Count: 140 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 38549 | Last updated: 19-03-2016 | Viewed: 795 times
 
 
 -  Age: 2006
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 5
 -  Impress.Count: 26 mio
SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 39151 | Last updated: 09-04-2016 | Viewed: 190 times
 
 
 -  Age: 1992
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 2
 -  Impress.Count: 49 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 33045 | Last updated: 04-08-2015 | Viewed: 1810 times
 
 
 -  Age: 1997
 -  Size: 45 x 34 cm (17 x 13 inch)
 -  Colors: 2
 -  Impress.Count: 20 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 38356 | Last updated: 12-03-2016 | Viewed: 378 times
 
 
 -  Age: 1997
 -  Size: 142 x 102 cm (55 x 40 inch)
 -  Colors: 6
 -  Impress.Count: 280 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 37647 | Last updated: 14-02-2016 | Viewed: 345 times
 
 
 -  Age: 1987
 -  Size: 52 x 36 cm (20 x 14 inch)
 -  Colors: 1
 -  Impress.Count: 47 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 33681 | Last updated: 16-02-2016 | Viewed: 1523 times
 
 
 -  Age: 2011
 -  Size: 74 x 53 cm (29 x 20 inch)
 -  Colors: 5
 -  Impress.Count: 24 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 = '39574' OR a.id = '38551' OR a.id = '38356' OR a.id = '30263' OR a.id = '37805' OR a.id = '38929' OR a.id = '38749' OR a.id = '38818' OR a.id = '38175' OR a.id = '39390' OR a.id = '32564' OR a.id = '39575' OR a.id = '39150' OR a.id = '38179' OR a.id = '37092' OR a.id = '1418' OR a.id = '37669' OR a.id = '37806' OR a.id = '32753' OR a.id = '38557' OR a.id = '37197' OR a.id = '39391' OR a.id = '21499' OR a.id = '38528' OR a.id = '38971' OR a.id = '38930' OR a.id = '36830' OR a.id = '36837' OR a.id = '39116' OR a.id = '37195' OR a.id = '38343' OR a.id = '36831' OR a.id = '38810' OR a.id = '39573' OR a.id = '38927' OR a.id = '37650' OR a.id = '33045' OR a.id = '38548' OR a.id = '37009' OR a.id = '37980' OR a.id = '37668' OR a.id = '39151' OR a.id = '33681' OR a.id = '34935' OR a.id = '38549' OR a.id = '36838' OR a.id = '37277' OR a.id = '32365' OR a.id = '34454' OR a.id = '38363' OR a.id = '37651' OR a.id = '37647' OR a.id = '38346' OR a.id = '36832' OR a.id = '39389' OR a.id = '28513') ORDER by rand()
Recommended machine
In production - Available: Immediately
 -
 
PD Ref: 39710 | Last updated: 29-04-2016 | Viewed: 5 times
 
 
 -  Age: 1996
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 8
 -  Impress.Count: 349 mio
In production - Available: Immediately
 -
 
PD Ref: 39706 | Last updated: 29-04-2016 | Viewed: 18 times
 
 
 -  Age: 1991
 -  Size: 35 x 35 cm (13 x 13 inch)
 -  Colors: 2
 -  Impress.Count: No counter
In stock - Available: Immediately
 -
 
PD Ref: 39705 | Last updated: 29-04-2016 | Viewed: 19 times
 
 
 -  Age: 1999
 -  Size: 45 x 34 cm (17 x 13 inch)
 -  Colors: 4
 -  Impress.Count: 22 mio
In production - Available: 06-2016
 -
 
PD Ref: 39699 | Last updated: 29-04-2016 | Viewed: 53 times
 
 
 -  Age: 1987
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 4
 -  Impress.Count: 120 mio
In production - Available: Immediately
 -
 
PD Ref: 39698 | Last updated: 29-04-2016 | Viewed: 35 times
 
 
 -  Age: 1987
 -  Size: 52 x 37 cm (20 x 14 inch)
 -  Colors: 4
 -  Impress.Count: 57 mio
In production - Available: Immediately
 -
 
PD Ref: 39697 | Last updated: 29-04-2016 | Viewed: 86 times
 
 
 -  Age: 2006
 -  Size: 104 x 74 cm (40 x 29 inch)
 -  Colors: 4
 -  Impress.Count: 192 mio
In production - Available: Immediately
 -
 
PD Ref: 39694 | Last updated: 29-04-2016 | Viewed: 40 times
 
 
 -  Age: 1995
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 8
 -  Impress.Count: 296 mio
In production - Available: 05-2016
 -
 
PD Ref: 39693 | Last updated: 29-04-2016 | Viewed: 70 times
 
 
 -  Age: 1976
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 2
 -  Impress.Count: 17 mio
In production - Available: Immediately
 -
 
PD Ref: 39685 | Last updated: 28-04-2016 | Viewed: 74 times
 
 
 -  Age: 2008
 -  Size: 74 x 60 cm (29 x 23 inch)
 -  Colors: 8
 -  Impress.Count: 132 mio
In stock - Available: Immediately
 -
 
PD Ref: 39682 | Last updated: 28-04-2016 | Viewed: 136 times
 
 
 -  Age: 2002
 -  Size: 105 x 72 cm (41 x 28 inch)
 -  Colors: 4
 -  Impress.Count: 210 mio
In production - Available: Immediately
 -
 
PD Ref: 39681 | Last updated: 28-04-2016 | Viewed: 51 times
 
 
 -  Age: 1980
 -  Size: 102 x 72 cm (40 x 28 inch)
 -  Colors: 4
 -  Impress.Count: No counter
In production - Available: 05-2016
 -
 
Used printing machines - Pinheirosshadow_adv

Subscribe for News
  • vipoffer
    Wohlenberg 76 Cut..
    1997 Used Guillotines
    Image1 Wohlenberg 76 Cut..
  • vipoffer
    Horizon BQ 270
    2005 Used Postpress
    Image2 Horizon BQ 270
  • vipoffer
    Heidelberg KORD 6..
    1976 Used Press
    Image3 Heidelberg KORD 6..
  • vipoffer
    Komori L 628 II
    1990 Used Press
    Image4 Komori L 628 II
  • vipoffer
    Muller Martini Ty..
    1989 Spare Parts
    Image5 Muller Martini Ty..
  • vipoffer
    Ryobi 3302 M
    1997 Used Press
    Image6 Ryobi 3302 M
  • vipoffer
    Muller Martini Ty..
    1989 Spare Parts
    Image7 Muller Martini Ty..
  • vipoffer
    Heidelberg GTO 52..
    1987 Used Press
    Image8 Heidelberg GTO 52..
 
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.