| Line 47... |
Line 47... |
| 47 |
<div class="col-lg-10 updatesql">select User.id from users User LEFT JOIN devices d ON d.user_id = User.id where User.id in (select userids from pushnotificationusergroups where brand = 'Samsung' and category_id = 3 and min_price < 5000 and 5000 < max_price) GROUP BY d.imeinumber order by User.id DESC</div>
|
47 |
<div class="col-lg-10 updatesql">select User.id from users User LEFT JOIN devices d ON d.user_id = User.id where User.id in (select userids from pushnotificationusergroups where brand = 'Samsung' and category_id = 3 and min_price < 5000 and 5000 < max_price) GROUP BY d.imeinumber order by User.id DESC</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>
|
| - |
|
53 |
<div class="label label-info">Unique users with Samsung in brand preferences or clicks or filters or search terms or orders or product views</div>
|
| - |
|
54 |
<div class="clearfix"></div>
|
| - |
|
55 |
<div class="col-lg-10 updatesql">select User.id from users User LEFT JOIN devices d ON d.user_id = User.id where User.id in (select distinct user_id from newuserlinkssegmentation where brand = 'Samsung') GROUP BY d.imeinumber order by User.id DESC</div>
|
| - |
|
56 |
<div class="col-lg-2">
|
| - |
|
57 |
<button type="button" class="btn btn-primary sqlslecter">Use This</button>
|
| - |
|
58 |
</div>
|
| - |
|
59 |
</li>
|
| 52 |
</ul>
|
60 |
</ul>
|
| 53 |
</div>
|
61 |
</div>
|
| 54 |
<div class="row">
|
62 |
<div class="row">
|
| 55 |
<h3>Enter message</h3>
|
63 |
<h3>Enter message</h3>
|
| 56 |
<?php //echo $this->Form->create('User',array('action'=>'push')); ?>
|
64 |
<?php //echo $this->Form->create('User',array('action'=>'push')); ?>
|