Search Category
 
Gab Supplies - used machinery
 
or Refine by Word:

Order by
Mach per page
 
 
Subscribe for this Query
 
You are here: Used Press Found 1493 Machines
Recommended machines
 
 
PD Ref: 26109 | Last updated: 14-09-2014 | Viewed: 107 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 09-2014
logo
 
PD Ref: 26112 | Last updated: 14-09-2014 | Viewed: 105 times
 
 
 Age: 1996
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 28 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
Under power - Available: 09-2014
logo
 
PD Ref: 25185 | Last updated: 11-07-2014 | Viewed: 511 times
 
 
 Age: 2001
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 8
 Impress.Count: 140 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26268 | Last updated: 22-09-2014 | Viewed: 46 times
 
 
 Age: 2010
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 5
 Impress.Count: 20 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
Under power - Available: 09-2014
logo
 
PD Ref: 26078 | Last updated: 12-09-2014 | Viewed: 749 times
 
 
 Age: 2006
 Size: 29 x 24 inch (73 x 60 cm)
 Colors: 6
 Impress.Count: 50 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 09-2014
logo
 
PD Ref: 26069 | Last updated: 11-09-2014 | Viewed: 225 times
 
 
 Age: 2005
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 4
 Impress.Count: 98 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
Under power - Available: 09-2014
logo
 
PD Ref: 25370 | Last updated: 27-07-2014 | Viewed: 705 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26108 | Last updated: 14-09-2014 | Viewed: 381 times
 
 
 Age: 1997
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 4
 Impress.Count: 14 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 09-2014
logo
 
PD Ref: 26187 | Last updated: 20-09-2014 | Viewed: 119 times
 
 
 Age: 1998
 Size: 74 x 59 cm (29 x 23 inch)
 Colors: 4
 Impress.Count: 70 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 09-2014
logo
 
