INSERT´S.sql

INSERT INTO `rubro` (`rubro_id`, `rubro_desc`) VALUES
(1,'Alimentos y Bebidas'),
(2,'Animales y Mascotas'),
(3,'Antigüedades'),
(4,'Arte y Artesanías'),
(5,'Bebés'),
(6,'Belleza y Cuidado Personal'),
(7,'Cámaras y Accesorios'),
(8,'Celulares y Teléfonos'),
(9,'Coleccionables y Hobbies'),
(10,'Computación'),
(11,'Consolas y Videojuegos'),
(12,'Deportes y Fitness'),
(13,'Electrodomésticos y Aires Ac.'),
(14,'Electrónica, Audio y Video'),
(15,'Entradas para Eventos'),
(16,'Herramientas y Construcción'),
(17,'Hogar, Muebles y Jardín'),
(18,'Industrias y Oficinas'),
(19,'Instrumentos Musicales'),
(20,'Joyas y Relojes');

INSERT INTO `articulo`(`art_id`, `art_desc`, `rubro_id`, `art_prec_compra`,`art_prec_vta`, `art_stock`, `art_stock_min`) VALUES 
(1, 'Taza', '15', '25,57', '28,127', '155', '30'),
(2, 'Licor yerba mate "Elixcor"', '13', '77,84', '85,624', '197', '30'),
(3, 'Licor yerba mate caja', '20', '72,19', '79,409', '283', '30'),
(4, 'Azúcar sin refinar', '18', '85,74', '94,314', '272', '30'),
(5, 'Azucar refinada', '16', '68,98', '75,878', '3', '30'),
(6, 'Licor mandarina (petaca)', '15', '92,99', '102,289', '76', '30'),
(7, 'Licor jabuticaba (petaca)', '4', '91,61', '100,771', '219', '30'),
(8, 'Mate cuero', '15', '57,85', '63,635', '91', '30'),
(9, 'Termo de cuero', '5', '53,76', '59,136', '966', '30'),
(10, 'Mate forrado cuero', '2', '50,8', '55,88', '780', '30'),
(11, 'Porta termo cuero', '20', '38,14', '41,954', '340', '30'),
(12, 'Llavero misiones', '2', '94,51', '103,961', '943', '30'),
(13, 'Mate porongo', '10', '28,17', '30,987', '996', '30'),
(14, 'Llavero', '4', '71,56', '78,716', '864', '30'),
(15, 'Taza sublimada', '2', '77,87', '85,657', '882', '30'),
(16, 'Mer. maracuya x 360gs', '5', '80,86', '88,946', '185', '30'),
(17, 'Mer. maracuya x 190gs', '9', '17,17', '18,887', '660', '30'),
(18, 'Mer. tomate x 360gs', '20', '50,62', '55,682', '972', '30'),
(19, 'Mer. tomate x 190gs', '6', '62,32', '68,552', '497', '30'),
(20, 'Mer. tomate x 360gs', '15', '62,89', '69,179', '455', '30'),
(21, 'Mer. rosella x 250gs', '17', '97,40', '107,14', '241', '30'),
(22, 'Mermelada de naranja (190g)', '9', '41,21', '45,331', '801', '30'),
(23, 'Mer. mandarina x 360gs', '15', '36,98', '40,678', '536', '30'),
(24, 'Mer. mandarina x 190gs', '15', '37,82', '41,602', '936', '30'),
(25, 'Mer. mamon x 360gs', '13', '34,79', '38,269', '523', '30'),
(26, 'Mer. mamon x 190gs', '8', '2,65', '2,915', '859', '30'),
(27, 'Mamon alm. x 360gs', '13', '65,60', '72,16', '72', '30'),
(28, 'Mamon alm. x 800gs', '11', '7,45', '8,195', '135', '30'),
(29, 'Bandeja de regalo x 2', '11', '40,31', '44,341', '57', '30'),
(30, 'Bandeja de regalo x 3', '20', '29,95', '32,945', '81', '30'),
(31, 'Quinoto en alm x 360gs', '8', '84,42', '92,862', '412', '30'),
(32, 'Quinoto en alm x 190gs', '20', '10,27', '11,297', '582', '30'),
(33, 'Quinoto en alm x 800gs', '10', '24,29', '26,719', '77', '30'),
(34, 'Muñeco tejido', '5', '78,79', '86,669', '104', '30'),
(35, 'Muñeco para pintar', '4', '14,65', '16,115', '802', '30'),
(36, 'Mate c/ base', '7', '60,84', '66,924', '339', '30'),
(37, 'Porta celular', '8', '65,68', '72,248', '31', '30'),
(38, 'Posa fuente', '4', '79,64', '87,604', '413', '30'),
(39, 'Llavero tucan', '5', '94,32', '103,752', '857', '30'),
(40, 'Monedero', '12', '95,65', '105,215', '740', '30'),
(41, 'Guirnalda', '4', '50,20', '55,22', '820', '30'),
(42, 'Llavero jacinto', '15', '69,16', '76,076', '615', '30'),
(43, 'Llavero corazon', '16', '46,99', '51,689', '16', '30'),
(44, 'Tic Tac', '11', '76,30', '83,93', '637', '30'),
(45, 'Gomitas', '3', '67,40', '74,14', '463', '30'),
(46, 'Llavero crochet', '7', '7,17', '7,887', '825', '30'),
(47, 'Llavero pac', '11', '11,58', '12,738', '984', '30'),
(48, 'Galletitas chicas', '14', '90,46', '99,506', '260', '30'),
(49, 'Galletitas grandes', '2', '64,24', '70,664', '870', '30'),
(50, 'Rosquitos', '12', '20,49', '22,539', '525', '30'),
(51, 'Pepona', '4', '21,80', '23,98', '693', '30'),
(52, 'Elefante', '11', '34,58', '38,038', '947', '30'),
(53, 'Cuello', '11', '89,58', '98,538', '819', '30'),
(54, 'Cuello grande', '18', '84,74', '93,214', '267', '30'),
(55, 'Osito', '19', '86,29', '94,919', '753', '30'),
(56, 'Conejo', '7', '58,3', '64,13', '183', '30'),
(57, 'Hipopotamo', '14', '84,47', '92,917', '19', '30'),
(58, 'Tortuga', '5', '93,19', '102,509', '295', '30'),
(59, 'Pesebre x 4 unidades', '13', '35,1', '38,61', '812', '30'),
(60, 'Pesebre red- cuad', '17', '50,50', '55,55', '779', '30'),
(61, 'Mini pesebre', '14', '90,35', '99,385', '354', '30'),
(62, 'Porta Lapices', '3', '69,63', '76,593', '490', '30'),
(63, 'Llav.jac, tierra y yerba', '3', '29,59', '32,549', '461', '30'),
(64, 'Tronco c/ frasco', '9', '79,56', '87,516', '611', '30'),
(65, 'Florero palmera', '17', '41,94', '46,134', '33', '30'),
(66, 'sobre palmera chico', '19', '27,7', '30,47', '42', '30'),
(67, 'Porta llaves chico', '2', '84,25', '92,675', '552', '30'),
(68, 'Porta termo cuerina', '1', '62,8', '69,08', '967', '30'),
(69, 'Porta llaves chicvato', '11', '47,55', '52,305', '347', '30'),
(70, 'Termolar forrado', '16', '12,74', '14,014', '905', '30'),
(71, 'Pesebre pomelo', '6', '10,29', '11,319', '890', '30'),
(72, 'Pesebre palta-pomelo', '3', '89,13', '98,043', '475', '30'),
(73, 'Vaso tere', '15', '70,25', '77,275', '234', '30'),
(74, 'Cuenco cer. c/canasto', '2', '75,98', '83,578', '415', '30'),
(75, 'Souvenir yerba', '10', '88,75', '97,625', '251', '30'),
(76, 'Souvenir tierra', '18', '61,5', '67,65', '549', '30'),
(77, 'Souvenir te', '5', '87,31', '96,041', '602', '30'),
(78, 'Stevia hoja', '14', '5,90', '6,49', '377', '30'),
(79, 'Mate cocido c/stevia', '14', '98,68', '108,548', '600', '30'),
(80, 'Te verde c/stevia', '8', '61,94', '68,134', '489', '30'),
(81, 'Stevia molida', '18', '51,2', '56,32', '665', '30'),
(82, 'Reloj pajaro', '10', '84,82', '93,302', '608', '30'),
(83, 'Anotador en madera (16,5 x 26,5)', '1', '81,13', '89,243', '215', '30'),
(84, 'Anotador en madera (12 x 17)', '7', '90,9', '99,99', '675', '30'),
(85, 'Anotador en madera (9 x 13)', '17', '56,32', '61,952', '165', '30'),
(86, 'Anotador en madera chico', '11', '55,91', '61,501', '152', '30'),
(87, 'Caja posavasos', '18', '11,57', '12,727', '95', '30'),
(88, 'Caja Wisky', '15', '91,97', '101,167', '803', '30'),
(89, 'Caja de te x 2', '17', '3,33', '3,663', '390', '30'),
(90, 'Caja naipes truco', '20', '27,36', '30,096', '328', '30'),
(91, 'Juego escritorio', '14', '45,74', '50,314', '743', '30'),
(92, 'Ordenador de escritorio', '3', '19,10', '21,01', '702', '30'),
(93, 'Reloj iconografia misiones', '19', '61,17', '67,287', '407', '30'),
(94, 'Caja saumerio', '12', '4,54', '4,994', '393', '30'),
(95, 'Caja te sin cierre', '11', '84,33', '92,763', '859', '30'),
(96, 'Caja te con cierre', '16', '88,76', '97,636', '134', '30'),
(97, 'Zapallo en alm. x 480gs', '1', '94,61', '104,071', '724', '30'),
(98, 'Berenjenas x 480gs', '3', '83,6', '91,96', '809', '30'),
(99, 'Pickle x 480gs', '20', '46,18', '50,798', '991', '30'),
(100, 'Pepino x 480gs', '10', '72,40', '79,64', '853', '30'),
(101, 'Higo en alm. x 480gs', '5', '37,17', '40,887', '923', '30'),
(102, 'Guayaba en alm x 480gs', '16', '17,6', '19,36', '18', '30'),
(103, 'Mamon en alm. x 480gs', '6', '37,49', '41,239', '508', '30'),
(104, 'Naranja en alm x 480gs', '20', '78,4', '86,24', '375', '30'),
(105, 'Quinoto en alm x 480gs', '18', '37,30', '41,03', '463', '30'),
(106, 'Zapallo en alm x 820gs', '6', '64,80', '71,28', '217', '30'),
(107, 'Mer. guayaba x 250gs', '20', '86,80', '95,48', '519', '30'),
(108, 'Mer. mamon x 250gs', '10', '76,64', '84,304', '108', '30'),
(109, 'Mer. naranja x 250gs', '9', '37,43', '41,173', '907', '30'),
(110, 'Mer. naranja x 45gs', '11', '25,7', '28,27', '792', '30'),
(111, 'Mer. mamon x 45gs', '4', '39,33', '43,263', '522', '30'),
(112, 'Mer. rosella x 45gs', '17', '75,44', '82,984', '976', '30'),
(113, 'Caja empresarial', '10', '48,62', '53,482', '389', '30'),
(114, 'Dulce cajita x 2', '1', '97,9', '107,69', '993', '30'),
(115, 'Cuadro Selva Misionera', '18', '95,55', '105,105', '651', '30'),
(116, 'Adorno CD reciclado', '17', '40,86', '44,946', '193', '30'),
(117, 'Pipper', '18', '34,28', '37,708', '930', '30'),
(118, 'Cañon azul noche', '5', '75,72', '83,292', '905', '30'),
(119, 'Guitarra con posador', '8', '36,30', '39,93', '323', '30'),
(120, 'Cañon azul noche', '2', '78,52', '86,372', '594', '30'),
(121, 'Bombardas', '16', '23,10', '25,41', '620', '30'),
(122, 'Avion dagger', '16', '44,25', '48,675', '15', '30'),
(123, 'Moto pistera', '18', '18,50', '20,35', '17', '30'),
(124, 'Moto grande azul', '15', '96,82', '106,502', '837', '30'),
(125, 'Daguer fuerza aerea', '8', '88,4', '97,24', '307', '30'),
(126, 'Garronero', '7', '37,42', '41,162', '462', '30'),
(127, 'Charly Garcia', '6', '94,29', '103,719', '666', '30'),
(128, 'Quijote', '12', '93,66', '103,026', '795', '30'),
(129, 'Llavero tortuga grande', '7', '44,61', '49,071', '596', '30'),
(130, 'Llavero tortuga chica', '11', '88,65', '97,515', '601', '30'),
(131, 'Quijote chico', '1', '61,71', '67,881', '855', '30'),
(132, 'Quijote mediano', '4', '61,77', '67,947', '684', '30'),
(133, 'Quijote Grande', '16', '24,90', '27,39', '470', '30'),
(134, 'Llavero vitro', '20', '71,79', '78,969', '611', '30'),
(135, 'Porta saumerio', '8', '40,15', '44,165', '597', '30'),
(136, 'Anillo', '7', '1,86', '2,046', '832', '30'),
(137, 'Aros chicos', '18', '16,25', '17,875', '756', '30'),
(138, 'Aros grandes', '19', '36,99', '40,689', '750', '30'),
(139, 'Collar cadena grande', '5', '34,53', '37,983', '990', '30'),
(140, 'Collar cadena chica', '18', '88,19', '97,009', '486', '30'),
(141, 'Collar hilo', '2', '18,58', '20,438', '23', '30'),
(142, 'Collar vs piedras', '10', '48,45', '53,295', '268', '30'),
(143, 'Collar vs', '4', '32,91', '36,201', '454', '30'),
(144, 'Pañuelos DC- MIK', '18', '5,26', '5,786', '744', '30'),
(145, 'Pañ. tinte natural caja', '7', '7,14', '7,854', '204', '30'),
(146, 'Pañuelo Edicion Especial', '9', '15,16', '16,676', '151', '30'),
(147, 'Remera Posadas', '18', '68,21', '75,031', '551', '30'),
(148, 'Remera Arboles', '3', '34,4', '37,84', '504', '30'),
(149, 'Tucan', '15', '75,58', '83,138', '407', '30'),
(150, 'Coati', '20', '81,78', '89,958', '628', '30'),
(151, 'Oso hormiguero', '9', '88,63', '97,493', '655', '30'),
(152, 'Oso hormiguero1', '13', '36,95', '40,645', '330', '30'),
(153, 'Mariposa', '12', '28,10', '30,91', '918', '30'),
(154, 'Móvil “Güembé”', '15', '52,18', '57,398', '815', '30'),
(155, 'Pesebre calabaza', '5', '8,63', '9,493', '819', '30'),
(156, 'Pesebre calabacita', '15', '48,71', '53,581', '237', '30'),
(157, 'Pajarito con alas', '10', '75,55', '83,105', '354', '30'),
(158, 'Lechuza marron', '7', '5,89', '6,479', '945', '30'),
(159, 'Hoja guaembe + bocha', '3', '51,73', '56,903', '264', '30'),
(160, 'Bandeja oso hormiguero', '6', '6,59', '7,249', '734', '30'),
(161, 'Bandeja mono', '20', '98,78', '108,658', '304', '30'),
(162, 'Bandeja mariposa(2)', '20', '81,37', '89,507', '418', '30'),
(163, 'Pesebre vasija', '18', '22,56', '24,816', '823', '30'),
(164, 'Pesebre palta', '20', '67,74', '74,514', '877', '30'),
(165, 'Pesebre cascara', '18', '95,10', '104,61', '547', '30'),
(166, 'Lechuza02', '15', '18,37', '20,207', '258', '30'),
(167, 'Lechuza05', '6', '47,46', '52,206', '566', '30'),
(168, 'Lechuza06', '13', '21,55', '23,705', '696', '30'),
(169, 'Lechuza 07', '13', '56,57', '62,227', '133', '30'),
(170, 'Mariposa01', '12', '98,54', '108,394', '664', '30'),
(171, 'Mariposa02', '7', '56,45', '62,095', '521', '30'),
(172, 'Porta llaves 01', '11', '66,77', '73,447', '156', '30'),
(173, 'Mermelada de ananá y romero', '20', '37,84', '41,624', '171', '30'),
(174, 'Mermelada de rosella', '11', '79,43', '87,373', '46', '30'),
(175, 'Chut mango sem vainilla', '18', '12,63', '13,893', '147', '30'),
(176, 'Chut mang tomates', '5', '13,89', '15,279', '691', '30'),
(177, 'Chut mang dat', '1', '26,53', '29,183', '184', '30'),
(178, 'Chut mang especias', '8', '76,99', '84,689', '279', '30'),
(179, 'Hot mango chutney', '15', '44,2', '48,62', '704', '30'),
(180, 'Mango chut haw.', '10', '1,53', '1,683', '437', '30'),
(181, 'plantilla fieltro', '5', '35,63', '39,193', '273', '30'),
(182, 'Manopla', '14', '8,78', '9,658', '9', '30'),
(183, 'Mono lana', '16', '54,80', '60,28', '209', '30'),
(184, 'Movil lana', '9', '37,37', '41,107', '533', '30'),
(185, 'Prendedor lana', '6', '51,3', '56,43', '122', '30'),
(186, 'Móvil "Loro"', '1', '93,68', '103,048', '437', '30'),
(187, 'Tucan lana', '11', '34,93', '38,423', '979', '30'),
(188, 'Pompones', '10', '45,74', '50,314', '241', '30'),
(189, 'Hoja 5', '13', '9,33', '10,263', '117', '30'),
(190, 'Cuenco', '4', '32,19', '35,409', '426', '30'),
(191, 'Base x 3 cuencos', '1', '88,75', '97,625', '120', '30'),
(192, 'Base x 2 cuencos', '4', '51,5', '56,65', '163', '30'),
(193, 'Llavero tierra', '3', '51,97', '57,167', '426', '30'),
(194, 'Collar tierra', '17', '55,63', '61,193', '731', '30'),
(195, 'Cuenco rojo pequeño', '2', '10,44', '11,484', '437', '30'),
(196, 'Hoja chica', '9', '6,24', '6,864', '569', '30'),
(197, 'Muñeca vellon', '18', '80,49', '88,539', '945', '30'),
(198, 'Escarapela de vellón', '16', '5,40', '5,94', '810', '30'),
(199, 'Cuencos', '3', '69,62', '76,582', '419', '30'),
(200, 'Cuenco', '9', '74,46', '81,906', '668', '30'),
(201, 'Plato Ojo de yacare', '19', '60,66', '66,726', '413', '30'),
(202, 'Taza', '19', '99,62', '109,582', '1', '30'),
(203, 'Taza chop', '18', '3,66', '4,026', '875', '30'),
(204, 'Botella roja', '8', '72,66', '79,926', '687', '30'),
(205, 'Botella roja (otra)', '9', '95,79', '105,369', '839', '30'),
(206, 'Dije', '8', '60,30', '66,33', '799', '30'),
(207, 'Collar', '18', '92,30', '101,53', '788', '30'),
(208, 'Collar Mboyere', '20', '87,32', '96,052', '800', '30'),
(209, 'Azucarero natural', '8', '60,75', '66,825', '655', '30'),
(210, 'Plato pintado', '14', '18,66', '20,526', '597', '30'),
(211, 'Hoja G. verde', '4', '35,97', '39,567', '696', '30'),
(212, 'Cipsela', '4', '25,51', '28,061', '248', '30'),
(213, 'Ysyry', '11', '89,15', '98,065', '585', '30'),
(214, 'Canasto', '12', '81,9', '90,09', '517', '30'),
(215, 'Movil triple', '20', '57,76', '63,536', '708', '30'),
(216, 'Dije azul', '5', '25,19', '27,709', '498', '30'),
(217, 'Dije con trama textil', '2', '11,89', '13,079', '350', '30'),
(218, 'Colgante cuero detras', '12', '34,83', '38,313', '933', '30'),
(219, 'Pote de yerba', '3', '28,71', '31,581', '823', '30'),
(220, 'Caja de te', '12', '17,53', '19,283', '912', '30'),
(221, 'Camion encastre', '14', '2,80', '3,08', '737', '30'),
(222, 'Tatu de arrastre', '3', '16,1', '17,71', '826', '30'),
(223, 'Kit Selva', '20', '1,65', '1,815', '801', '30'),
(224, 'Rompecabeza Tucan', '3', '66,59', '73,249', '199', '30'),
(225, 'Huevo de cod. c/mostaza', '6', '44,86', '49,346', '433', '30'),
(226, 'Huevo de cod. c/provenzal', '2', '26,45', '29,095', '391', '30'),
(227, 'Huevo de cod. c/zan.', '2', '72,97', '80,267', '270', '30'),
(228, 'Set asado', '12', '1,59', '1,749', '855', '30'),
(229, 'Porta termo con bordado', '9', '33,86', '37,246', '306', '30'),
(230, 'Porta termo', '13', '49,93', '54,923', '218', '30'),
(231, 'Termo bordado', '7', '51,6', '56,76', '84', '30'),
(232, 'Vaso terere', '10', '43,53', '47,883', '949', '30'),
(233, 'Termos forrados', '7', '74,43', '81,873', '493', '30'),
(234, 'Mate forrado c/bombilla', '17', '80,57', '88,627', '914', '30'),
(235, 'Escarapela vitrofusion', '15', '53,48', '58,828', '216', '30'),
(236, 'Llavero vitrofusion', '7', '72,60', '79,86', '802', '30'),
(237, 'Plato vitro chico', '14', '90,2', '99,22', '720', '30'),
(238, 'Plato vitro mediano', '1', '21,76', '23,936', '263', '30'),
(239, 'Movil vitro x 3 piezas', '1', '55,41', '60,951', '639', '30'),
(240, 'Anillo en vitrofusion', '11', '92,47', '101,717', '597', '30'),
(241, 'Aros en vitrofusion', '3', '35,21', '38,731', '787', '30'),
(242, 'Collar en vitrof. chico', '4', '12,53', '13,783', '876', '30'),
(243, 'Collar en vitrof. mediano', '7', '54,60', '60,06', '695', '30'),
(244, 'Te verde con stevia', '4', '36,7', '40,37', '493', '30'),
(245, 'Te negro con stevia', '14', '70,49', '77,539', '34', '30'),
(246, 'Manzanilla con stevia', '11', '57,58', '63,338', '848', '30'),
(247, 'Matecocido con stevia', '7', '75,7', '83,27', '429', '30'),
(248, 'Hierbas con stevia', '14', '42,1', '46,31', '555', '30'),
(249, 'Boina', '17', '60,23', '66,253', '910', '30'),
(250, 'Gorra lana', '17', '85,75', '94,325', '56', '30'),
(251, 'Yacare lana', '13', '4,2', '4,62', '279', '30'),
(252, 'Llaveros', '2', '26,36', '28,996', '709', '30'),
(253, 'Iman lana', '3', '70,39', '77,429', '499', '30'),
(254, 'Vincha mariposa', '4', '38,81', '42,691', '659', '30'),
(255, 'Pie de cama', '14', '78,71', '86,581', '236', '30'),
(256, 'Coati lana', '10', '12,97', '14,267', '950', '30'),
(257, 'Posa fuente', '1', '50,97', '56,067', '901', '30'),
(258, 'Oveja lana', '4', '35,16', '38,676', '788', '30'),
(259, 'Tubo yerba', '1', '35,74', '39,314', '348', '30'),
(260, 'Tubo te', '19', '42,86', '47,146', '279', '30'),
(261, 'Colgante alpaca', '19', '30,2', '33,22', '987', '30'),
(262, 'Anillo ceramica', '1', '28,98', '31,878', '596', '30'),
(263, 'Carpincho bb', '18', '38,95', '42,845', '985', '30'),
(264, 'Carpincho tierra colorada', '5', '49,79', '54,769', '136', '30'),
(265, 'Mini botella roja', '19', '3,14', '3,454', '874', '30'),
(266, 'Mini botella roja (otra)', '19', '58,99', '64,889', '650', '30'),
(267, 'Mate con esmalte', '17', '60,34', '66,374', '828', '30'),
(268, 'Mate con cesteria', '18', '75,47', '83,017', '676', '30'),
(269, 'Mate c/cesteria (grande)', '9', '51,85', '57,035', '886', '30'),
(270, 'Bombilla con firulete', '16', '50,84', '55,924', '106', '30'),
(271, 'Bombilla con cesteria', '11', '44,50', '48,95', '924', '30'),
(272, 'Mate de gress', '2', '45,4', '49,94', '857', '30'),
(273, 'Mate forrado grande', '7', '98,34', '108,174', '432', '30'),
(274, 'Mate bordo', '8', '25,72', '28,292', '232', '30'),
(275, 'Botella roja grande', '11', '92,63', '101,893', '498', '30'),
(276, 'Botella caramelo/negra', '13', '28,12', '30,932', '137', '30'),
(277, 'Botella delgada', '12', '31,21', '34,331', '432', '30'),
(278, 'Pez azul', '12', '64,82', '71,302', '616', '30'),
(279, 'Taza azul', '4', '74,95', '82,445', '401', '30'),
(280, 'Mate con linea verde', '3', '97,67', '107,437', '599', '30'),
(281, 'Mate con linea verde (otro)', '4', '68,52', '75,372', '445', '30'),
(282, 'Movil Hada', '19', '46,38', '51,018', '848', '30'),
(283, 'Movil Pajaro', '17', '65,23', '71,753', '237', '30'),
(284, 'Movil grande', '15', '68,40', '75,24', '412', '30'),
(285, 'Movil bebe', '4', '21,83', '24,013', '627', '30'),
(286, 'Movil mariposa', '16', '91,17', '100,287', '536', '30'),
(287, 'Movil en vitrofusion', '3', '76,10', '83,71', '227', '30'),
(288, 'Collar en vitrofusion', '8', '15,57', '17,127', '852', '30'),
(289, 'Stevia dulce x 100 sobres', '16', '86,90', '95,59', '982', '30'),
(290, 'Endulzante stevia x 100 gs', '18', '72,60', '79,86', '265', '30'),
(291, 'End. liquido x 100cc', '10', '26,67', '29,337', '814', '30'),
(292, 'Hoja stevia x15 gs', '11', '67,37', '74,107', '570', '30'),
(293, 'Te stevia x 25 saquitos', '2', '98,94', '108,834', '197', '30'),
(294, 'Lienzo en oleo', '19', '93,26', '102,586', '540', '30'),
(295, 'Cuadro (color)', '15', '76,99', '84,689', '870', '30'),
(296, 'Cuadro lapiz digital', '1', '82,3', '90,53', '358', '30'),
(297, 'Remera spum', '12', '56,47', '62,117', '447', '30');

