Search Category
 
Camporese- macchine graphiche
 
or Refine by Word:

Order by
Mach per page
 
 
Subscribe for this Query
 
You are here: Used Press Found 1580 Machines
Recommended machines
 
 
PD Ref: 25187 | Last updated: 12-07-2014 | Viewed: 1477 times
 
 
 Age: 2006
 Size: 52 x 37 cm (20 x 14 inch)
 Colors: 4
 Impress.Count: 65 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26109 | Last updated: 14-09-2014 | Viewed: 886 times
 
 
 Age: 1991
 Size: 72 x 52 cm (28 x 20 inch)
 Colors: 2
 Impress.Count: 113 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26971 | Last updated: 21-10-2014 | Viewed: 191 times
 
 
 Age: 2006
 Size: 104 x 74 cm (40 x 29 inch)
 Colors: 5
 Impress.Count: No counter
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 25370 | Last updated: 27-07-2014 | Viewed: 1739 times
 
 
 Age: 1995
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 2
 Impress.Count: 47 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 25369 | Last updated: 27-07-2014 | Viewed: 1065 times
 
 
 Age: 1989
 Size: 65 x 48 cm (25 x 18 inch)
 Colors: 5
 Impress.Count: 133 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 22504 | Last updated: 09-03-2014 | Viewed: 2107 times
 
 
 Age: 1990
 Size: 71 x 51 cm (27 x 20 inch)
 Colors: 1
 Impress.Count: 44 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
Dismantled - Available: Immediately
logo
 
PD Ref: 27564 | Last updated: 16-11-2014 | Viewed: 247 times
 
 
 Age: 1989
 Size: 65 x 48 cm (25 x 18 inch)
 Colors: 5
 Impress.Count: 90 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: 11-2014
logo
 
PD Ref: 27544 | Last updated: 14-11-2014 | Viewed: 221 times
 
 
 Age: 2003
 Size: 74 x 53 cm (29 x 20 inch)
 Colors: 5
 Impress.Count: 71 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: 11-2014
logo
 
PD Ref: 26784 | Last updated: 14-10-2014 | Viewed: 540 times
 
 
 Age: 2000
 Size: 74 x 60 cm (29 x 23 inch)
 Colors: 5
 Impress.Count: 145 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: 12-2014
logo
 
PD Ref: 27440 | Last updated: 09-11-2014 | Viewed: 277 times
 
 
 Age: 2000
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 41 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: 11-2014
logo
 
PD Ref: 25986 | Last updated: 07-09-2014 | Viewed: 780 times
 
 
 Age: 1986
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 31 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 27562 | Last updated: 15-11-2014 | Viewed: 423 times
 
 
 Age: 1992
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 5
 Impress.Count: No counter
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
Under power - Available: 11-2014
logo
 
PD Ref: 26711 | Last updated: 12-10-2014 | Viewed: 652 times
 
 
 Age: 1988
 Size: 66 x 48 cm (25 x 18 inch)
 Colors: 5
 Impress.Count: 89 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 22502 | Last updated: 09-03-2014 | Viewed: 3687 times
 
 
 Age: 1984
 Size: 65 x 48 cm (25 x 18 inch)
 Colors: 5
 Impress.Count: 86 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26712 | Last updated: 12-10-2014 | Viewed: 388 times
 
 
 Age: 2000
 Size: 72 x 52 cm (28 x 20 inch)
 Colors: 5
 Impress.Count: 105 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 23464 | Last updated: 19-04-2014 | Viewed: 2661 times
 
 
 Age: 1995
 Size: 65 x 48 cm (25 x 18 inch)
 Colors: 5
 Impress.Count: 135 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26889 | Last updated: 18-10-2014 | Viewed: 1103 times
 
 
 Age: 2001
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 15 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26552 | Last updated: 05-10-2014 | Viewed: 743 times
 
 
 Age: 1987
 Size: 65 x 48 cm (25 x 18 inch)
 Colors: 2
 Impress.Count: 63 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
Under power - Available: Immediately
logo
 
PD Ref: 27435 | Last updated: 09-11-2014 | Viewed: 333 times
 
 
 Age: 1986
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 4
 Impress.Count: 71 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
Dismantled - Available: 11-2014
logo
 
PD Ref: 27557 | Last updated: 14-11-2014 | Viewed: 221 times
 
 
 Age: 2004
 Size: 74 x 53 cm (29 x 20 inch)
 Colors: 5
 Impress.Count: 115 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: 11-2014
logo
 
PD Ref: 13201 | Last updated: 05-08-2013 | Viewed: 6218 times
 
 
 Age: 2006
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 12
 Impress.Count: 135 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 22301 | Last updated: 11-11-2014 | Viewed: 838 times
 
 
 Age: 1992
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 56 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In stock - Available: 11-2014
logo
 
PD Ref: 27589 | Last updated: 17-11-2014 | Viewed: 178 times
 
 
 Age: 1993
 Size: 65 x 48 cm (25 x 18 inch)
 Colors: 2
 Impress.Count: 54 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: 12-2014
logo
 
PD Ref: 26875 | Last updated: 17-10-2014 | Viewed: 135 times
 
 
 Age: 2002
 Size: 29 x 23 inch (73 x 58 cm)
 Colors: 6
 Impress.Count: No counter
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26947 | Last updated: 21-10-2014 | Viewed: 319 times
 
 
 Age: 2008
 Size: 104 x 74 cm (40 x 29 inch)
 Colors: 6
 Impress.Count: 198 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 27441 | Last updated: 09-11-2014 | Viewed: 540 times
 
 
 Age: 1986
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 1
 Impress.Count: 11 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: 11-2014
