select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text 
				from `prodchar` as pc 
				left join `char` as c on c.id = pc.`char` 
				left join `charval` as cv on cv.id = pc.charval 
				where c.inprod = 1 and pc.prod = '1' and cv.value != ''