DROP TABLE IF EXISTS test;
CREATE  TABLE test (field_1 int(18) NOT NULL auto_increment,field_3 varchar(12) default NULL,field_6 int 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_3),KEY (field_7,field_1),KEY (field_6,field_10,field_9)) DEFAULT CHARSET=latin1 ENGINE = InnoDB;
INSERT INTO test VALUES (15,'FRL',0,NULL,'1',NULL,0),(16,'FRL',0,NULL,'15',NULL,0);
select field_10, field_3, field_1 from test where field_3 = 'FRL';