SELECT new_frames.*, frame_colors.color AS color5 FROM new_frames INNER JOIN frame_colors ON new_frames.color1 = frame_colors.id WHERE in_stock = '1'  ORDER BY  priceperfoot,color1 ASC 
| 
                    
                    
 | 
				
				
                
                                       
					 	                     
                     
															  
									  
									  
									 
										
																			  
									  
									  
									 
										
																			  
									  
									  
									 
										
																			  
									  
									  
									 
										
																			  
									  
									  
									 
										
																			  
									  
									  
									 
										
																			  
									  
									  
									 
										
																			  
									  
									  
									 
										
																			  
									  
									  
									 
										
																			  
									  
									  
									 
										
																			  
									  
									  
									 
										
																			  
									  
									  
									 
										
																			  
									  
									  
									 
										
  | 	
                    ||||||
											
											
											
											
											
											
								
Copyright © - 2015 by rkcadres.com,All Right Reserved.