Subversion Repositories SmartDukaan

Rev

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

Rev 14408 Rev 14411
Line 6... Line 6...
6
			<?php echo $this->Form->input('sql',array('type'=>'textarea'));?>
6
			<?php echo $this->Form->input('sql',array('type'=>'textarea'));?>
7
			<?php echo $this->Form->end(__('Submit')); ?>
7
			<?php echo $this->Form->end(__('Submit')); ?>
8
		</div>
8
		</div>
9
	</div>
9
	</div>
10
	<div class="row well">		
10
	<div class="row well">		
11
		<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' OR Brand.brand IS NULL</div>
11
		<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>
12
		<div class="col-lg-2">
12
		<div class="col-lg-2">
13
			<button type="button" class="btn btn-primary sqlslecter">Use This</button>
13
			<button type="button" class="btn btn-primary sqlslecter">Use This</button>
14
		</div>
14
		</div>
15
	</div>
15
	</div>
16
	<hr/>
16
	<hr/>