INSERT INTO `vendedor`(`vend_id`, `vend_apellido`, `vend_nombres`, `vend_porc_comis`) VALUES 
(1,	'ARANDA', '	MIRTA', '10,00'),
(2,	'SOTO', 'RODRIGO', '10,00'),
(3,	'DIAZ', 'SERGIO', '10,00'),
(4,	'SANCHEZ', 'ANTONELLA', '10,00'),
(5,	'FERNANDEZ', 'ADRIANA', '10,00'),
(6,	'HILLEBRAND', 'SANTIAGO', '10,00'),
(7,	'ROJAS', 'GERARDO', '10,00'),
(8,	'FERNANDEZ', 'MARIANA', '10,00'),
(9,	'DIAZ', 'PATRICIA', '10,00');

INSERT INTO `provincia` (`prov_id`, `prov_desc`) VALUES
(1, 'Buenos Aires'),
(2, 'Buenos Aires-GBA'),
(3, 'Capital Federal'),
(4, 'Catamarca'),
(5, 'Chaco'),
(6, 'Chubut'),
(7, 'Córdoba'),
(8, 'Corrientes'),
(9, 'Entre Ríos'),
(10, 'Formosa'),
(11, 'Jujuy'),
(12, 'La Pampa'),
(13, 'La Rioja'),
(14, 'Mendoza'),
(15, 'Misiones'),
(16, 'Neuquén'),
(17, 'Río Negro'),
(18, 'Salta'),
(19, 'San Juan'),
(20, 'San Luis'),
(21, 'Santa Cruz'),
(22, 'Santa Fe'),
(23, 'Santiago del Estero'),
(24, 'Tierra del Fuego'),
(25, 'Tucumán');

