složitý SELECT z jedné tabulky

CREATE TABLE IF NOT EXISTS `mantis_custom_field_string_table` (
  `field_id` int(3) NOT NULL default '0',
  `bug_id` int(7) NOT NULL default '0',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`field_id`,`bug_id`),
  KEY `bug_id` (`bug_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

--
-- Vypisuji data pro tabulku `mantis_custom_field_string_table`
--

INSERT INTO `mantis_custom_field_string_table` (`field_id`, `bug_id`, `value`) VALUES
(2, 1, '3'),
(8, 1, 'ANO'),
(10, 1, '600'),
(2, 3, ''),
(8, 3, 'NE'),
(10, 3, ''),
(2, 4, '1,5'),
(8, 4, 'NE'),
(10, 4, ''),
(2, 5, '0,5'),
(8, 5, 'NE'),
(10, 5, '200'),
(2, 6, '2');
(8, 6, 'NE'),
(10, 6, '800'),
(2, 7, ''),
(8, 7, 'NE'),
(10, 7, ''),
(2, 10, '2'),
(8, 10, 'NE'),
(10, 10, ''),

$query = "SELECT org.value FROM
					mantis_custom_field_string_table org
					INNER JOIN
					mantis_custom_field_string_table cpy
					ON
					cpy.bug_id = org.bug_id 
					AND cpy.field_id = 8 
					AND cpy.value = 'NE'
					WHERE org.field_id = 2";
		$soucet = 0;
		for ($t_result = db_query($query); !$t_result->EOF; $t_result->MoveNext() ) {
			$soucet += (float)str_replace(",",".",$t_result->fields['value']);
		}
		$soucet = str_replace(".",",",$soucet);
		return " <span style=\"color:red;font-family:Courier;\">[celkem -> ".$soucet ." hod]</span>";

$result = db_query($query);	
		$row = db_fetch_array($result);
		echo $row['soucet'];

case when org.field_id=2 then org.value else '' end as 'cas',
case when org.field_id=10 then org.value else '' end as 'castka'

$result = db_query($query);	
			for ($i=0;$i<db_num_rows($result); $i++)
			while ($celkem = db_fetch_array($result)){
				//echo $celkem;
				$TOTAL = $TOTAL + $celkem;
			} 
			echo $TOTAL;

$soucet = 0;
		for ($t_result = db_query($query); !$t_result->EOF; $t_result->MoveNext() ) {
			$soucet += (float)str_replace(",",".",$t_result->fields['value']);
			//echo $t_result->fields['value']."<br>";
		}//for	
		$soucet = str_replace(".",",",$soucet);
		return " <span style=\"color:red;font-family:Courier;\">[celkem -> ".$soucet ." hod]</span>";

$query = "SELECT * 
			FROM mantis_user_table 
			ORDER BY realname ASC";
$result = db_query($query);	

?><form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<select name="user_id">
<option value="0">Vše

<?php
while ($row = db_fetch_array($result)) {	
	echo '<option value = "' .$row['id']. '"' . 
    ((int) $row['id'] === (int) $_POST['user_id'] ? 'selected' : '') . '>'. 
    $row['realname'];
}?>	

</select>
<input type="submit" name="zobrazit" value="<?php echo 'Zobrazit' ?>">
</form>

-- Struktura tabulky `mantis_bug_table`
--

CREATE TABLE IF NOT EXISTS `mantis_bug_table` (
  `id` int(7) unsigned NOT NULL auto_increment,
  `project_id` int(7) unsigned NOT NULL default '0',
  `reporter_id` int(7) unsigned NOT NULL default '0',
  `handler_id` int(7) unsigned NOT NULL default '0',
  `duplicate_id` int(7) unsigned NOT NULL default '0',
  `priority` int(2) NOT NULL default '30',
  `severity` int(2) NOT NULL default '50',
  `reproducibility` int(2) NOT NULL default '10',
  `status` int(2) NOT NULL default '10',
  `resolution` int(2) NOT NULL default '10',
  `projection` int(2) NOT NULL default '10',
  `category` varchar(64) NOT NULL default '',
  `date_submitted` datetime NOT NULL default '1970-01-01 00:00:01',
  `last_updated` datetime NOT NULL default '1970-01-01 00:00:01',
  `eta` int(2) NOT NULL default '10',
  `bug_text_id` int(7) unsigned NOT NULL default '0',
  `os` varchar(32) NOT NULL default '',
  `os_build` varchar(32) NOT NULL default '',
  `platform` varchar(32) NOT NULL default '',
  `version` varchar(64) NOT NULL default '',
  `fixed_in_version` varchar(64) NOT NULL default '',
  `build` varchar(32) NOT NULL default '',
  `profile_id` int(7) unsigned NOT NULL default '0',
  `view_state` int(2) NOT NULL default '10',
  `summary` varchar(128) NOT NULL default '',
  `sponsorship_total` int(7) NOT NULL default '0',
  `sticky` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `sponsorship_total` (`sponsorship_total`),
  KEY `fixed_in_version` (`fixed_in_version`),
  KEY `status` (`status`),
  KEY `project_id` (`project_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=11 ;

--
-- Vypisuji data pro tabulku `mantis_bug_table`
--

INSERT INTO `mantis_bug_table` (`id`, `project_id`, `reporter_id`, `handler_id`, `duplicate_id`, `priority`, `severity`, `reproducibility`, `status`, `resolution`, `projection`, `category`, `date_submitted`, `last_updated`, `eta`, `bug_text_id`, `os`, `os_build`, `platform`, `version`, `fixed_in_version`, `build`, `profile_id`, `view_state`, `summary`, `sponsorship_total`, `sticky`) VALUES
(1, 6, 35, 63, 0, 30, 50, 10, 80, 20, 10, 'RS', '2008-07-02 22:27:35', '2008-08-01 13:42:41', 10, 1, '', '', '', '', '2006-A', '', 0, 10, 'Testovací projekt', 0, 0),  atd.. atd..

$query = "SELECT field_id, sum(replace(value, ',', '.')) soucet
					FROM $t_custom_field_string_table
					WHERE field_id in (2, 10) 
		 			AND bug_id in (
						SELECT bug_id
						FROM $t_custom_field_string_table, $t_bug_table
						WHERE field_id = 8 ";
						if (isset ($_POST['user_id']) AND ($_POST['user_id']) != 0) {
							$query .= " AND $t_custom_field_string_table.bug_id = $t_bug_table.id 
					  					AND $t_bug_table.handler_id = {$_POST['user_id']} ";
						}	
					$query .= " AND value = 'NE')
					GROUP BY field_id
					ORDER BY field_id";