HEX
Server: Apache/2.2.15 (CentOS)
System: Linux ip-10-0-2-146.eu-west-1.compute.internal 2.6.32-754.35.1.el6.centos.plus.x86_64 #1 SMP Sat Nov 7 11:33:42 UTC 2020 x86_64
User: root (0)
PHP: 5.6.40
Disabled: NONE
$ pwd: /www/exchange0old/sql/archive/
Upload Files
File: /www/exchange0old/sql/archive/2016-01-20-346.sql
DELETE FROM `risk_credit` WHERE `risk_credit_id`=843 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=200 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=228 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=279 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=280 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=410 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=411 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=412 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=413 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=414 LIMIT 1;

DELETE FROM `risk_credit` WHERE `risk_credit_id`=415 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=416 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=417 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=418 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=419 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=488 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=489 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=490 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=491 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=492 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=493 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=494 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=495 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=496 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=497 LIMIT 1;

DELETE FROM `risk_credit` WHERE `risk_credit_id`=498 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=499 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=500 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=501 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=502 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=503 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=503 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=504 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=505 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=506 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=507 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=508 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=509 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=510 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=511 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=512 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=513 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=514 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=515 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=516 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=517 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=518 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=520 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=521 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=522 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=523 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=524 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=525 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=526 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=527 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=528 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=529 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=530 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=532 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=533 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=534 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=535 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=536 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=537 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=538 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=539 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=540 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=541 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=691 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=692 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=693 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=694 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=695 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=696 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=697 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=698 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=699 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=700 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=701 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=702 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=703 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=704 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=705 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=706 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=707 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=708 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=779 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=827 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=828 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=829 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=830 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=831 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=832 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=833 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=834 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=835 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=836 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=837 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=838 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=840 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=841 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=844 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=845 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=953 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=954 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=955 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=957 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=958 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=959 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=960 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=961 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=962 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=963 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=992 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=964 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=965 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=966 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=967 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=968 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=969 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=970 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=972 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=973 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=974 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=975 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=976 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=977 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=978 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=1007 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=979 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=980 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=981 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=982 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=983 LIMIT 1;
DELETE FROM `risk_credit` WHERE `risk_credit_id`=1392 LIMIT 1;


UPDATE risk_credit
SET risk_credit.provider2_credit_limit=''
WHERE risk_credit.provider2_credit_limit IS NULL;

UPDATE risk_credit
SET risk_credit.provider2_risk_score=''
WHERE risk_credit.provider2_risk_score IS NULL;

UPDATE risk_credit
SET risk_credit.provider3_credit_limit=''
WHERE risk_credit.provider3_credit_limit IS NULL;

UPDATE risk_credit
SET risk_credit.provider3_risk_score=''
WHERE risk_credit.provider3_risk_score IS NULL;

UPDATE risk_credit
SET risk_credit.provider5_credit_limit=''
WHERE risk_credit.provider5_credit_limit IS NULL;

UPDATE risk_credit
SET risk_credit.provider5_risk_score=''
WHERE risk_credit.provider5_risk_score IS NULL;

UPDATE risk_credit
SET risk_credit.provider6_credit_limit=''
WHERE risk_credit.provider6_credit_limit IS NULL;

UPDATE risk_credit
SET risk_credit.provider6_risk_score=''
WHERE risk_credit.provider6_risk_score IS NULL;

UPDATE risk_credit
SET risk_credit.company_number=''
WHERE risk_credit.company_number IS NULL;

DELETE risk_credit
FROM risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
WHERE debtors_master.debtor_master_id IS NULL AND risk_credit.debtor_id <>0;

UPDATE risk_credit
SET risk_credit.address_id=0
WHERE risk_credit.address_id IS NULL;

UPDATE debtors_master
SET debtors_master.debtor_min_offers = 0
WHERE debtors_master.debtor_min_offers IS NULL;

UPDATE debtors_master
SET debtors_master.debtor_max_offers = 0
WHERE debtors_master.debtor_max_offers IS NULL;

UPDATE debtors_master
SET debtors_master.debtor_max_bid = 0
WHERE debtors_master.debtor_max_bid IS NULL;

UPDATE debtors_master
SET debtors_master.debtor_insurance_cost = 0
WHERE debtors_master.debtor_insurance_cost IS NULL;

UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='463';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='482';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='484';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='486';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='488';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='492';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='498';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='507';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='508';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='509';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='510';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='511';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='512';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='514';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='515';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='516';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='541';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='542';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='543';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='544';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='545';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='546';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='547';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='548';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='549';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='550';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='551';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='552';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='553';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='554';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='555';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='556';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='557';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='558';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='559';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='560';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='561';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='562';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='563';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='564';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='565';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='566';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='567';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='568';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='570';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='571';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='573';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='575';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='576';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='577';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='578';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='579';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='580';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='581';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='582';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='583';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='585';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='586';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='587';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='588';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='589';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='590';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='591';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='592';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='593';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='594';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='702';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='704';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='706';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='707';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='709';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='710';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='711';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='713';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='714';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='715';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='716';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='717';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='718';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='719';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='821';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='822';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='823';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='824';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='825';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='826';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='827';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='828';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='829';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='830';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='831';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='832';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='834';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='835';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='837';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='838';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='839';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='940';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='943';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='944';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='945';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='947';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='948';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='949';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='950';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='951';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='952';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='953';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='954';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='955';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='956';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='957';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='959';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='960';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='961';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='962';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='963';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='964';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='965';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='966';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='968';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='969';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1Q', risk_credit.provider1_risk_score='Q-1'
WHERE debtors_master.debtor_master_id='970';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='1325';
UPDATE risk_credit
LEFT JOIN debtors_master ON debtors_master.debtor_master_id = risk_credit.debtor_id
SET risk_credit.provider1_credit_limit='X1E', risk_credit.provider1_risk_score='E-1'
WHERE debtors_master.debtor_master_id='1326';
@ Telegram