Miscellany

SELECT i.*, si.*
FROM swaps s
INNER JOIN items i ON (s.swap_item_id=i.item_id)
INNER JOIN swap_fors sf ON (s.swap_id=sf.swap_for_swap_id)
INNER JOIN items si ON (sf.swap_for_item_id=si.item_id)
WHERE s.swap_id=1