Subversion Repositories SmartDukaan

Rev

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

Rev 15583 Rev 15606
Line 20... Line 20...
20 
				<div class="col-lg-2">
 20 
				<div class="col-lg-2">
21 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
 21 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
22 
				</div>
 22 
				</div>
23 
			</li>
 23 
			</li>
24 
			<li>
 24 
			<li>
25 
				<div class="col-lg-10 updatesql">SELECT User.id, User.email, ifnull(P.min_price,0), ifnull(P.max_price,0) FROM users User LEFT JOIN price_preferences P ON User.id = P.user_id LEFT JOIN devices d ON d.user_id = User.id WHERE (P.min_price >=  5000 AND P.Max_price <= 50000 AND P.category_id =3) OR P.min_price is NULL GROUP BY d.imeinumber</div>
 25 
				<div class="col-lg-10 updatesql">SELECT User.id, User.email, ifnull(P.min_price,0), ifnull(P.max_price,0) FROM users User LEFT JOIN price_preferences P ON User.id = P.user_id LEFT JOIN devices d ON d.user_id = User.id WHERE (P.min_price <=  5000 AND P.Max_price >= 5000 AND P.category_id =3) OR P.min_price is NULL GROUP BY d.imeinumber</div>
26 
				<div class="col-lg-2">
 26 
				<div class="col-lg-2">
27 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
 27 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
28 
				</div>
 28 
				</div>
29 
			</li>
 29 
			</li>
30 
		</ul>
 30 
		</ul>