Colors: 5
Impress.Count: 68 mio
SELECT (SELECT email FROM auth_user WHERE id = a.tpl_userid) AS mylogo, a.video1, date_format(a.user_date, '%d-%m-%Y') AS uk_date, a.video2, a.id AS mash_id, a.tpl_userid, a.name AS mash_name, d.name AS age, a.width, a.height, m.name as sizeunit, c.name as unitcol, a.impressions, a.description, a.availableafter, a.new, a.underoption, a.specialprice, a.sold, a.m_sold, a.m_soldtxt, a.m_solddate, a.hitspd, a.cat_id, b.name_en AS cat_name, a.out_shared, a.out_sharedid, n.name_en AS subcat_name, e.name AS instok, FORMAT(a.price,0) AS mash_price, a.dontshowprice, a.nocounter, h.name AS currency, x.name AS manif_name, y.name AS model_name, a.is_livefeed 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 = '10489' OR a.id = '7905' OR a.id = '1418' OR a.id = '11403' OR a.id = '11652' OR a.id = '7459' OR a.id = '11645' OR a.id = '11203' OR a.id = '11395' OR a.id = '11500' OR a.id = '11502' OR a.id = '8653' OR a.id = '11790' OR a.id = '10494' OR a.id = '11792' OR a.id = '10398' OR a.id = '9444' OR a.id = '11396' OR a.id = '7906' OR a.id = '11801' OR a.id = '8658' OR a.id = '11794' OR a.id = '11805' OR a.id = '6406' OR a.id = '11729' OR a.id = '11510' OR a.id = '10748' OR a.id = '11795' OR a.id = '11798' OR a.id = '10758' OR a.id = '11651' OR a.id = '11803' OR a.id = '11512' OR a.id = '11329' OR a.id = '8941' OR a.id = '11800' OR a.id = '11507' OR a.id = '9813' OR a.id = '11789' OR a.id = '11856' OR a.id = '8673' OR a.id = '11807' OR a.id = '11960')