INSERT INTO `localidad` (`loc_id`, `prov_id`, `loc_des`) VALUES
(1, 1, '25 de Mayo'),
(2, 2, 'Malvinas Argentinas'),
(3, 3, 'Parque Avellaneda'),
(4, 4, 'San Fernando del Valle'),
(5, 5, 'Capital'),
(6, 6, 'Pto. Madryn'),
(7, 7, 'Alta Gracia'),
(8, 8, 'Goya'),
(9, 9, 'Gualeguaychú'),
(10, 10, 'Clorinda'),
(11, 11, 'Humahuaca'),
(12, 12, 'Falucho'),
(13, 13, 'Capital'),
(14, 14, 'Sta. Rosa'),
(15, 15, 'Posadas'),
(16, 16, 'Villa del Puente Picún Leuvú'),
(17, 17, 'Bariloche'),
(18, 18, 'Cafayate'),
(19, 19, 'Veinticinco de Mayo'),
(20, 20, 'Luján'),
(21, 21, 'Calafate'),
(22, 22, 'Avellaneda'),
(23, 23, 'Weisburd'),
(24, 24, 'Río Grande'),
(25, 25, 'Amaicha del Valle');

INSERT INTO `domicilio`(`dom_id`, `dom_calle`, `loc_id`) VALUES
(1,	'COL.LIEBIG CTES', '23'),
(2,	'B°JAPON 4420', '13'),
(3,	'PEDERNERA 87', '1'),
(4,	'ZAPIOLA 2230', '2'),
(5,	'BOLIVAR1553', '3'),
(6,	'AV.115 N° 1834', '4'),
(7,	'B°JAPON 4420', ' 5'),
(8,	'B° 40 VIV. CASA 25', '6'),
(9,	'SAN LORENZO 97', '7'),
(10,'CH 193 ED. B 13', '8'),
(11, 'CH 120 MZ 6 CASA 15', '9'),
(12, 'PERITO MORENO 3140', '10'),
(13, 'B°JAPON 4420', '11'),
(14, 'QUINTANA 1136', '12'),
(15, 'CH 120 MZ L CASA 10', '13'),
(16, 'NEUQUEN 1538', '13'),
(17, 'PVIA JUJUY', '14'),
(18, 'GUEMES N°12', '12'),
(19, '3 de Febrero Nº2329', '15'),
(20, 'B°JAPON 4420', '13'),
(21, 'B°JAPON 4420', '16'),
(22, 'B°JAPON 4420', '17'),
(23, 'PEDRO CORREZ 2217', '13'),
(24, 'BELGRANO 1832', '14'),
(25, 'AV. CABRED 2471', '15'),
(26, 'LA RIOJA 1859', '15'),
(27, 'B°JAPON 4420', '25'),
(28, 'M.FIERRO3126', '24'),
(29, 'CAMPO GRANDE', '25'),
(30, 'MENDOZA 3449', '14'),
(31, 'MENDOZA 3450', '19'),
(32, 'LA PLATA ', '19'),
(33, 'MONTECARLOS MNES', '13'),
(34, 'PADRE NEUQUEN 4396', '11'),
(35, 'CALLE 95 2023', '8'),
(36, 'SAN IGNACIO 3300', '7'),
(37, 'CALLE 128 Nº5545', '6'),
(38, 'rota 8542', '4'),
(39, 'BºPARQUE 2 DE ABRIL', '5'),
(40, 'España 3352', '6'),
(41, 'Derqui 1256', '1'),
(42, 'Perito Moreno 3140', '1'),
(43, 'Derqui 1256', '2'),
(44, 'Perito Moreno 3140', '1'),
(45, 'CALLE 128 Nº5545', '3'),
(46, 'ALBA POSSE', '4'),
(47, 'BºPARQUE 2 DE ABRIL', '5'),
(48, 'España 3352', '8'),
(49, 'Derqui 1256', '9'),
(50, 'Perito Moreno 3140', '15'),
(51, 'GUEMES N°12 APOSTOLES', '17'),
(52, 'ARTIGAS 3404', '16'),
(53, 'CH 128 CALLE 66 C 306', '15'),
(54, 'CH 107 CALLE 09 C 30', '17'),
(55, 'SAN IGNACIO-MNES', '6'),
(56, 'CALLE 128 Nº5545', '25'),
(57, 'ALBA POSSE', '24'),
(58, 'BºPARQUE 2 DE ABRIL', '23'),
(59, 'España 3352', '22'),
(60, 'Derqui 1256', '21'),
(61, 'Perito Moreno 3140', '20'),
(62, 'Bº PROOBRAS', '20'),
(63, 'CALLE 34 3745', '19'),
(64, 'MAGRI 1379', '18'),
(65, 'PTO RICO', '17'),
(66, 'PTO RICO', '16'),
(67, 'BºSAN MARCOS 3461', '15'),
(68, 'POSADAS', '14'),
(69, 'ENTRE RIOS 31-PDAS', '13'),
(70, 'OBERA-MNES', '12');

