select
	b.id,
	b.id as brand_id,
	b.title2 as brand,
	b.label as brand_label,
	if(b.id = 32,1,0) as ordercol2,
	b.label2 as lang_label,
	c1.id as catid,
	concat(c1.title2) as title,
	concat(c2.title2) as parentcategory,
	concat(b.title2,' ',i.model) as product,
	b.url,
	b.image as image2,
	i.id as product_id,
	i.label,
	c1.label as catlabel,
	c2.label as pcatlabel,
	concat(c2.title1) as category
from brands_utf8 as b

inner join items_utf8 as i on
	i.brand_id = b.id AND
	i.active=1 AND
	i.status=1
inner join categories_utf8 as c1 on
	c1.id = i.category_id AND
	c1.active=1
inner join categories_utf8 as c2 on
	c2.active=1 AND
	c2.id = c1.parent_id
where 
	b.active = 1 and 
	b.status = 1 and
	b.id not in(25)
order by ordercol2,b.weight	

<p class="error">Unknown column 'b.label2' in 'field list'</p>