Subversion Repositories SmartDukaan

Rev

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

Rev 23288 Rev 23289
Line 42... Line 42...
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.id not in (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 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.id not in (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 is null or u.state !='HARYANA') or (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>
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>