INSERT INTO `cliente`(`clie_id`, `clie_razon`, `clie_nombre`, `dom_id`) VALUES 
(1, '', 'BARBIAN MATIAS', '34'),
(2, '', 'CARLOS BOTIUK', '43'),
(3, '', 'DARIO ALDANA', '55'),
(4, '', 'PELINA FRINED', '6'),
(5, '', 'JAVIER ALMADA', '21'),
(6, '', 'MARIELA (MACRI)', '29'),
(7, '', 'ALICIA HEIN', '50'),
(8, '', 'MARTIN LUIS', '42'),
(9, '', 'PAOLA CALISTRO', '3'),
(10, '', 'RODRIGUEZ RAMON', '68'),
(11, '', 'GUILLERMO ORSAT', '46'),
(12, '', 'CARLOS RAMPONI', '15'),
(13, '', 'PAMELA ALMADA', '36'),
(14, '', 'JAVIER ALMADA', '52'),
(15, '', 'LUIS MARTIN', '2'),
(16, '', 'TARNOSKI', '65'),
(17, '', 'ALBERTO MORALES', '17'),
(18, '', 'ANGEL MARTINEZ', '33'),
(19, '', 'DARIO', '11'),
(20, '', 'MARCELO BOGADO', '10'),
(21, '', 'JAVIER ALMADA', '14'),
(22, '', 'DE SOUZA HECTOR', '44'),
(23, '', 'MARCELO DELGADO', '3'),
(24, '', 'YONATAN LUKOSKI', '4'),
(25, '', 'DORA DURE', '33'),
(26, '', 'GUSTAVO ACTIS(PARQUE TECNOLOGICO)', '28'),
(27, '', 'GIULIA CACCIN', '38'),
(28, '', 'ALEJANDRO GONZALEZ', '45'),
(29, '', 'LUISIANA PORTILLO', '46'),
(30, '', 'GUILLERMO FERNANDEZ', '23'),
(31, '', 'MARIA DUARTE', '62'),
(32, '', 'JORGE HIPPLE', '65'),
(33, '', 'SEBASTIAN MEDINA', '59'),
(34, '', 'JUAN GARCIA', '12'),
(35, '', 'RAUL BARRUFALDI', '20'),
(36, '', '', '34'),
(37, '', 'MARCELO DELGADO', '7'),
(38, '', 'JUAN BERNAL', '8'),
(39, '', 'CECILIA ROSIAK', '14'),
(40, '', 'JOSE FERREIRA', '24'),
(41, '', 'NORMA PINEDA', '44'),
(42, '', 'CARLA CUCZUK', '27'),
(43, '', 'SILVIO SOTELO', '69'),
(44, '', 'MAURICIO ALVES', '65'),
(45, '', 'DIEGO FANTUCHI', '70'),
(46, '', 'FABIANA PARLASUR', '50'),
(47, '', 'RUNKE ESTEBAN', '31'),
(48, '', 'REINKO LILIANA', '23'),
(49, '', 'TRINIDAD LIOTTA', '38'),
(50, '', 'NADIA TARNOSKI', '70'),
(51, '', 'LUIS SOTELO', '8'),
(52, '', 'LAURA CACERES', '49'),
(53, '', 'VERONICA MAIDANA', '52'),
(54, '', 'STRIEDER RAIMUNDO', '38'),
(55, '', 'ALEJANDRO PEEPO', '11'),
(56, '', 'DAIANA BARBARO', '63'),
(57, '', 'CLAUDELINA ISABEL CARRERA SILVA', '68'),
(58, '', 'WALTER MACHADO', '61'),
(59, '', 'MARIA LUISA CANEVA', '20'),
(60, '', 'VIRGINIA AGENCIA DOPPLER', '1'),
(61, '', 'BENITEZ JORGE', '33'),
(62, '', 'YASMIN ZAMPACA', '38'),
(63, '', 'GRACIELA WORONOWICZ', '59'),
(64, '', 'JORGE ESCALANTE', '11'),
(65, '', 'MIGUEL ANGEL BOGADO', '60'),
(66, '', 'RAMONA NUÑEZ', '57'),
(67, '', 'ALEXIS SOSA', '35'),
(68, '', 'ROSANA LUGRIN', '68'),
(69, '', 'CLAUDIO CLERMONT', '68'),
(70, '', 'DAVID ULFSJOO', '26'),
(71, '', 'CLAUDIA BOGADO', '38'),
(72, '', 'MABEL CARDOZO', '57'),
(73, '', 'ANA RIOS', '44'),
(74, '', 'SANDRA GULARTE', '49'),
(75, '', 'LAURA BACKES.', '69'),
(76, '', 'LAURA HETTINGER', '31'),
(77, '', 'GUILLERMO CRIBB LIBARDI', '28'),
(78, '', 'GRACIELA LOPEZ', '15'),
(79, '', 'ARACELLI BRIZUELA', '70'),
(80, '', 'HECTOR ACOSTA', '55'),
(81, '', 'JUAN CARLOS CABASSI', '40'),
(82, '', 'SEBASTIAN TENAYO', '37'),
(83, '', 'IRRAZABAL RAUL', '12'),
(84, '', 'CASILDO HECK', '17'),
(85, '', 'NOLAZQUE MIRTA', '68'),
(86, '', 'MERCEDES MORAIS', '32'),
(87, '', 'VICTOR GUERRERO', '11'),
(88, '', 'CECILIA RODRIGUEZ', '28'),
(89, '', 'CRISTINA STEVENSON', '44'),
(90, '', 'MONICA SANCHEZ', '17'),
(91, '', 'DIEGO SALDIVIA', '19'),
(92, '', 'CARMEN CAMEN', '7'),
(93, '', 'MARIANA BARCHUK', '63'),
(94, '', 'DARDO AGUIRRE', '3'),
(95, '', 'NORMA BESOL', '30'),
(96, '', 'FEDERICO LOCKETT', '22'),
(97, '', 'LUISINA PERÓ', '4'),
(98, '', 'MARILENA STEVENS', '50'),
(99, '', 'MACHICOTE PABLO', '20'),
(100, '', 'CARINA ELENA BRODZICZ', '3'),
(101, '', 'SILVINA GOERLNG', '28'),
(102, '', 'MARILENA STEVENS', '14'),
(103, '', 'BIBIANA GALEANO', '50'),
(104, '', 'SILVINA GOERLNG', '9'),
(105, '', 'MICHELA BERTOLOTTI', '66'),
(106, '', 'MARIANO MAYOL', '28'),
(107, '', 'MARCELA DIAZ', '25'),
(108, '', 'NESTOR ORTIZ', '54'),
(109, '', 'PEDRO DUARTE', '26'),
(110, '', 'NATALIA ROA', '66'),
(111, '', 'TERESA POLATTINI', '37'),
(112, '', 'MAURO ARANDA', '39'),
(113, '', 'JOSE LUIS BAEZ', '24'),
(114, '', 'BARRIOS BLANCA', '28'),
(115, '', 'MERCEDES VERA', '9'),
(116, '', 'SILVIA ITATI SANCHEZ', '35'),
(117, '', 'MARCOS STEVENS', '4'),
(118, '', 'MIRIAM CHELALICHE', '37'),
(119, '', 'GERONIMO GALEANO', '22'),
(120, '', 'GRABRIEL GORTARI', '20'),
(121, '', 'CRISTIAN SCHMIDT', '27'),
(122, '', 'EDUARDO SANCHEZ', '68'),
(123, '', 'GRISELL WORBACH', '9'),
(124, '', 'EUGENIA NUINEN', '13'),
(125, '', 'GLADYS ESCOBAR', '63'),
(126, '', 'JOAQUIN DELPIANO', '37'),
(127, '', 'JOSE PIZAT', '68'),
(128, '', 'JUAN CARLOS GOMEZ PEREIRA', '7'),
(129, '', 'PABLO ANDRES BOERO', '51');

INSERT INTO `pto_vta`(`pto_vta_id`, `pto_vta_descr`) VALUES 
(1,	'Posadas 1'),
(2,	'Posadas 2'),
(3,	'Garupa 1'),
(4,	'Candelaria 1'),
(5,	'Garupa 2'),
(6,	'CBA 1'),
(7,	'CBA 2'),
(8,	'Snatiago 1'),
(9,	'Cordoba 1'),
(10,'Candelaria 2'),
(11,'Cordoba 2');

