| Line 10... |
Line 10... |
| 10 |
<!--<div class="col-lg-10 updatesql">SELECT User.id,User.email,Brand.brand FROM users User LEFT JOIN brand_preferences Brand ON User.id = Brand.user_id WHERE (Brand.brand = 'Micromax' AND Brand.category_id = 3) OR Brand.brand IS NULL</div>-->
|
10 |
<!--<div class="col-lg-10 updatesql">SELECT User.id,User.email,Brand.brand FROM users User LEFT JOIN brand_preferences Brand ON User.id = Brand.user_id WHERE (Brand.brand = 'Micromax' AND Brand.category_id = 3) OR Brand.brand IS NULL</div>-->
|
| 11 |
<ul class="list list-unstyled sqlrules">
|
11 |
<ul class="list list-unstyled sqlrules">
|
| 12 |
<li>
|
12 |
<li>
|
| 13 |
<div class="label label-info">Unique users with brand preferences set as Micromax or not set at all</div>
|
13 |
<div class="label label-info">Unique users with brand preferences set as Micromax or not set at all</div>
|
| 14 |
<div class="clearfix"></div>
|
14 |
<div class="clearfix"></div>
|
| 15 |
<div class="col-lg-10 updatesql">SELECT distinct User.id, User.email, Brand.brand FROM users User LEFT JOIN brand_preferences Brand ON User.id = Brand.user_id LEFT JOIN devices d ON d.user_id = User.id WHERE (Brand.brand = 'Micromax' AND Brand.category_id =3) OR Brand.brand IS NULL GROUP BY d.imeinumber order by User.id DESC</div>
|
15 |
<div class="col-lg-10 updatesql">SELECT User.id, User.email, Brand.brand FROM users User LEFT JOIN brand_preferences Brand ON User.id = Brand.user_id LEFT JOIN devices d ON d.user_id = User.id WHERE (Brand.brand = 'Micromax' AND Brand.category_id =3) OR Brand.brand IS NULL GROUP BY d.imeinumber order by User.id DESC</div>
|
| 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 unique Users</div>
|
21 |
<div class="label label-info">All unique Users</div>
|
| 22 |
<div class="clearfix"></div>
|
22 |
<div class="clearfix"></div>
|
| 23 |
<div class="col-lg-10 updatesql">SELECT User.id,User.email FROM users User LEFT JOIN devices d ON d.user_id = User.id GROUP BY d.imeinumber order by User.id DESC</div>
|
23 |
<div class="col-lg-10 updatesql">SELECT distinct User.id,User.email FROM users User LEFT JOIN devices d ON d.user_id = User.id GROUP BY d.imeinumber order by User.id DESC</div>
|
| 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>
|