MAP
  NAME "distributori_carburante"
  SIZE 400 400
  IMAGECOLOR 255 255 255

  PROJECTION
    "init=epsg:4326"
  END
  EXTENT 11.14764256 43.72871798 11.35072204 43.84176395
  UNITS dd

  SYMBOL
    NAME "circle"
    TYPE ELLIPSE
    POINTS
      1 1
    END
    FILLED true
  END

  LAYER
    NAME "distributori_carburante"
    STATUS DEFAULT
    TYPE POINT
    CONNECTIONTYPE postgis
    CONNECTION "user=dbuser password=MySecret dbname=dbname host=127.0.0.1"
    DATA "the_geom from (SELECT * FROM table) as foo using unique table_pk using SRID=3003"
    PROJECTION
      "+init=epsg:3003 +towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68"
    END

    CLASS
      NAME 'distributori_carburante'
      STYLE
        SYMBOL 'CIRCLE'
        SIZE 6
        OUTLINECOLOR 0 0 0
        COLOR 189 164 91
      END
    END
  END

END