INSERT INTO `fac_cab`(`fac_cab_id`, `fac_cab_fecha`, `fac_cab_monto_bruto`, `fac_cab_iva`, `clie_id`, `vend_id`, `pto_vta_id`) VALUES
(1, '2017-9-28', '375,62', '7,88802', '41', '5', '1'),
(2, '2016-7-12', '300,38', '6,30798', '95', '2', '4'),
(3, '2016-7-21', '49,45', '1,03845', '83', '6', '5'),
(4, '2017-6-1', '489,27', '10,27467', '52', '1', '8'),
(5, '2016-11-18', '689,7', '14,4837', '96', '7', '2'),
(6, '2017-10-30', '82,75', '1,73775', '90', '4', '11'),
(7, '2016-11-17', '408,85', '8,58585', '88', '1', '9'),
(8, '2017-1-25', '369,74', '7,76454', '33', '4', '6'),
(9, '2017-10-12', '370,22', '7,77462', '101', '9', '2'),
(10, '2016-6-12', '408,40', '8,5764', '78', '2', '7'),
(11, '2016-5-3', '820,76', '17,23596', '56', '2', '5'),
(12, '2017-11-3', '241,39', '5,06919', '14', '3', '10'),
(13, '2017-9-22', '994,30', '20,8803', '73', '3', '6'),
(14, '2016-3-28', '184,17', '3,86757', '71', '3', '3'),
(15, '2016-10-12', '438,85', '9,21585', '112', '4', '5'),
(16, '2016-11-27', '158,74', '3,33354', '86', '3', '2'),
(17, '2017-7-7', '114,85', '2,41185', '37', '5', '7'),
(18, '2017-2-5', '140,99', '2,96079', '97', '3', '9'),
(19, '2017-3-22', '108,13', '2,27073', '90', '7', '1'),
(20, '2017-1-19', '115,22', '2,41962', '114', '1', '8'),
(21, '2017-10-8', '337,66', '7,09086', '29', '1', '9'),
(22, '2016-1-22', '135,16', '2,83836', '105', '1', '6'),
(23, '2016-12-11', '868,68', '18,24228', '14', '5', '2'),
(24, '2016-7-29', '520,60', '10,9326', '30', '7', '7'),
(25, '2017-6-28', '367,26', '7,71246', '54', '6', '4'),
(26, '2017-5-7', '838,84', '17,61564', '7', '6', '6'),
(27, '2017-6-29', '673,57', '14,14497', '39', '2', '7'),
(28, '2016-7-17', '972,39', '20,42019', '42', '4', '2'),
(29, '2016-11-1', '733,26', '15,39846', '114', '7', '3'),
(30, '2016-4-9', '548,87', '11,52627', '113', '4', '3'),
(31, '2017-4-20', '918,94', '19,29774', '111', '5', '2'),
(32, '2017-7-8', '962,27', '20,20767', '19', '4', '1'),
(33, '2017-8-2', '284,13', '5,96673', '101', '8', '2'),
(34, '2017-1-2', '526,98', '11,06658', '79', '4', '9'),
(35, '2016-5-30', '470,22', '9,87462', '40', '2', '5'),
(36, '2017-12-15', '517,97', '10,87737', '117', '5', '10'),
(37, '2017-4-28', '747,48', '15,69708', '21', '8', '3'),
(38, '2017-1-4', '520,72', '10,93512', '51', '6', '10'),
(39, '2017-8-19', '171,68', '3,60528', '19', '7', '3'),
(40, '2016-6-8', '55,14', '1,15794', '88', '7', '5'),
(41, '2016-3-24', '969,38', '20,35698', '67', '9', '5'),
(42, '2017-1-29', '335,89', '7,05369', '128', '8', '5'),
(43, '2016-4-4', '6,68', '0,14028', '23', '2', '4'),
(44, '2017-12-18', '976,80', '20,5128', '55', '1', '7'),
(45, '2017-10-7', '641,87', '13,47927', '42', '4', '1'),
(46, '2017-1-10', '628,11', '13,19031', '93', '2', '2'),
(47, '2017-12-4', '405,41', '8,51361', '123', '2', '9'),
(48, '2017-8-27', '756,52', '15,88692', '17', '1', '11'),
(49, '2017-6-18', '594,90', '12,4929', '23', '2', '3'),
(50, '2016-11-13', '307,80', '6,4638', '95', '2', '8'),
(51, '2016-8-8', '383,82', '8,06022', '70', '8', '5'),
(52, '2017-8-18', '549,43', '11,53803', '125', '7', '3'),
(53, '2017-3-3', '21,41', '0,44961', '49', '2', '8'),
(54, '2016-4-28', '168,89', '3,54669', '54', '6', '6'),
(55, '2017-11-28', '471,29', '9,89709', '19', '5', '5'),
(56, '2016-1-6', '602,60', '12,6546', '106', '3', '4'),
(57, '2017-9-6', '172,96', '3,63216', '116', '3', '2'),
(58, '2016-10-12', '694,91', '14,59311', '89', '2', '10'),
(59, '2017-4-9', '647,90', '13,6059', '16', '2', '1'),
(60, '2016-8-18', '957,61', '20,10981', '84', '2', '5'),
(61, '2016-11-19', '386,65', '8,11965', '31', '6', '4'),
(62, '2016-3-3', '130,10', '2,7321', '40', '6', '10'),
(63, '2016-4-30', '729,75', '15,32475', '51', '3', '4'),
(64, '2017-12-9', '257,14', '5,39994', '54', '8', '10'),
(65, '2017-6-5', '522,72', '10,97712', '63', '3', '11'),
(66, '2017-6-9', '241,13', '5,06373', '87', '8', '8'),
(67, '2016-8-7', '929,37', '19,51677', '62', '1', '7'),
(68, '2016-8-16', '622,91', '13,08111', '69', '6', '9'),
(69, '2017-8-25', '125,31', '2,63151', '77', '1', '2'),
(70, '2016-3-21', '412,19', '8,65599', '73', '8', '1'),
(71, '2016-8-8', '530,19', '11,13399', '66', '9', '6'),
(72, '2016-3-2', '928,53', '19,49913', '31', '5', '8'),
(73, '2016-2-11', '911,42', '19,13982', '109', '4', '7'),
(74, '2017-1-26', '951,68', '19,98528', '114', '5', '10'),
(75, '2016-6-2', '891,95', '18,73095', '121', '7', '6'),
(76, '2016-3-15', '943,81', '19,82001', '18', '4', '1'),
(77, '2016-12-30', '415,66', '8,72886', '100', '7', '9'),
(78, '2017-12-22', '776,72', '16,31112', '47', '4', '10'),
(79, '2017-10-23', '245,9', '5,1639', '112', '7', '4'),
(80, '2017-3-2', '146,72', '3,08112', '123', '5', '10'),
(81, '2017-9-20', '854,72', '17,94912', '33', '1', '1'),
(82, '2017-3-30', '852,29', '17,89809', '87', '4', '10'),
(83, '2017-3-16', '972,62', '20,42502', '32', '3', '2'),
(84, '2016-11-15', '200,4', '4,2084', '26', '2', '4'),
(85, '2016-9-19', '571,40', '11,9994', '41', '8', '9'),
(86, '2017-5-26', '39,60', '0,8316', '79', '8', '2'),
(87, '2017-7-11', '352,27', '7,39767', '30', '2', '1'),
(88, '2017-11-29', '399,40', '8,3874', '30', '5', '6'),
(89, '2016-3-2', '613,68', '12,88728', '6', '8', '9'),
(90, '2017-11-5', '240,18', '5,04378', '10', '5', '7'),
(91, '2016-6-11', '936,64', '19,66944', '69', '7', '6'),
(92, '2017-2-5', '557,31', '11,70351', '12', '5', '9'),
(93, '2017-2-16', '300,37', '6,30777', '77', '7', '7'),
(94, '2016-4-2', '996,57', '20,92797', '22', '4', '10'),
(95, '2017-6-1', '73,62', '1,54602', '80', '2', '2'),
(96, '2017-2-17', '148,10', '3,1101', '105', '6', '5'),
(97, '2016-2-30', '848,89', '17,82669', '14', '1', '1'),
(98, '2017-5-26', '916,67', '19,25007', '80', '5', '1'),
(99, '2017-7-22', '219,56', '4,61076', '122', '6', '4'),
(100, '2017-1-2', '694,29', '14,58009', '52', '9', '7'),
(101, '2017-12-25', '392,70', '8,2467', '18', '8', '2'),
(102, '2016-1-16', '597,39', '12,54519', '25', '7', '10'),
(103, '2016-2-19', '56,79', '1,19259', '85', '8', '2'),
(104, '2017-12-30', '685,53', '14,39613', '61', '2', '6'),
(105, '2017-4-16', '969,18', '20,35278', '103', '8', '10'),
(106, '2017-7-28', '913,64', '19,18644', '3', '5', '6'),
(107, '2017-5-29', '575,39', '12,08319', '69', '2', '3'),
(108, '2016-11-22', '537,11', '11,27931', '28', '3', '2'),
(109, '2016-4-6', '336,83', '7,07343', '119', '9', '5'),
(110, '2017-12-6', '844,29', '17,73009', '121', '7', '7'),
(111, '2016-11-7', '614,51', '12,90471', '115', '4', '10'),
(112, '2017-11-22', '369,85', '7,76685', '58', '5', '11'),
(113, '2017-3-11', '642,56', '13,49376', '83', '1', '3'),
(114, '2017-12-10', '203,43', '4,27203', '15', '9', '4'),
(115, '2017-9-13', '534,52', '11,22492', '117', '6', '11'),
(116, '2017-3-12', '611,84', '12,84864', '70', '2', '5'),
(117, '2017-8-15', '359,91', '7,55811', '56', '8', '10'),
(118, '2016-3-29', '941,2', '19,7652', '95', '3', '8'),
(119, '2017-10-26', '13,81', '0,29001', '74', '1', '3'),
(120, '2017-1-21', '719,19', '15,10299', '103', '6', '1'),
(121, '2016-8-23', '981,80', '20,6178', '61', '7', '6'),
(122, '2017-5-11', '902,82', '18,95922', '72', '6', '9'),
(123, '2016-2-5', '142,1', '2,9841', '12', '1', '11'),
(124, '2016-11-14', '506,79', '10,64259', '56', '6', '1'),
(125, '2017-8-1', '392,12', '8,23452', '96', '2', '9'),
(126, '2017-11-13', '178,22', '3,74262', '49', '8', '2'),
(127, '2017-10-28', '303,90', '6,3819', '71', '4', '6'),
(128, '2016-8-3', '872,5', '18,3225', '20', '8', '9'),
(129, '2017-11-9', '918,7', '19,2927', '52', '3', '4'),
(130, '2016-9-1', '460,34', '9,66714', '120', '7', '6'),
(131, '2017-5-25', '516,53', '10,84713', '21', '2', '3'),
(132, '2017-8-19', '947,63', '19,90023', '34', '9', '1'),
(133, '2016-10-17', '462,35', '9,70935', '28', '6', '2'),
(134, '2016-10-3', '41,42', '0,86982', '88', '2', '8'),
(135, '2016-3-29', '220,91', '4,63911', '58', '2', '3'),
(136, '2016-9-20', '905,2', '19,0092', '53', '6', '1'),
(137, '2016-10-21', '241,32', '5,06772', '20', '3', '5'),
(138, '2017-9-28', '334,58', '7,02618', '71', '2', '3'),
(139, '2016-8-3', '699,66', '14,69286', '6', '5', '1'),
(140, '2016-7-23', '993,26', '20,85846', '94', '5', '4'),
(141, '2016-7-29', '9,88', '0,20748', '48', '6', '3'),
(142, '2016-6-14', '86,26', '1,81146', '67', '1', '7'),
(143, '2016-11-3', '611,29', '12,83709', '7', '9', '1'),
(144, '2017-4-5', '518,29', '10,88409', '110', '9', '11'),
(145, '2017-9-13', '812,76', '17,06796', '34', '3', '3'),
(146, '2017-3-10', '657,1', '13,7991', '81', '4', '7'),
(147, '2016-7-7', '308,93', '6,48753', '21', '5', '11'),
(148, '2017-2-15', '833,68', '17,50728', '127', '4', '3'),
(149, '2017-11-7', '629,29', '13,21509', '37', '1', '3'),
(150, '2016-10-7', '25,46', '0,53466', '120', '5', '3'),
(151, '2017-7-25', '934,10', '19,6161', '128', '4', '11'),
(152, '2016-4-19', '579,61', '12,17181', '25', '3', '8'),
(153, '2016-10-4', '466,96', '9,80616', '83', '3', '4'),
(154, '2017-8-18', '393,64', '8,26644', '30', '7', '9'),
(155, '2017-12-26', '487,13', '10,22973', '28', '6', '3'),
(156, '2016-5-14', '706,56', '14,83776', '55', '2', '6'),
(157, '2016-7-21', '746,37', '15,67377', '23', '7', '11'),
(158, '2016-1-22', '566,93', '11,90553', '105', '1', '5'),
(159, '2017-8-20', '300,96', '6,32016', '73', '3', '4'),
(160, '2016-11-28', '42,93', '0,90153', '5', '1', '7'),
(161, '2016-6-1', '74,18', '1,55778', '127', '8', '7'),
(162, '2016-10-2', '474,30', '9,9603', '63', '6', '6'),
(163, '2017-10-5', '666,32', '13,99272', '100', '9', '1'),
(164, '2017-3-7', '430,69', '9,04449', '96', '5', '4'),
(165, '2016-6-11', '703,44', '14,77224', '74', '7', '10'),
(166, '2017-4-5', '488,67', '10,26207', '75', '9', '1'),
(167, '2016-2-23', '553,95', '11,63295', '122', '5', '2'),
(168, '2017-12-20', '710,50', '14,9205', '41', '1', '8'),
(169, '2017-7-11', '292,23', '6,13683', '78', '6', '6'),
(170, '2016-6-4', '437,67', '9,19107', '89', '6', '11'),
(171, '2017-7-4', '610,27', '12,81567', '6', '8', '1'),
(172, '2016-11-7', '47,22', '0,99162', '70', '2', '1'),
(173, '2017-4-3', '784,48', '16,47408', '76', '5', '10'),
(174, '2016-5-6', '450,78', '9,46638', '60', '3', '10'),
(175, '2017-10-17', '929,96', '19,52916', '54', '8', '6'),
(176, '2017-10-24', '388,66', '8,16186', '8', '1', '6'),
(177, '2017-10-12', '481,57', '10,11297', '4', '8', '6'),
(178, '2017-10-19', '39,97', '0,83937', '79', '5', '8'),
(179, '2016-2-12', '278,54', '5,84934', '60', '6', '6'),
(180, '2016-3-23', '76,83', '1,61343', '30', '1', '7'),
(181, '2017-3-15', '662,76', '13,91796', '106', '9', '11'),
(182, '2017-3-15', '44,26', '0,92946', '108', '1', '11'),
(183, '2017-4-23', '738,18', '15,50178', '14', '4', '11'),
(184, '2016-6-15', '865,19', '18,16899', '22', '8', '4'),
(185, '2016-12-17', '305,1', '6,4071', '7', '1', '2'),
(186, '2016-5-21', '362,52', '7,61292', '85', '3', '2'),
(187, '2016-5-29', '979,84', '20,57664', '55', '9', '8'),
(188, '2016-2-15', '885,61', '18,59781', '65', '6', '6'),
(189, '2016-3-13', '768,26', '16,13346', '48', '1', '7'),
(190, '2016-5-7', '580,95', '12,19995', '4', '2', '8'),
(191, '2016-12-22', '613,2', '12,8772', '91', '3', '2'),
(192, '2016-1-19', '297,19', '6,24099', '75', '9', '1'),
(193, '2017-8-17', '499,54', '10,49034', '79', '6', '9'),
(194, '2017-10-29', '916,65', '19,24965', '45', '3', '1'),
(195, '2016-8-16', '331,21', '6,95541', '107', '1', '4'),
(196, '2017-7-29', '678,86', '14,25606', '11', '6', '8'),
(197, '2017-12-28', '95,51', '2,00571', '57', '8', '4'),
(198, '2017-1-2', '120,27', '2,52567', '37', '6', '4'),
(199, '2017-8-16', '802,14', '16,84494', '82', '4', '4'),
(200, '2017-8-12', '415,59', '8,72739', '49', '6', '3'),
(201, '2017-10-1', '325,89', '6,84369', '2', '4', '9'),
(202, '2016-2-24', '216,81', '4,55301', '67', '9', '5'),
(203, '2017-6-27', '512,42', '10,76082', '104', '9', '10'),
(204, '2017-8-10', '583,67', '12,25707', '7', '9', '4'),
(205, '2016-3-8', '912,44', '19,16124', '13', '3', '1'),
(206, '2016-9-22', '237,5', '4,9875', '28', '9', '2'),
(207, '2017-2-16', '19,90', '0,4179', '34', '3', '2'),
(208, '2017-8-29', '133,29', '2,79909', '42', '3', '9'),
(209, '2017-5-15', '189,10', '3,9711', '7', '7', '6'),
(210, '2017-1-8', '352,92', '7,41132', '121', '7', '6'),
(211, '2017-5-19', '327,20', '6,8712', '33', '8', '8'),
(212, '2017-8-13', '366,42', '7,69482', '59', '1', '1'),
(213, '2016-6-29', '925,44', '19,43424', '80', '4', '3'),
(214, '2016-2-29', '19,15', '0,40215', '40', '2', '9');

