Subversion Repositories SmartDukaan

Rev

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

Rev 21260 Rev 22376
Line 18... Line 18...
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 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</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>
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>