DROP TABLE IF EXISTS test;
CREATE  TABLE test (field_1 int(18) NOT NULL auto_increment,field_2 varchar(50) NOT NULL default '',field_3 varchar(12) default NULL,field_4 int(18) default NULL,field_5 int(18) default NULL,field_6 datetime default NULL,field_7 varchar(30) default NULL,field_8 varchar(50) default NULL,field_9 datetime default NULL,field_10 int(18) NOT NULL default '0',PRIMARY KEY  (field_1),KEY (field_4),KEY (field_2),KEY (field_3),KEY (field_7,field_1),KEY (field_5),KEY (field_6,field_10,field_9)) DEFAULT CHARSET=latin1 ENGINE = InnoDB;
INSERT INTO test VALUES (15,'0','FRL',1,0,'0000-00-00 00:00:00',NULL,'1',NULL,0),(16,'0','FRL',1,0,'0000-00-00 00:00:00',NULL,'15',NULL,0);
select field_10, field_3 from test where field_3 = 'FRL';