lcr mysql table structure:

CREATE TABLE `lcr` (

`id` INT(11) NOT NULL AUTO_INCREMENT,

`digits` VARCHAR(15) DEFAULT NULL,

`rate` FLOAT(11,5) DEFAULT NULL,

`intrastate_rate` FLOAT(11,5) DEFAULT NULL,

`intralata_rate` FLOAT(11,5) DEFAULT NULL,

`carrier_id` INT(11) NOT NULL,

`lead_strip` INT(11) NOT NULL,

`trail_strip` INT(11) NOT NULL,

`prefix` VARCHAR(16) NOT NULL,

`suffix` VARCHAR(16) NOT NULL,

`lcr_profile` VARCHAR(32) DEFAULT NULL,

`date_start` DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00',

`date_end` DATETIME NOT NULL DEFAULT '2030-12-31 00:00:00',

`quality` FLOAT(10,6) NOT NULL,

`reliability` FLOAT(10,6) NOT NULL,

`cid` VARCHAR(32) NOT NULL DEFAULT '',

`enabled` TINYINT(1) NOT NULL DEFAULT '1',

PRIMARY KEY (`id`),

KEY `carrier_id` (`carrier_id`),

KEY `digits` (`digits`),

KEY `lcr_profile` (`lcr_profile`),

KEY `digits_profile_cid_rate` USING BTREE (`digits`),

CONSTRAINT `carrier_id` FOREIGN KEY (`carrier_id`) REFERENCES `carriers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=INNODB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1

lcr_admin show profiles

Name: default

custom sql: SELECT l.digits, c.carrier_name, l.${lcr_rate_field}, cg.prefix AS gw_prefix, cg.suffix AS gw_suffix, l.lead_strip, l.trail_strip, l.prefix, l.suffix , cg.codec , l.cid FROM lcr l JOIN carriers c ON l.carrier_id=c.id JOIN carrier_gateway cg ON c.id=cg.carrier_id WHERE c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1' AND digits IN (${lcr_query_expanded_digits}) AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end ORDER BY digits DESC, ${lcr_rate_field}, quality DESC, reliability DESC, rand();

has %: false

has vars: true

has intrastate: true

has intralata: true

has npanxx: true

Reorder rate: enabled

Info in headers: disabled

Quote IN() List: disabled

lcr 617642 default returns rate from the rate field table and not intra/inter state fields rates.

Any ideas? thanks!