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 (21,39,40,43,76,83,89,103,104,110,115,117,144,150,158,159,196,204,249,265,279,288,293,295,298,335,346,347,357,359,376,391,420,429,464,479,486,489,554,556,593,595,648,660,662,667,707,713,750,752,778,783,785,787,788,808) AND pl.id_lang = 1 AND cl.id_lang = 1 AND od.product_id NOT IN (13) AND i.cover = 1 AND product_shop.active = 1 AND cg.`id_group` =1 ORDER BY RAND() LIMIT 5