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

Order by
Mach per page
 
 
Subscribe for this Query
 
You are here: Used Press Found 1454 Machines
Recommended machines
 
 
PD Ref: 26195 | Last updated: 24-03-2015 | Viewed: 836 times
 
 
 Age: 2007
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 4
 Impress.Count: 19 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
Dismantled - Available: Immediately
logo
 
PD Ref: 30271 | Last updated: 23-03-2015 | Viewed: 497 times
 
 
 Age: 1997
 Size: 28 x 28 inch (71 x 71 cm)
 Colors: 4
 Impress.Count: 46 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 27561 | Last updated: 15-11-2014 | Viewed: 844 times
 
 
 Age: 2006
 Size: 130 x 100 cm (51 x 39 inch)
 Colors: 8
 Impress.Count: 83 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In stock - Available: Immediately
logo
 
PD Ref: 26886 | Last updated: 18-10-2014 | Viewed: 1895 times
 
 
 Age: 1990
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 1
 Impress.Count: 21 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 30272 | Last updated: 22-03-2015 | Viewed: 275 times
 
 
 Age: 1990
 Size: 28 x 20 inch (71 x 50 cm)
 Colors: 5
 Impress.Count: 80 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 27440 | Last updated: 09-11-2014 | Viewed: 2441 times
 
 
 Age: 2000
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 41 mio
SELECT (SELECT email FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 26109 | Last updated: 14-09-2014 | Viewed: 3275 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 29835 | Last updated: 08-03-2015 | Viewed: 226 times
 
 
 Age: 2001
 Size: 66 x 48 cm (25 x 18 inch)
 Colors: 5
 Impress.Count: 122 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: 04-2015
logo
 
PD Ref: 26887 | Last updated: 18-10-2014 | Viewed: 1107 times
 
 
 Age: 1996
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 42 mio
SELECT (SELECT email FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 29171 | Last updated: 10-02-2015 | Viewed: 842 times
 
 
 Age: 1997
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 2
 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In stock - Available: Immediately
logo
 
PD Ref: 06534 | Last updated: 27-05-2012 | Viewed: 4334 times
 
 
 Age: 1990
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 26 mio
SELECT (SELECT email FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
Dismantled - Available: Immediately
logo
 
PD Ref: 24561 | Last updated: 24-03-2015 | Viewed: 649 times
 
 
 Age: 2001
 Size: 46 x 34 cm (18 x 13 inch)
 Colors: 4
 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
Dismantled - Available: Immediately
logo
 
PD Ref: 29327 | Last updated: 15-02-2015 | Viewed: 995 times
 
 
 Age: 1989
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 2
 Impress.Count: 62 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 22504 | Last updated: 09-03-2014 | Viewed: 3075 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
Dismantled - Available: Immediately
logo
 
PD Ref: 26551 | Last updated: 05-10-2014 | Viewed: 1069 times
 
 
 Age: 1979
 Size: 46 x 32 cm (18 x 12 inch)
 Colors: 2
 Impress.Count: 59 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In stock - Available: Immediately
logo
 
PD Ref: 29643 | Last updated: 28-02-2015 | Viewed: 598 times
 
 
 Age: 1998
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 4
 Impress.Count: 24 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 28510 | Last updated: 11-01-2015 | Viewed: 1846 times
 
 
 Age: 1996
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 4
 Impress.Count: 97 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
Under power - Available: Immediately
logo
 
PD Ref: 27715 | Last updated: 22-11-2014 | Viewed: 1933 times
 
 
 Age: 1995
 Size: 72 x 52 cm (28 x 20 inch)
 Colors: 4
 Impress.Count: 88 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 30295 | Last updated: 23-03-2015 | Viewed: 74 times
 
 
 Age: 1999
 Size: 72 x 52 cm (28 x 20 inch)
 Colors: 5
 Impress.Count: 10 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
Under power - Available: Immediately
logo
 
PD Ref: 25368 | Last updated: 27-07-2014 | Viewed: 2713 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In stock - Available: Immediately
logo
 
PD Ref: 29601 | Last updated: 27-02-2015 | Viewed: 453 times
 
 
 Age: 1997
 Size: 40 x 28 inch (101 x 71 cm)
 Colors: 8
 Impress.Count: 303 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 28811 | Last updated: 25-01-2015 | Viewed: 1885 times
 
 
 Age: 2007
 Size: 52 x 37 cm (20 x 14 inch)
 Colors: 4
 Impress.Count: 21 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 30354 | Last updated: 25-03-2015 | Viewed: 86 times
 
 
 Age: 1998
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 6
 Impress.Count: 160 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 28810 | Last updated: 25-01-2015 | Viewed: 518 times
 
 
 Age: 1991
 Size: 45 x 34 cm (17 x 13 inch)
 Colors: 1
 Impress.Count: 21 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 13201 | Last updated: 05-08-2013 | Viewed: 7910 times
 
 
 Age: 2006
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 12
 Impress.Count: 135 mio
SELECT (SELECT email FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 27441 | Last updated: 09-11-2014 | Viewed: 1287 times
 
 
 Age: 1986
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 1
 Impress.Count: 11 mio
SELECT (SELECT email FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a LEFT OUTER JOIN category AS b ON a.cat_id = b.id LEFT OUTER JOIN unit_colors AS c ON a.unitcolors_id = c.id LEFT OUTER JOIN yearofproduction AS d ON a.yearofprod_id = d.id LEFT OUTER JOIN currstatemachine AS e ON a.currstate_id = e.id LEFT OUTER JOIN currency AS h ON a.currency_id = h.id LEFT OUTER JOIN sizeunit AS m ON a.sizeunit_id = m.id LEFT OUTER JOIN subcategory AS n ON a.subcat_id = n.id LEFT OUTER JOIN manufacturer AS x ON a.man_id = x.id LEFT OUTER JOIN model AS y ON a.model_id = y.id WHERE a.m_pressdep = '1' AND a.out_shared = '0' AND (a.cat_id='1') AND (a.id = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 29836 | Last updated: 08-03-2015 | Viewed: 198 times
 
 
 Age: 2001
 Size: 46 x 34 cm (18 x 13 inch)
 Colors: 2
 Impress.Count: 5 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: 04-2015
logo
 
PD Ref: 30234 | Last updated: 20-03-2015 | Viewed: 110 times
 
 
 Age: 1993
 Size: 52 x 36 cm (20 x 14 inch)
 Colors: 4
 Impress.Count: 36 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 29483 | Last updated: 22-02-2015 | Viewed: 1265 times
 
 
 Age: 2007
 Size: 46 x 34 cm (18 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 = '29483' OR a.id = '13201' OR a.id = '29835' OR a.id = '29643' OR a.id = '28510' OR a.id = '28811' OR a.id = '27715' OR a.id = '6534' OR a.id = '29327' OR a.id = '26551' OR a.id = '29836' OR a.id = '27440' OR a.id = '26887' OR a.id = '26109' OR a.id = '29171' OR a.id = '26886' OR a.id = '27441' OR a.id = '25368' OR a.id = '28810' OR a.id = '22504' OR a.id = '29834' OR a.id = '27862' OR a.id = '29167' OR a.id = '26414' OR a.id = '29331' OR a.id = '29324' OR a.id = '29642' OR a.id = '27863' OR a.id = '28963' OR a.id = '27865' OR a.id = '29487' OR a.id = '29328' OR a.id = '25372' OR a.id = '29489' OR a.id = '11507' OR a.id = '22173' OR a.id = '13036' OR a.id = '29169' OR a.id = '29644' OR a.id = '28809' OR a.id = '30132' OR a.id = '22002' OR a.id = '28514' OR a.id = '28648' OR a.id = '28644' OR a.id = '8660' OR a.id = '27102' OR a.id = '28513' OR a.id = '14081' OR a.id = '1418' OR a.id = '27561' OR a.id = '28192' OR a.id = '30234' OR a.id = '30278' OR a.id = '29601' OR a.id = '30272' OR a.id = '30271' OR a.id = '26195' OR a.id = '24561' OR a.id = '30310' OR a.id = '30295' OR a.id = '30354' OR a.id = '28000') ORDER by rand()
Recommended machine
In production - Available: Immediately
logo
Used Press 12 colors
 
 
PD Ref: 13201 | Last updated: 05-08-2013 | Viewed: 7910 times
 
 
 Age: 2006
 Size: 74 x 52 cm (29 x 20 inch)
 Colors: 12
 Impress.Count: 135 mio
Recommended machine
In production - Available: Immediately
logo
 
PD Ref: 30227 | Last updated: 19-03-2015 | Viewed: 249 times
 
 
 Age: 2007
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 12
 Impress.Count: 131 mio
In production - Available: Immediately
logo
 
PD Ref: 29527 | Last updated: 24-02-2015 | Viewed: 183 times
 
 
 Age: 2004
 Size: 102 x 72 cm (40 x 28 inch)
 Colors: 12
 Impress.Count: 352 mio
 
In production - Available: 05-2015
logo
 
PD Ref: 13536 | Last updated: 04-09-2013 | Viewed: 1624 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: 2225 times
 
 
 Age: 2004
 Size: 300 x 50 cm (118 x 19 inch)
 Colors: 12
 Impress.Count: No counter
 
In production - Available: Immediately
logo
 
PD Ref: 25530 | Last updated: 03-03-2015 | Viewed: 793 times
 
 
 Age: 2005
 Size: 15000 x 50 cm (5905 x 19 inch)
 Colors: 12
 Impress.Count: 3.5 mio
 
In production - Available: Immediately
logo
 
PD Ref: 30335 | Last updated: 24-03-2015 | Viewed: 52 times
 
 
 Age: 2009
 Size: 48 x 33 cm (18 x 12 inch)
 Colors: 12
In production - Available: Immediately
logo
Used Press 10 colors
 
 
PD Ref: 27039 | Last updated: 23-10-2014 | Viewed: 612 times
 
 
 Age: 2005
 Size: 62 x 42 cm (24 x 16 inch)
 Colors: 10
 Impress.Count: 190 mio
 
In production - Available: Immediately
logo
 
PD Ref: 20674 | Last updated: 15-12-2013 | Viewed: 1397 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: 29985 | Last updated: 11-03-2015 | Viewed: 81 times
 
 
 Age: 2000
 Size: 104 x 74 cm (40 x 29 inch)
 Colors: 10
 Impress.Count: 139 mio
 
In production - Available: Immediately
logo
 
PD Ref: 28195 | Last updated: 18-12-2014 | Viewed: 597 times
 
 
 Age: 2005
 Size: 74 x 53 cm (29 x 20 inch)
 Colors: 10
 Impress.Count: 148 mio
 
In stock - Available: Immediately
logo
 
  • vipoffer
    Heidelberg GTOVP ..
    1993 Used Press
    Image1 Heidelberg GTOVP ..
  • vipoffer
    Duplo System 5000..
    2005 Used Postpress
    Image2 Duplo System 5000..
  • vipoffer
    Heidelberg SB Cyl..
    1959 Used Packaging
    Image3 Heidelberg SB Cyl..
  • vipoffer
    Komori L 528
    1990 Used Press
    Image4 Komori L 528
  • vipoffer
    Stahl T 52 4-4
    1996 Used Postpress
    Image5 Stahl T 52 4-4
  • vipoffer
    ECRM MAKO 56
    2007 Used Prepress
    Image6 ECRM MAKO 56
  • vipoffer
    Heidelberg SM 52-..
    2000 Used Press
    Image7 Heidelberg SM 52-..
  • 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.