SELECT DISTINCT od.product_id, pl.name, pl.description_short, pl.link_rewrite, p.reference, i.id_image, product_shop.show_price, cl.link_rewrite category, p.ean13, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity FROM ps_order_detail od LEFT JOIN ps_product p ON (p.id_product = od.product_id) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN ps_product_lang pl ON (pl.id_product = od.product_id AND pl.id_shop = 1 ) LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 ) LEFT JOIN ps_image i ON (i.id_product = od.product_id) LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = product_shop.id_category_default AND cp.id_product = product_shop.id_product) LEFT JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category`) WHERE od.id_order IN (58,223,237,247,290,291,307,313,314,341,351,360,384,421,435,501,515,519,540,605,637,698,715,742,759) AND pl.id_lang = 1 AND cl.id_lang = 1 AND od.product_id NOT IN (5) AND i.cover = 1 AND product_shop.active = 1 AND cg.`id_group` =1 ORDER BY RAND() LIMIT 5