SELECT `promotions`.*
FROM `promotions`
    INNER JOIN `orders_promotions` ON `promotions`.`id` = `orders_promotions`.`promotion_id`
WHERE `orders_promotions`.`order_id` = 3
WHERE `promotions`.`code` = 'blablabla'