Subversion Repositories SmartDukaan

Rev

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

Rev 19373 Rev 20346
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 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 d1.user_id from devices d1 left join devices d2 on (d1.imeinumber = d2.imeinumber and d1.created > d2.created) and 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>