Hi Panos:
First of all, I want to tell you that your script is really good, excellent work.
Second, I'm going to explain what I'm trying to do and may be you can suggest me something
I have only one table and the structure is:

CREATE TABLE `Autos_Qualitas_Tarifa` (
`tipo` varchar(10) NOT NULL default '',
`clave` mediumint(5) NOT NULL default '0',
`marca` varchar(20) NOT NULL default '',
`desc` varchar(90) NOT NULL default '',
`modelo` mediumint(4) NOT NULL default '0',
`vc` int(7) NOT NULL default '0',
`limitada` int(6) NOT NULL default '0',
`plus` int(6) NOT NULL default '0',
`amplia` int(6) NOT NULL default '0',
`premium` int(6) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


tipo – just tow choices AUTO,CAMION
clave – number of the car
marca – Brand
desc – Description of the car
modelo – year model
vc – value
limitada – price 1
plus – price 2
amplia – price 3
premium – price 4

Some of the data is:


INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 320, 'GENERAL MOTORS', 'CARRY ALL STD., 07 OCUP.', 1998, 55000, 3230, 4126, 4924, 6412);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 320, 'GENERAL MOTORS', 'CARRY ALL STD., 07 OCUP.', 1997, 45000, 3107, 4017, 4697, 6080);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 320, 'GENERAL MOTORS', 'CARRY ALL STD., 07 OCUP.', 1996, 33000, 2960, 0, 4425, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 320, 'GENERAL MOTORS', 'CARRY ALL STD., 07 OCUP.', 1995, 32000, 2948, 0, 4402, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 320, 'GENERAL MOTORS', 'CARRY ALL STD., 07 OCUP.', 1994, 31000, 2935, 0, 4380, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 320, 'GENERAL MOTORS', 'CARRY ALL STD., 07 OCUP.', 1993, 28000, 2898, 0, 4312, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 320, 'GENERAL MOTORS', 'CARRY ALL STD., 07 OCUP.', 1992, 26000, 2874, 0, 4266, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 7915, 'SEAT', 'LEON 1.8L STELLA C/A AC STD., 05 OCUP.', 2003, 85000, 3887, 5889, 9747, 12688);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 7915, 'SEAT', 'LEON 1.8L STELLA C/A AC STD., 05 OCUP.', 2002, 67000, 3607, 5419, 9039, 11637);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 7915, 'SEAT', 'LEON 1.8L STELLA C/A AC STD., 05 OCUP.', 2001, 65000, 3576, 5371, 8961, 11520);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 7916, 'SEAT', 'LEON 1.8L SIGNO C/A AC Q/C STD., 05 OCUP.', 2005, 122000, 4486, 7108, 11802, 15543);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 7916, 'SEAT', 'LEON 1.8L SIGNO C/A AC Q/C STD., 05 OCUP.', 2004, 105000, 4221, 6613, 11134, 14550);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 7916, 'SEAT', 'LEON 1.8L SIGNO C/A AC Q/C STD., 05 OCUP.', 2003, 94000, 4050, 6308, 10701, 13908);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 7916, 'SEAT', 'LEON 1.8L SIGNO C/A AC Q/C STD., 05 OCUP.', 2002, 68000, 3646, 5663, 9680, 12389);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 7921, 'SEAT', 'TOLEDO 1.8L SIGNO C/A AC STD., 05 OCUP.', 2002, 80000, 3742, 5490, 9034, 11613);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 7921, 'SEAT', 'TOLEDO 1.8L SIGNO C/A AC STD., 05 OCUP.', 2001, 74000, 3656, 5371, 8836, 11319);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8280, 'GENERAL MOTORS', 'PONTIAC GRAND PRIX GT AUT., 05 OCUP.', 2000, 73000, 4092, 6309, 9781, 12578);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8280, 'GENERAL MOTORS', 'PONTIAC GRAND PRIX GT AUT., 05 OCUP.', 1999, 66000, 3953, 6164, 9490, 12149);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8282, 'GENERAL MOTORS', 'PONTIAC GRAND AM GT SEDAN V/T AUT., 05 OCUP.', 1999, 63000, 3842, 5579, 8379, 10830);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8283, 'GENERAL MOTORS', 'PONTIAC GRAND AM SE SEDAN EE AUT., 05 OCUP.', 2004, 106000, 4692, 6811, 10047, 13326);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8283, 'GENERAL MOTORS', 'PONTIAC GRAND AM SE SEDAN EE AUT., 05 OCUP.', 2000, 67000, 3916, 5627, 8423, 10933);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8283, 'GENERAL MOTORS', 'PONTIAC GRAND AM SE SEDAN EE AUT., 05 OCUP.', 1999, 60000, 3776, 5445, 8131, 10504);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8284, 'GENERAL MOTORS', 'PONTIAC GRAND AM GT COUPE V/T AUT., 05 OCUP.', 2003, 90000, 4375, 6312, 9411, 12380);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8286, 'GENERAL MOTORS', 'PONTIAC GRAND AM GT SEDAN V/P AUT., 05 OCUP.', 2000, 71000, 4013, 5883, 8928, 11569);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8286, 'GENERAL MOTORS', 'PONTIAC GRAND AM GT SEDAN V/P AUT., 05 OCUP.', 1999, 65000, 3893, 5732, 8678, 11201);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8290, 'GENERAL MOTORS', 'VENTURE BASE CORTA AUT., 07 OCUP.', 2003, 105000, 3965, 5056, 7014, 9181);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8290, 'GENERAL MOTORS', 'VENTURE BASE CORTA AUT., 07 OCUP.', 2002, 97000, 3863, 4914, 6829, 8911);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8290, 'GENERAL MOTORS', 'VENTURE BASE CORTA AUT., 07 OCUP.', 2001, 90000, 3773, 4793, 6667, 8674);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8690, 'FORD', 'CONTOUR GL EQ (POWER) V6 BA AUT., 05 OCUP.', 2000, 50000, 3292, 4936, 6295, 8180);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8690, 'FORD', 'CONTOUR GL EQ (POWER) V6 BA AUT., 05 OCUP.', 1999, 43000, 3182, 4847, 6043, 7807);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8690, 'FORD', 'CONTOUR GL EQ (POWER) V6 BA AUT., 05 OCUP.', 1998, 37000, 3088, 4812, 5827, 7487);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8690, 'FORD', 'CONTOUR GL EQ (POWER) V6 BA AUT., 05 OCUP.', 1997, 33200, 3028, 0, 5690, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8690, 'FORD', 'CONTOUR GL EQ (POWER) V6 BA AUT., 05 OCUP.', 1996, 25500, 2907, 0, 5413, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8697, 'FORD', 'CONTOUR SPORT V6 BA STD., 05 OCUP.', 1998, 39000, 3115, 4714, 5800, 7479);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8699, 'FORD', 'CONTOUR SPORT V6 BA Q/C STD., 05 OCUP.', 1998, 42000, 3166, 4838, 6007, 7753);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8730, 'FORD', 'ESCORT LX EQ C/A AC AUT., 05 OCUP.', 1997, 32600, 2674, 0, 5338, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8731, 'FORD', 'ESCORT LX EQ C/A AC BA AUT., 05 OCUP.', 1999, 40000, 2727, 4344, 5634, 7280);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8731, 'FORD', 'ESCORT LX EQ C/A AC BA AUT., 05 OCUP.', 1998, 36000, 2699, 4335, 5511, 7094);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8731, 'FORD', 'ESCORT LX EQ C/A AC BA AUT., 05 OCUP.', 1997, 33700, 2683, 0, 5440, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8770, 'FORD', 'MERCURY SABLE LS V/P AUT., 05 OCUP.', 1998, 48000, 2786, 5051, 6773, 8594);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8770, 'FORD', 'MERCURY SABLE LS V/P AUT., 05 OCUP.', 1997, 42500, 2751, 5128, 6631, 8380);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8770, 'FORD', 'MERCURY SABLE LS V/P AUT., 05 OCUP.', 1996, 31100, 2677, 0, 6338, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8791, 'FORD', 'MERCURY SABLE LS CD V/P Q/C AUT., 05 OCUP.', 1996, 34500, 2709, 0, 6895, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8800, 'FORD', 'ESCORT EQ DEPORTIVO (L7A) AUT., 05 OCUP.', 1997, 32600, 2676, 0, 5429, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8810, 'FORD', 'ESCORT TIPICO DEPORTIVO AUT., 05 OCUP.', 1997, 31600, 2667, 0, 5285, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8820, 'FORD', 'ESCORT TIPICO DEPORTIVO STD., 05 OCUP.', 1997, 30400, 2657, 0, 5145, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8821, 'FORD', 'ESCORT ZX2 COUPE EQ MT STD., 05 OCUP.', 1999, 43000, 2878, 5269, 7341, 9426);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8821, 'FORD', 'ESCORT ZX2 COUPE EQ MT STD., 05 OCUP.', 1998, 40000, 2850, 5268, 7221, 9245);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8822, 'FORD', 'ESCORT ZX2 COUPE EQ AT AUT., 05 OCUP.', 1999, 45000, 2900, 5409, 7578, 9729);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8822, 'FORD', 'ESCORT ZX2 COUPE EQ AT AUT., 05 OCUP.', 1998, 42000, 2871, 5408, 7459, 9548);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8826, 'FORD', 'ESCORT ZX2 COUPE EQ AT BA Q/C CD AUT., 05 OCUP.', 1999, 51000, 2963, 5769, 8221, 10558);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8826, 'FORD', 'ESCORT ZX2 COUPE EQ AT BA Q/C CD AUT., 05 OCUP.', 1998, 46000, 2916, 5770, 8022, 10256);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8830, 'FORD', 'EXPEDITION EDDIE BAUER 4X4 AUT., 08 OCUP.', 2004, 248000, 7172, 9947, 14308, 19066);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8830, 'FORD', 'EXPEDITION EDDIE BAUER 4X4 AUT., 08 OCUP.', 2003, 205000, 6423, 8906, 13032, 17208);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8830, 'FORD', 'EXPEDITION EDDIE BAUER 4X4 AUT., 08 OCUP.', 2002, 160000, 5639, 7877, 11697, 15264);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8870, 'FORD', 'EXPEDITION XLT PLUS V/T V8 4.6L AUT., 09 OCUP.', 1998, 90000, 4395, 6189, 8946, 11477);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8870, 'FORD', 'EXPEDITION XLT PLUS V/T V8 4.6L AUT., 09 OCUP.', 1997, 86800, 4340, 6139, 8851, 11339);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 8880, 'FORD', 'EXPEDITION XLT V/T V8 4.6L AUT., 09 OCUP.', 1997, 84000, 4270, 5933, 8498, 10908);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9471, 'CHRYSLER', 'CIRRUS CONVERTIBLE TURBO L4 AUT., 05 OCUP.', 2001, 91000, 4249, 7320, 10497, 13640);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9471, 'CHRYSLER', 'CIRRUS CONVERTIBLE TURBO L4 AUT., 05 OCUP.', 2000, 75000, 3961, 7046, 9847, 12678);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9471, 'CHRYSLER', 'CIRRUS CONVERTIBLE TURBO L4 AUT., 05 OCUP.', 1999, 63000, 3746, 6941, 9359, 11957);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9471, 'CHRYSLER', 'CIRRUS CONVERTIBLE TURBO L4 AUT., 05 OCUP.', 1998, 57000, 3638, 6940, 9115, 11596);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9472, 'CHRYSLER', 'CIRRUS LXI C/A AC V/T L4 TBO AUT., 05 OCUP.', 2006, 135000, 4982, 7911, 11008, 14813);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9472, 'CHRYSLER', 'CIRRUS LXI C/A AC V/T L4 TBO AUT., 05 OCUP.', 2005, 122000, 4748, 7493, 10480, 14032);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9472, 'CHRYSLER', 'CIRRUS LXI C/A AC V/T L4 TBO AUT., 05 OCUP.', 2004, 106000, 4461, 6996, 9830, 13070);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9472, 'CHRYSLER', 'CIRRUS LXI C/A AC V/T L4 TBO AUT., 05 OCUP.', 2003, 91000, 4191, 6555, 9220, 12168);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9472, 'CHRYSLER', 'CIRRUS LXI C/A AC V/T L4 TBO AUT., 05 OCUP.', 2002, 80000, 3994, 6256, 8773, 11507);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9472, 'CHRYSLER', 'CIRRUS LXI C/A AC V/T L4 TBO AUT., 05 OCUP.', 2001, 70000, 3814, 6011, 8367, 10906);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9472, 'CHRYSLER', 'CIRRUS LXI C/A AC V/T L4 TBO AUT., 05 OCUP.', 2000, 52000, 3490, 5682, 7635, 9824);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9472, 'CHRYSLER', 'CIRRUS LXI C/A AC V/T L4 TBO AUT., 05 OCUP.', 1999, 48000, 3418, 5642, 7473, 9583);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9473, 'CHRYSLER', 'CIRRUS LXI C/A AC V/T L4 TBO BA AUT., 05 OCUP.', 2006, 142000, 5116, 8199, 11463, 15431);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9473, 'CHRYSLER', 'CIRRUS LXI C/A AC V/T L4 TBO BA AUT., 05 OCUP.', 2005, 127000, 4846, 7718, 10853, 14529);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9476, 'CHRYSLER', 'CIRRUS LXI C/A AC V/P L4 TBO BA AUT., 05 OCUP.', 2001, 76000, 3929, 6258, 8781, 11463);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9476, 'CHRYSLER', 'CIRRUS LXI C/A AC V/P L4 TBO BA AUT., 05 OCUP.', 2000, 58000, 3606, 5904, 8049, 10381);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9476, 'CHRYSLER', 'CIRRUS LXI C/A AC V/P L4 TBO BA AUT., 05 OCUP.', 1999, 53000, 3516, 5841, 7846, 10080);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9485, 'CHRYSLER', 'PT CRUISER CLASSIC EDITION C/A AC STD., 05 OCUP.', 2001, 69000, 4012, 5685, 8176, 10603);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9486, 'CHRYSLER', 'PT CRUISER CLASSIC EDITION C/A AC AUT., 05 OCUP.', 2007, 139000, 5451, 7890, 11051, 14781);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9486, 'CHRYSLER', 'PT CRUISER CLASSIC EDITION C/A AC AUT., 05 OCUP.', 2006, 115000, 4960, 7106, 10107, 13396);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9486, 'CHRYSLER', 'PT CRUISER CLASSIC EDITION C/A AC AUT., 05 OCUP.', 2005, 100000, 4653, 6634, 9516, 12530);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9514, 'CHRYSLER', 'NEON RT C/A AC BA STD., 05 OCUP.', 1998, 37000, 2734, 4982, 6931, 8729);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9515, 'CHRYSLER', 'NEON SRT-4 C/A AC BA VE RA Q/C STD., 05 OCUP.', 2005, 153000, 3562, 7045, 11646, 15398);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9515, 'CHRYSLER', 'NEON SRT-4 C/A AC BA VE RA Q/C STD., 05 OCUP.', 2004, 119000, 3326, 6405, 10645, 13884);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9516, 'CHRYSLER', 'NEON SXT C/A AC AUT., 05 OCUP.', 2005, 94000, 3114, 5565, 8586, 11378);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9538, 'CHRYSLER', 'JEEP WRANGLER "X" TECHO DURO AUT., 04 OCUP.', 2003, 137000, 4722, 6579, 9601, 12699);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9538, 'CHRYSLER', 'JEEP WRANGLER "X" TECHO DURO AUT., 04 OCUP.', 2002, 118000, 4423, 6126, 9022, 11849);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9539, 'CHRYSLER', 'JEEP WRANGLER RUBICON AUT., 04 OCUP.', 2007, 315000, 7601, 11382, 16301, 22125);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9670, 'BMW', '525I FORMULA 1 AUT., 05 OCUP.', 2006, 413000, 7009, 11572, 19165, 25426);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9670, 'BMW', '525I FORMULA 1 AUT., 05 OCUP.', 2003, 250000, 5337, 8924, 15507, 20024);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9670, 'BMW', '525I FORMULA 1 AUT., 05 OCUP.', 2002, 211000, 4937, 8408, 14632, 18731);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9670, 'BMW', '525I FORMULA 1 AUT., 05 OCUP.', 2001, 195000, 4773, 8225, 14273, 18201);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9673, 'BMW', 'X5 VAGONETA V8 FORMULA 1 AUT., 05 OCUP.', 2003, 371000, 9206, 13246, 21030, 27446);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9673, 'BMW', 'X5 VAGONETA V8 FORMULA 1 AUT., 05 OCUP.', 2002, 336000, 8638, 12536, 20105, 26103);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9674, 'BMW', 'MINI COOPER SALT V/T STD., 04 OCUP.', 2007, 214000, 6627, 10059, 14912, 20115);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9674, 'BMW', 'MINI COOPER SALT V/T STD., 04 OCUP.', 2006, 163000, 5672, 8454, 12963, 17247);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9674, 'BMW', 'MINI COOPER SALT V/T STD., 04 OCUP.', 2005, 137000, 5185, 7663, 11969, 15785);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9674, 'BMW', 'MINI COOPER SALT V/T STD., 04 OCUP.', 2004, 127000, 4998, 7367, 11587, 15223);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9674, 'BMW', 'MINI COOPER SALT V/T STD., 04 OCUP.', 2003, 120000, 4867, 7164, 11320, 14829);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9676, 'BMW', 'MINI COOPER CHILI V/P Q/C STD., 04 OCUP.', 2004, 140000, 5266, 7883, 12548, 16488);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9676, 'BMW', 'MINI COOPER CHILI V/P Q/C STD., 04 OCUP.', 2003, 132000, 5117, 7651, 12242, 16038);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9676, 'BMW', 'MINI COOPER CHILI V/P Q/C STD., 04 OCUP.', 2002, 130000, 5079, 7594, 12165, 15925);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9679, 'BMW', 'MINI COOPER "S" CHILI 6VEL V/T Q/C STD., 04 OCUP.', 2005, 179000, 6043, 9278, 14894, 19666);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9679, 'BMW', 'MINI COOPER "S" CHILI 6VEL V/T Q/C STD., 04 OCUP.', 2004, 165000, 5781, 8864, 14359, 18879);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9679, 'BMW', 'MINI COOPER "S" CHILI 6VEL V/T Q/C STD., 04 OCUP.', 2003, 158000, 5650, 8661, 14091, 18486);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9679, 'BMW', 'MINI COOPER "S" CHILI 6VEL V/T Q/C STD., 04 OCUP.', 2002, 148000, 5463, 8375, 13709, 17923);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9680, 'BMW', 'MINI COOPER "S" CHILI 6VEL V/P Q/C STD., 04 OCUP.', 2006, 213000, 6680, 10313, 16193, 21578);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9683, 'BMW', 'MINI COOPER LAUNCH EDITION V/P STD., 04 OCUP.', 2002, 127000, 5023, 7508, 12051, 15757);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9685, 'BMW', 'Z4 CONVERTIBLE 2.5L STD., 02 OCUP.', 2007, 498000, 12184, 20167, 31433, 42602);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9685, 'BMW', 'Z4 CONVERTIBLE 2.5L STD., 02 OCUP.', 2006, 356000, 9525, 15714, 26006, 34617);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9685, 'BMW', 'Z4 CONVERTIBLE 2.5L STD., 02 OCUP.', 2005, 312000, 8701, 14386, 24325, 32142);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9685, 'BMW', 'Z4 CONVERTIBLE 2.5L STD., 02 OCUP.', 2004, 281000, 8120, 13476, 23140, 30399);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9689, 'BMW', 'M3 CABRIOLET STD., 02 OCUP.', 2006, 632000, 15085, 25953, 43758, 58432);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9689, 'BMW', 'M3 CABRIOLET STD., 02 OCUP.', 2005, 584000, 14186, 24487, 41924, 55733);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9689, 'BMW', 'M3 CABRIOLET STD., 02 OCUP.', 2004, 499000, 12595, 21954, 38676, 50953);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9689, 'BMW', 'M3 CABRIOLET STD., 02 OCUP.', 2003, 440000, 11490, 20264, 36421, 47635);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9766, 'HONDA', 'CIVIC L4 EX SEDAN ABS Q/C STD., 05 OCUP.', 2003, 103000, 3064, 4424, 7081, 9173);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9766, 'HONDA', 'CIVIC L4 EX SEDAN ABS Q/C STD., 05 OCUP.', 2002, 86000, 2969, 4233, 6765, 8698);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9766, 'HONDA', 'CIVIC L4 EX SEDAN ABS Q/C STD., 05 OCUP.', 2001, 79000, 2929, 4164, 6634, 8502);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9767, 'HONDA', 'FIT L4 LX STD., 05 OCUP.', 2007, 127000, 3178, 4551, 6668, 8849);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9767, 'HONDA', 'FIT L4 LX STD., 05 OCUP.', 2006, 106000, 3059, 4255, 6277, 8263);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9767, 'HONDA', 'FIT L4 LX STD., 05 OCUP.', 2005, 96000, 3003, 4119, 6091, 7983);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9770, 'HONDA', 'ACCORD V6 EX-R SEDAN V/P ABS CD Q/C AUT., 05 OCUP.', 2002, 104000, 3114, 4746, 7449, 9654);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9770, 'HONDA', 'ACCORD V6 EX-R SEDAN V/P ABS CD Q/C AUT., 05 OCUP.', 2001, 95000, 3060, 4649, 7269, 9384);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9770, 'HONDA', 'ACCORD V6 EX-R SEDAN V/P ABS CD Q/C AUT., 05 OCUP.', 2000, 84000, 2994, 4545, 7049, 9054);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9774, 'HONDA', 'FIT L4 LX AUT., 05 OCUP.', 2007, 140000, 3256, 4770, 7105, 9439);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9776, 'HONDA', 'FIT L4 EX AUT., 05 OCUP.', 2007, 154000, 3340, 5003, 7561, 10056);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9776, 'HONDA', 'FIT L4 EX AUT., 05 OCUP.', 2006, 129000, 3199, 4651, 7096, 9357);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9777, 'HONDA', 'ACURA RDX AUT., 05 OCUP.', 2007, 434000, 8741, 11917, 17904, 23779);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9780, 'HONDA', 'ACCORD V6 EX-R COUPE V/P ABS CD Q/C AUT., 05 OCUP.', 2002, 107000, 3134, 4799, 7558, 9801);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9780, 'HONDA', 'ACCORD V6 EX-R COUPE V/P ABS CD Q/C AUT., 05 OCUP.', 2001, 99000, 3086, 4711, 7398, 9561);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9780, 'HONDA', 'ACCORD V6 EX-R COUPE V/P ABS CD Q/C AUT., 05 OCUP.', 1998, 73000, 2929, 4492, 6879, 8781);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9921, 'MERCEDES BENZ', 'SL-55 AMG AUT., 02 OCUP.', 2007, 1765000, 37309, 65601, 105530, 143416);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9921, 'MERCEDES BENZ', 'SL-55 AMG AUT., 02 OCUP.', 2006, 1277000, 28170, 50285, 86881, 115974);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9921, 'MERCEDES BENZ', 'SL-55 AMG AUT., 02 OCUP.', 2005, 1107000, 24986, 45148, 80385, 106414);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9921, 'MERCEDES BENZ', 'SL-55 AMG AUT., 02 OCUP.', 2004, 898000, 21071, 39106, 72399, 94661);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9921, 'MERCEDES BENZ', 'SL-55 AMG AUT., 02 OCUP.', 2003, 661000, 16633, 32966, 63342, 81334);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9921, 'MERCEDES BENZ', 'SL-55 AMG AUT., 02 OCUP.', 2002, 561000, 14760, 30821, 59521, 75711);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9922, 'MERCEDES BENZ', 'E-350 ELEGANCE AUT., 05 OCUP.', 2007, 656000, 9522, 16078, 25076, 34008);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9922, 'MERCEDES BENZ', 'E-350 ELEGANCE AUT., 05 OCUP.', 2006, 480000, 7718, 12869, 21126, 28174);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9923, 'MERCEDES BENZ', 'CLS-500 AUT., 04 OCUP.', 2007, 932000, 20865, 35807, 56901, 77246);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9923, 'MERCEDES BENZ', 'CLS-500 AUT., 04 OCUP.', 2006, 664000, 15846, 27404, 46660, 62175);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9923, 'MERCEDES BENZ', 'CLS-500 AUT., 04 OCUP.', 2005, 611000, 14853, 25798, 44635, 59194);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9924, 'MERCEDES BENZ', 'E-350 SPORT AUT., 05 OCUP.', 2007, 652000, 9479, 15993, 24933, 33814);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9924, 'MERCEDES BENZ', 'E-350 SPORT AUT., 05 OCUP.', 2006, 491000, 7828, 13052, 21320, 28478);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9925, 'MERCEDES BENZ', 'SLK 55 AMG AUT., 02 OCUP.', 2007, 938000, 20910, 35945, 57164, 77611);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('AUTO', 9925, 'MERCEDES BENZ', 'SLK 55 AMG AUT., 02 OCUP.', 2006, 677000, 16021, 27755, 47190, 62934);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50350, 'CHRYSLER', 'RAM 1500 PICK-UP RUNNER AUT., 02 OCUP.', 1996, 33300, 3231, 0, 6315, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50350, 'CHRYSLER', 'RAM 1500 PICK-UP RUNNER AUT., 02 OCUP.', 1995, 30600, 3199, 0, 6229, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50350, 'CHRYSLER', 'RAM 1500 PICK-UP RUNNER AUT., 02 OCUP.', 1994, 29600, 3187, 0, 6197, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50360, 'CHRYSLER', 'RAM 1500 PICK-UP RUNNER C/A AC AUT., 02 OCUP.', 1998, 52000, 3461, 4603, 7068, 8967);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50360, 'CHRYSLER', 'RAM 1500 PICK-UP RUNNER C/A AC AUT., 02 OCUP.', 1997, 44000, 3365, 0, 6814, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50360, 'CHRYSLER', 'RAM 1500 PICK-UP RUNNER C/A AC AUT., 02 OCUP.', 1996, 34900, 3255, 0, 6525, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50360, 'CHRYSLER', 'RAM 1500 PICK-UP RUNNER C/A AC AUT., 02 OCUP.', 1995, 32100, 3222, 0, 6436, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50370, 'CHRYSLER', 'RAM 2500 PICK-UP LUJO C/A AC EE AUT., 02 OCUP.', 1998, 51000, 3453, 4630, 7180, 9096);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50370, 'CHRYSLER', 'RAM 2500 PICK-UP LUJO C/A AC EE AUT., 02 OCUP.', 1997, 48000, 3417, 4576, 7084, 8964);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50370, 'CHRYSLER', 'RAM 2500 PICK-UP LUJO C/A AC EE AUT., 02 OCUP.', 1996, 35800, 3270, 0, 6697, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50370, 'CHRYSLER', 'RAM 2500 PICK-UP LUJO C/A AC EE AUT., 02 OCUP.', 1995, 32300, 3228, 0, 6586, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50370, 'CHRYSLER', 'RAM 2500 PICK-UP LUJO C/A AC EE AUT., 02 OCUP.', 1994, 28100, 3178, 0, 6453, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50380, 'CHRYSLER', 'RAM 2500 PICK-UP RUNNER AUT., 02 OCUP.', 1998, 48000, 3416, 4559, 7036, 8906);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50380, 'CHRYSLER', 'RAM 2500 PICK-UP RUNNER AUT., 02 OCUP.', 1997, 46000, 3391, 4524, 6973, 8819);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50380, 'CHRYSLER', 'RAM 2500 PICK-UP RUNNER AUT., 02 OCUP.', 1996, 33600, 3243, 0, 6580, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50380, 'CHRYSLER', 'RAM 2500 PICK-UP RUNNER AUT., 02 OCUP.', 1995, 29600, 3195, 0, 6453, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50380, 'CHRYSLER', 'RAM 2500 PICK-UP RUNNER AUT., 02 OCUP.', 1994, 29000, 3187, 0, 6434, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50390, 'CHRYSLER', 'RAM 2500 PICK-UP CLUB CAB LTD LARAMIE AUT., 05 OCUP.', 1998, 67000, 3745, 5114, 8018, 10204);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50390, 'CHRYSLER', 'RAM 2500 PICK-UP CLUB CAB LTD LARAMIE AUT., 05 OCUP.', 1997, 55000, 3600, 4875, 7638, 9678);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 50390, 'CHRYSLER', 'RAM 2500 PICK-UP CLUB CAB LTD LARAMIE AUT., 05 OCUP.', 1996, 41500, 3438, 0, 7209, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53211, 'FORD', 'F-250 PICK-UP XLT LOBO AUT., 02 OCUP.', 1995, 32800, 3301, 0, 7099, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53211, 'FORD', 'F-250 PICK-UP XLT LOBO AUT., 02 OCUP.', 1994, 31700, 3285, 0, 7058, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53211, 'FORD', 'F-250 PICK-UP XLT LOBO AUT., 02 OCUP.', 1993, 31000, 3276, 0, 7032, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53211, 'FORD', 'F-250 PICK-UP XLT LOBO AUT., 02 OCUP.', 1992, 30500, 3269, 0, 7014, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53211, 'FORD', 'F-250 PICK-UP XLT LOBO AUT., 02 OCUP.', 1991, 30000, 3262, 0, 6995, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53220, 'FORD', 'F-250 PICK-UP XLT C/A AC STD., 02 OCUP.', 1995, 32800, 3301, 0, 7099, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53220, 'FORD', 'F-250 PICK-UP XLT C/A AC STD., 02 OCUP.', 1988, 25400, 3198, 0, 6824, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53220, 'FORD', 'F-250 PICK-UP XLT C/A AC STD., 02 OCUP.', 1987, 23900, 3178, 0, 6768, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 2007, 198000, 5590, 9234, 13487, 17730);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 2003, 107000, 4333, 6521, 10099, 13040);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 2002, 92000, 4126, 6101, 9541, 12266);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 2001, 79000, 3946, 5753, 9057, 11596);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 2000, 71000, 3835, 5549, 8759, 11184);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 1999, 65000, 3753, 5404, 8536, 10874);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 1998, 60000, 3684, 5290, 8350, 10617);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 1997, 46000, 3490, 5019, 7829, 9895);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 1996, 35700, 3348, 0, 7445, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 1995, 33400, 3316, 0, 7360, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 1994, 31600, 3291, 0, 7293, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 53221, 'FORD', 'F-250 PICK-UP XLT C/A AC AUT., 02 OCUP.', 1993, 30900, 3281, 0, 7267, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54260, 'GENERAL MOTORS', 'SIERRA "A" 4X2 CREW CAB Q/C V/P AUT., 05 OCUP.', 2007, 369000, 9292, 14762, 22557, 29398);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54270, 'GENERAL MOTORS', 'MAXI-CAB CUSTOM V6 STD., 05 OCUP. MAXI-CAB CUSTOM V6', 1993, 25600, 3194, 0, 6170, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54270, 'GENERAL MOTORS', ' STD., 05 OCUP.', 1992, 24600, 3183, 0, 6141, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54270, 'GENERAL MOTORS', ' STD., 05 OCUP.', 1991, 23900, 3176, 0, 6120, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54270, 'GENERAL MOTORS', ' STD., 05 OCUP.', 1990, 23000, 3166, 0, 6094, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54280, 'GENERAL MOTORS', 'MAXI-CAB TIPICA V6 STD., 05 OCUP.', 1993, 27900, 3220, 0, 6272, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54280, 'GENERAL MOTORS', 'MAXI-CAB TIPICA V6 STD., 05 OCUP.', 1992, 25900, 3198, 0, 6214, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54280, 'GENERAL MOTORS', 'MAXI-CAB TIPICA V6 STD., 05 OCUP.', 1991, 24800, 3187, 0, 6182, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54280, 'GENERAL MOTORS', 'MAXI-CAB TIPICA V6 STD., 05 OCUP.', 1990, 23900, 3177, 0, 6156, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54330, 'GENERAL MOTORS', 'AVALANCHE LS 4X2 V/T AUT., 05 OCUP.', 2003, 188000, 6960, 9523, 15388, 19568);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54330, 'GENERAL MOTORS', 'AVALANCHE LS 4X2 V/T AUT., 05 OCUP.', 2002, 149000, 6182, 8455, 14044, 17758);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54331, 'GENERAL MOTORS', 'AVALANCHE LT 4X4 V/P Q/C AUT., 05 OCUP.', 2007, 418000, 11644, 16563, 24874, 32098);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54341, 'GENERAL MOTORS', 'CADILLAC ESCALADE EXT "Q" 4X4 Q/C AUT., 05 OCUP.', 2003, 270000, 8970, 13389, 24453, 30822);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54341, 'GENERAL MOTORS', 'CADILLAC ESCALADE EXT "Q" 4X4 Q/C AUT., 05 OCUP.', 2002, 224400, 8060, 12282, 22880, 28706);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54350, 'GENERAL MOTORS', 'TORNADO PICK-UP STD., 02 OCUP.', 2007, 92000, 3788, 5149, 7281, 9417);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 54353, 'GENERAL MOTORS', 'TORNADO PICK-UP C/A AC EE STD., 02 OCUP.', 2006, 98000, 3869, 5373, 8056, 10380);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 15300, 'HONDA', 'RIDGELINE AUT., 05 OCUP.', 2007, 386000, 8946, 13160, 21156, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 55301, 'HONDA', 'RIDGELINE AUT., 05 OCUP.', 2006, 333000, 8093, 11836, 19598, 25170);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 15205, 'ISUZU', 'ELF 400 ESTACAS "G" STD., 02 OCUP.', 2007, 351000, 8217, 13158, 19359, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 15205, 'ISUZU', 'ELF 400 ESTACAS "G" STD., 02 OCUP.', 2006, 305000, 7624, 11989, 17947, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 15211, 'ISUZU', 'ELF 450 ESTACAS "T" STD., 02 OCUP.', 2007, 410000, 9008, 14781, 22035, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 16105, 'MERCEDES BENZ', 'SPRINTER 316 CARGO VAN M903661 STD., 02 OCUP.', 2006, 259000, 8357, 10755, 15752, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 16105, 'MERCEDES BENZ', 'SPRINTER 316 CARGO VAN M903661 STD., 02 OCUP.', 2005, 208000, 7385, 9442, 14229, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 16110, 'MERCEDES BENZ', 'SPRINTER 416 CARGO VAN M904662 STD., 02 OCUP.', 2006, 289000, 8961, 11634, 17196, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 16110, 'MERCEDES BENZ', 'SPRINTER 416 CARGO VAN M904662 STD., 02 OCUP.', 2005, 234000, 7912, 10217, 15553, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 16122, 'MERCEDES BENZ', 'SPRINTER 415 CARGO VAN CDI LWB EXTRA LGA TA STD., 02 OCUP.', 2007, 428000, 11665, 15440, 22275, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11010, 'NISSAN', 'PICK-UP 3/4TON STD., 02 OCUP.', 1998, 38000, 4329, 0, 7150, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11050, 'NISSAN', 'CAMIONETA VAN STD., 02 OCUP.', 1987, 21400, 3897, 0, 6586, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11060, 'NISSAN', 'ICHI VAN PANEL STD., 02 OCUP.', 1998, 44000, 4503, 0, 7592, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11060, 'NISSAN', 'ICHI VAN PANEL STD., 02 OCUP.', 1997, 38000, 4342, 0, 7325, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11060, 'NISSAN', 'ICHI VAN PANEL STD., 02 OCUP.', 1987, 21400, 3897, 0, 6586, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11061, 'NISSAN', 'URVAN DX CORTA STD., 02 OCUP.', 2006, 158000, 7652, 9954, 13886, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11064, 'NISSAN', 'URVAN LARGA TOLDO ALTO 4P STD., 02 OCUP.', 2005, 143000, 7283, 9468, 13672, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11070, 'NISSAN', 'PICK-UP CORTA TIPICO STD., 02 OCUP.', 2000, 48000, 4598, 5501, 7595, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11113, 'NISSAN', 'PICK-UP DOBLE CABINA TIPICO DH STD., 05 OCUP.', 2001, 67000, 5200, 6349, 8889, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11113, 'NISSAN', 'PICK-UP DOBLE CABINA TIPICO DH STD., 05 OCUP.', 2000, 57000, 4932, 5994, 8444, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11120, 'NISSAN', 'PICK-UP DOBLE CABINA TIPICO AUT., 05 OCUP. PICK-UP DOBLE CABINA TIPICO', 2003, 85000, 5678, 6999, 9620, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11120, 'NISSAN', ' AUT., 05 OCUP.', 2002, 78000, 5490, 6736, 9309, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11120, 'NISSAN', ' AUT., 05 OCUP.', 2001, 68000, 5222, 6367, 8864, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11120, 'NISSAN', ' AUT., 05 OCUP.', 2000, 60000, 5007, 6078, 8508, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11120, 'NISSAN', ' AUT., 05 OCUP.', 1999, 56000, 4900, 5938, 8330, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 11121, 'NISSAN', 'PICK-UP DOBLE CABINA TIPICO DH AUT., 05 OCUP.', 2003, 87000, 5736, 7086, 9761, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17500, 'TOYOTA', 'HILUX "B" PICK-UP STD., 02 OCUP.', 2006, 122000, 4965, 6336, 9182, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17501, 'TOYOTA', 'HILUX "B" PICK-UP C/A AC STD., 02 OCUP.', 2005, 106000, 4741, 5999, 8907, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17503, 'TOYOTA', 'HILUX "D" PICK-UP DOBLE CABINA CONFORT STD., 05 OCUP.', 2005, 122000, 5058, 6552, 10162, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17505, 'TOYOTA', 'HIACE PANEL LARGA 5P STD., 02 OCUP.', 2007, 199000, 6099, 8029, 11698, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17505, 'TOYOTA', 'HIACE PANEL LARGA 5P STD., 02 OCUP.', 2006, 176000, 5771, 7518, 11097, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17506, 'TOYOTA', 'HIACE PANEL SUPER LARGA 5P STD., 02 OCUP.', 2005, 155000, 5489, 7150, 11083, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17507, 'TOYOTA', 'TACOMA TRD DOBLE CABINA AUT., 05 OCUP.', 2007, 274000, 7280, 10272, 15953, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17508, 'TOYOTA', 'TACOMA SR5 DOBLE CABINA AUT., 05 OCUP.', 2006, 212000, 6386, 8806, 14009, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17509, 'TOYOTA', 'HIACE PANEL LARGA C/VENTANA 4P STD., 02 OCUP.', 2007, 200000, 6114, 8053, 11739, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17511, 'TOYOTA', 'TUNDRA CABINA REGULAR DX V6 AUT., 02 OCUP.', 2007, 232000, 6590, 9123, 13931, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17512, 'TOYOTA', 'TUNDRA CABINA REGULAR DX V8 AUT., 02 OCUP.', 2007, 264000, 7066, 9948, 15413, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 17514, 'TOYOTA', 'TUNDRA CABINA REGULAR SR5 4X4 V8 AUT., 02 OCUP.', 2007, 291000, 7468, 10645, 16673, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 57500, 'TOYOTA', 'HILUX "B" PICK-UP STD., 02 OCUP.', 2006, 122000, 4676, 6048, 8894, 11391);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 57502, 'TOYOTA', 'HILUX "D" PICK-UP DOBLE CABINA STD., 05 OCUP.', 2006, 141000, 5067, 6650, 9924, 12719);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 57502, 'TOYOTA', 'HILUX "D" PICK-UP DOBLE CABINA STD., 05 OCUP.', 2005, 111000, 4616, 5947, 9074, 11567);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18030, 'VOLKSWAGEN', 'POINTER PICK-UP STD., 02 OCUP.', 2002, 45000, 3888, 0, 7208, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18050, 'VOLKSWAGEN', 'POINTER PICK-UP C/A AC EE STD., 02 OCUP.', 2004, 68000, 4246, 5653, 8524, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18061, 'VOLKSWAGEN', 'EUROVAN PANEL T4 BANCA CORRIDA STD., 02 OCUP.', 2003, 115000, 8719, 10114, 12699, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18061, 'VOLKSWAGEN', 'EUROVAN PANEL T4 BANCA CORRIDA STD., 02 OCUP.', 2002, 106000, 8313, 9628, 12166, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18061, 'VOLKSWAGEN', 'EUROVAN PANEL T4 BANCA CORRIDA STD., 02 OCUP.', 2001, 97000, 7908, 9145, 11634, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18062, 'VOLKSWAGEN', 'EUROVAN CARGA L5 DIESEL STD., 02 OCUP.', 2007, 230000, 14042, 16637, 20470, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18065, 'VOLKSWAGEN', 'EUROVAN CARGA L5 DIESEL BANCA DOBLE C/A AC STD., 02 OCUP.', 2007, 246000, 14800, 17576, 21673, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18065, 'VOLKSWAGEN', 'EUROVAN CARGA L5 DIESEL BANCA DOBLE C/A AC STD., 02 OCUP.', 2006, 205000, 12952, 15329, 19247, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18070, 'VOLKSWAGEN', 'VAN STD., 02 OCUP.', 2007, 109000, 4302, 5914, 8434, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18070, 'VOLKSWAGEN', 'VAN STD., 02 OCUP.', 2006, 90000, 4110, 5483, 7892, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18070, 'VOLKSWAGEN', 'VAN STD., 02 OCUP.', 2005, 80000, 4009, 5260, 7607, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18072, 'VOLKSWAGEN', 'VAN C/A AC STD., 02 OCUP.', 2007, 119000, 4409, 6170, 8931, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18072, 'VOLKSWAGEN', 'VAN C/A AC STD., 02 OCUP.', 2003, 71000, 3924, 5104, 7562, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18073, 'VOLKSWAGEN', 'VAN C/VENT TRAS C/A AC STD., 02 OCUP.', 2007, 119000, 4409, 6170, 8931, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 18073, 'VOLKSWAGEN', 'VAN C/VENT TRAS C/A AC STD., 02 OCUP.', 2003, 71000, 3924, 5104, 7562, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 58030, 'VOLKSWAGEN', 'POINTER PICK-UP STD., 02 OCUP.', 2007, 94000, 4313, 6060, 8767, 11353);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 58030, 'VOLKSWAGEN', 'POINTER PICK-UP STD., 02 OCUP.', 2004, 54000, 3684, 4824, 7213, 9211);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 58030, 'VOLKSWAGEN', 'POINTER PICK-UP STD., 02 OCUP.', 2003, 51000, 3637, 4737, 7096, 9050);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 58030, 'VOLKSWAGEN', 'POINTER PICK-UP STD., 02 OCUP.', 2002, 45000, 3542, 0, 6863, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 58051, 'VOLKSWAGEN', 'POINTER PICK-UP C/A AC EE STD., 02 OCUP.', 2000, 44000, 3542, 0, 7265, 0);
INSERT INTO `Autos_Qualitas_Tarifa` VALUES ('CAMION', 58052, 'VOLKSWAGEN', 'POINTER PICK-UP C/A AC EE STD., 02 OCUP.', 1999, 38000, 3448, 0, 7032, 0);


