SELECT count(*) FROM phpbb_voc_cat c, phpbb_voc_rows r
LEFT JOIN phpbb_voc v ON v.cat_id = c.cat_id WHERE r.cat_id = c.cat_id AND c.cat_id = 2
ORDER BY r.row_id ASC, v.voc_id DESC

CREATE TABLE `phpbb_voc` (
  `voc_id` mediumint(8) NOT NULL default '0',
  `cat_id` mediumint(8) NOT NULL default '0',
  `voc_row` smallint(2) NOT NULL default '0',
  `voc_text` text NOT NULL,
  KEY `voc_id` (`voc_id`)
) TYPE=MyISAM;

CREATE TABLE `phpbb_voc_cat` (
  `cat_id` mediumint(8) NOT NULL default '0',
  `cat_name` varchar(80) NOT NULL default '',
  `cat_desc` text NOT NULL,
  `cat_mod` mediumint(8) NOT NULL default '0',
  `cat_auth_view` smallint(1) NOT NULL default '0',
  `cat_auth_write` smallint(1) NOT NULL default '1',
  PRIMARY KEY (`cat_id`)
) TYPE=MyISAM;

CREATE TABLE `phpbb_voc_rows` (
  `row_id` mediumint(2) NOT NULL default '0',
  `cat_id` mediumint(8) NOT NULL default '0',
  `row_width` varchar(4) NOT NULL default '0',
  `row_title` varchar(80) NOT NULL default '',
  KEY `row_id` (`row_id`)
) TYPE=MyISAM;