Dan Langille

  SELECT DISTINCT         PA.category,         PA.name AS port,         coalesce(V.date_modified, V.date_entry, V.date_discovery) AS date,         V.vid,         to_char(coalesce(V.date_modified, V.date_entry, V.date_discovery)::date, 'Mon DD') AS date_formatted,         V.date_modified IS NULL AS new,         lower(name)    FROM commit_log_ports_vuxml CLPV, vuxml V, ports_all PA   WHERE CLPV.vuxml_id = V.id     AND CLPV.port_id  = PA.idORDER BY coalesce(V.date_modified, V.date_entry, V.date_discovery) desc, lower(name)   LIMIT 15