INSERT INTO `fac_det`(`fac_det_id`, `fac_det_cant`, `art_id`, `fac_cab_id`) VALUES 
(1, '2', '10', '104'),
(2, '4', '48', '38'),
(3, '3', '163', '29'),
(4, '2', '179', '183'),
(5, '1', '142', '132'),
(6, '3', '256', '41'),
(7, '4', '201', '36'),
(8, '2', '197', '44'),
(9, '5', '85', '91'),
(10, '1', '234', '2'),
(11, '4', '132', '28'),
(12, '4', '199', '116'),
(13, '5', '280', '40'),
(14, '3', '160', '207'),
(15, '1', '241', '80'),
(16, '3', '141', '152'),
(17, '5', '24', '203'),
(18, '1', '237', '144'),
(19, '4', '32', '156'),
(20, '3', '137', '96'),
(21, '3', '184', '31'),
(22, '2', '255', '18'),
(23, '5', '239', '154'),
(24, '1', '17', '138'),
(25, '3', '50', '103'),
(26, '4', '210', '194'),
(27, '3', '174', '157'),
(28, '4', '17', '20'),
(29, '5', '90', '145'),
(30, '5', '104', '122'),
(31, '5', '257', '148'),
(32, '3', '104', '168'),
(33, '5', '48', '152'),
(34, '4', '159', '134'),
(35, '4', '119', '156'),
(36, '2', '145', '144'),
(37, '1', '132', '27'),
(38, '5', '121', '15'),
(39, '2', '152', '203'),
(40, '3', '202', '100'),
(41, '5', '235', '3'),
(42, '3', '219', '183'),
(43, '4', '297', '136'),
(44, '1', '38', '50'),
(45, '3', '140', '181'),
(46, '2', '137', '150'),
(47, '3', '288', '167'),
(48, '4', '202', '57'),
(49, '5', '139', '11'),
(50, '1', '9', '56'),
(51, '1', '148', '161'),
(52, '2', '187', '30'),
(53, '1', '283', '124'),
(54, '5', '261', '168'),
(55, '3', '118', '201'),
(56, '5', '86', '171'),
(57, '4', '219', '1'),
(58, '3', '228', '93'),
(59, '4', '84', '25'),
(60, '1', '174', '12'),
(61, '3', '70', '162'),
(62, '4', '79', '173'),
(63, '5', '167', '160'),
(64, '5', '62', '10'),
(65, '5', '86', '24'),
(66, '1', '213', '81'),
(67, '4', '68', '40'),
(68, '4', '122', '208'),
(69, '3', '110', '76'),
(70, '2', '85', '17'),
(71, '5', '254', '162'),
(72, '2', '100', '155'),
(73, '5', '177', '16'),
(74, '3', '132', '170'),
(75, '2', '180', '62'),
(76, '4', '19', '203'),
(77, '3', '141', '43'),
(78, '3', '50', '197'),
(79, '1', '270', '67'),
(80, '4', '17', '139'),
(81, '3', '90', '113'),
(82, '5', '179', '41'),
(83, '1', '281', '62'),
(84, '4', '192', '120'),
(85, '4', '247', '183'),
(86, '4', '141', '89'),
(87, '2', '35', '173'),
(88, '2', '126', '26'),
(89, '1', '292', '146'),
(90, '2', '251', '189'),
(91, '1', '127', '77'),
(92, '4', '4', '75'),
(93, '1', '121', '94'),
(94, '4', '253', '14'),
(95, '3', '245', '112'),
(96, '1', '174', '157'),
(97, '5', '250', '166'),
(98, '3', '56', '78'),
(99, '2', '171', '205'),
(100, '2', '262', '142'),
(101, '1', '165', '25'),
(102, '3', '238', '167'),
(103, '3', '9', '57'),
(104, '3', '290', '47'),
(105, '1', '141', '1'),
(106, '4', '1', '144'),
(107, '3', '85', '53'),
(108, '2', '35', '138'),
(109, '2', '27', '213'),
(110, '4', '216', '22'),
(111, '4', '247', '56'),
(112, '4', '58', '25'),
(113, '5', '245', '212'),
(114, '1', '291', '155'),
(115, '3', '154', '136'),
(116, '1', '46', '91'),
(117, '3', '12', '155'),
(118, '5', '226', '147'),
(119, '2', '293', '1'),
(120, '2', '157', '99'),
(121, '2', '262', '10'),
(122, '4', '228', '157'),
(123, '5', '46', '36'),
(124, '2', '225', '135'),
(125, '2', '201', '12'),
(126, '5', '39', '59'),
(127, '1', '82', '212'),
(128, '2', '158', '169'),
(129, '2', '237', '159'),
(130, '3', '25', '35'),
(131, '1', '249', '195'),
(132, '3', '159', '163'),
(133, '1', '220', '17'),
(134, '1', '32', '162'),
(135, '2', '172', '121'),
(136, '2', '60', '15'),
(137, '4', '132', '108'),
(138, '2', '157', '180'),
(139, '1', '254', '130'),
(140, '3', '293', '39'),
(141, '2', '265', '210'),
(142, '4', '220', '28'),
(143, '3', '255', '69'),
(144, '2', '171', '96'),
(145, '2', '183', '71'),
(146, '1', '123', '51'),
(147, '1', '85', '49'),
(148, '4', '276', '131'),
(149, '3', '231', '108'),
(150, '4', '282', '70'),
(151, '1', '124', '152'),
(152, '3', '245', '189'),
(153, '5', '110', '172'),
(154, '1', '83', '205'),
(155, '5', '17', '40'),
(156, '4', '172', '107'),
(157, '5', '96', '89'),
(158, '1', '209', '57'),
(159, '5', '43', '189'),
(160, '3', '51', '4'),
(161, '1', '72', '210'),
(162, '2', '295', '209'),
(163, '5', '184', '67'),
(164, '5', '209', '123'),
(165, '5', '33', '157'),
(166, '3', '87', '142'),
(167, '2', '195', '197'),
(168, '4', '65', '204'),
(169, '3', '84', '189'),
(170, '4', '156', '42'),
(171, '2', '96', '206'),
(172, '1', '167', '108'),
(173, '2', '270', '101'),
(174, '1', '296', '75'),
(175, '4', '142', '194'),
(176, '5', '139', '147'),
(177, '5', '57', '125'),
(178, '2', '252', '72'),
(179, '5', '231', '155'),
(180, '4', '166', '94'),
(181, '1', '227', '40'),
(182, '3', '175', '48'),
(183, '2', '211', '111'),
(184, '1', '47', '87'),
(185, '4', '3', '47'),
(186, '5', '162', '44'),
(187, '4', '218', '139'),
(188, '1', '248', '184'),
(189, '3', '63', '114'),
(190, '1', '153', '1'),
(191, '3', '253', '37'),
(192, '2', '217', '203'),
(193, '3', '24', '76'),
(194, '3', '6', '193'),
(195, '1', '94', '13'),
(196, '3', '67', '13'),
(197, '3', '152', '141'),
(198, '3', '214', '104'),
(199, '5', '193', '166'),
(200, '3', '136', '6'),
(201, '1', '88', '116'),
(202, '5', '148', '108'),
(203, '1', '170', '42'),
(204, '2', '88', '24'),
(205, '5', '281', '32'),
(206, '3', '110', '204'),
(207, '4', '67', '151'),
(208, '5', '34', '28'),
(209, '4', '248', '1'),
(210, '3', '39', '50'),
(211, '1', '213', '78'),
(212, '5', '122', '36'),
(213, '5', '179', '173'),
(214, '5', '2', '183'),
(215, '5', '240', '120'),
(216, '3', '222', '25'),
(217, '4', '257', '169'),
(218, '2', '263', '53'),
(219, '1', '170', '72'),
(220, '4', '297', '103'),
(221, '2', '67', '113'),
(222, '2', '270', '10'),
(223, '5', '235', '160'),
(224, '5', '244', '203'),
(225, '5', '294', '181'),
(226, '1', '30', '93'),
(227, '5', '288', '31'),
(228, '3', '161', '105'),
(229, '1', '284', '2'),
(230, '1', '185', '24'),
(231, '4', '16', '8'),
(232, '4', '121', '22'),
(233, '2', '105', '168'),
(234, '1', '249', '204'),
(235, '1', '73', '109'),
(236, '3', '258', '163'),
(237, '1', '37', '26'),
(238, '4', '289', '118'),
(239, '3', '191', '116'),
(240, '5', '45', '119'),
(241, '1', '197', '87'),
(242, '2', '125', '82'),
(243, '3', '295', '124'),
(244, '1', '243', '171'),
(245, '5', '117', '16'),
(246, '5', '12', '202'),
(247, '3', '87', '188'),
(248, '1', '42', '88'),
(249, '4', '194', '28'),
(250, '4', '233', '140'),
(251, '5', '227', '151'),
(252, '4', '123', '182'),
(253, '5', '276', '175'),
(254, '3', '259', '59'),
(255, '4', '129', '80'),
(256, '3', '297', '125'),
(257, '3', '185', '213'),
(258, '3', '163', '43'),
(259, '2', '109', '84'),
(260, '3', '297', '70'),
(261, '2', '104', '57'),
(262, '2', '275', '14'),
(263, '3', '181', '118'),
(264, '5', '220', '15'),
(265, '1', '36', '178'),
(266, '1', '276', '212'),
(267, '3', '273', '155'),
(268, '1', '11', '91'),
(269, '2', '205', '49'),
(270, '4', '167', '6'),
(271, '5', '133', '89'),
(272, '5', '75', '154'),
(273, '5', '292', '161'),
(274, '4', '263', '76'),
(275, '1', '260', '181'),
(276, '1', '159', '12'),
(277, '2', '178', '49'),
(278, '5', '296', '75'),
(279, '2', '193', '18'),
(280, '2', '140', '126'),
(281, '2', '43', '29'),
(282, '3', '36', '162'),
(283, '2', '184', '69'),
(284, '1', '90', '48'),
(285, '5', '149', '120'),
(286, '2', '172', '183'),
(287, '3', '184', '185'),
(288, '3', '165', '51'),
(289, '4', '19', '139'),
(290, '1', '256', '212'),
(291, '5', '112', '96'),
(292, '4', '129', '83'),
(293, '5', '144', '46'),
(294, '5', '107', '125'),
(295, '5', '199', '194'),
(296, '3', '195', '124'),
(297, '4', '185', '20'),
(298, '3', '155', '80'),
(299, '3', '150', '175'),
(300, '1', '239', '104'),
(301, '2', '16', '130'),
(302, '2', '53', '136'),
(303, '1', '294', '180'),
(304, '1', '20', '21'),
(305, '5', '250', '214'),
(306, '1', '186', '204'),
(307, '1', '144', '167'),
(308, '1', '130', '147'),
(309, '4', '43', '38'),
(310, '2', '252', '53'),
(311, '1', '228', '47'),
(312, '3', '268', '135'),
(313, '5', '236', '77'),
(314, '4', '200', '175'),
(315, '5', '23', '115'),
(316, '2', '9', '210'),
(317, '1', '273', '68'),
(318, '2', '52', '99'),
(319, '1', '37', '123'),
(320, '3', '161', '208'),
(321, '5', '161', '192'),
(322, '5', '237', '211'),
(323, '2', '165', '214'),
(324, '1', '294', '47'),
(325, '1', '79', '45'),
(326, '1', '232', '190'),
(327, '2', '248', '85'),
(328, '1', '144', '204'),
(329, '1', '290', '148'),
(330, '3', '107', '104'),
(331, '4', '274', '156'),
(332, '2', '232', '46'),
(333, '1', '30', '104'),
(334, '1', '17', '75'),
(335, '4', '277', '89'),
(336, '5', '115', '183'),
(337, '4', '261', '37'),
(338, '3', '258', '132'),
(339, '1', '154', '108'),
(340, '5', '136', '206'),
(341, '3', '236', '181'),
(342, '4', '217', '114'),
(343, '5', '201', '196'),
(344, '2', '117', '53'),
(345, '5', '191', '149'),
(346, '3', '257', '104'),
(347, '5', '148', '81'),
(348, '5', '183', '43'),
(349, '2', '106', '2'),
(350, '2', '231', '164'),
(351, '2', '143', '13'),
(352, '2', '24', '132'),
(353, '1', '113', '62'),
(354, '1', '195', '58'),
(355, '1', '295', '55'),
(356, '5', '57', '163'),
(357, '5', '63', '143'),
(358, '2', '226', '150'),
(359, '2', '246', '70'),
(360, '4', '163', '79'),
(361, '5', '126', '56'),
(362, '1', '12', '194'),
(363, '1', '293', '83'),
(364, '5', '248', '96'),
(365, '1', '217', '57'),
(366, '4', '233', '99'),
(367, '1', '59', '137'),
(368, '2', '162', '21'),
(369, '3', '120', '155'),
(370, '1', '115', '6'),
(371, '2', '69', '54'),
(372, '4', '237', '95'),
(373, '5', '225', '175'),
(374, '1', '185', '100'),
(375, '4', '169', '164'),
(376, '1', '195', '43'),
(377, '3', '134', '57'),
(378, '5', '223', '102'),
(379, '3', '208', '158'),
(380, '5', '148', '104'),
(381, '5', '263', '18'),
(382, '2', '231', '29'),
(383, '5', '15', '8'),
(384, '5', '265', '38'),
(385, '3', '62', '68'),
(386, '1', '255', '129'),
(387, '5', '119', '145'),
(388, '5', '82', '47'),
(389, '1', '57', '171'),
(390, '2', '130', '14'),
(391, '3', '186', '106'),
(392, '1', '76', '64'),
(393, '2', '180', '203'),
(394, '4', '42', '47'),
(395, '5', '173', '1'),
(396, '1', '290', '124'),
(397, '5', '196', '171'),
(398, '1', '203', '88'),
(399, '4', '46', '1'),
(400, '2', '31', '78'),
(401, '2', '214', '23'),
(402, '4', '58', '213'),
(403, '1', '190', '44'),
(404, '1', '109', '6'),
(405, '5', '163', '39'),
(406, '2', '101', '130'),
(407, '4', '16', '207'),
(408, '5', '116', '175'),
(409, '2', '34', '121'),
(410, '4', '81', '109'),
(411, '5', '71', '170'),
(412, '5', '160', '10'),
(413, '3', '115', '201'),
(414, '4', '104', '132'),
(415, '4', '95', '126'),
(416, '2', '30', '86'),
(417, '3', '119', '23'),
(418, '4', '219', '80'),
(419, '4', '140', '204'),
(420, '3', '224', '47'),
(421, '1', '118', '131'),
(422, '5', '177', '72'),
(423, '5', '247', '205'),
(424, '2', '139', '31'),
(425, '3', '20', '150'),
(426, '5', '175', '19'),
(427, '5', '21', '132'),
(428, '5', '143', '155'),
(429, '5', '142', '206'),
(430, '5', '141', '193'),
(431, '2', '16', '64'),
(432, '4', '225', '74'),
(433, '4', '214', '131'),
(434, '1', '139', '125'),
(435, '2', '1', '132'),
(436, '5', '145', '36'),
(437, '1', '31', '146'),
(438, '1', '213', '204'),
(439, '5', '189', '41'),
(440, '5', '227', '176'),
(441, '4', '83', '185'),
(442, '1', '222', '111'),
(443, '3', '281', '139'),
(444, '3', '83', '8'),
(445, '1', '218', '135'),
(446, '5', '71', '33'),
(447, '5', '144', '130'),
(448, '4', '81', '143'),
(449, '1', '241', '85'),
(450, '3', '180', '194'),
(451, '1', '138', '51'),
(452, '5', '73', '43'),
(453, '5', '178', '35'),
(454, '1', '1', '108'),
(455, '5', '91', '10'),
(456, '1', '28', '43'),
(457, '3', '12', '167'),
(458, '2', '82', '123'),
(459, '3', '282', '192'),
(460, '4', '86', '46'),
(461, '1', '280', '100'),
(462, '2', '54', '52'),
(463, '2', '219', '40'),
(464, '4', '150', '188'),
(465, '5', '208', '101'),
(466, '5', '219', '105'),
(467, '5', '162', '35'),
(468, '1', '250', '95'),
(469, '1', '42', '13'),
(470, '4', '30', '77'),
(471, '2', '149', '160'),
(472, '5', '42', '80'),
(473, '4', '76', '189'),
(474, '4', '181', '16'),
(475, '4', '209', '60'),
(476, '2', '139', '29'),
(477, '3', '61', '170'),
(478, '5', '232', '14'),
(479, '5', '76', '104'),
(480, '3', '206', '21'),
(481, '4', '209', '159'),
(482, '2', '21', '202'),
(483, '3', '18', '134'),
(484, '1', '161', '11'),
(485, '4', '182', '8'),
(486, '4', '2', '152'),
(487, '2', '15', '135'),
(488, '5', '283', '176'),
(489, '3', '133', '122'),
(490, '3', '278', '145'),
(491, '3', '224', '34'),
(492, '2', '190', '60'),
(493, '2', '157', '194'),
(494, '3', '81', '201'),
(495, '2', '165', '8'),
(496, '4', '21', '42'),
(497, '3', '132', '41'),
(498, '5', '91', '144'),
(499, '1', '127', '115'),
(500, '4', '196', '62'),
(501, '2', '231', '146'),
(502, '3', '15', '40'),
(503, '4', '147', '201'),
(504, '5', '21', '77'),
(505, '5', '46', '141'),
(506, '3', '125', '17'),
(507, '2', '148', '147'),
(508, '5', '238', '78'),
(509, '1', '51', '174'),
(510, '2', '53', '163'),
(511, '1', '275', '19'),
(512, '1', '277', '192'),
(513, '3', '290', '212'),
(514, '3', '169', '81'),
(515, '2', '135', '189'),
(516, '1', '277', '4'),
(517, '1', '20', '24'),
(518, '5', '108', '4'),
(519, '5', '95', '133'),
(520, '1', '257', '176'),
(521, '2', '55', '121'),
(522, '2', '77', '39'),
(523, '5', '67', '146'),
(524, '1', '282', '4'),
(525, '4', '68', '16'),
(526, '1', '20', '116'),
(527, '1', '169', '213'),
(528, '2', '167', '86'),
(529, '3', '169', '27'),
(530, '3', '285', '50'),
(531, '5', '285', '68'),
(532, '3', '54', '8'),
(533, '2', '112', '92'),
(534, '1', '88', '50'),
(535, '1', '113', '154'),
(536, '5', '147', '207'),
(537, '3', '83', '153'),
(538, '4', '29', '150'),
(539, '3', '203', '66'),
(540, '1', '283', '39'),
(541, '5', '2', '58'),
(542, '4', '9', '151'),
(543, '3', '204', '196'),
(544, '1', '184', '214'),
(545, '4', '179', '208'),
(546, '3', '59', '61'),
(547, '4', '207', '89'),
(548, '1', '232', '179'),
(549, '2', '105', '114'),
(550, '5', '100', '102'),
(551, '2', '5', '158'),
(552, '3', '8', '40'),
(553, '2', '187', '143'),
(554, '1', '80', '150'),
(555, '3', '215', '52'),
(556, '3', '283', '124'),
(557, '5', '179', '111'),
(558, '3', '116', '160'),
(559, '1', '295', '61'),
(560, '5', '116', '44'),
(561, '1', '27', '73'),
(562, '2', '257', '114'),
(563, '1', '27', '13'),
(564, '4', '106', '39'),
(565, '4', '203', '167'),
(566, '1', '287', '184'),
(567, '2', '105', '123'),
(568, '3', '74', '95'),
(569, '2', '231', '100'),
(570, '1', '124', '125'),
(571, '5', '156', '149'),
(572, '4', '242', '176'),
(573, '2', '83', '135'),
(574, '4', '33', '143'),
(575, '5', '57', '123'),
(576, '4', '146', '192'),
(577, '1', '102', '108'),
(578, '2', '224', '37'),
(579, '3', '90', '112'),
(580, '5', '103', '27'),
(581, '4', '266', '209'),
(582, '2', '10', '83'),
(583, '5', '92', '108'),
(584, '5', '178', '207'),
(585, '2', '123', '153'),
(586, '3', '277', '1'),
(587, '2', '258', '193'),
(588, '3', '26', '141'),
(589, '3', '22', '73'),
(590, '5', '139', '160'),
(591, '4', '260', '177'),
(592, '1', '133', '198'),
(593, '3', '77', '147'),
(594, '4', '233', '124'),
(595, '2', '33', '142'),
(596, '2', '230', '188'),
(597, '3', '49', '48'),
(598, '1', '13', '94'),
(599, '3', '231', '140'),
(600, '5', '234', '41'),
(601, '4', '156', '185'),
(602, '5', '226', '56'),
(603, '4', '292', '93'),
(604, '5', '8', '181'),
(605, '2', '50', '33'),
(606, '3', '116', '33'),
(607, '5', '111', '104'),
(608, '1', '206', '166'),
(609, '4', '213', '119'),
(610, '2', '16', '98'),
(611, '2', '28', '182'),
(612, '2', '255', '9'),
(613, '4', '183', '28'),
(614, '5', '293', '179'),
(615, '3', '153', '115'),
(616, '5', '167', '101'),
(617, '5', '131', '52'),
(618, '1', '12', '124'),
(619, '1', '138', '10'),
(620, '5', '39', '34'),
(621, '2', '148', '57'),
(622, '2', '23', '175'),
(623, '1', '14', '4'),
(624, '1', '149', '150'),
(625, '5', '191', '30'),
(626, '3', '142', '142'),
(627, '3', '190', '207'),
(628, '5', '261', '160'),
(629, '3', '189', '180'),
(630, '1', '23', '208'),
(631, '2', '60', '31'),
(632, '5', '44', '8'),
(633, '4', '80', '63'),
(634, '4', '31', '187'),
(635, '3', '222', '64'),
(636, '2', '216', '1'),
(637, '3', '40', '21'),
(638, '4', '91', '35'),
(639, '2', '153', '172'),
(640, '3', '88', '186'),
(641, '1', '51', '162'),
(642, '4', '146', '55'),
(643, '5', '84', '30'),
(644, '1', '249', '34'),
(645, '2', '204', '96'),
(646, '1', '3', '104'),
(647, '5', '67', '6'),
(648, '3', '247', '148'),
(649, '5', '48', '114'),
(650, '3', '94', '95'),
(651, '1', '196', '148'),
(652, '2', '26', '41'),
(653, '1', '275', '201'),
(654, '3', '286', '34'),
(655, '2', '94', '176'),
(656, '5', '263', '1'),
(657, '3', '136', '84'),
(658, '2', '122', '46'),
(659, '2', '248', '128'),
(660, '5', '122', '184'),
(661, '2', '37', '44'),
(662, '3', '45', '8'),
(663, '1', '181', '202'),
(664, '3', '62', '170'),
(665, '5', '9', '158'),
(666, '4', '79', '19'),
(667, '2', '156', '143'),
(668, '1', '168', '65'),
(669, '4', '255', '32'),
(670, '5', '91', '30'),
(671, '4', '163', '135'),
(672, '5', '34', '14'),
(673, '1', '173', '17'),
(674, '3', '248', '76'),
(675, '1', '250', '41'),
(676, '1', '200', '133'),
(677, '2', '152', '30'),
(678, '4', '77', '131'),
(679, '3', '203', '112'),
(680, '5', '179', '207'),
(681, '1', '24', '185'),
(682, '3', '238', '45'),
(683, '1', '103', '4'),
(684, '5', '93', '51'),
(685, '3', '207', '107'),
(686, '1', '137', '2'),
(687, '2', '266', '22'),
(688, '1', '121', '80'),
(689, '5', '43', '149'),
(690, '2', '202', '202'),
(691, '2', '258', '20'),
(692, '4', '33', '6'),
(693, '1', '286', '102'),
(694, '3', '29', '198'),
(695, '3', '270', '106'),
(696, '3', '40', '13'),
(697, '3', '222', '35'),
(698, '3', '121', '64'),
(699, '4', '166', '46'),
(700, '4', '287', '71'),
(701, '3', '116', '19'),
(702, '3', '181', '43'),
(703, '5', '191', '102'),
(704, '3', '219', '168'),
(705, '2', '274', '175'),
(706, '5', '87', '103'),
(707, '2', '23', '25'),
(708, '2', '129', '112'),
(709, '2', '283', '91'),
(710, '2', '179', '79'),
(711, '2', '123', '198'),
(712, '2', '284', '194'),
(713, '3', '156', '12'),
(714, '2', '136', '89'),
(715, '1', '246', '33'),
(716, '3', '273', '138'),
(717, '5', '208', '78'),
(718, '1', '128', '212'),
(719, '2', '30', '38'),
(720, '4', '150', '80'),
(721, '4', '62', '202'),
(722, '2', '54', '47'),
(723, '3', '193', '53'),
(724, '1', '194', '64'),
(725, '1', '51', '171'),
(726, '5', '284', '10'),
(727, '2', '210', '209'),
(728, '3', '40', '56'),
(729, '4', '46', '39'),
(730, '3', '229', '14'),
(731, '4', '130', '171'),
(732, '2', '185', '183'),
(733, '3', '180', '159'),
(734, '2', '72', '130'),
(735, '1', '296', '199'),
(736, '2', '243', '17'),
(737, '2', '72', '170'),
(738, '2', '244', '172'),
(739, '2', '148', '169'),
(740, '2', '284', '123'),
(741, '3', '250', '3'),
(742, '3', '55', '75'),
(743, '5', '29', '161'),
(744, '1', '213', '124'),
(745, '3', '203', '51'),
(746, '1', '16', '13'),
(747, '2', '215', '50'),
(748, '3', '118', '65'),
(749, '2', '284', '67'),
(750, '5', '114', '147'),
(751, '2', '85', '140'),
(752, '4', '203', '188'),
(753, '1', '87', '2'),
(754, '5', '21', '148'),
(755, '2', '239', '151'),
(756, '5', '257', '163'),
(757, '3', '21', '191'),
(758, '1', '206', '131'),
(759, '5', '89', '136'),
(760, '3', '127', '207'),
(761, '2', '279', '204'),
(762, '4', '201', '171'),
(763, '5', '29', '138'),
(764, '2', '87', '137'),
(765, '2', '256', '34'),
(766, '5', '91', '105'),
(767, '2', '273', '135'),
(768, '5', '184', '212'),
(769, '2', '256', '179'),
(770, '4', '202', '146'),
(771, '3', '265', '127'),
(772, '1', '50', '211'),
(773, '5', '205', '184'),
(774, '3', '85', '74'),
(775, '5', '211', '142'),
(776, '4', '165', '201'),
(777, '2', '252', '188'),
(778, '1', '83', '99'),
(779, '3', '37', '145'),
(780, '4', '149', '132'),
(781, '3', '115', '165'),
(782, '4', '266', '108'),
(783, '1', '13', '106'),
(784, '5', '49', '112'),
(785, '1', '152', '72'),
(786, '1', '123', '40'),
(787, '3', '261', '179'),
(788, '4', '47', '113'),
(789, '5', '36', '203'),
(790, '1', '49', '111'),
(791, '2', '274', '99'),
(792, '1', '141', '89'),
(793, '3', '42', '70'),
(794, '3', '227', '152'),
(795, '1', '43', '161'),
(796, '5', '229', '112'),
(797, '2', '274', '8'),
(798, '1', '151', '172'),
(799, '2', '44', '98'),
(800, '5', '240', '38'),
(801, '1', '248', '102'),
(802, '4', '71', '143'),
(803, '1', '203', '87'),
(804, '3', '191', '127'),
(805, '1', '209', '35'),
(806, '2', '116', '87'),
(807, '2', '261', '43'),
(808, '3', '102', '101'),
(809, '3', '282', '15'),
(810, '4', '31', '58'),
(811, '4', '4', '157'),
(812, '5', '116', '151'),
(813, '1', '265', '81'),
(814, '3', '75', '165'),
(815, '5', '190', '76'),
(816, '4', '243', '95'),
(817, '4', '10', '168'),
(818, '5', '43', '171'),
(819, '3', '244', '177'),
(820, '2', '71', '4'),
(821, '5', '19', '155'),
(822, '3', '96', '112'),
(823, '5', '78', '14'),
(824, '2', '136', '73'),
(825, '2', '229', '54'),
(826, '3', '149', '213'),
(827, '2', '105', '122'),
(828, '5', '53', '164'),
(829, '5', '41', '89'),
(830, '5', '282', '125'),
(831, '2', '117', '207'),
(832, '3', '146', '165'),
(833, '1', '193', '196'),
(834, '1', '11', '164'),
(835, '2', '158', '172'),
(836, '3', '133', '61'),
(837, '4', '294', '129'),
(838, '5', '160', '22'),
(839, '3', '158', '173'),
(840, '2', '226', '34'),
(841, '2', '94', '6'),
(842, '4', '123', '179'),
(843, '5', '272', '61'),
(844, '4', '6', '184'),
(845, '2', '187', '171'),
(846, '4', '108', '16'),
(847, '2', '208', '29'),
(848, '2', '93', '61'),
(849, '3', '269', '153'),
(850, '3', '70', '66'),
(851, '1', '212', '5'),
(852, '4', '12', '104'),
(853, '1', '80', '202'),
(854, '1', '208', '139'),
(855, '1', '61', '169'),
(856, '3', '4', '214'),
(857, '3', '218', '90'),
(858, '2', '270', '60'),
(859, '5', '140', '196'),
(860, '2', '134', '134'),
(861, '5', '258', '127'),
(862, '4', '37', '81'),
(863, '3', '54', '26'),
(864, '3', '152', '103'),
(865, '4', '56', '53'),
(866, '2', '26', '198'),
(867, '4', '52', '123'),
(868, '2', '58', '131'),
(869, '4', '22', '178'),
(870, '2', '273', '13'),
(871, '5', '228', '20'),
(872, '3', '41', '133'),
(873, '4', '210', '193'),
(874, '5', '260', '156'),
(875, '3', '240', '185'),
(876, '2', '225', '54'),
(877, '5', '173', '167'),
(878, '2', '265', '186'),
(879, '4', '45', '175'),
(880, '3', '163', '91'),
(881, '3', '43', '68'),
(882, '3', '41', '168'),
(883, '1', '213', '122'),
(884, '3', '280', '164'),
(885, '5', '101', '190'),
(886, '2', '28', '178'),
(887, '5', '250', '28'),
(888, '2', '61', '105'),
(889, '2', '282', '40'),
(890, '1', '171', '65'),
(891, '1', '75', '28'),
(892, '3', '36', '38'),
(893, '4', '47', '72'),
(894, '1', '66', '212'),
(895, '2', '266', '42'),
(896, '5', '295', '207'),
(897, '1', '277', '197'),
(898, '5', '132', '173'),
(899, '3', '154', '90'),
(900, '4', '114', '152'),
(901, '2', '184', '49'),
(902, '1', '206', '165'),
(903, '3', '291', '73'),
(904, '3', '172', '119'),
(905, '3', '166', '167'),
(906, '4', '17', '127'),
(907, '5', '85', '210'),
(908, '1', '87', '190'),
(909, '3', '101', '96'),
(910, '1', '200', '66'),
(911, '3', '125', '117'),
(912, '5', '94', '97'),
(913, '5', '19', '47'),
(914, '3', '135', '101'),
(915, '5', '97', '50'),
(916, '3', '60', '68'),
(917, '3', '295', '60'),
(918, '1', '164', '182'),
(919, '2', '212', '76'),
(920, '3', '224', '61'),
(921, '2', '226', '149'),
(922, '1', '265', '185'),
(923, '3', '216', '109'),
(924, '3', '93', '85'),
(925, '5', '197', '60'),
(926, '1', '189', '98'),
(927, '4', '33', '4'),
(928, '2', '35', '96'),
(929, '5', '124', '95'),
(930, '3', '297', '166'),
(931, '1', '296', '202'),
(932, '2', '284', '90'),
(933, '3', '125', '193'),
(934, '2', '29', '126'),
(935, '4', '71', '56'),
(936, '1', '91', '91'),
(937, '1', '157', '206'),
(938, '2', '235', '40'),
(939, '4', '286', '134'),
(940, '4', '224', '173'),
(941, '3', '48', '188'),
(942, '3', '109', '76'),
(943, '5', '258', '200'),
(944, '4', '65', '200'),
(945, '4', '252', '65'),
(946, '3', '260', '196'),
(947, '1', '242', '110'),
(948, '3', '195', '102'),
(949, '3', '47', '88'),
(950, '2', '173', '102'),
(951, '2', '97', '80'),
(952, '3', '158', '10'),
(953, '2', '170', '63'),
(954, '2', '160', '2'),
(955, '5', '225', '204'),
(956, '2', '3', '110'),
(957, '1', '243', '136'),
(958, '1', '225', '54'),
(959, '1', '44', '83'),
(960, '4', '58', '121'),
(961, '3', '280', '75'),
(962, '2', '160', '32'),
(963, '4', '47', '190'),
(964, '2', '40', '149'),
(965, '4', '187', '195'),
(966, '3', '229', '8'),
(967, '3', '273', '5'),
(968, '2', '76', '74'),
(969, '4', '70', '110'),
(970, '5', '239', '150'),
(971, '5', '40', '21'),
(972, '4', '31', '119'),
(973, '5', '81', '191'),
(974, '2', '102', '24'),
(975, '1', '142', '136'),
(976, '3', '245', '78'),
(977, '5', '117', '175'),
(978, '1', '110', '74'),
(979, '2', '287', '3'),
(980, '1', '202', '209'),
(981, '5', '102', '106'),
(982, '3', '181', '188'),
(983, '4', '267', '194'),
(984, '3', '79', '142'),
(985, '3', '219', '41'),
(986, '3', '76', '102'),
(987, '2', '239', '193'),
(988, '1', '167', '121'),
(989, '3', '82', '24'),
(990, '1', '293', '165'),
(991, '1', '264', '166'),
(992, '5', '274', '104'),
(993, '4', '154', '92'),
(994, '5', '20', '155'),
(995, '5', '154', '129'),
(996, '1', '144', '54'),
(997, '5', '80', '167'),
(998, '1', '106', '76'),
(999, '4', '171', '103');