1:
2:
3:
4:
5:
6:
7:

SELECT op.name, op.uniqueitem , op.weight, b.bonusscore, b.onwhat, p.name Prerequisite
  FROM tblotherpossessions op
  left join(tblpossessionsbonuses pb, tblbonuses b)
  on op.idotherpossession=pb.idfiotherpossession and b.idbonus=pb.idfibonus
  left join (tblprerequisitesotherpossessionsbonuses popb, tblprequisites p)
  on p.idprerequisite=popb.idfiprerequisite and pb.idfibonus=popb.idfibonus and pb.idfiotherpossession=popb.idfiotherpossession;

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:

DROP TABLE IF EXISTS `dandd`.`tblotherpossessions`;
CREATE TABLE  `dandd`.`tblotherpossessions` (
  `idOtherPossession` int(11) NOT NULL auto_increment,
  `UniqueItem` bit(1) default NULL,
  `Name` varchar(20) default NULL,
  `Weight` int(11) default NULL,
  PRIMARY KEY  (`idOtherPossession`),
  UNIQUE KEY `XPKtblOtherPossessions` (`idOtherPossession`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `dandd`.`tblbonuses`;
CREATE TABLE  `dandd`.`tblbonuses` (
  `idBonus` int(11) NOT NULL auto_increment,
  `BonusScore` int(11) default NULL,
  `onWhat` char(20) default NULL,
  PRIMARY KEY  (`idBonus`),
  UNIQUE KEY `XPKtblBonuses` (`idBonus`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `dandd`.`tblpossessionsbonuses`;
CREATE TABLE  `dandd`.`tblpossessionsbonuses` (
  `idfiBonus` int(11) NOT NULL default '0',
  `idfiOtherPossession` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idfiBonus`,`idfiOtherPossession`),
  UNIQUE KEY `XPKtblPossessionsBonuses` (`idfiBonus`,`idfiOtherPossession`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `dandd`.`tblprerequisitesotherpossessionsbonuses`;
CREATE TABLE  `dandd`.`tblprerequisitesotherpossessionsbonuses` (
  `idfiPrerequisite` int(11) NOT NULL default '0',
  `idfiBonus` int(11) NOT NULL default '0',
  `idOtherPossession` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idfiPrerequisite`,`idfiBonus`,`idOtherPossession`),
  UNIQUE KEY `XPKtblPrerequisitesOtherPossessionsBonuses` (`idfiPrerequisite`,`idfiBonus`,`idOtherPossession`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;