run sql=drop table if exists table_amazon_downloading_control run sql=create table table_amazon_downloading_control ( id int NOT NULL AUTO_INCREMENT, manufacture varchar(200) comment 'manufacture', MinimumPrice int comment 'price USD(cents)' , MaximumPrice int comment 'price USD(cents)' ,PRIMARY KEY (id) ) run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('Haier',0,20000),('Haier',20001,40000),('Haier',40001,60000),('Haier',40001,60000),('Haier',60001,80000),('Haier',80001,100000),('Haier',100001,120000),('Haier',120001,150000),('Haier',150001,250000),('Haier',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('AVC',0,20000),('AVC',20001,40000),('AVC',40001,60000),('AVC',40001,60000),('AVC',60001,80000),('AVC',80001,100000),('AVC',100001,120000),('AVC',120001,150000),('AVC',150001,250000),('AVC',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('JVC',0,20000),('JVC',20001,40000),('JVC',40001,60000),('JVC',40001,60000),('JVC',60001,80000),('JVC',80001,100000),('JVC',100001,120000),('JVC',120001,150000),('JVC',150001,250000),('JVC',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('Insignia',0,20000),('Insignia',20001,40000),('Insignia',40001,60000),('Insignia',40001,60000),('Insignia',60001,80000),('Insignia',80001,100000),('Insignia',100001,120000),('Insignia',120001,150000),('Insignia',150001,250000),('Insignia',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('Emerson',0,20000),('Emerson',20001,40000),('Emerson',40001,60000),('Emerson',40001,60000),('Emerson',60001,80000),('Emerson',80001,100000),('Emerson',100001,120000),('Emerson',120001,150000),('Emerson',150001,250000),('Emerson',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('Magnavox',0,20000),('Magnavox',20001,40000),('Magnavox',40001,60000),('Magnavox',40001,60000),('Magnavox',60001,80000),('Magnavox',80001,100000),('Magnavox',100001,120000),('Magnavox',120001,150000),('Magnavox',150001,250000),('Magnavox',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('MEGNAVOX',0,20000),('MEGNAVOX',20001,40000),('MEGNAVOX',40001,60000),('MEGNAVOX',40001,60000),('MEGNAVOX',60001,80000),('MEGNAVOX',80001,100000),('MEGNAVOX',100001,120000),('MEGNAVOX',120001,150000),('MEGNAVOX',150001,250000),('MEGNAVOX',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('PHILIPS',0,20000),('PHILIPS',20001,40000),('PHILIPS',40001,60000),('PHILIPS',40001,60000),('PHILIPS',60001,80000),('PHILIPS',80001,100000),('PHILIPS',100001,120000),('PHILIPS',120001,150000),('PHILIPS',150001,250000),('PHILIPS',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('Sanyo',0,20000),('Sanyo',20001,40000),('Sanyo',40001,60000),('Sanyo',40001,60000),('Sanyo',60001,80000),('Sanyo',80001,100000),('Sanyo',100001,120000),('Sanyo',120001,150000),('Sanyo',150001,250000),('Sanyo',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('LG',0,20000),('LG',20001,40000),('LG',40001,60000),('LG',40001,60000),('LG',60001,80000),('LG',80001,100000),('LG',100001,120000),('LG',120001,150000),('LG',150001,250000),('LG',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('Hitachi',0,20000),('Hitachi',20001,40000),('Hitachi',40001,60000),('Hitachi',40001,60000),('Hitachi',60001,80000),('Hitachi',80001,100000),('Hitachi',100001,120000),('Hitachi',120001,150000),('Hitachi',150001,250000),('Hitachi',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('KONTECH',0,20000),('KONTECH',20001,40000),('KONTECH',40001,60000),('KONTECH',40001,60000),('KONTECH',60001,80000),('KONTECH',80001,100000),('KONTECH',100001,120000),('KONTECH',120001,150000),('KONTECH',150001,250000),('KONTECH',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('Panasonic',0,20000),('Panasonic',20001,40000),('Panasonic',40001,60000),('Panasonic',40001,60000),('Panasonic',60001,80000),('Panasonic',80001,100000),('Panasonic',100001,120000),('Panasonic',120001,150000),('Panasonic',150001,250000),('Panasonic',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('PDI',0,20000),('PDI',20001,40000),('PDI',40001,60000),('PDI',40001,60000),('PDI',60001,80000),('PDI',80001,100000),('PDI',100001,120000),('PDI',120001,150000),('PDI',150001,250000),('PDI',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('Crosley',0,20000),('Crosley',20001,40000),('Crosley',40001,60000),('Crosley',40001,60000),('Crosley',60001,80000),('Crosley',80001,100000),('Crosley',100001,120000),('Crosley',120001,150000),('Crosley',150001,250000),('Crosley',250001,950000) ____________________ 10 records were inserted into table run sql=insert into table_amazon_downloading_control(manufacture,MinimumPrice,MaximumPrice)values('Samsung',0,20000),('Samsung',20001,40000),('Samsung',40001,60000),('Samsung',40001,60000),('Samsung',60001,80000),('Samsung',80001,100000),('Samsung',100001,120000),('Samsung',120001,150000),('Samsung',150001,250000),('Samsung',250001,950000) ____________________ 10 records were inserted into table ----------- Now downloading list for Haier.... price 0 (cents) -> 20000
------------------------ 8 were found for the request Electronics,6459737011,Haier,0,20000 Manufacture matching.................................... First One=haier america Manufacture matching.................................... two items are=haier , haier price=$212.70 -----------Next item price=Too low to display *************** Too low to display ************, but get price from offerlisting -----------Next item Manufacture matching.................................... First One=hastings publishing Manufacture matching.................................... two items are=hastings , haier --------- Manufacture not match. Hastings Publishing vs Haier -----------Next item -----------Next item price=$180.00 -----------Next item Manufacture matching.................................... First One=hastings publishing Manufacture matching.................................... two items are=hastings , haier --------- Manufacture not match. Hastings Publishing vs Haier price=$189.00 -----------Next item Manufacture matching.................................... First One=haier america Manufacture matching.................................... two items are=haier , haier price=$369.78 -----------Next item Manufacture matching.................................... First One=hastings publishing Manufacture matching.................................... two items are=hastings , haier --------- Manufacture not match. Hastings Publishing vs Haier -----------Next item run sql=insert IGNORE into tb_tv_amazon_origin_download (ASIN,upc,PriceAmazon,brand_name,model_number,PageURLAmazon,Title,SalesRank,MediumImageURL,LargeImageURL,Color,EAN,ProductTypeName,ProductGroup,Size,Height,Length,Weigth,Width,MPN,Feature)values ('B00BEU3FU2','080000284341',212.70,'Haier America','LE32F32200','http://www.amazon.com/Haier-LE32F32200-32-Inch-720p-60Hz/dp/B00BEU3FU2%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00BEU3FU2','Haier LE32F32200 32-Inch 720p 60Hz LED HDTV','54832','http://ecx.images-amazon.com/images/I/31Zlsm--RAL._SL160_.jpg','http://ecx.images-amazon.com/images/I/31Zlsm--RAL.jpg','black','0080000284341','TELEVISION','Home Theater',32,21.73,34.71,5.40,18.50,'LE32F32200','32-Inch LED TV;;720p HD Resolution;;Roku Ready;;'),('B00JK1E4HA','688057328409',NULL,'Haier','32D3000','http://www.amazon.com/Haier-32d3000-32-720p-Led-lcd/dp/B00JK1E4HA%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00JK1E4HA','Haier 32d3000 32 720p Led-lcd Tv - 16:9 - Hdtv - Atsc - 170 / 160 - 1366 X 768 - Surround Sound - 3 X Hdmi - Usb','28251','http://ecx.images-amazon.com/images/I/41pNgIiKLKL._SL160_.jpg','http://ecx.images-amazon.com/images/I/41pNgIiKLKL.jpg',NULL,'0688057328409','TELEVISION','CE',NULL,0,0,0,0,'32D3000','Multiple A/V Inputs, Including 3 HDMI;;720p and 16:9;;'),('B004UK72IE','688057327099',249.99,'Hastings Publishing','LE22B13800','http://www.amazon.com/Haier-LE22B13800-22-Inch-1080p-60HzLED/dp/B004UK72IE%3Fpsc%3D1%26SubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB004UK72IE','Haier LE22B13800 22-Inch 1080p 60HzLED HDTV','175563','http://ecx.images-amazon.com/images/I/41s%2BLKCWkFL._SL160_.jpg','http://ecx.images-amazon.com/images/I/41s%2BLKCWkFL.jpg','Black','0688057327099','TELEVISION','Home Theater',22,14.01,21.06,7.10,0.98,'LE22B13800','22\" LED HDTV;;Ultra Slim LED HDTV;;720p HD Resolution;;1920 x 1080 Native Resolution;;3W/channel speakers;;'),('B003QFOO3K','688057326030',699.99,'HAIER','HL26P2','http://www.amazon.com/Haier-HL26P2-26-720p-LCD/dp/B003QFOO3K%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB003QFOO3K','Haier HL26P2 HL26P2 26 720p LCD TV','330297','http://ecx.images-amazon.com/images/I/31jQn98yngL._SL160_.jpg','http://ecx.images-amazon.com/images/I/31jQn98yngL.jpg',NULL,'0688057326030','CONSUMER_ELECTRONICS','CE',NULL,0,0,0,0,'HL26P2','Traditional CCFL Backlight For 800 To 1 Native Contrast Ratio;;PC VGA Input And Headphone Out;;Inputs: 2 HDMI, 1 Component, 1 AV, 1 VGA, Mini Analog Out;;Dimensions On Stand (WHD): 25.98\" X 19.69\" X 8.46\";;'),('B004UK71HQ','763615910330',180.00,'Haier','L19B1120','http://www.amazon.com/Haier-L19B1120-19-Inch-720p-60Hz/dp/B004UK71HQ%3Fpsc%3D1%26SubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB004UK71HQ','Haier L19B1120 19-Inch 720p 60Hz LCD HDTV','183648','http://ecx.images-amazon.com/images/I/51vMstWjSqL._SL160_.jpg','http://ecx.images-amazon.com/images/I/51vMstWjSqL.jpg','Black','0688057327136','TELEVISION','Home Theater',19,13.62,5.51,9.30,18.11,'L19B1120','19\" LCD color display;;720p resolution;;PC input, A/V input, USB input, HDMI input & component input;;Includes full tilt stand & remote;;1-year parts warranty;;'),('B004UK71HG','688057326986',189.00,'Hastings Publishing','L22B1120','http://www.amazon.com/Haier-L22B1120-21-6-Inch-720p-Black/dp/B004UK71HG%3Fpsc%3D1%26SubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB004UK71HG','Haier L22B1120 21.6-Inch 720p 60Hz LCD HDTV (Black)','231417','http://ecx.images-amazon.com/images/I/41qwHHT8hML._SL160_.jpg','http://ecx.images-amazon.com/images/I/41qwHHT8hML.jpg','Black','0688057326986','TELEVISION','Home Theater',6,13.86,20.87,12.60,3.82,'L22B1120','22\" LCD HDTV;;Slim LCD HDTV;;720p HD Resolution;;1400 x 900 Native Resolution;;3W/channel speakers;;'),('B007ZT45U0','688057327549',369.78,'Haier America','LE39F2280','http://www.amazon.com/Haier-LE39F2280-39-Inch-1080p-60Hz/dp/B007ZT45U0%3Fpsc%3D1%26SubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB007ZT45U0','Haier LE39F2280 39-Inch 1080p 60Hz LED HDTV','57471','http://ecx.images-amazon.com/images/I/51O7BegPxdL._SL160_.jpg','http://ecx.images-amazon.com/images/I/51O7BegPxdL.jpg','Black','0688057327549','TELEVISION','Home Theater',39,28.00,42.44,28.00,6.97,'LE39F2280','1080p Full HDTV;;Integrated ATSC/NTSC/QAM Tuners;;Auto Volume Leveler (AVL);;Multiple A/V inputs, including 2 HDMI and 1 Component;;'),('B004OBYWNC','688057326900',259.99,'Hastings Publishing','L24B1180','http://www.amazon.com/Haier-L24B1180-23-6-Inch-1080p-Black/dp/B004OBYWNC%3Fpsc%3D1%26SubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB004OBYWNC','Haier L24B1180 23.6-Inch 1080p 60Hz LCD HDTV (Black)','142111','http://ecx.images-amazon.com/images/I/51TxXZFDfgL._SL160_.jpg','http://ecx.images-amazon.com/images/I/51TxXZFDfgL.jpg','Black','0688057326900','TELEVISION','Home Theater',6,17.64,25.98,12.00,4.09,'L24B1180','24\" LCD HDTV;;Slim LCD HDTV;;Full HD 1080p Resolution;;1920 x 1080 Native Resolution;;3W/channel speakers;;') 0 records were Insert records into the table tb_tv_amazon_origin_download in this page &&&&&&&&&&&&&&&&&&&&&&&&& The returned count(0) doesnot match the supposed (8) ...........................page 1 is downloaded. Now go to page 2 ___________________ Total 0 records were downloaded. ________________ ************************ total time consumption=1.00543284416 seconds ********************* ------------------------ 0 were found for the request Electronics,6463520011,Haier,0,20000 ------------------------ 0 were found for the request Electronics,6459738011,Haier,0,20000 run sql=delete from table_amazon_downloading_control where id=1 ...................... process record id=1 is done. Record is removed from the task list ***********************
run sql=update processcontrol set ProcessStatus='DownloadingPrice',RecOffset=0,RecCount=0 where id=1 ----------- Now downloading list for Haier.... price 20001 (cents) -> 40000
------------------------ 12 were found for the request Electronics,6459737011,Haier,20001,40000 --------- Manufacture not match. TCL vs Haier price=$278.88 -----------Next item Manufacture matching.................................... First One=haier america Manufacture matching.................................... two items are=haier , haier price=$333.50 -----------Next item price=$229.99 -----------Next item price=$319.99 -----------Next item price=$399.99 -----------Next item price=$599.99 this is not a valid model..UPC=NULL. Model='48D3500' ASIN='B00JFGS804' -----------Next item Manufacture matching.................................... First One=hastings publishing Manufacture matching.................................... two items are=hastings , haier --------- Manufacture not match. Hastings Publishing vs Haier price=$389.99 -----------Next item Manufacture matching.................................... First One=haier america Manufacture matching.................................... two items are=haier , haier -----------Next item Manufacture matching.................................... First One=hastings publishing Manufacture matching.................................... two items are=hastings , haier --------- Manufacture not match. Hastings Publishing vs Haier price=$381.03 -----------Next item Manufacture matching.................................... First One=haier america Manufacture matching.................................... two items are=haier , haier price=$389.99 -----------Next item run sql=insert IGNORE into tb_tv_amazon_origin_download (ASIN,upc,PriceAmazon,brand_name,model_number,PageURLAmazon,Title,SalesRank,MediumImageURL,LargeImageURL,Color,EAN,ProductTypeName,ProductGroup,Size,Height,Length,Weigth,Width,MPN,Feature)values ('B00BP5N498','883291100532',278.88,'TCL','LE40FHDE3010','http://www.amazon.com/TCL-LE40FHDE3010-40-Inch-1080p-60Hz/dp/B00BP5N498%3Fpsc%3D1%26SubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00BP5N498','TCL LE40FHDE3010 40-Inch 1080p 60Hz LED TV','467','http://ecx.images-amazon.com/images/I/416bLnX49%2BL._SL160_.jpg','http://ecx.images-amazon.com/images/I/416bLnX49%2BL.jpg','Black','0846042001441','TELEVISION','Home Theater',40,22.20,36.80,15.20,3.70,'LE40FHDE3010','Refresh Rate: 60Hz;;Backlight: LED (Full Array);;Smart Functionality: No;;Dimensions (W x H x D): TV without stand: 36.8\" x 22.2\" x 3.7\'\', TV with stand: 36.8\" x 24.4\" x 9.4\'\';;Inputs: 3 HDMI, 1 MHL, 1 USB;;Accessories Included: Remote Control with Batteries;;'),('B00GMM94CK','688057327921',333.50,'Haier America','LE39F32800','http://www.amazon.com/Haier-America-LE39F32800-39-Inch-1080p/dp/B00GMM94CK%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00GMM94CK','Haier America LE39F32800 39-Inch 1080p 60Hz LED TV','86013','http://ecx.images-amazon.com/images/I/510Bq9Xy34L._SL160_.jpg','http://ecx.images-amazon.com/images/I/510Bq9Xy34L.jpg',NULL,'0688057327921','TELEVISION','Home Theater',39,23.61,35.72,6.97,9.82,'LE39F32800','39-Inch television;;LED HDTV;;1080p/60Hz;;'),('B00PYML2G0','688057328614',229.99,'HAIER','32D2000','http://www.amazon.com/HAIER-32D2000-32-720P-LED/dp/B00PYML2G0%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00PYML2G0','HAIER 32D2000 32\" 720P HD LED TV','51607','http://ecx.images-amazon.com/images/I/51reVL1uxJL._SL160_.jpg','http://ecx.images-amazon.com/images/I/51reVL1uxJL.jpg',NULL,'0688057328614','TELEVISION','CE',32,19.20,6.70,11.70,29.10,'32D2000','720P HD;;AUTO VOLUME LEVELER (AVL);;MULTIPLE A/V INPUTS;;INTEGRATED STEREO SPEAKERS;;DIRECT LED BACKLIGHT;;'),('B00JFGS606','688057328539',319.99,'Haier','40D3500M','http://www.amazon.com/Haier-40d3500m-40-1080p-Led-lcd/dp/B00JFGS606%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00JFGS606','Haier 40d3500m 40 1080p Led-lcd Tv - 16:9 - Hdtv 1080p - Atsc - 170 / 160 - 1920 X 1080 - Surround Sound - 3 X Hdmi - Usb','149399','http://ecx.images-amazon.com/images/I/318tysZ%2BblL._SL160_.jpg','http://ecx.images-amazon.com/images/I/318tysZ%2BblL.jpg',NULL,'0688057328539','TELEVISION','CE',NULL,0,0,9.08,0,'40D3500M','40 LED HDTV 40D3500M Remote Control;;Full HD 1920x1080p resolution;;60Hz refresh rate;;1,000,000:1 dynamic contrast ratio;;170-/160-degree vertical/horizontal viewing angles;;'),('B00PWQ8XD8','688057328713',399.99,'Haier','40DR3505','http://www.amazon.com/Haier-40DR3505-Full-1080p-Streaming/dp/B00PWQ8XD8%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00PWQ8XD8','Haier 40DR3505 40\" Full HD 1080p LED TV with Roku Streaming',NULL,'http://ecx.images-amazon.com/images/I/513a00TUHqL._SL160_.jpg','http://ecx.images-amazon.com/images/I/513a00TUHqL.jpg',NULL,'0688057328713','TELEVISION','CE',40,21.90,9.80,0,35.70,'40DR3505','1080P FULL HD;;INCLUDES ROKU STREAMING STICK;;SOUND CHAMBER FOR ENHANCED SOUND;;THIN FRAME - BEZEL - LESS THAN 1/2\";;MUSIC AND PHOTO FILE PLAYBACK VIA USB;;'),('B008005TXU','688057327556',389.99,'Hastings Publishing','LE42F2280','http://www.amazon.com/Haier-LE42F2280-42-Inch-1080p-Black/dp/B008005TXU%3Fpsc%3D1%26SubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB008005TXU','Haier LE42F2280 42-Inch 1080p 60Hz LED HDTV (Black)','318960','http://ecx.images-amazon.com/images/I/31lCimSSc8L._SL160_.jpg','http://ecx.images-amazon.com/images/I/31lCimSSc8L.jpg','Black','0688057327556','TELEVISION','Home Theater',42,2.56,38.11,32.00,23.15,'LE42F2280','1080p delivers the highest quality picture possible from a high-definition source;;Edge-lit LED backlight with ultra-slim design;;Multiple A/V inputs, including 3 HDMI and 1 Component;;Music, photo and video file playback via USB port;;Headphone jack and coaxial output and Full function remote control; Wall mountable (VESA compliant);;'),('B0035EQMXW','688057324999',749.99,'Haier America','HL42XD2','http://www.amazon.com/Haier-HL42XD2-42-Inch-1080p-Series/dp/B0035EQMXW%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0035EQMXW','Haier HL42XD2 42-Inch 1080p D Series LCD HDTV','374872','http://ecx.images-amazon.com/images/I/51V5GtU97TL._SL160_.jpg','http://ecx.images-amazon.com/images/I/51V5GtU97TL.jpg','Black','0688057324999','TELEVISION','CE',42,27.71,40.00,45.10,11.00,'HL42XD2','42-inch LCD TV with piano black cabinet;;Full HD 1080p;;2 HDMI inputs, PC input, 2 component inputs, 1 AV input;;USB input playback for MP3 and JPEG;;2x10W output;;42\" Lcd Color Display;;1080P Resolution;;Integrated Atsc/Ntsc/Qam Tuners;;3D Digital Comb Filter;;'),('B008005UIY','688057327679',381.03,'Hastings Publishing','LE39D2380','http://www.amazon.com/Haier-LE39D2380-39-Inch-1080p-Black/dp/B008005UIY%3Fpsc%3D1%26SubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB008005UIY','Haier LE39D2380 39-Inch 1080p 60Hz LED HDTV (Black)','250225','http://ecx.images-amazon.com/images/I/51O7BegPxdL._SL160_.jpg','http://ecx.images-amazon.com/images/I/51O7BegPxdL.jpg','Black','0688057327679','TELEVISION','Home Theater',39,2.56,34.88,22.70,21.26,'LE39D2380','1080p delivers the highest quality picture possible from a high-definition source;;Integrated ATSC/NTSC/QAM Tuners;;Multiple A/V inputs, including 2 HDMI and 1 Component;;Music, photo and video file playback via USB port;;Headphone jack and coaxial output and Full function remote control; Wall mountable (VESA compliant);;'),('B008809VFO','688057327426',389.99,'Haier America','LE24SCB20Bundle','http://www.amazon.com/Haier-24-Inch-1080p-60Hz-Soundbar/dp/B008809VFO%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB008809VFO','Haier 24-Inch 1080p 60Hz LCD HDTV with Soundbar','123527','http://ecx.images-amazon.com/images/I/51YW4xqjWIL._SL160_.jpg','http://ecx.images-amazon.com/images/I/51YW4xqjWIL.jpg',NULL,'0688057327426','TELEVISION','Home Theater',24,20.00,27.00,20.00,11.50,'LE24SCB20Bundle','Haier LE24B13200 Core Series 24-Inch Ultra Slim LED HDTV and the Haier SBC20 20-Inch, 2-channel soundbar;;Ultra Slim LED HDTV;;Full HD 1080p Resolution;;1920 x 1080 Native Resolution;;Includes 2-Channel Soundbar with iPod/iPhone/iPad dock;;') 0 records were Insert records into the table tb_tv_amazon_origin_download in this page &&&&&&&&&&&&&&&&&&&&&&&&& The returned count(0) doesnot match the supposed (9) ...........................page 1 is downloaded. Now go to page 2 --------- Manufacture not match. Philips vs Haier -----------Next item --------- Manufacture not match. Vizta vs Haier price=$219.99 this is not a valid model..UPC='091037385918'. Model=NULL ASIN='B0096V1Q1G' -----------Next item run sql=insert IGNORE into tb_tv_amazon_origin_download (ASIN,upc,PriceAmazon,brand_name,model_number,PageURLAmazon,Title,SalesRank,MediumImageURL,LargeImageURL,Color,EAN,ProductTypeName,ProductGroup,Size,Height,Length,Weigth,Width,MPN,Feature)values ('B001C9FDUU','609585152366',1998.00,'Philips','42TA648BX/37','http://www.amazon.com/Philips-Factory-Refurbished-42TA648BX-37/dp/B001C9FDUU%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB001C9FDUU','Philips Factory Refurbished 42TA648BX/37 42\" 1080p HD LCD TV','640296','http://ecx.images-amazon.com/images/I/41zESJkf7DL._SL160_.jpg','http://ecx.images-amazon.com/images/I/41zESJkf7DL.jpg',NULL,'0609585152366','TELEVISION','Home Theater',42,25.39,3.48,0,41.19,'42TA648BX/37','Full HD LCD display, with a 1920x1080p resolution;;ATSC & QAM tuner receives over the air and unscrambled cable;;Invisible speakers with incredible surround / USB for fantastic photo and music playback;;ATSC & QAM tuner receives over the air and unscrambled cable /25 watt with BBE for powerful sound and great voice clarity;;4 HDMI inputs for full digital HD connection in one cable / Dolby Digital output for connection to a home theatre system;;') 0 records were Insert records into the table tb_tv_amazon_origin_download in this page &&&&&&&&&&&&&&&&&&&&&&&&& The returned count(0) doesnot match the supposed (1) .....................................page 2 is downloaded. ___________________ Total 0 records were downloaded. ________________ ************************ total time consumption=2.00938510895 seconds ********************* ------------------------ 0 were found for the request Electronics,6463520011,Haier,20001,40000 ------------------------ 0 were found for the request Electronics,6459738011,Haier,20001,40000 run sql=delete from table_amazon_downloading_control where id=2 ...................... process record id=2 is done. Record is removed from the task list ***********************
----------- Now downloading list for Haier.... price 40001 (cents) -> 60000
------------------------ 7 were found for the request Electronics,6459737011,Haier,40001,60000 price=$549.99 -----------Next item price=$479.99 -----------Next item Manufacture matching.................................... First One=haier america Manufacture matching.................................... two items are=haier , haier price=$595.75 -----------Next item price=$474.99 -----------Next item price=$595.75 -----------Next item Manufacture matching.................................... First One=haier america Manufacture matching.................................... two items are=haier , haier price=$475.83 this is not a valid model..UPC=NULL. Model=NULL ASIN='B00C2GFC94' -----------Next item --------- Manufacture not match. Samsung vs Haier -----------Next item run sql=insert IGNORE into tb_tv_amazon_origin_download (ASIN,upc,PriceAmazon,brand_name,model_number,PageURLAmazon,Title,SalesRank,MediumImageURL,LargeImageURL,Color,EAN,ProductTypeName,ProductGroup,Size,Height,Length,Weigth,Width,MPN,Feature)values ('B00PWQSYGE','688057328690',549.99,'HAIER','48DR3505','http://www.amazon.com/HAIER-48DR3505-FULL-1080P-STREAMING/dp/B00PWQSYGE%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00PWQSYGE','HAIER 48DR3505 48\" FULL HD 1080P LED TV WITH ROKU STREAMING','201721','http://ecx.images-amazon.com/images/I/513a00TUHqL._SL160_.jpg','http://ecx.images-amazon.com/images/I/513a00TUHqL.jpg',NULL,'0688057328690','TELEVISION','CE',48,26.20,9.80,23.30,42.70,'48DR3505','1080P FULL HD;;INCLUDES ROKU STREAMING STICK;;MULTIPLE A/V INPUTS;;THIN FRAME - BEZEL - LESS THAN 1/2\";;MUSIC AND PHOTO FILE PLAYBACK VIA USB;;'),('B00TOZ3PZY','688057328775',479.99,'HAIER','50E3500','http://www.amazon.com/HAIER-50E3500-FULL-1080P-HDTV/dp/B00TOZ3PZY%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00TOZ3PZY','HAIER 50E3500 50\" FULL HD 1080P LED HDTV',NULL,'http://ecx.images-amazon.com/images/I/51cdgSY4VsL._SL160_.jpg','http://ecx.images-amazon.com/images/I/51cdgSY4VsL.jpg',NULL,'0688057328775','TELEVISION','Home Theater',50,27.40,10.20,0,44.40,'50E3500','1080P FULL HD;;3 HDMI INPUTS;;1 MHL ENABLED / 1 USB PORT;;INTEGRATED STEREO SPEAKERS;;DIRECT LED BACKLIGHT;;'),('B00BLX83G8','688057327792',595.75,'Haier America','LE50F2280','http://www.amazon.com/Haier-50-Inch-1080p-60Hz-LE50F2280/dp/B00BLX83G8%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00BLX83G8','Haier 50-Inch 1080p 60Hz LED HDTV (LE50F2280)','233397','http://ecx.images-amazon.com/images/I/51n%2BrGZ9C4L._SL160_.jpg','http://ecx.images-amazon.com/images/I/51n%2BrGZ9C4L.jpg','Black','0080000284389','TELEVISION','Home Theater',50,11.02,45.19,39.60,29.06,'LE50F2280','Integrated ATSC /NTSC /QAM tuners;;Energy Star 5.3; RoHS compliant;;Multiple A/V inputs, including 2 HDMI and 1 USB port;;Music and photo file playback via USB port;;Headphone jack and coaxial output;;'),('B00LUV8N6G','688057328461',474.99,'Haier','50D3505','http://www.amazon.com/Haier-50D3505-50d3505/dp/B00LUV8N6G%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00LUV8N6G','50d3505',NULL,'http://ecx.images-amazon.com/images/I/41bAjB5xyuL._SL160_.jpg','http://ecx.images-amazon.com/images/I/41bAjB5xyuL.jpg',NULL,'0688057328461','TELEVISION','Home Theater',NULL,0,0,32.00,0,'50D3505','LED HDTV;;50.0\" Measured Diagonally;;1080p Display Resolution;;3 HDMI Inputs & 1 PC Input;;44.3(w) X 25.7(h) X 3.0(d);;'),('B00E8JLLCK','080000541390',595.75,'HAIER','HERLE50F2280','http://www.amazon.com/HAIER-LE50F2280-1080P-DIRECT-HDTV/dp/B00E8JLLCK%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00E8JLLCK','HAIER LE50F2280 50\" 1080P 60 HZ DIRECT LED HDTV',NULL,'http://ecx.images-amazon.com/images/I/51a%2BdQkb0%2BL._SL160_.jpg','http://ecx.images-amazon.com/images/I/51a%2BdQkb0%2BL.jpg',NULL,'0080000541390','HOME_THEATER_SYSTEM_OR_HTIB','Home Theater',50,0,0,39.00,0,'HERLE50F2280',NULL),('B002ARKDS0','036725229198',1299.99,'Samsung','LN40B540','http://www.amazon.com/Samsung-LN40B540P-LCD-1080P-HDMI/dp/B002ARKDS0%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB002ARKDS0','Samsung LN40B540P 40\" LCD TV 1080P 3 HDMI','570795','http://ecx.images-amazon.com/images/I/41FdaFIgfTL._SL160_.jpg','http://ecx.images-amazon.com/images/I/41FdaFIgfTL.jpg','black','0036725229198','TELEVISION','CE',40,0,0,45.00,0,'LN40B540P','1080p Resolution;;60,000:1 Dynamic Contrast Ratio;;Touch of Color design;;6ms Response Time;;Energy Star compliant;;') 0 records were Insert records into the table tb_tv_amazon_origin_download in this page &&&&&&&&&&&&&&&&&&&&&&&&& The returned count(0) doesnot match the supposed (6) ...........................page 1 is downloaded. Now go to page 2 ___________________ Total 0 records were downloaded. ________________ ************************ total time consumption=1.00467705727 seconds ********************* ------------------------ 0 were found for the request Electronics,6463520011,Haier,40001,60000 ------------------------ 1 were found for the request Electronics,6459738011,Haier,40001,60000 --------- Manufacture not match. Panasonic vs Haier -----------Next item run sql=insert IGNORE into tb_tv_amazon_origin_download (ASIN,upc,PriceAmazon,brand_name,model_number,PageURLAmazon,Title,SalesRank,MediumImageURL,LargeImageURL,Color,EAN,ProductTypeName,ProductGroup,Size,Height,Length,Weigth,Width,MPN,Feature)values ('B002643EY2','037988242306',999.99,'Panasonic','TC-42PX14','http://www.amazon.com/Panasonic-VIERA-TC-42PX14-Inch-Plasma/dp/B002643EY2%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB002643EY2','Panasonic VIERA X1 series TC-42PX14 42 Inch 720p Plasma HDTV','389879','http://ecx.images-amazon.com/images/I/31iNe5aBtLL._SL160_.jpg','http://ecx.images-amazon.com/images/I/31iNe5aBtLL.jpg',NULL,'0037988242306','CONSUMER_ELECTRONICS','CE',NULL,0,0,0,0,'TC-42PX14','X14 Series Plasma HDTV, 720p HDTV;;600Hz Sub-field Drive;;Contrast Ratio Native: 15,000:1;;Aspect Ratio 16:9;;') 0 records were Insert records into the table tb_tv_amazon_origin_download in this page &&&&&&&&&&&&&&&&&&&&&&&&& The returned count(0) doesnot match the supposed (1) ...........................page 1 is downloaded. Now go to page 2 ___________________ Total 0 records were downloaded. ________________ ************************ total time consumption=1.00344896317 seconds ********************* run sql=delete from table_amazon_downloading_control where id=3 ...................... process record id=3 is done. Record is removed from the task list ***********************
----------- Now downloading list for Haier.... price 40001 (cents) -> 60000
------------------------ 7 were found for the request Electronics,6459737011,Haier,40001,60000 price=$549.99 -----------Next item price=$479.99 -----------Next item Manufacture matching.................................... First One=haier america Manufacture matching.................................... two items are=haier , haier price=$595.75 -----------Next item price=$474.99 -----------Next item price=$595.75 -----------Next item Manufacture matching.................................... First One=haier america Manufacture matching.................................... two items are=haier , haier price=$475.83 this is not a valid model..UPC=NULL. Model=NULL ASIN='B00C2GFC94' -----------Next item --------- Manufacture not match. Samsung vs Haier -----------Next item run sql=insert IGNORE into tb_tv_amazon_origin_download (ASIN,upc,PriceAmazon,brand_name,model_number,PageURLAmazon,Title,SalesRank,MediumImageURL,LargeImageURL,Color,EAN,ProductTypeName,ProductGroup,Size,Height,Length,Weigth,Width,MPN,Feature)values ('B00PWQSYGE','688057328690',549.99,'HAIER','48DR3505','http://www.amazon.com/HAIER-48DR3505-FULL-1080P-STREAMING/dp/B00PWQSYGE%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00PWQSYGE','HAIER 48DR3505 48\" FULL HD 1080P LED TV WITH ROKU STREAMING','201721','http://ecx.images-amazon.com/images/I/513a00TUHqL._SL160_.jpg','http://ecx.images-amazon.com/images/I/513a00TUHqL.jpg',NULL,'0688057328690','TELEVISION','CE',48,26.20,9.80,23.30,42.70,'48DR3505','1080P FULL HD;;INCLUDES ROKU STREAMING STICK;;MULTIPLE A/V INPUTS;;THIN FRAME - BEZEL - LESS THAN 1/2\";;MUSIC AND PHOTO FILE PLAYBACK VIA USB;;'),('B00TOZ3PZY','688057328775',479.99,'HAIER','50E3500','http://www.amazon.com/HAIER-50E3500-FULL-1080P-HDTV/dp/B00TOZ3PZY%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00TOZ3PZY','HAIER 50E3500 50\" FULL HD 1080P LED HDTV',NULL,'http://ecx.images-amazon.com/images/I/51cdgSY4VsL._SL160_.jpg','http://ecx.images-amazon.com/images/I/51cdgSY4VsL.jpg',NULL,'0688057328775','TELEVISION','Home Theater',50,27.40,10.20,0,44.40,'50E3500','1080P FULL HD;;3 HDMI INPUTS;;1 MHL ENABLED / 1 USB PORT;;INTEGRATED STEREO SPEAKERS;;DIRECT LED BACKLIGHT;;'),('B00BLX83G8','688057327792',595.75,'Haier America','LE50F2280','http://www.amazon.com/Haier-50-Inch-1080p-60Hz-LE50F2280/dp/B00BLX83G8%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00BLX83G8','Haier 50-Inch 1080p 60Hz LED HDTV (LE50F2280)','233397','http://ecx.images-amazon.com/images/I/51n%2BrGZ9C4L._SL160_.jpg','http://ecx.images-amazon.com/images/I/51n%2BrGZ9C4L.jpg','Black','0080000284389','TELEVISION','Home Theater',50,11.02,45.19,39.60,29.06,'LE50F2280','Integrated ATSC /NTSC /QAM tuners;;Energy Star 5.3; RoHS compliant;;Multiple A/V inputs, including 2 HDMI and 1 USB port;;Music and photo file playback via USB port;;Headphone jack and coaxial output;;'),('B00LUV8N6G','688057328461',474.99,'Haier','50D3505','http://www.amazon.com/Haier-50D3505-50d3505/dp/B00LUV8N6G%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00LUV8N6G','50d3505',NULL,'http://ecx.images-amazon.com/images/I/41bAjB5xyuL._SL160_.jpg','http://ecx.images-amazon.com/images/I/41bAjB5xyuL.jpg',NULL,'0688057328461','TELEVISION','Home Theater',NULL,0,0,32.00,0,'50D3505','LED HDTV;;50.0\" Measured Diagonally;;1080p Display Resolution;;3 HDMI Inputs & 1 PC Input;;44.3(w) X 25.7(h) X 3.0(d);;'),('B00E8JLLCK','080000541390',595.75,'HAIER','HERLE50F2280','http://www.amazon.com/HAIER-LE50F2280-1080P-DIRECT-HDTV/dp/B00E8JLLCK%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00E8JLLCK','HAIER LE50F2280 50\" 1080P 60 HZ DIRECT LED HDTV',NULL,'http://ecx.images-amazon.com/images/I/51a%2BdQkb0%2BL._SL160_.jpg','http://ecx.images-amazon.com/images/I/51a%2BdQkb0%2BL.jpg',NULL,'0080000541390','HOME_THEATER_SYSTEM_OR_HTIB','Home Theater',50,0,0,39.00,0,'HERLE50F2280',NULL),('B002ARKDS0','036725229198',1299.99,'Samsung','LN40B540','http://www.amazon.com/Samsung-LN40B540P-LCD-1080P-HDMI/dp/B002ARKDS0%3FSubscriptionId%3DAKIAILBJQ5IZAEKBWFLQ%26tag%3Dchange_iot%26linkCode%3Dsp1%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB002ARKDS0','Samsung LN40B540P 40\" LCD TV 1080P 3 HDMI','570795','http://ecx.images-amazon.com/images/I/41FdaFIgfTL._SL160_.jpg','http://ecx.images-amazon.com/images/I/41FdaFIgfTL.jpg','black','0036725229198','TELEVISION','CE',40,0,0,45.00,0,'LN40B540P','1080p Resolution;;60,000:1 Dynamic Contrast Ratio;;Touch of Color design;;6ms Response Time;;Energy Star compliant;;') 0 records were Insert records into the table tb_tv_amazon_origin_download in this page &&&&&&&&&&&&&&&&&&&&&&&&& The returned count(0) doesnot match the supposed (6) ...........................page 1 is downloaded. Now go to page 2 ___________________ Total 0 records were downloaded. ________________ ************************ total time consumption=1.00407791138 seconds *********************