gistfile1.txt

DELETE t2 FROM `mysr_data_table2` t1,  `mysr_data_table2` t2 
WHERE
 t1.`country` = 9969977496 
AND t1.version =  6
AND t1.country = t2.country
AND t1.version = t2.version
AND t1.`origin` = t2.`origin`
AND t2.id > t1.id

DELETE t2 FROM `mysr_data_table1` t1,  `mysr_data_table1` t2 WHERE
 t1.`country` = 9969977496 
AND t1.version = 6 
AND t1.country = t2.country
AND t1.version = t2.version
AND t1.`data_origin` = t2.`data_origin`
AND t2.id > t1.id