Subversion Repositories SmartDukaan

Rev

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

Rev 15721 Rev 15834
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>
 12 
			<li>
- 
 
 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>
13 
				<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>
 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>
14 
				<div class="col-lg-2">
 16 
				<div class="col-lg-2">
15 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
 17 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
16 
				</div>
 18 
				</div>
17 
			</li>
 19 
			</li>
18 
			<li>
20 
			<li>
- 
 
 21 
				<div class="label label-info">All unique Users</div>
- 
 
 22 
				<div class="clearfix"></div>
19 
				<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 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>
20 
				<div class="col-lg-2">
 24 
				<div class="col-lg-2">
21 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
 25 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
22 
				</div>
 26 
				</div>
23 
			</li>
 27 
			</li>
24 
			<li>
 28 
			<li>
- 
 
 29 
				<div class="label label-info">Unique users with price preferences set in range of 5000 or not set at all</div>
- 
 
 30 
				<div class="clearfix"></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 order by User.id DESC</div>
 31 
				<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 order by User.id DESC</div>
26 
				<div class="col-lg-2">
 32 
				<div class="col-lg-2">
27 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
 33 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
28 
				</div>
 34 
				</div>
29 
			</li>
 35 
			</li>
30 
			<li>
 36 
			<li>
- 
 
 37 
				<div class="label label-info">Unique users with Samsung in brand preferences or clicks or filters or search terms or orders</div>
- 
 
 38 
				<div class="clearfix"></div>
31 
				<div class="col-lg-10 updatesql">SELECT User.id, User.email, Brand.brand, 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 LEFT JOIN brand_preferences Brand ON User.id = Brand.user_id  WHERE ((P.min_price <= 5000 AND P.max_price >= 5000 AND P.category_id =3) OR P.min_price is NULL) AND ((Brand.brand =  'Micromax' AND Brand.category_id =3) OR Brand.brand IS NULL) GROUP BY d.imeinumber order by User.id DESC</div>
 39 
				<div class="col-lg-10 updatesql">select User.id from users User LEFT JOIN devices d ON d.user_id = User.id where User.id in (select userids from pushnotificationusergroups where brand = 'Samsung') GROUP BY d.imeinumber order by User.id DESC</div>
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>
- 
 
 45 
				<div class="label label-info">Unique users with Samsung in brand preferences or clicks or filters or search terms or orders and price preference in range of 5000</div>
- 
 
 46 
				<div class="clearfix"></div>
37 
				<div class="col-lg-10 updatesql">SELECT User.id,User.email,Filter.filters,BP.brand,ST.search_term,Click.brand FROM users User LEFT JOIN user_filters Filter ON User.id = Filter.user_id LEFT JOIN brand_preferences BP ON User.id = BP.user_id LEFT JOIN search_terms ST ON User.id = ST.user_id LEFT JOIN clicks Click ON User.id = Click.user_id LEFT JOIN devices Device On User.id = Device.user_id WHERE lower(BP.brand) LIKE '%samsung%' or lower(ST.search_term) LIKE '%samsung%' OR lower(Click.brand) LIKE '%samsung%' OR lower(Filter.filters) LIKE '%samsung%' GROUP BY Device.imeinumber</div>
 47 
				<div class="col-lg-10 updatesql">select User.id from users User LEFT JOIN devices d ON d.user_id = User.id where User.id in (select userids from pushnotificationusergroups where brand = 'Samsung' and category_id = 3 and min_price < 5000 and 5000 < max_price) GROUP BY d.imeinumber order by User.id DESC</div>
38 
				<div class="col-lg-2">
 48 
				<div class="col-lg-2">
39 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
 49 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
40 
				</div>
 50 
				</div>
41 
			</li>-->
 51 
			</li>
42 
		</ul>
 52 
		</ul>
43 
	</div>
 53 
	</div>
44 
	<div class="row">
 54 
	<div class="row">
45 
		<h3>Enter message</h3>
55 
		<h3>Enter message</h3>
46 
		<?php //echo $this->Form->create('User',array('action'=>'push')); ?>
56 
		<?php //echo $this->Form->create('User',array('action'=>'push')); ?>