logo
 
PD Ref: 06534 | Last updated: 27-05-2012 | Viewed: 3359 times
 
 
 Age: 1990
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 26 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
Dismantled - Available: Immediately
logo
 
PD Ref: 25368 | Last updated: 27-07-2014 | Viewed: 1333 times
 
 
 Age: 1987
 Size: 66 x 50 cm (25 x 19 inch)
 Colors: 1
 Impress.Count: 34 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In stock - Available: Immediately
logo
 
PD Ref: 26887 | Last updated: 18-10-2014 | Viewed: 170 times
 
 
 Age: 1996
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 42 mio
SELECT (SELECT email 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 = '23017' OR a.id = '27405' OR a.id = '27435' OR a.id = '13201' OR a.id = '22502' OR a.id = '25369' OR a.id = '26711' OR a.id = '23464' OR a.id = '26712' OR a.id = '6534' OR a.id = '25986' OR a.id = '26552' OR a.id = '26889' OR a.id = '26887' OR a.id = '27440' OR a.id = '26109' OR a.id = '25370' OR a.id = '27441' OR a.id = '25368' OR a.id = '22504' OR a.id = '27436' OR a.id = '22658' OR a.id = '24010' OR a.id = '23796' OR a.id = '22171' OR a.id = '26414' OR a.id = '11396' OR a.id = '23674' OR a.id = '25539' OR a.id = '22657' OR a.id = '25069' OR a.id = '26111' OR a.id = '25372' OR a.id = '20128' OR a.id = '25990' OR a.id = '25072' OR a.id = '26106' OR a.id = '22173' OR a.id = '25992' OR a.id = '24747' OR a.id = '25538' OR a.id = '27439' OR a.id = '26248' OR a.id = '26553' OR a.id = '22653' OR a.id = '25265' OR a.id = '25071' OR a.id = '14080' OR a.id = '8941' OR a.id = '6662' OR a.id = '8660' OR a.id = '27102' OR a.id = '14081' OR a.id = '22301' OR a.id = '26784' OR a.id = '26971' OR a.id = '26947' OR a.id = '27557' OR a.id = '25187' OR a.id = '27544' OR a.id = '27562' OR a.id = '27564' OR a.id = '1418' OR a.id = '27589' OR a.id = '26875') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
Used Press 12 colors
 
 
PD Ref: 13201 | Last updated: 05-08-2013 | Viewed: 6218 times
 
 
 Age: 2006
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 12
 Impress.Count: 135 mio
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 27179 | Last updated: 30-10-2014 | Viewed: 120 times
 
 
 Age: 2002
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 12
 Impress.Count: No counter
 
In production - Available: 12-2014
logo
Used Press 10 colors
 
 
PD Ref: 27039 | Last updated: 23-10-2014 | Viewed: 193 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: 906 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: 25696 | Last updated: 31-10-2014 | Viewed: 370 times
 
 
 Age: 2007
 Size: 103 x 72 cm (40 x 28 inch)
 Colors: 10
 Impress.Count: 77 mio
 
In production - Available: Immediately
logo
 
PD Ref: 21784 | Last updated: 06-02-2014 | Viewed: 878 times
 
 
 Age: 1997
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 10
 Impress.Count: 230 mio
 
In production - Available: Immediately
logo
 
PD Ref: 21213 | Last updated: 16-01-2014 | Viewed: 700 times
 
 
 Age: 1998
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 10
 Impress.Count: 155 mio
 
In production - Available: Immediately
logo
 
PD Ref: 26644 | Last updated: 09-10-2014 | Viewed: 316 times
 
 
 Age: 2006
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 10
 Impress.Count: 216 mio
 
In production - Available: Immediately
logo
 
PD Ref: 27183 | Last updated: 30-10-2014 | Viewed: 120 times
 
 
 Age: 2006
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 10
 Impress.Count: No counter
 
In production - Available: 11-2014
logo
 
PD Ref: 21515 | Last updated: 27-01-2014 | Viewed: 902 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: 27180 | Last updated: 30-10-2014 | Viewed: 129 times
 
 
 Age: 2006
 Size: 74 x 53 cm (29 x 20 inch)
 Colors: 10
 Impress.Count: No counter
 
In production - Available: 01-2015
logo
 
 
Subscribe for latest equipment
  • vipoffer
    MBO K-72 6 KTL
    1988 Used Postpress
    Image1 MBO K-72 6 KTL
  • vipoffer
    Paper bags foldin..
    2009 Used Packaging
    Image2 Paper bags foldin..
  • vipoffer
    Polar 92 EM-MON
    1990 Used Guillotines
    Image3 Polar 92 EM-MON
  • vipoffer
    Sakurai Oliver 72..
    1990 Used Press
    Image4 Sakurai Oliver 72..
  • vipoffer
    Komori L 526
    1988 Used Press
    Image5 Komori L 526
  • vipoffer
    Muller Martini 15..
    1994 Used Postpress
    Image6 Muller Martini 15..
  • vipoffer
    NEW !!! Hot foil ..
    2014 Used Postpress
    Image7 NEW !!! Hot foil ..
  • vipoffer
    Heidelberg MOFP-H..
    1989 Used Press
    Image8 Heidelberg MOFP-H..
 
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.