Actually I have 14,300 records in this table. The idea is to show the 4 different prices form one specific car or truck initiating form the type (tipo-AUTO, CAMION), the next box suppose to show all the different years available, then the Brand, and finally all the descriptions of all the models, form one brand, form one year.

My problem is that I don't have any key to link the data
I tried to do something but it doesn’t work, and you can see it at [www.proaseguros.com]
Can you suggest me some thing?

Thank for your attention

Good morning Mau,

Sorry for the delay to respond but been busy last week.
Will do my best to get a solution for you.

Best regards



Edited 1 time(s). Last edit at 11/26/2007 04:03AM by panos.

Finaly today i got some time to give some thought on your problem.

you have 14000 records eh?

hard one, i think you realy need to refactor the whole application.
do you have a form or something that users enter their cars or you
imported those from some file?

what i can think of is:

have table with tipo, just 2 rows
tipo_id - tipo
1 camion
2 auto

have table with marca
marca_id - tipo_id - marca
1 1 bmw
2 2 bmw
...

a table with models

model_id - tipo_id - marca_id - model
1 1 1 316i AUTO
2 1 1 316i A/C
....

and finaly the table with auto details

auto_id - tipo_id - marca_id - model_id - clave – modelo - vc – limitada – plus – amplia – premium

with that structure queries are a bit more complex but you can build selections with them.

If you have form for users to enter their car information then you are in trouble
You have either to use select boxes and some autocomplete components and check
if new value not already in table add it, like new car model or marca.

in order to move data in new tables you need some code to do it.

Maybe i say maybe some solution could be made with views in mysql 5 but i cant say 100% that can be done.

Sorry again for the delayed response.

panos

Hi Panos:
Thanks for your help; actually I tried before to split the tables, something similar that you are suggesting me.
I was trying to find a different way to do it easier, because I have to update seven different tables with the same quantity of records every month.
Thanks again to take your time helping me.
Regards
Mau

Hi,
maybe you make the spliting script little automated so after updating "mother" table to call it and move things around.

Regards
Panos