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