SELECT SQL_CALC_FOUND_ROWS p.*,
						b.name as bname, b.discount,
						s.discount, s.name as series_name
				FROM products p 
				LEFT JOIN brands b ON p.brand_id = b.id
				LEFT JOIN series s ON p.series_id = s.id
				WHERE 1
				AND p.status != 'deleted'
				
				 AND b.brand_id = 10 
				
				
				 AND p.mps = 'cat' 
				
				ORDER BY k20
				LIMIT 10 OFFSET 10
				

Unknown column 'b.brand_id' in 'where clause'