Closed herrBez closed 6 years ago
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/mcguia/sexyigit/1e95ce1a357375a92e1a68b949ab1f8f1ed8fbe4/tf2items/profiles/CorkscrewTehKilla.xml'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/mcguia/sexyigit/1e95ce1a357375a92e1a68b949ab1f8f1ed8fbe4/tf2items/profiles/CorkscrewTehKilla.xml'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/kinmanz/PythonManualEstimationAssessment/248926cc29a66d3614e31b4c72a07f89919d2697/CVs/GrahamCampbell'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/kinmanz/PythonManualEstimationAssessment/248926cc29a66d3614e31b4c72a07f89919d2697/CVs/GrahamCampbell'
----------------------------------------
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/kinmanz/PythonManualEstimationAssessment/248926cc29a66d3614e31b4c72a07f89919d2697/CVs/rdegges'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/kinmanz/PythonManualEstimationAssessment/248926cc29a66d3614e31b4c72a07f89919d2697/CVs/rdegges'
-------------------------------------------------
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/kinmanz/PythonManualEstimationAssessment/248926cc29a66d3614e31b4c72a07f89919d2697/CVsGermany/CVs/c-kr.json'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/kinmanz/PythonManualEstimationAssessment/248926cc29a66d3614e31b4c72a07f89919d2697/CVsGermany/CVs/c-kr.json'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/Ramanan1980/boot-strap-/580afad059d17dde7517fdb8870327784aa7d5cf/bootstrap.git'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/Ramanan1980/boot-strap-/580afad059d17dde7517fdb8870327784aa7d5cf/bootstrap.git'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/joancaron/cryptocompare-api/a79b74f04de43849706e4ff7e704e8923333daf9/test/CryptoCompare.Tests/Fixtures/Exchanges/List.json'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/joancaron/cryptocompare-api/a79b74f04de43849706e4ff7e704e8923333daf9/test/CryptoCompare.Tests/Fixtures/Exchanges/List.json'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/sniperkit/xfilter/ccf28d18d70dcfa621027ce701a6d32ec9f5a4a0/test/data/readmes.json'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/sniperkit/xfilter/ccf28d18d70dcfa621027ce701a6d32ec9f5a4a0/test/data/readmes.json'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/tejaykodali/iPython-stuff/fc1d4826897a0e578ed7f23eb559adabebf4c2cc/.ipynb_checkpoints/Election%20Analysis-checkpoint.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/tejaykodali/iPython-stuff/fc1d4826897a0e578ed7f23eb559adabebf4c2cc/.ipynb_checkpoints/Election%20Analysis-checkpoint.ipynb'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/beckyclark17/Cash-Prompts-project/290c2b68342d0ed398fe31ebfb6f2038b5d67256/1a%20Linear%20Regression%20Model%20Build%20-%20cash%20prompts%20lapsed%20supporters.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/beckyclark17/Cash-Prompts-project/290c2b68342d0ed398fe31ebfb6f2038b5d67256/1a%20Linear%20Regression%20Model%20Build%20-%20cash%20prompts%20lapsed%20supporters.ipynb'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/pjavaji/Capstone_2016/5a607934fdc113fb828126dd161c1ae717b5bb81/Sentiment_classfication/Sentiment_ApplyCannedClassifiers_05-05-16.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/pjavaji/Capstone_2016/5a607934fdc113fb828126dd161c1ae717b5bb81/Sentiment_classfication/Sentiment_ApplyCannedClassifiers_05-05-16.ipynb'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/rabernat/python_teaching/2b13870c5509b7c0edac57ed817c561a29423f59/old_notebooks/04_pandas_NYC_collisions.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/rabernat/python_teaching/2b13870c5509b7c0edac57ed817c561a29423f59/old_notebooks/04_pandas_NYC_collisions.ipynb'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/drippyx/podmail-pristine/3eeeba34fc4a8dee52ddddfeb81a563ced892744/cur/54776'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/drippyx/podmail-pristine/3eeeba34fc4a8dee52ddddfeb81a563ced892744/cur/54776'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/nealrea/collisionViz/1b7bedca38877c05d0ca71aa9be65863460fc340/data_exploration/coll_causes_exploration.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/nealrea/collisionViz/1b7bedca38877c05d0ca71aa9be65863460fc340/data_exploration/coll_causes_exploration.ipynb'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/nealrea/collisionViz/1b7bedca38877c05d0ca71aa9be65863460fc340/data_exploration/coll_causes_exploration.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/nealrea/collisionViz/1b7bedca38877c05d0ca71aa9be65863460fc340/data_exploration/coll_causes_exploration.ipynb'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/Harshisanjeev/Data-Project-Election-Analysis/9226ba3bc48e8e46d4026c8ac91aa4fd7520db67/Election%20Analysis-%20Data%20Project.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/Harshisanjeev/Data-Project-Election-Analysis/9226ba3bc48e8e46d4026c8ac91aa4fd7520db67/Election%20Analysis-%20Data%20Project.ipynb'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/gthoma17/BookmarkGen/02b8785bcb01a9c2015fe922e5f2e2fc2c1a5c12/index.html'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/gthoma17/BookmarkGen/02b8785bcb01a9c2015fe922e5f2e2fc2c1a5c12/index.html'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/zhangyongjiang/blocktrail/a69a0a127d5c644418890200e1ce11b181351911/pycoin/COMMAND-LINE-TOOLS.md'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/zhangyongjiang/blocktrail/a69a0a127d5c644418890200e1ce11b181351911/pycoin/COMMAND-LINE-TOOLS.md'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/geraldo1993/Spring2017/dd608dea6ab72243e03a19adc2c7b4d8b2a0278c/Comp%204353%20Data%20Mining/FinalProject_EnsembleModel/MOLG_EnsModel.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/geraldo1993/Spring2017/dd608dea6ab72243e03a19adc2c7b4d8b2a0278c/Comp%204353%20Data%20Mining/FinalProject_EnsembleModel/MOLG_EnsModel.ipynb'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/scgordon/CrosswalksWorkflow/69b820259495efdb95006aa9d9c4edc1c7145a4f/collections/USGS/ScienceBase/CSDGM/xml/Ozarks_seepagerun_flowlines.shp.xml'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/scgordon/CrosswalksWorkflow/69b820259495efdb95006aa9d9c4edc1c7145a4f/collections/USGS/ScienceBase/CSDGM/xml/Ozarks_seepagerun_flowlines.shp.xml'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/revanurambareesh/forexInsights/8241aa0e676014c516faa6adf725b0665bcb4752/forex/data/sample_train_data/0%2CESAF%20MICRO%20FINANCE%20AND%20INVESTM/10.txt'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/revanurambareesh/forexInsights/8241aa0e676014c516faa6adf725b0665bcb4752/forex/data/sample_train_data/0%2CESAF%20MICRO%20FINANCE%20AND%20INVESTM/10.txt'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/EEXCESS/EEXCESS.github.io/9de601f4e77400a4346d811154790e62a62391fb/visualization-widgets-collaborativebookmarking/Dashboard/js/viseval-demodata.js'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/EEXCESS/EEXCESS.github.io/9de601f4e77400a4346d811154790e62a62391fb/visualization-widgets-collaborativebookmarking/Dashboard/js/viseval-demodata.js'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/avantichande/IPython-Notebooks/4ef6bb92563164faee920c0b2c815b201717fa89/Data%20Project%203%20-%20Election%20Analysis.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/avantichande/IPython-Notebooks/4ef6bb92563164faee920c0b2c815b201717fa89/Data%20Project%203%20-%20Election%20Analysis.ipynb'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/mtchem/Twitter-Politics/c3d8fe70b1d7b942fbeac8a191dd542ecc193fac/EDA.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/mtchem/Twitter-Politics/c3d8fe70b1d7b942fbeac8a191dd542ecc193fac/EDA.ipynb'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/HammurabiCode/knowledge/601930117dba2dc377de098787277d365852d18c/Project/DoubanBook/book_html/%E4%BA%8C%E6%88%98/3683301'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/HammurabiCode/knowledge/601930117dba2dc377de098787277d365852d18c/Project/DoubanBook/book_html/%E4%BA%8C%E6%88%98/3683301'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/GizerInc/crowdsale/4243f2627d869195aaba3e430ed3dc4ca6715ca0/dev-tests/sLog_4.log'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/GizerInc/crowdsale/4243f2627d869195aaba3e430ed3dc4ca6715ca0/dev-tests/sLog_4.log'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/cheseaux/BitcoinTradingSystem/c74bac819469657a243003b1ec336de0f3cbcc63/scripts/sentiment/neutral_tweets_to_split.txt'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/cheseaux/BitcoinTradingSystem/c74bac819469657a243003b1ec336de0f3cbcc63/scripts/sentiment/neutral_tweets_to_split.txt'
--------------------------------------
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/cheseaux/BitcoinTradingSystem/c74bac819469657a243003b1ec336de0f3cbcc63/scripts/sentiment/Moi/neutral_tweets.txt'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/cheseaux/BitcoinTradingSystem/c74bac819469657a243003b1ec336de0f3cbcc63/scripts/sentiment/Moi/neutral_tweets.txt'
--------------------------------------
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/cheseaux/BitcoinTradingSystem/c74bac819469657a243003b1ec336de0f3cbcc63/scripts/sentiment/Ilia/neutral_tweets.txt'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/cheseaux/BitcoinTradingSystem/c74bac819469657a243003b1ec336de0f3cbcc63/scripts/sentiment/Ilia/neutral_tweets.txt'
--------------------------------------
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/cheseaux/BitcoinTradingSystem/c74bac819469657a243003b1ec336de0f3cbcc63/scripts/sentiment/mergedUniq.csv'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/cheseaux/BitcoinTradingSystem/c74bac819469657a243003b1ec336de0f3cbcc63/scripts/sentiment/mergedUniq.csv'
--------------------------------------
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/cheseaux/BitcoinTradingSystem/c74bac819469657a243003b1ec336de0f3cbcc63/scripts/sentiment/mergedWithApple.csv'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/cheseaux/BitcoinTradingSystem/c74bac819469657a243003b1ec336de0f3cbcc63/scripts/sentiment/mergedWithApple.csv'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/mtochs/Udacity/2f4100147a624aa0b124fde1213b3d52db103a0d/Machine%20Learning%20Engineer%20Nanodegree/P2%20Finding%20Donors/finding_donors.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/mtochs/Udacity/2f4100147a624aa0b124fde1213b3d52db103a0d/Machine%20Learning%20Engineer%20Nanodegree/P2%20Finding%20Donors/finding_donors.ipynb'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/btclovebot/BitcoinDonationScripts/933e8f7bcc9337f3d24631fe4edf746553e7357b/BTCLOVEBOT.py'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/btclovebot/BitcoinDonationScripts/933e8f7bcc9337f3d24631fe4edf746553e7357b/BTCLOVEBOT.py'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/doGoodio/MultiSigWallet/0175b95a3588f85ed7f6f0cb00ccf4b2e9a22de4/test/contribution_test.js'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/doGoodio/MultiSigWallet/0175b95a3588f85ed7f6f0cb00ccf4b2e9a22de4/test/contribution_test.js'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/digitalab/digitalab.github.io/b4773af7be49e0b9c115b9e5ed92433f62f2c6a0/np/srs/dkosmos/metadata.xml'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/digitalab/digitalab.github.io/b4773af7be49e0b9c115b9e5ed92433f62f2c6a0/np/srs/dkosmos/metadata.xml'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/johnsroy/MachineLearning/fdb4718f0c0c43e747371693914e01d51ea715b5/project/tickmate/v1.1.2.csv'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/johnsroy/MachineLearning/fdb4718f0c0c43e747371693914e01d51ea715b5/project/tickmate/v1.1.2.csv'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/johnsroy/MachineLearning/fdb4718f0c0c43e747371693914e01d51ea715b5/project/boilr/0.1.0.csv'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/johnsroy/MachineLearning/fdb4718f0c0c43e747371693914e01d51ea715b5/project/boilr/0.1.0.csv'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/Dnncha/dataplay/c66287aa6ac89849bf257a46ca2995bcc2f41318/word_count_data/golemproject.csv'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/Dnncha/dataplay/c66287aa6ac89849bf257a46ca2995bcc2f41318/word_count_data/golemproject.csv'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/alisw/AliPhysics/e03501545f969c83c33e7c253935e102705f63db/PWGJE/UserTasks/AliAnalysisTaskFragmentationTriggered.cxx'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/alisw/AliPhysics/e03501545f969c83c33e7c253935e102705f63db/PWGJE/UserTasks/AliAnalysisTaskFragmentationTriggered.cxx'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/prabhaace/DOCUMENTS/d269bfceb2e326c14b90204d5d3226d0e1d977a9/Cruise%20control/CruiseControl%20Overview.mht'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/prabhaace/DOCUMENTS/d269bfceb2e326c14b90204d5d3226d0e1d977a9/Cruise%20control/CruiseControl%20Overview.mht'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/CogPsyDraftTable/MinervaExplore/8cdae08bab653bf6a11379d42d27c93630b28144/SomeExplorations_R_Crump/MinervaOrthonormal3.html'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/CogPsyDraftTable/MinervaExplore/8cdae08bab653bf6a11379d42d27c93630b28144/SomeExplorations_R_Crump/MinervaOrthonormal3.html'
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM
AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND a._id = 1376 AND RawURL != 'https://raw.githubusercontent.com/makevoid/paperbank/d0eb7d8887d2f666686c9e9b55ae250f37a72536/Readme.md'
);
DELETE FROM AccountWallet WHERE Account = 1376 and RawURL != 'https://raw.githubusercontent.com/makevoid/paperbank/d0eb7d8887d2f666686c9e9b55ae250f37a72536/Readme.md';
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/bradd123/Udacity_DataAnalyst_NanoDegree/37feb909b16eadd76438ba5edda138a688ff5e2c/P2%20Investigate%20a%20Dataset/.ipynb_checkpoints/Investigate_Titanic_Dataset-checkpoint.ipynb'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/bradd123/Udacity_DataAnalyst_NanoDegree/37feb909b16eadd76438ba5edda138a688ff5e2c/P2%20Investigate%20a%20Dataset/.ipynb_checkpoints/Investigate_Titanic_Dataset-checkpoint.ipynb'
UPDATE Wallet SET Status = -1 WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/jaydeepchakraborty/PorfRecommendation/6ea215f3ff86b3a6d0568f3f518cf23a8aff36a6/data/papers/AhnGailJoon/6.pdf.txt'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/jaydeepchakraborty/PorfRecommendation/6ea215f3ff86b3a6d0568f3f518cf23a8aff36a6/data/papers/AhnGailJoon/6.pdf.txt';
DELETE FROM Wallet WHERE Address IN (SELECT aw.Wallet
FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w
WHERE a._id = aw.Account AND w.Address = aw.Wallet
AND aw.RawURL = 'https://raw.githubusercontent.com/deerishi/thesis/f84316cba292a8eb8d4217cd612a532fde8fc4df/myd.csv'
);
DELETE FROM AccountWallet WHERE RawURL = 'https://raw.githubusercontent.com/deerishi/thesis/f84316cba292a8eb8d4217cd612a532fde8fc4df/myd.csv'
[x] Remove all mcguja addresses sinche they are taken from this file --> https://raw.githubusercontent.com/mcguia/sexyigit/1e95ce1a357375a92e1a68b949ab1f8f1ed8fbe4/tf2items/profiles/CorkscrewTehKilla.xml it is clearly a false positive!!!
[x] Remove all kinmanz https://raw.githubusercontent.com/kinmanz/PythonManualEstimationAssessment/248926cc29a66d3614e31b4c72a07f89919d2697/CVs/GrahamCampbell , https://raw.githubusercontent.com/kinmanz/PythonManualEstimationAssessment/248926cc29a66d3614e31b4c72a07f89919d2697/CVs/rdegges , https://raw.githubusercontent.com/kinmanz/PythonManualEstimationAssessment/248926cc29a66d3614e31b4c72a07f89919d2697/CVsGermany/CVs/c-kr.json
[x] Remove all Ramanan1980 since they are false positive: https://raw.githubusercontent.com/Ramanan1980/boot-strap-/580afad059d17dde7517fdb8870327784aa7d5cf/bootstrap.git
[x] I do not know what to make with -->
"2875" "github.com" "marquefan" "59" "https://raw.githubusercontent.com/marquefan/biz_trader
/6e4028a24ac01ceca7f989c9117e10feda928164/Desktop/biz/data/biz-info-2017-06-12.txt"[x] Same story with
"2875" "github.com" "marquefan" "12" "https://raw.githubusercontent.com/marquefan/biz_trader/cdc6a260e34997c900a7e4c307879974998ca2f3/Desktop/biz/data/biz-info-2017-06-10.txt"
[x] Big CSV Table https://raw.githubusercontent.com/deerishi/thesis/f84316cba292a8eb8d4217cd612a532fde8fc4df/myd.csv
"4020" "github.com" "deerishi" "65" "https://raw.githubusercontent.com/deerishi/thesis/f84316cba292a8eb8d4217cd612a532fde8fc4df/myd.csv"
I do not know what to do :/ One possibility is to simply remove all wallets belonging todeerishi
[x] Remove this guy: https://raw.githubusercontent.com/joancaron/cryptocompare-api/a79b74f04de43849706e4ff7e704e8923333daf9/test/CryptoCompare.Tests/Fixtures/Exchanges/List.json because it is a simple unit-test
[x] Remove this guy: https://raw.githubusercontent.com/sniperkit/xfilter/ccf28d18d70dcfa621027ce701a6d32ec9f5a4a0/test/data/readmes.json --> It is the result of a test . Or we should consider it more carefully
[x] Remove this guy: https://raw.githubusercontent.com/tejaykodali/iPython-stuff/fc1d4826897a0e578ed7f23eb559adabebf4c2cc/.ipynb_checkpoints/Election%20Analysis-checkpoint.ipynb
"github.com" "tejaykodali"
[x] Remove this guy: "beckyclark17" "44" "https://raw.githubusercontent.com/beckyclark17/Cash-Prompts-project/290c2b68342d0ed398fe31ebfb6f2038b5d67256/1a%20Linear%20Regression%20Model%20Build%20-%20cash%20prompts%20lapsed%20supporters.ipynb"
github.com beckyclark17
[x] Remove also: "github.com" "pjavaji" "37" "https://raw.githubusercontent.com/pjavaji/Capstone_2016/5a607934fdc113fb828126dd161c1ae717b5bb81/Sentiment_classfication/Sentiment_ApplyCannedClassifiers_05-05-16.ipynb"
[x] Remove https://raw.githubusercontent.com/rabernat/python_teaching/2b13870c5509b7c0edac57ed817c561a29423f59/old_notebooks/04_pandas_NYC_collisions.ipynb -->
"github.com" "rabernat"
[x] Remove? "3035" "github.com" "CoinCircle" "35" "https://raw.githubusercontent.com/CoinCircle/icostats/22a552599a8308714dbc7c94e8fd9d833e57bb50/src/server/lib/ico-data.js"
[x] Remove? https://raw.githubusercontent.com/bradd123/Udacity_DataAnalyst_NanoDegree/37feb909b16eadd76438ba5edda138a688ff5e2c/P2%20Investigate%20a%20Dataset/.ipynb_checkpoints/Investigate_Titanic_Dataset-checkpoint.ipynb "4042" "github.com" "bradd123" "33"
[x] Erroneous categorization: "2987" "github.com" "drippyx" "32" "https://raw.githubusercontent.com/drippyx/podmail-pristine/3eeeba34fc4a8dee52ddddfeb81a563ced892744/cur/54776"
[x] Erronerous categorization. Please delete: "nealrea" "30" "https://raw.githubusercontent.com/nealrea/collisionViz/1b7bedca38877c05d0ca71aa9be65863460fc340/data_exploration/coll_causes_exploration.ipynb"
[x] Remove, since it is a false positive:
"github.com" "nealrea" "30" "https://raw.githubusercontent.com/nealrea/collisionViz/1b7bedca38877c05d0ca71aa9be65863460fc340/data_exploration/coll_causes_exploration.ipynb"
[x] Remove this "github.com" "Harshisanjeev" "29" "https://raw.githubusercontent.com/Harshisanjeev/Data-Project-Election-Analysis/9226ba3bc48e8e46d4026c8ac91aa4fd7520db67/Election%20Analysis-%20Data%20Project.ipynb"
[x] Remove "github.com" "gthoma17" "29" "https://raw.githubusercontent.com/gthoma17/BookmarkGen/02b8785bcb01a9c2015fe922e5f2e2fc2c1a5c12/index.html"
[x] Eliminate "3000" "github.com" "gthoma17" "29" "https://raw.githubusercontent.com/gthoma17/BookmarkGen/02b8785bcb01a9c2015fe922e5f2e2fc2c1a5c12/index.html"
[x] Remove https://raw.githubusercontent.com/zhangyongjiang/blocktrail/a69a0a127d5c644418890200e1ce11b181351911/pycoin/COMMAND-LINE-TOOLS.md and all its addresses 'cause they are only examples
[x] Remove "2983" "github.com" "geraldo1993" "25" "https://raw.githubusercontent.com/geraldo1993/Spring2017/dd608dea6ab72243e03a19adc2c7b4d8b2a0278c/Comp%204353%20Data%20Mining/FinalProject_EnsembleModel/MOLG_EnsModel.ipynb"
[x] Remove "4031" "github.com" "scgordon" "25" "https://raw.githubusercontent.com/scgordon/CrosswalksWorkflow/69b820259495efdb95006aa9d9c4edc1c7145a4f/collections/USGS/ScienceBase/CSDGM/xml/Ozarks_seepagerun_flowlines.shp.xml"
[x] Remove this https://raw.githubusercontent.com/revanurambareesh/forexInsights/8241aa0e676014c516faa6adf725b0665bcb4752/forex/data/sample_train_data/0%2CESAF%20MICRO%20FINANCE%20AND%20INVESTM/10.txt "github.com" "revanurambareesh" "24"
[x] Remove this stuff https://raw.githubusercontent.com/EEXCESS/EEXCESS.github.io/9de601f4e77400a4346d811154790e62a62391fb/visualization-widgets-collaborativebookmarking/Dashboard/js/viseval-demodata.js "3490" "github.com" "EEXCESS" "23" "https://raw.githubusercontent.com/EEXCESS/EEXCESS.github.io/9de601f4e77400a4346d811154790e62a62391fb/visualization-widgets-collaborativebookmarking/Dashboard/js/viseval-demodata.js"
[x] Remove this https://raw.githubusercontent.com/avantichande/IPython-Notebooks/4ef6bb92563164faee920c0b2c815b201717fa89/Data%20Project%203%20-%20Election%20Analysis.ipynb "github.com" "avantichande" "23" "https://raw.githubusercontent.com/avantichande/IPython-Notebooks/4ef6bb92563164faee920c0b2c815b201717fa89/Data%20Project%203%20-%20Election%20Analysis.ipynb"
[x] Remove "2997" "github.com" "mtchem" "23" "https://raw.githubusercontent.com/mtchem/Twitter-Politics/c3d8fe70b1d7b942fbeac8a191dd542ecc193fac/EDA.ipynb"
[x] Remove False Positive "3439" "github.com" "HammurabiCode" "22" "https://raw.githubusercontent.com/HammurabiCode/knowledge/601930117dba2dc377de098787277d365852d18c/Project/DoubanBook/book_html/%E4%BA%8C%E6%88%98/3683301"
[x] "3620" "github.com" "GizerInc" "21" "https://raw.githubusercontent.com/GizerInc/crowdsale/4243f2627d869195aaba3e430ed3dc4ca6715ca0/dev-tests/sLog_4.log" log of a smart-contract???
[x] Remove this stuff "2695" "github.com" "Mondego" "21" "https://raw.githubusercontent.com/Mondego/pyreco/0ac6653219c2701c13c508c5c4fc9bc3437eea06/repoData/ctfs-write-ups/description.txt"
[x] Eliminate: 1."1381" "github.com" "cheseaux" "21" "https://raw.githubusercontent.com/cheseaux/BitcoinTradingSystem/c74bac819469657a243003b1ec336de0f3cbcc63/scripts/sentiment/neutral_tweets_to_split.txt"
[x] Remove: https://raw.githubusercontent.com/mtochs/Udacity/2f4100147a624aa0b124fde1213b3d52db103a0d/Machine%20Learning%20Engineer%20Nanodegree/P2%20Finding%20Donors/finding_donors.ipynb
[x] Remove "126" "github.com" "btclovebot" "20" "https://raw.githubusercontent.com/btclovebot/BitcoinDonationScripts/933e8f7bcc9337f3d24631fe4edf746553e7357b/BTCLOVEBOT.py"
[x] Delete "3043" "github.com" "MakeYourLaws" "18" "https://raw.githubusercontent.com/MakeYourLaws/MakeYourLaws/08f578522579a307a52ee3d37926d806fc872258/app/views/main/fec/bitcoin_pacs.html.erb"
[x] remove https://github.com/doGoodio/MultiSigWallet "3146" "github.com" "doGoodio" "18" "https://raw.githubusercontent.com/doGoodio/MultiSigWallet/0175b95a3588f85ed7f6f0cb00ccf4b2e9a22de4/test/contribution_test.js" all the doGoodio entries --> because it is simply a test
[x] KEEP ONLY THIS ENTRY FOR
makevoid
user: "2852" "1376" "1PBank95kE4BZaQBfMsGZ3RCkqwwtGHjKA" "https://raw.githubusercontent.com/makevoid/paperbank/d0eb7d8887d2f666686c9e9b55ae250f37a72536/Readme.md"[x] Remove all "3731" "github.com" "digitalab" "17" "https://raw.githubusercontent.com/digitalab/digitalab.github.io/b4773af7be49e0b9c115b9e5ed92433f62f2c6a0/np/srs/dkosmos/metadata.xml"
[x] remove all "1256" "github.com" "johnsroy" "17" "https://raw.githubusercontent.com/johnsroy/MachineLearning/fdb4718f0c0c43e747371693914e01d51ea715b5/project/tickmate/v1.1.2.csv" (They are hash of commits -.-)
[x] "1256" "github.com" "johnsroy" "10" "https://raw.githubusercontent.com/johnsroy/MachineLearning/fdb4718f0c0c43e747371693914e01d51ea715b5/project/boilr/0.1.0.csv" they are hash of commits :sob:
[x] Remove false positives "2884" "github.com" "Dnncha" "16" "https://raw.githubusercontent.com/Dnncha/dataplay/c66287aa6ac89849bf257a46ca2995bcc2f41318/word_count_data/golemproject.csv"
[x] Remove false positive "3261" "github.com" "alisw" "14" "https://raw.githubusercontent.com/alisw/AliPhysics/e03501545f969c83c33e7c253935e102705f63db/PWGJE/UserTasks/AliAnalysisTaskFragmentationTriggered.cxx"
[x] Remove "4026" "github.com" "prabhaace" "14" "https://raw.githubusercontent.com/prabhaace/DOCUMENTS/d269bfceb2e326c14b90204d5d3226d0e1d977a9/Cruise%20control/CruiseControl%20Overview.mht"
[x] Analyze -> Don't know what to do: "3157" "github.com" "wanchain" "14" "https://raw.githubusercontent.com/wanchain/wanchain-token/cf9625a96c517be80976cba35ccc414043cad641/test/wanchainContribution.js"
[x] Remove https://raw.githubusercontent.com/CogPsyDraftTable/MinervaExplore/8cdae08bab653bf6a11379d42d27c93630b28144/SomeExplorations_R_Crump/MinervaOrthonormal3.html
"4015" "github.com" "CogPsyDraftTable" "13" "https://raw.githubusercontent.com/CogPsyDraftTable/MinervaExplore/8cdae08bab653bf6a11379d42d27c93630b28144/SomeExplorations_R_Crump/MinervaOrthonormal3.html"
[x] Analyze further. It seems a sort of paper in which some bitcoin addresses are cited: "3590" "github.com" "jaydeepchakraborty" "13" "https://raw.githubusercontent.com/jaydeepchakraborty/PorfRecommendation/6ea215f3ff86b3a6d0568f3f518cf23a8aff36a6/data/papers/AhnGailJoon/6.pdf.txt" --> Put status to -1 to avoid possible exploration of these nodes