| Line 32... |
Line 32... |
| 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>
|
| - |
|
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>
|
| - |
|
40 |
<div class="col-lg-2">
|
| - |
|
41 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
| - |
|
42 |
</div>
|
| - |
|
43 |
</li>
|
| - |
|
44 |
<li>
|
| - |
|
45 |
<div class="label label-info">All Non-Haryana users</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>
|
| - |
|
48 |
<div class="col-lg-2">
|
| - |
|
49 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
| - |
|
50 |
</div>
|
| - |
|
51 |
</li>
|
| - |
|
52 |
<li>
|
| 37 |
<div class="label label-info">All Non-Haryana users</div>
|
53 |
<div class="label label-info">All Non-Haryana users</div>
|
| 38 |
<div class="clearfix"></div>
|
54 |
<div class="clearfix"></div>
|
| 39 |
<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>
|
55 |
<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>
|
| 40 |
<div class="col-lg-2">
|
56 |
<div class="col-lg-2">
|
| 41 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
57 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
| 42 |
</div>
|
58 |
</div>
|
| 43 |
</li>
|
59 |
</li>
|
| 44 |
<li>
|
60 |
<li>
|