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 (23,31,41,42,43,47,60,72,78,80,101,151,177,180,215,229,231,278,323,388,402,405,415,419,437,456,468,470,475,545,561,564,566,583,585,597,603,612,613,615,654,671,672,690,700,712,723,733,768,783,789,816,829,859,878,882,884,908,956,957,980,1004,1034,1088,1091,1105,1107,1114,1167,1170,1179,1216,1222,1237,1271,1289,1302,1311,1314,1404,1417,1420,1470,1490,1491,1494,1501,1508,1515,1516,1531) AND pl.id_lang = 1 AND cl.id_lang = 1 AND od.product_id NOT IN (2) AND i.cover = 1 AND product_shop.active = 1 AND cg.`id_group` =1 ORDER BY RAND() LIMIT 5