(SELECT 1 as Class_ID, Message_ID, LastUpdated FROM Message1 ORDER BY LastUpdated DESC LIMIT 3)

UNION

(SELECT 2 as Class_ID, Message_ID, LastUpdated FROM Message2 ORDER BY LastUpdated DESC LIMIT 3)

UNION

(SELECT 3 as Class_ID, Message_ID, LastUpdated FROM Message3 ORDER BY LastUpdated DESC LIMIT 3)

ORDER BY LastUpdated DESC LIMIT 3

";

$goods_types = $shop->GuessGoodsTypeIDs();

$num_goods = 4;

$qry = array();



foreach ($goods_types as $goods_type) {

  $qry[] = "(SELECT $goods_type as Class_ID, Message_ID, Name

              FROM Message$goods_type

             ORDER BY LastUpdated DESC LIMIT $num_goods)";

}



$qry = join("nUNIONn", $qry) . "nORDER BY LastUpdated DESC LIMIT $num_goods";



echo listQuery($qry, '<a href='".nc_message_link($data[Message_ID], $data[Class_ID])."'>$data[Name]</a><br>');



echo "