Дык, по аналогии

G_Z 28.11.2004 18:09

$tbl1[^table::sql{
  SELECT DISTINCT
    ref.site_id,
    ref_sites.site
  FROM
    ref_idx
  LEFT JOIN
    ref
  ON
    ref.ref_id = ref_idx.ref_id
  LEFT JOIN
    ref_sites
  ON
    ref_sites.refsite_id = ref_idx.ref_id
  WHERE
    ref_idx.count_id = <номер ресурса>
  ORDER BY 
    ref.site_id
}]