[Drugwars] How to find good targets using STEEMSQL DB

I've notice on discord chat a lot of people with trouble finding good targets to battle so I decide to write a post with a few tips on how to do that in a easy way. And in name of fairness, so all players can do the same.

Attencion, this might not work in the near future!! Drugwars is changing constantly and the shield will be removed soon, with many other changes that will make bots useless, I believe.

Most of the top heist players are getting their drugs from inactive players (or ones without army and + res).

But where in the hell they find so many targets in this conditions??? Well...they probably access the block chain and with a script in python they query those targets very easy (steempy or beem)

If you are like me, a person who don't know how to do that, you are in the right post xD

Think this way...those top heisters are target finders for us. We just need to know who they are attacking and get there first...and this can be done to all attacks from all players...

The hard way to do that is on Steemd.com , checking accounts and their attacks (5h-6h ago) and hiting next when shield goes down.

Now the easy way...

You will needMS Excel or similarSTEEMSQL subscription (thanks @arcange)

On Excel>
Data>From Other Sources>From SQL Server
Server name: sql.steemsql.com > Set your name and password (steemsql.com subscribe) > Select any table and Finish
Data>Existing Connections>Select sql.steemsql.com> Properties...
Definition tab>Check Save Password>Commant type: SQL

Now you add this SQL query to the command text box:
(just put the name of the top heisters)

---

select  timestamp,
JSON_VALUE(json_metadata,'$.payload.target') AS Target,
JSON_VALUE(json_metadata,'$.author') AS Attacker
from Txcustoms
where CONVERT(DATE,timestamp) = '2019-03-11' AND tid = 'drugwars' AND JSON_VALUE(json_metadata,'$.author') IN ('top1','top2','top3','top5','top6','top7','top8','top9','top10')

---

or use this if you want to query all attacks from everyone :

select  timestamp,
JSON_VALUE(json_metadata,'$.payload.target') AS Target,
JSON_VALUE(json_metadata,'$.author') AS Attacker
from Txcustoms
where CONVERT(DATE,timestamp) = '2019-03-11' AND tid = 'drugwars'

*Don't forget to set DATE *

Click OK...

You will get this, now you use your Excel abilities to filter the timing for the shields (6hrs) and you are all set!!

You can play a lot with it...

This can be improved , its just an small example, I'm not a programmer so i'm doing the best I can xD

Now you know...bye