Kód: Vybrať všetko

id_order_history 	id_employee 	id_order 	id_order_state 	date_add

Kód: Vybrať všetko

           1	0	1	1	2010-10-02 00:05:33
 	 	 	2	0	2	3	2010-10-02 00:37:56
 	 	 	3	0	2	9	2010-10-02 00:37:56
 	 	 	4	1	2	11	2010-10-02 16:33:58
 	 	 	5	1	2	4	2010-10-02 16:34:01
 	 	 	6	1	2	9	2010-10-02 16:34:05
 	 	 	7	1	2	9	2010-10-02 16:34:07
 	 	 	8	0	3	3	2010-10-02 16:43:53
 	 	 	9	0	3	9	2010-10-02 16:43:54
 	 	 	10	1	2	4	2010-10-02 16:45:01
 	 	 	11	1	3	4	2010-10-02 16:45:07
 	 	 	12	1	1	9	2010-10-02 17:04:42
 	 	 	13	1	2	9	2010-10-02 17:04:52
 	 	 	14	1	2	6	2010-10-02 17:33:56
 	 	 	15	1	2	9	2010-10-02 17:34:04
 	 	 	16	1	2	10	2010-10-02 17:35:13
 	 	 	17	1	1	11	2010-10-02 17:35:18
 	 	 	18	1	2	9	2010-10-02 18:21:39
 	 	 	19	1	2	1	2010-10-02 18:36:15
 	 	 	20	1	1	9	2010-10-02 18:37:05

Kód: Vybrať všetko

SELECT a.id_order FROM tabulka a
WHERE a.id_order_state = 9 
AND id_order_history = max(SELECT b.id_order_history FROM tabulka b WHERE b.id_order = a.id_order) )  

Kód: Vybrať všetko

SELECT a.id_order FROM tabulka a
WHERE a.id_order_state = 9 
AND a.date_add = max(SELECT b.date_add FROM tabulka b WHERE b.id_order = a.id_order) )  

Kód: Vybrať všetko

select * from test_a where id_order_history in (
select max(id_order_history) from test_a group by id_order
) and id_order_state = 9

Kód: Vybrať všetko

SELECT * 
FROM test_a 
WHERE id_order_history IN (
   SELECT max(id_order_history) 
   FROM test_a
   WHERE id_order_state = 9 
   GROUP BY id_order)

Kód: Vybrať všetko

$i = 0;
$ii = 0;
$query = "SELECT id_order
FROM ps_order_history 
WHERE  `id_order_state` =9

	";
  $result = mysql_query($query) or die(mysql_error());
 while($row = mysql_fetch_array( $result )) { 
$pole_order[$ii]=$row['id_order'];
$ii++;
}
foreach ($pole_order as &$value) {
	$query = "SELECT id_order, `id_order_state`
FROM ps_order_history 
WHERE `id_order` = ".$value." 
ORDER BY `id_order_history` DESC LIMIT 1

	";
  $result = mysql_query($query) or die(mysql_error());
 while($row = mysql_fetch_array( $result )) { 
 $status = $row['id_order_state'];
if( $status == 9){
$orderpole[$i]=$row['id_order'];
$i++;
}


}
}