Примерно таким образом...

Sumo 23.01.2007 13:45

    select b.id as id, b.title as title, ..., 
           m.title as marka,
           g.title as gear,
           ...
      from bulletin as b
 left join marka as m on b.marka_id = m.id
 left join gear as g on b.gear_id = g.id
 left join ...