create a mysql query
I have problems for this query :(
demo, the change table
http://www.dailychanges.com/

my table:


CREATE TABLE `monitor_logs` (
  `id` int(11) NOT NULL auto_increment,
  `sitename` varchar(500) NOT NULL,
  `change` varchar(10) NOT NULL,
  `server` varchar(500) NOT NULL,
  `time` varchar(20) NOT NULL,
  `main_server` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5536 ;

please help :( for this query create

create a mysql query
===

I have problems for this query :(
demo, the change table
http://www.dailychanges.com/

my table:


CREATE TABLE `monitor_logs` (
  `id` int(11) NOT NULL auto_increment,
  `sitename` varchar(500) NOT NULL,
  `change` varchar(10) NOT NULL,
  `server` varchar(500) NOT NULL,
  `time` varchar(20) NOT NULL,
  `main_server` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5536 ;

please help :( for this query create
