| Line 24... |
Line 24... |
| 24 |
<div class="col-lg-2">
|
24 |
<div class="col-lg-2">
|
| 25 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
25 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
| 26 |
</div>
|
26 |
</div>
|
| 27 |
</li>
|
27 |
</li>
|
| 28 |
<li>
|
28 |
<li>
|
| 29 |
<div class="label label-info">All Haryana users</div>
|
29 |
<div class="label label-info">Haryana FOS</div>
|
| 30 |
<div class="clearfix"></div>
|
30 |
<div class="clearfix"></div>
|
| 31 |
<div class="col-lg-10 updatesql">SELECT distinct(u.id) FROM users u left join retailerlinks rl on rl.user_id=u.id left join retailers r on r.id=rl.retailer_id left join dtr.user_accounts ua on (u.id=ua.user_id and ua.account_type='saholic') left join retailer rt on (rt.id=ua.account_key and ua.account_type='saholic') where u.state ='HARYANA' or r.state='HARYANA' and (rt.active=1 or rt.migrated=1)</div>
|
31 |
<div class="col-lg-10 updatesql">select id from users where referrer in ('Sas96x8w38', 'sajwq5v9w4', 'Saznvgm9zx', 'SAC5R3YA39')</div>
|
| 32 |
<div class="col-lg-2">
|
32 |
<div class="col-lg-2">
|
| 33 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
33 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
| 34 |
</div>
|
34 |
</div>
|
| 35 |
</li>
|
35 |
</li>
|
| 36 |
<li>
|
36 |
<li>
|
| 37 |
<div class="label label-info">All Haryana users through affiliate</div>
|
37 |
<div class="label label-info">All Haryana users - FOS</div>
|
| 38 |
<div class="clearfix"></div>
|
38 |
<div class="clearfix"></div>
|
| 39 |
<div class="col-lg-10 updatesql">select u.id from dtr.users u join dtr.user_accounts ua on (u.id=ua.user_id and ua.account_type='saholic') join transaction.pmsa_agents a on a.userId=ua.account_key join transaction.pmsa pmsa on pmsa.id=a.pmsa_id where pmsa.state='HARYANA' and u.activated = 1</div>
|
39 |
<div class="col-lg-10 updatesql">SELECT u.id FROM users u left join retailerlinks rl on rl.user_id=u.id left join retailers r on r.id=rl.retailer_id left join dtr.user_accounts ua on (u.id=ua.user_id and ua.account_type='saholic') left join retailer rt on (rt.id=ua.account_key and ua.account_type='saholic') where (u.state ='HARYANA' or r.state='HARYANA') and (rt.active=1 or rt.migrated=1) and u.referrer not in ('Sas96x8w38', 'sajwq5v9w4', 'Saznvgm9zx', 'SAC5R3YA39')</div>
|
| 40 |
<div class="col-lg-2">
|
40 |
<div class="col-lg-2">
|
| 41 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
41 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
| 42 |
</div>
|
42 |
</div>
|
| 43 |
</li>
|
43 |
</li>
|
| 44 |
<li>
|
44 |
<li>
|
| 45 |
<div class="label label-info">All Non-Haryana users</div>
|
45 |
<div class="label label-info">All India -Haryana -FOS</div>
|
| 46 |
<div class="clearfix"></div>
|
46 |
<div class="clearfix"></div>
|
| 47 |
<div class="col-lg-10 updatesql">SELECT distinct(u.id) FROM users u left join retailerlinks rl on rl.user_id=u.id left join retailers r on r.id=rl.retailer_id left join dtr.user_accounts ua on (u.id=ua.user_id and ua.account_type='saholic') left join retailer rt on (rt.id=ua.account_key and ua.account_type='saholic') where u.state !='HARYANA' and r.state!='HARYANA' and (rt.active=1 or rt.migrated=1)</div>
|
47 |
<div class="col-lg-10 updatesql">SELECT u.id, u.referrer, u.city, u.state FROM users u left join retailerlinks rl on rl.user_id=u.id left join retailers r on r.id=rl.retailer_id left join dtr.user_accounts ua on (u.id=ua.user_id and ua.account_type='saholic') left join retailer rt on (rt.id=ua.account_key and ua.account_type='saholic') where u.id not in (SELECT u.id FROM users u left join retailerlinks rl on rl.user_id=u.id left join retailers r on r.id=rl.retailer_id left join dtr.user_accounts ua on (u.id=ua.user_id and ua.account_type='saholic') left join retailer rt on (rt.id=ua.account_key and ua.account_type='saholic') where (u.state is null or u.state !='HARYANA') and (r.state is null or r.state!='HARYANA')) and (rt.active=1 or rt.migrated=1) and u.referrer not in ('Sas96x8w38', 'sajwq5v9w4', 'Saznvgm9zx', 'SAC5R3YA39')</div>
|
| 48 |
<div class="col-lg-2">
|
48 |
<div class="col-lg-2">
|
| 49 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
49 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
| 50 |
</div>
|
50 |
</div>
|
| 51 |
</li>
|
51 |
</li>
|
| 52 |
<li>
|
52 |
<li>
|