Used Press Sheetfed offset

 Age: 2001

 Size: 102 x 72 cm (40 x 28 inch)

 Colors: 4

 Impress.Count: 119 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 1992

 Size: 102 x 72 cm (40 x 28 inch)

 Colors: 2

 Impress.Count: 116 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 1999

 Size: 1020 x 720 cm (401 x 283 inch)

 Colors: 5

 Impress.Count: 231 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 2015

 Size: 75 x 53 cm (29 x 20 inch)

 Colors: 4

 Impress.Count: 35 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 2006

 Size: 103 x 73 cm (40 x 28 inch)

 Colors: 5

 Impress.Count: 83 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 2007

 Size: 105 x 75 cm (41 x 29 inch)

 Colors: 5

 Impress.Count: 221 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 1986

 Size: 102 x 72 cm (40 x 28 inch)

 Colors: 1

 Impress.Count: 21 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 2004

 Size: 52 x 36 cm (20 x 14 inch)

 Colors: 2

 Impress.Count: 86 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 2005

 Size: 52 x 36 cm (20 x 14 inch)

 Colors: 4

 Impress.Count: 60 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 1996

 Size: 52 x 36 cm (20 x 14 inch)

 Colors: 2

 Impress.Count: 34 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 2007

 Size: 105 x 72 cm (41 x 28 inch)

 Colors: 4

 Impress.Count: 166 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 2004

 Size: 52 x 36 cm (20 x 14 inch)

 Colors: 1

 Impress.Count: 27 mio

SELECT (SELECT id FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed, DATE_FORMAT(a.a_begin,'%d %b %Y %h:%i %p') AS a_begin_uk, DATE_FORMAT(a.a_inspection,'%d %b %Y %h:%i %p') AS a_inspection_uk, DATE_FORMAT(a.a_end,'%d %b %Y %h:%i %p') AS a_end_uk FROM machines AS a USE INDEX (mpresdep_outshared) 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.subcat_id='51') AND (a.id = '45639' OR a.id = '1418' OR a.id = '50062' OR a.id = '49104' OR a.id = '50008' OR a.id = '46469' OR a.id = '46596' OR a.id = '48063' OR a.id = '48643' OR a.id = '46474' OR a.id = '45887' OR a.id = '47712' OR a.id = '49761' OR a.id = '49602' OR a.id = '49899' OR a.id = '49105' OR a.id = '49599' OR a.id = '48265' OR a.id = '48572' OR a.id = '48931' OR a.id = '46473' OR a.id = '49758' OR a.id = '47663' OR a.id = '49618' OR a.id = '49106' OR a.id = '49673' OR a.id = '49682' OR a.id = '48650') ORDER by rand()

 Age: 1987

 Size: 74 x 52 cm (29 x 20 inch)

 Colors: 2

 Impress.Count: No counter

 Age: 2008

 Size: 74 x 52 cm (29 x 20 inch)

 Colors: 4

 Impress.Count: 39 mio

 Age: 1981

 Size: 52 x 36 cm (20 x 14 inch)

 Colors: 2

 Impress.Count: 95 mio

 Age: 2007

 Size: 74 x 53 cm (29 x 20 inch)

 Colors: 5

 Impress.Count: 90 mio

 Age: 2012

 Size: 52 x 37 cm (20 x 14 inch)

 Colors: 2

 Impress.Count: 2 mio

 Age: 2007

 Size: 105 x 75 cm (41 x 29 inch)

 Colors: 5

 Impress.Count: 221 mio

 Age: 1981

 Size: 65 x 48 cm (25 x 18 inch)

 Colors: 2

 Impress.Count: No counter

 Age: 1978

 Size: 65 x 48 cm (25 x 18 inch)

 Colors: 2

 Impress.Count: No counter

 Age: 1977

 Size: 65 x 48 cm (25 x 18 inch)

 Colors: 2

 Impress.Count: No counter

 Age: 2000

 Size: 102 x 72 cm (40 x 28 inch)

 Colors: 6

 Impress.Count: 193 mio

 Age: 2005

 Size: 72 x 52 cm (28 x 20 inch)

 Colors: 5

 Impress.Count: 174 mio