Subversion Repositories SmartDukaan

Rev

Rev 23291 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 23291 Rev 23311
Line 34... Line 34...
34 
				</div>
 34 
				</div>
35 
			</li>
 35 
			</li>
36 
			<li>
36 
			<li>
37 
				<div class="label label-info">All Haryana users - FOS</div>
 37 
				<div class="label label-info">All Haryana users - FOS</div>
38 
				<div class="clearfix"></div>
 38 
				<div class="clearfix"></div>
39 
				<div class="col-lg-10 updatesql">SELECT u.id FROM users u left join retailerlinks rl on rl.user_id=u.id  left join retailers r on r.id=rl.retailer_id  left join dtr.user_accounts ua on (u.id=ua.user_id and ua.account_type='saholic')  left join retailer rt on (rt.id=ua.account_key and ua.account_type='saholic') where  (u.state ='HARYANA' or r.state='HARYANA')  and (rt.active=1 or rt.migrated=1) and u.referrer not in ('Sas96x8w38', 'sajwq5v9w4', 'Saznvgm9zx', 'SAC5R3YA39')</div>
 39 
				<div class="col-lg-10 updatesql">SELECT u.id FROM users u left join retailerlinks rl on rl.user_id=u.id  left join retailers r on r.id=rl.retailer_id  left join dtr.user_accounts ua on (u.id=ua.user_id and ua.account_type='saholic')  left join retailer rt on (rt.id=ua.account_key and ua.account_type='saholic') where  (u.state ='HARYANA' or r.state='HARYANA')  and (rt.active=1 or rt.migrated=1) and (u.referrer not in ('Sas96x8w38', 'sajwq5v9w4', 'Saznvgm9zx', 'SAC5R3YA39') or u.referrer is null)</div>
40 
				<div class="col-lg-2">
 40 
				<div class="col-lg-2">
41 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
 41 
					<button type="button" class="btn btn-primary sqlslecter">Use This</button>
42 
				</div>
 42 
				</div>
43 
			</li>
 43 
			</li>
44 
			<li>
44 
			<li>
45 
				<div class="label label-info">All India -Haryana -FOS</div>
 45 
				<div class="label label-info">All India -Haryana -FOS</div>
46 
				<div class="clearfix"></div>
 46 
				<div class="clearfix"></div>
47 
				<div class="col-lg-10 updatesql">SELECT u.id, u.referrer, u.city, u.state FROM users u left join retailerlinks rl on rl.user_id=u.id  left join retailers r on r.id=rl.retailer_id  left join dtr.user_accounts ua on (u.id=ua.user_id and ua.account_type='saholic')  left join retailer rt on (rt.id=ua.account_key and ua.account_type='saholic') where  (u.state is null or u.state !='HARYANA') and (r.state is null or r.state!='HARYANA')  and (rt.active=1 or rt.migrated=1) and u.referrer not in ('Sas96x8w38', 'sajwq5v9w4', 'Saznvgm9zx', 'SAC5R3YA39')</div>
 47 
				<div class="col-lg-10 updatesql">SELECT u.id, u.referrer, u.city, u.state FROM users u left join retailerlinks rl on rl.user_id=u.id  left join retailers r on r.id=rl.retailer_id  left join dtr.user_accounts ua on (u.id=ua.user_id and ua.account_type='saholic')  left join retailer rt on (rt.id=ua.account_key and ua.account_type='saholic') where  (u.state is null or u.state !='HARYANA') and (r.state is null or r.state!='HARYANA')  and (rt.active=1 or rt.migrated=1) and (u.referrer not in ('Sas96x8w38', 'sajwq5v9w4', 'Saznvgm9zx', 'SAC5R3YA39') or u.referrer is null)</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>
50 
				</div>
 50 
				</div>
51 
			</li>
 51 
			</li>
52 
			<li>
52 
			<li>