Subversion Repositories SmartDukaan

Rev

Rev 23275 | Rev 23279 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 23275 Rev 23276
Line 7... Line 7...
7 
		</div>
 7 
		</div>
8 
	</div>
 8 
	</div>
9 
	<div class="mt20 row">
 9 
	<div class="mt20 row">
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>
- 
 
 13 
				<div class="label label-info">All unique Users</div>
- 
 
 14 
				<div class="clearfix"></div>
- 
 
 15 
				<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>
- 
 
 16 
				<div class="col-lg-2">
- 
 
 17 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
- 
 
 18 
				</div>
- 
 
 19 
			</li>
12 
			<li>
20 
			<li>
13 
				<div class="label label-info">Unique users with brand preferences set as Micromax or not set at all</div>
 21 
				<div class="label label-info">Unique users with brand preferences set as Micromax or not set at all</div>
14 
				<div class="clearfix"></div>
 22 
				<div class="clearfix"></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>
 23 
				<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">
 24 
				<div class="col-lg-2">
Line 32... Line 40...
32 
				<div class="col-lg-2">
 40 
				<div class="col-lg-2">
33 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
 41 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
34 
				</div>
 42 
				</div>
35 
			</li>
 43 
			</li>
36 
			<li>
44 
			<li>
37 
				<div class="label label-info">All unique Users</div>
 - 
 
38 
				<div class="clearfix"></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>
 - 
 
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">Test Notification</div>
 45 
				<div class="label label-info">Test Notification</div>
46 
				<div class="clearfix"></div>
 46 
				<div class="clearfix"></div>
47 
				<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>
 47 
				<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>
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>