| Line 48... |
Line 48... |
| 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>
|
| 53 |
<div class="label label-info">All Non-Haryana users</div>
|
- |
|
| 54 |
<div class="clearfix"></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>
|
- |
|
| 56 |
<div class="col-lg-2">
|
- |
|
| 57 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
- |
|
| 58 |
</div>
|
- |
|
| 59 |
</li>
|
- |
|
| 60 |
<li>
|
- |
|
| 61 |
<div class="label label-info">Test Notification</div>
|
53 |
<div class="label label-info">Test Notification</div>
|
| 62 |
<div class="clearfix"></div>
|
54 |
<div class="clearfix"></div>
|
| 63 |
<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.created < d2.created) where d2.id is null and d1.user_id in (168,14,47,30916)</div>
|
55 |
<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.created < d2.created) where d2.id is null and d1.user_id in (168,14,47,30916)</div>
|
| 64 |
<div class="col-lg-2">
|
56 |
<div class="col-lg-2">
|
| 65 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
57 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|