PD Ref: 20126 | Last updated: 17-11-2013 | Viewed: 2923 times
 
 
 Age: 2002
 Size: 46 x 32 cm (18 x 12 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 25882 | Last updated: 02-09-2014 | Viewed: 417 times
 
 
 Age: 2001
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 4
 Impress.Count: 51 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 09-2014
logo
 
PD Ref: 25662 | Last updated: 16-08-2014 | Viewed: 1338 times
 
 
 Age: 2007
 Size: 45 x 34 cm (17 x 13 inch)
 Colors: 4
 Impress.Count: 23 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26113 | Last updated: 14-09-2014 | Viewed: 103 times
 
 
 Age: 1985
 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 10-2014
logo
 
PD Ref: 23494 | Last updated: 18-09-2014 | Viewed: 928 times
 
 
 Age: 2005
 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26246 | Last updated: 21-09-2014 | Viewed: 104 times
 
 
 Age: 1984
 Size: 65 x 48 cm (25 x 18 inch)
 Colors: 1
 Impress.Count: 78 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 09-2014
logo
 
PD Ref: 21123 | Last updated: 14-09-2014 | Viewed: 849 times
 
 
 Age: 1993
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 4
 Impress.Count: 98 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26200 | Last updated: 18-09-2014 | Viewed: 118 times
 
 
 Age: 2007
 Size: 74 x 52 cm (29 x 20 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 10-2014
logo
 
PD Ref: 25970 | Last updated: 05-09-2014 | Viewed: 320 times
 
 
 Age: 2010
 Size: 52 x 37 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 6 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 09-2014
logo
 
PD Ref: 25368 | Last updated: 27-07-2014 | Viewed: 574 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In stock - Available: Immediately
logo
 
PD Ref: 26068 | Last updated: 11-09-2014 | Viewed: 256 times
 
 
 Age: 1995
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 2
 Impress.Count: 178 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
Under power - Available: 09-2014
logo
 
PD Ref: 26061 | Last updated: 11-09-2014 | Viewed: 55 times
 
 
 Age: 2010
 Size: 92 x 65 cm (36 x 25 inch)
 Colors: 5
 Impress.Count: 48 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 12-2014
logo
 
PD Ref: 22170 | Last updated: 06-07-2014 | Viewed: 1952 times
 
 
 Age: 1989
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 53 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26125 | Last updated: 14-09-2014 | Viewed: 323 times
 
 
 Age: 1993
 Size: 74 x 53 cm (29 x 20 inch)
 Colors: 4
 Impress.Count: 29 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 09-2014
logo
 
PD Ref: 25962 | Last updated: 04-09-2014 | Viewed: 214 times
 
 
 Age: 2002
 Size: 105 x 72 cm (41 x 28 inch)
 Colors: 6
 Impress.Count: 68 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: 09-2014
logo
 
PD Ref: 22502 | Last updated: 09-03-2014 | Viewed: 2684 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 23464 | Last updated: 19-04-2014 | Viewed: 1709 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 25187 | Last updated: 12-07-2014 | Viewed: 888 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 22504 | Last updated: 09-03-2014 | Viewed: 1646 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
Dismantled - Available: Immediately
logo
 
PD Ref: 25531 | Last updated: 09-08-2014 | Viewed: 303 times
 
 
 Age: 1990
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 4
 Impress.Count: 57 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 25002 | Last updated: 02-07-2014 | Viewed: 631 times
 
 
 Age: 1996
 Size: 74 x 53 cm (29 x 20 inch)
 Colors: 2
 Impress.Count: 29 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 25369 | Last updated: 27-07-2014 | Viewed: 610 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26201 | Last updated: 18-09-2014 | Viewed: 136 times
 
 
 Age: 1978
 Size: 94 x 61 cm (37 x 24 inch)
 Colors: 2
 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
Dismantled - Available: 09-2014
logo
 
PD Ref: 25075 | Last updated: 06-07-2014 | Viewed: 391 times
 
 
 Age: 1986
 Size: 65 x 48 cm (25 x 18 inch)
 Colors: 2
 Impress.Count: 49 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
In stock - Available: Immediately
logo
 
PD Ref: 25466 | Last updated: 03-08-2014 | Viewed: 302 times
 
 
 Age: 1983
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 1
 Impress.Count: 29 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 = '25662' OR a.id = '25665' OR a.id = '25187' OR a.id = '25531' OR a.id = '25882' OR a.id = '25185' OR a.id = '25970' OR a.id = '20563' OR a.id = '26068' OR a.id = '26069' OR a.id = '26078' OR a.id = '26125' OR a.id = '21123' OR a.id = '1418' OR a.id = '25962' OR a.id = '26200' OR a.id = '26201' OR a.id = '23494' OR a.id = '26202' OR a.id = '26187' OR a.id = '26112' OR a.id = '26113' OR a.id = '22502' OR a.id = '25369' OR a.id = '23464' OR a.id = '26061' OR a.id = '26108' OR a.id = '25370' OR a.id = '26109' OR a.id = '20126' OR a.id = '22170' OR a.id = '25075' OR a.id = '25466' OR a.id = '26246' OR a.id = '25368' OR a.id = '22504' OR a.id = '22658' OR a.id = '25260' OR a.id = '22171' OR a.id = '23796' OR a.id = '23674' OR a.id = '25988' OR a.id = '25069' OR a.id = '25539' OR a.id = '26111' OR a.id = '23463' OR a.id = '23138' OR a.id = '20273' OR a.id = '12656' OR a.id = '20128' OR a.id = '25992' OR a.id = '26106' OR a.id = '25072' OR a.id = '22173' OR a.id = '25990' OR a.id = '24747' OR a.id = '25076' OR a.id = '26247' OR a.id = '21063' OR a.id = '22002' OR a.id = '22653' OR a.id = '25265' OR a.id = '25987' OR a.id = '25071' OR a.id = '26110' OR a.id = '25989' OR a.id = '24008' OR a.id = '8660' OR a.id = '14081' OR a.id = '26268' OR a.id = '25002') ORDER by rand()
Recommended machine
Under power - Available: Immediately
logo
Used Press 12 colors
 
 
PD Ref: 13201 | Last updated: 05-08-2013 | Viewed: 5400 times
 
 
 Age: 2006
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 12
 Impress.Count: 135 mio
 
In production - Available: Immediately
logo
 
PD Ref: 25873 | Last updated: 01-09-2014 | Viewed: 95 times
 
 
 Age: 2007
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 12
 Impress.Count: 137 mio
 
Under power - Available: 09-2014
logo
 
PD Ref: 20489 | Last updated: 06-12-2013 | Viewed: 1396 times
 
 
 Age: 2009
 Size: 105 x 75 cm (41 x 29 inch)
 Colors: 12
 Impress.Count: 120 mio
 
In production - Available: Immediately
logo
 
PD Ref: 25632 | Last updated: 14-08-2014 | Viewed: 83 times
 
 
 Age: 2006
 Size: 105 x 75 cm (41 x 29 inch)
 Colors: 12
 Impress.Count: 120 mio
 
In production - Available: Immediately
logo
 
PD Ref: 13536 | Last updated: 04-09-2013 | Viewed: 1240 times
 
 
 Age: 2002
 Size: 1000 x 32 cm (393 x 12 inch)
 Colors: 12
 Impress.Count: No counter
 
In stock - Available: Immediately
logo
 
PD Ref: 11222 | Last updated: 23-05-2013 | Viewed: 1577 times
 
 
 Age: 2004
 Size: 300 x 50 cm (118 x 19 inch)
 Colors: 12
 Impress.Count: No counter
 
In production - Available: Immediately
logo
Used Press 10 colors
 
 
PD Ref: 20674 | Last updated: 15-12-2013 | Viewed: 710 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: 23877 | Last updated: 13-05-2014 | Viewed: 362 times
 
 
 Age: 2006
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 10
 Impress.Count: 75 mio
 
In production - Available: Immediately
logo
 
PD Ref: 25696 | Last updated: 22-08-2014 | Viewed: 186 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: 657 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: 25605 | Last updated: 13-08-2014 | Viewed: 99 times
 
 
 Age: 2005
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 10
 Impress.Count: 168 mio
 
In production - Available: Immediately
logo
 
 
Subscribe for latest equipment
  • vipoffer
    Wohlenberg 115 Cu..
    2007 Used Guillotines
    Image1 Wohlenberg 115 Cu..
  • vipoffer
    Presstek 34 DI X
    2007 Used Press
    Image2 Presstek 34 DI X
  • vipoffer
    Heidelberg SM 102..
    1995 Used Press
    Image3 Heidelberg SM 102..
  • vipoffer
    Sakurai Oliver 72..
    1990 Used Press
    Image4 Sakurai Oliver 72..
  • vipoffer
    Man-Roland Rekord..
    1993 Used Press
    Image5 Man-Roland Rekord..
  • vipoffer
    Heidelberg MOF-S
    1984 Used Press
    Image6 Heidelberg MOF-S
  • vipoffer
    Heidelberg SM 74-..
    2001 Used Press
    Image7 Heidelberg SM 74-..
  • vipoffer
    Muller Martini HB..
    1971 Used Postpress
    Image8 Muller Martini HB..
 
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.