Original query:

SELECT * FROM channels t1
JOIN table costs t2 ON (t1.channel_id = t2.channel_id)
JOIN table promotions t3 ON (t2.promo_id = t3.promo_id);