SELECT idProduct, ImageUrl,description,user1,sku,ean, skuvarianty, skudoplnky, emise,bonuspoints,deliveringTime,idsupplier,buybackprice, price, sleva, idUp, listprice, details, popis, searchKeywords, dateAdded, isInvest, hasPersonalization, imageUrl2, imageUrl3, imageUrl4, stock, Praha, Brno, Bratislava, PRid, PRVote, PR5, PR4, PR3, PR2, PR1 FROM products LEFT JOIN stock ON stock.idproductmain = products.idProduct LEFT JOIN PublicRank ON PublicRank.PRid=products.idProduct WHERE idproduct=9414