| Line 16... |
Line 16... |
| 16 |
<div class="col-lg-2">
|
16 |
<div class="col-lg-2">
|
| 17 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
17 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
| 18 |
</div>
|
18 |
</div>
|
| 19 |
</li>
|
19 |
</li>
|
| 20 |
<li>
|
20 |
<li>
|
| - |
|
21 |
<div class="label label-info">All Haryana users</div>
|
| - |
|
22 |
<div class="clearfix"></div>
|
| - |
|
23 |
<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>
|
| - |
|
24 |
<div class="col-lg-2">
|
| - |
|
25 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
| - |
|
26 |
</div>
|
| - |
|
27 |
</li>
|
| - |
|
28 |
<li>
|
| - |
|
29 |
<div class="label label-info">All Non-Haryana users</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>
|
| - |
|
32 |
<div class="col-lg-2">
|
| - |
|
33 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
| - |
|
34 |
</div>
|
| - |
|
35 |
</li>
|
| - |
|
36 |
<li>
|
| 21 |
<div class="label label-info">All unique Users</div>
|
37 |
<div class="label label-info">All unique Users</div>
|
| 22 |
<div class="clearfix"></div>
|
38 |
<div class="clearfix"></div>
|
| 23 |
<div class="col-lg-10 updatesql">SELECT distinct d1.user_id from devices d1 left join devices d2 on (d1.imeinumber = d2.imeinumber and d1.modified < d2.modified) where d2.id is null</div>
|
39 |
<div class="col-lg-10 updatesql">SELECT distinct d1.user_id from devices d1 left join devices d2 on (d1.imeinumber = d2.imeinumber and d1.modified < d2.modified) where d2.id is null</div>
|
| 24 |
<div class="col-lg-2">
|
40 |
<div class="col-lg-2">
|
| 25 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
41 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|